Rail ridership during the summer months in the North-East is believed to be closely related to the number of tourists visiting the region. The following table shows the data on the number of tourists and North-East ridership for the past 16 years. (Answer in Excel showing formulas for answers) Year Tourists( in millions) Rail Ridership (in millions) 2000 9 2.3 2001 4 1.9 2002 7 1.7 2003 5 1.8 2004 12 2.8 2005 13 2.9 2006 14 2.4 2007 20 4.8 2008 7 1.3 2009 5 1.1 2010 9 1.9 2011 11 2.1 2012 16 3.3 2013 14 2.8 2014 18 3.6 2015 17 3.2 a Develop a linear regression equation for rail ridership as a function of the average number of tourists visiting the North-East. b Forecast Rail ridership if the average number of tourists visiting the North-East is 19.2 million. c Evaluate the goodness of fit of the regression equation by computing the values of R2, r, and syx and interpreting the results
Rail ridership during the summer months in the North-East is believed to be
closely related to the number of tourists visiting the region. The following table
shows the data on the number of tourists and North-East ridership for the past
16 years. (Answer in Excel showing formulas for answers)
Year Tourists( in millions) Rail Ridership (in millions)
2000 9 2.3
2001 4 1.9
2002 7 1.7
2003 5 1.8
2004 12 2.8
2005 13 2.9
2006 14 2.4
2007 20 4.8
2008 7 1.3
2009 5 1.1
2010 9 1.9
2011 11 2.1
2012 16 3.3
2013 14 2.8
2014 18 3.6
2015 17 3.2
a Develop a linear regression equation for rail ridership as a
b Forecast Rail ridership if the average number of tourists
visiting the North-East is 19.2 million.
c Evaluate the goodness of fit of the regression equation by
computing the values of R2, r, and syx and interpreting the results.
Step by step
Solved in 3 steps with 1 images
