Description 2- A sample of students was taken measuring the hours studied for a test and the score on the test (out of a possible total of 350 points) X(# hours study) Y (Score on test) 5 155 7 210 8 150 10 192 11 245 13 260 15 270 18 275 20 290 a). Give the following: i) sum of the x ii) sum of the y iii) sum of the x squared iv) sum of the xy v) sum of the y squared b) Find b sub 0 and b sub 1 using the formulas in Excel that were used in the module. Round to 3 decimal places. c) Find the equation of the regression line. d) What is the value of the slope and interpret its meaning in the context of this problem e) Predict the test score for 13 hours of study. f) Calculate the coefficient of determination by writing the formula in Excel. Show your calculations. g) What % of the variation in test scores is explained by the # hours of study? h) What % is due to other factors? i) Name 1 other factor that could affect a test score. j) What is the calculated F in testing the null hyothesis: no significant relation between # hours of study and test scores. (You must use the Tool-Pak for this.) k) What is the p-value? l) Is there a significant relation between #hours of study and test scores? Please answer yes or no 3- The following data give the sales in millions of dollars for a company for the given years: Years Sales 2001 3.1 2002 3.6 2003 4.3 2004 4.9 2005 5.2 2006 6.1 2007 6.9 2008 7.2 a) Give the equation of the trend line for this time series. Round to 3 decimal places. b) Interpret the intercept in the context of this problem. Move decimal appropriately in your answer. c) Interpret the slope of sales in the context of this problem. Move decimal appropriately in your answer. d) Forecast sales for the year 2012. Move decimal appropriately in your answer. e)
Recent Comments