Exam 13: Simple Linear Regression

SCENARIO 13-14-A You are the CEO of a dairy company. You are planning to expand production by purchasing additional cows, lands and hiring more workers. From the existing 50 farms owned by the company, you have collected data on total milk production (in liters) and the number of milking cows. The data are shown below and also available in the Excel file Scenario13-14-DataA.XLSX. MILK 84729 101969 103314 70574 76144 86695 87600 105272 120422 68749 85541 91910 110465 125369 159470 102930 113214 133328 140086 145514 152589 128304 138093 161368 208136 224205 231090 122204 132311 155154 177268 196449 205324 89562 94840 94997 97625 102226 103832 239673 239861 241298 249196 294455 318871 66483 100459 103847 154141 155516 COWS 18 24 22 19 21 19 22 19 24 18 20 25 26 27 29 24 25 28 26 28 27 21 24 27 33 32 32 22 25 26 29 29 28 25 21 23 24 28 25 39 40 40 39 42 47 19 20 21 25 31 You believe that the number of milking cows is the best predictor for total milk production on any given farm. -Referring to Scenario 13-14-A, the value of the F test statistic on whether the number of milking cows is a good predictor for the total milk production is _________.

SCENARIO 13-3 The director of cooperative education at a state college wants to examine the effect of cooperative education job experience on marketability in the work place. She takes a random sample of 4 students. For these 4, she finds out how many times each had a cooperative education job and how many job offers they received upon graduation. These data are presented in the table below. Student CoopJobs JobOffer 1 1 4 2 2 6 3 1 3 4 0 1 -Referring to Scenario 13-3, the error or residual sum of squares (SSE) is __________.

SCENARIO 13-7 An investment specialist claims that if one holds a portfolio that moves in the opposite direction to the market index like the S&P 500, then it is possible to reduce the variability of the portfolio's return. In other words, one can create a portfolio with positive returns but less exposure to risk. A sample of 26 years of S&P 500 index and a portfolio consisting of stocks of private prisons, which are believed to be negatively related to the S&P 500 index, is collected. A regression analysis was performed by regressing the returns of the prison stocks portfolio (Y) on the returns of S&P 500 index (X) to prove that the prison stocks portfolio is negatively related to the S&P 500 index at a 5% level of significance. The results are given in the following EXCEL output. Coefficients \bullet Standard Error \bullet T Stat \bullet P- Coefficients Standard Error T Stat P-value Intercept 4.8660 0.3574 13.6136 0.0000 S\&P -0.5025 0.0716 -7.0186 0.0000 -Referring to Scenario 13-7, which of the following will be a correct conclusion?