Exam 13: Simple Linear Regression

If the correlation coefficient (r) = 1.00, then

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, if you purchase 40 cows for the new farm, its mean total milk production is estimated to be _________ liters.

SCENARIO 13-10 The management of a chain electronic store would like to develop a model for predicting the weekly sales (in thousand of dollars) for individual stores based on the number of customers who made purchases. A random sample of 12 stores yields the following results: Customers Sales (Thousands of Dollars) 907 11.20 926 11.05 713 8.21 741 9.21 780 9.42 898 10.08 510 6.73 529 7.02 460 6.12 872 9.52 650 7.53 603 7.25 -Referring to Scenario 13-10, it is inappropriate to compute the Durbin-Watson statistic and test for autocorrelation in this case.

If the plot of the residuals is fan shaped, which assumption is violated?

SCENARIO 13-10 The management of a chain electronic store would like to develop a model for predicting the weekly sales (in thousand of dollars) for individual stores based on the number of customers who made purchases. A random sample of 12 stores yields the following results: Customers Sales (Thousands of Dollars) 907 11.20 926 11.05 713 8.21 741 9.21 780 9.42 898 10.08 510 6.73 529 7.02 460 6.12 872 9.52 650 7.53 603 7.25 -Referring to Scenario 13-10, construct a 95% confidence interval for the mean weekly sales when the number of customers who make purchases is 600.

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 least squares estimate of the Y-intercept is __________.

The standard error of the estimate is a measure of

SCENARIO 13-13 In this era of tough economic conditions, voters increasingly ask the question: "Is the educational achievement level of students dependent on the amount of money the state in which they reside spends on education?" The partial computer output below is the result of using spending per student ($) as the independent variable and composite score which is the sum of the math, science and reading scores as the dependent variable on 35 states that participated in a study. The table includes only partial results. Regression Statistics Multiple R 0.3122 R Square 0.0975 Adjusted R 0.0701 Square Standard 26.9122 Error Observations 35 $\text { ANOVA }$ -Referring to Scenario 13-13, the conclusion on the test of whether composite score depends linearly on spending per student using a 10% level of significance is _________

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, construct a scatter plot for the simple linear regression.

SCENARIO 13-13 In this era of tough economic conditions, voters increasingly ask the question: "Is the educational achievement level of students dependent on the amount of money the state in which they reside spends on education?" The partial computer output below is the result of using spending per student ($) as the independent variable and composite score which is the sum of the math, science and reading scores as the dependent variable on 35 states that participated in a study. The table includes only partial results. Regression Statistics Multiple R 0.3122 R Square 0.0975 Adjusted R 0.0701 Square Standard 26.9122 Error Observations 35 $\text { ANOVA }$ -Referring to Scenario 13-13, the critical value at 5% level of significance of the F test on whether spending per student affects composite score is _________.

SCENARIO 13-12 The manager of the purchasing department of a large saving and loan organization would like to develop a model to predict the amount of time (measured in hours) it takes to record a loan application. Data are collected from a sample of 30 days, and the number of applications recorded and completion time in hours is recorded. Below is the regression output: Regression Statistics Multiple R 0.9447 R Square 0.8924 Adjusted R 0.8886 Square Standard 0.3342 Error Observations 30 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 0.4024 0.1236 3.2559 0.0030 0.1492 0.6555 Applications 0.0126 0.0008 15.2388 0.0000 0.0109 0.0143 -Referring to Scenario 13-12, what are the critical values of the Durbin-Watson test statistic using the 5% level of significance to test for evidence of positive autocorrelation?

SCENARIO 13-11 A computer software developer would like to use the number of downloads (in thousands) for the trial version of his new shareware to predict the amount of revenue (in thousands of dollars) he can make on the full version of the new shareware. Following is the output from a simple linear regression along with the residual plot and normal probability plot obtained from a data set of 30 different sharewares that he has developed: -Referring to Scenario 13-11, predict the revenue when the number of downloads is 30 thousands.

SCENARIO 13-12 The manager of the purchasing department of a large saving and loan organization would like to develop a model to predict the amount of time (measured in hours) it takes to record a loan application. Data are collected from a sample of 30 days, and the number of applications recorded and completion time in hours is recorded. Below is the regression output: Regression Statistics Multiple R 0.9447 R Square 0.8924 Adjusted R 0.8886 Square Standard 0.3342 Error Observations 30 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 0.4024 0.1236 3.2559 0.0030 0.1492 0.6555 Applications 0.0126 0.0008 15.2388 0.0000 0.0109 0.0143 -Referring to Scenario 13-12, the estimated mean amount of time it takes to record one additional loan application is

EXPLANATION: The t-test statistic is $t = \frac { \left( b _ { 1 } - \beta _ { 1 } \right) } { S _ { b _ { 1 } } } = \frac { ( 2.5 - 3 ) } { 0.3536 } = - 1.4142$ KEYWORDS: t test on slope, p-value, slope SCENARIO 13-4 The managers of a brokerage firm are interested in finding out if the number of new clients a broker brings into the firm affects the sales generated by the broker. They sample 12 brokers and determine the number of new clients they have enrolled in the last year and their sales amounts in thousands of dollars. These data are presented in the table that follows. 1 27 52 2 11 37 3 42 64 4 33 55 5 15 29 6 15 34 7 25 58 8 36 59 9 28 44 10 30 48 11 17 31 12 22 38 -Referring to Scenario 13-4, the managers of the brokerage firm wanted to test the hypothesis that the population slope was equal to 0. At a level of significance of 0.01, the decision that should be made implies that _____ (there is a or there is no) linear dependent relationship between the independent and dependent variables.

SCENARIO 13-10 The management of a chain electronic store would like to develop a model for predicting the weekly sales (in thousand of dollars) for individual stores based on the number of customers who made purchases. A random sample of 12 stores yields the following results: Customers Sales (Thousands of Dollars) 907 11.20 926 11.05 713 8.21 741 9.21 780 9.42 898 10.08 510 6.73 529 7.02 460 6.12 872 9.52 650 7.53 603 7.25 -Referring to Scenario 13-10, what is the p-value of the F test statistic when testing whether the number of customers who make purchases is a good predictor for weekly sales?

EXPLANATION: The t-test statistic is $t = \frac { \left( b _ { 1 } - \beta _ { 1 } \right) } { S _ { b _ { 1 } } } = \frac { ( 2.5 - 3 ) } { 0.3536 } = - 1.4142$ KEYWORDS: t test on slope, p-value, slope SCENARIO 13-4 The managers of a brokerage firm are interested in finding out if the number of new clients a broker brings into the firm affects the sales generated by the broker. They sample 12 brokers and determine the number of new clients they have enrolled in the last year and their sales amounts in thousands of dollars. These data are presented in the table that follows. 1 27 52 2 11 37 3 42 64 4 33 55 5 15 29 6 15 34 7 25 58 8 36 59 9 28 44 10 30 48 11 17 31 12 22 38 -Referring to Scenario 13-4, the least squares estimate of the Y-intercept is __________.

SCENARIO 13-12 The manager of the purchasing department of a large saving and loan organization would like to develop a model to predict the amount of time (measured in hours) it takes to record a loan application. Data are collected from a sample of 30 days, and the number of applications recorded and completion time in hours is recorded. Below is the regression output: Regression Statistics Multiple R 0.9447 R Square 0.8924 Adjusted R 0.8886 Square Standard 0.3342 Error Observations 30 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 0.4024 0.1236 3.2559 0.0030 0.1492 0.6555 Applications 0.0126 0.0008 15.2388 0.0000 0.0109 0.0143 -Referring to Scenario 13-12, the degrees of freedom for the t test on whether the number of loan applications recorded affects the amount of time are

SCENARIO 13-11 A computer software developer would like to use the number of downloads (in thousands) for the trial version of his new shareware to predict the amount of revenue (in thousands of dollars) he can make on the full version of the new shareware. Following is the output from a simple linear regression along with the residual plot and normal probability plot obtained from a data set of 30 different sharewares that he has developed: -Referring to Scenario 13-11, the normality of error assumption appears to have been violated.

SCENARIO 13-10 The management of a chain electronic store would like to develop a model for predicting the weekly sales (in thousand of dollars) for individual stores based on the number of customers who made purchases. A random sample of 12 stores yields the following results: Customers Sales (Thousands of Dollars) 907 11.20 926 11.05 713 8.21 741 9.21 780 9.42 898 10.08 510 6.73 529 7.02 460 6.12 872 9.52 650 7.53 603 7.25 -Referring to Scenario 13-10, what are the degrees of freedom of the t test statistic when testing whether the number of customers who make a purchase affects weekly sales?

SCENARIO 13-14-B 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-DataB.XLSX. MILK 84686 101876 103248 70508 76072 86615 87508 105195 120351 68658 85478 91902 110374 125364 159401 102883 113151 133297 140073 145434 152513 128275 138040 161276 208079 224119 231071 122114 132222 155092 177273 196399 205329 89564 94838 94920 97577 102163 103754 239585 239773 241293 249157 294388 318813 66462 100444 103846 154118 155460 COWS 21 20 22 17 16 20 21 19 21 19 22 24 26 26 27 22 27 24 27 24 29 21 25 26 33 31 33 23 27 29 27 28 32 22 26 24 26 28 26 39 44 42 41 42 47 18 21 22 27 27 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-B, the decision on the test of whether total milk production depends linearly on the number of milking cows using a 1% level of significance is to ________ (reject or not reject) H0 .