BUS 308 Statistics for Managers ( work in Excel (with plotting graph) and Word File) - 22440

Solution Posted by
Solution Detail
Price: $10.00
  • From: Business,
  • Posted on: Tue 13 Aug, 2013
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

Part 1

 

  1. Calculate the mean yearly value using the average gas prices by month found in the “Final Project Data Set.”
  2. Using the years as your x-axis and the annual mean as your y-axis, create a scatterplot and a linear regression line.
  3. Answer the following questions using your scatterplot and linear regression line:

 

  • What is the slope of the linear regression line?
  • What is the Y-intercept of the linear regression line?
  • What is the equation of the linear regression line in slope-intercept form?
  • Based on the linear regression line, what would be an estimated cost of gas in the year 2020?
  • What are the residuals of each year?
  • Select a current price that you have seen or paid recently for gas. Is that price within the range of the linear regression line or is it an outlier? Is it within the confidence interval of 5% or either end?
BUS 308 Statistics for Managers
BUS308 Statistics for Managers
BUS/308 Statistics for Managers 

Solution Description

BUS 308 Statisti

Attachments
BUS 308 Statistics for Managers..xls
BUS 308 Statist...
BUS 308 Statistics for Managers....docx
BUS 308 Statist...