Exam 13: Simple Linear Regression

TABLE 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 Table 13-3, the regression sum of squares (SSR)is ________.

TABLE 13-10 The management of a chain electronic store would like to develop a model for predicting the weekly sales (in thousands 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 Table 13-10, construct a 95% confidence interval for the change in mean weekly sales when the number of customers who make purchases increases by one.

TABLE 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 Table 13-4, the coefficient of determination is ________.

TABLE 13-5 The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excel to analyze the last 4 years of quarterly data (i.e., n = 16) with the following results: Regression Statistics Multiple R 0.802 R Square 0.643 Adjusted R Square 0.618 Standard Error SYX 0.9224 Observations 16 ANOVA df SS MS F Sig.F Regression 1 21.497 21.497 25.27 0.000 Error 14 11.912 0.851 Total 15 33.409 p -value Intercept 3.962 1.440 2.75 0.016 Industry 0.040451 0.008048 5.03 0.000 Durbin-Watson Statistic $1.59$ -Referring to Table 13-5, the partner wants to test for autocorrelation using the Durbin-Watson statistic. Using a level of significance of 0.05, the critical values of the test are dL = ________, and dU = ________.

TABLE 13-6 The following Excel tables are obtained when "Score received on an exam (measured in percentage points)" (Y) is regressed on "percentage attendance" (X) for 22 students in a Statistics for Business and Economics course. Regression Statistics Multiple R 0.142620229 R Square 0.02034053 Standard Error 20.25979924 Observations 22 Coefficients Standard Error T Stat P-value Intercept 39.39027309 37.24347659 1.057642216 0.302826622 Attendance 0.340583573 0.52852452 0.644404489 0.526635689 -Referring to Table 13-6, which of the following statements is true?

TABLE 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 }$ df SS MS F Significance F Regression 1 25.9438 25.9438 232.2200 4.3946-15 Residual 28 3.1282 0.1117 Total 29 29.072 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 Recorded 0.0126 0.0008 15.2388 4.3946-15 0.0109 0.0143 Note: 4.3946E-15 is 4.3946*10^-15 -Referring to Table 13-12, there is sufficient evidence that the amount of time needed linearly depends on the number of loan applications at a 1% level of significance.

TABLE 13-2 A candy bar manufacturer is interested in trying to estimate how sales are influenced by the price of their product. To do this, the company randomly chooses 6 small cities and offers the candy bar at different prices. Using candy bar sales as the dependent variable, the company will conduct a simple linear regression on the data below: River Falls 1.30 100 Hudson 1.60 90 Ellsworth 1.80 90 Prescott 2.00 40 Rock Elm 2.40 38 Stillwater 2.90 32 -Referring to Table 13-2, what is the coefficient of correlation for these data?

TABLE 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 Table 13-4, the error or residual sum of squares (SSE)is ________.

TABLE 13-5 The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excel to analyze the last 4 years of quarterly data (i.e., n = 16) with the following results: Regression Statistics Multiple R 0.802 R Square 0.643 Adjusted R Square 0.618 Standard Error SYX 0.9224 Observations 16 ANOVA df SS MS F Sig.F Regression 1 21.497 21.497 25.27 0.000 Error 14 11.912 0.851 Total 15 33.409 p -value Intercept 3.962 1.440 2.75 0.016 Industry 0.040451 0.008048 5.03 0.000 Durbin-Watson Statistic $1.59$ -The standard error of the estimate is a measure of

TABLE 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 }$ df SS MS F Regression 1 2581.5759 Residual 724.2674 Total 34 26482.4000 Coefficients Standard Error t Stat P-value Intercept 595.540251 22.115176 Spending per Student () 0.007996 0.004235 -Referring to Table 13-13, the p-value of the measured F-test statistic to test whether spending per student affects composite score is ________.

TABLE 13-2 A candy bar manufacturer is interested in trying to estimate how sales are influenced by the price of their product. To do this, the company randomly chooses 6 small cities and offers the candy bar at different prices. Using candy bar sales as the dependent variable, the company will conduct a simple linear regression on the data below: River Falls 1.30 100 Hudson 1.60 90 Ellsworth 1.80 90 Prescott 2.00 40 Rock Elm 2.40 38 Stillwater 2.90 32 -Referring to Table 13-2, what is the standard error of the regression slope estimate, $S_{b_{1}}$ ?

TABLE 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 Table 13-3, the coefficient of correlation is ________.

TABLE 13-10 The management of a chain electronic store would like to develop a model for predicting the weekly sales (in thousands 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 Table 13-10, the mean weekly sales will increase by an estimated $0.01 for each additional purchasing customer.

TABLE 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 }$ df SS MS F Significance F Regression 1 25.9438 25.9438 232.2200 4.3946-15 Residual 28 3.1282 0.1117 Total 29 29.072 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 Recorded 0.0126 0.0008 15.2388 4.3946-15 0.0109 0.0143 Note: 4.3946E-15 is 4.3946*10^-15 -Referring to Table 13-12, the model appears to be adequate based on the residual analyses.

TABLE 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: Regression Statistics Multiple R 0.8691 R Square 0.7554 Adjusted R Square 0.7467 Standard Error 44.4765 Observations 30.0000 $\text { ANOVA }$ df SS MS F Significance F Regression 1 171062.9193 171062.9193 86.4759 0.0000 Residual 28 55388.4309 1978.1582 Total 29 226451.3503 Coefficients Standard Error t Stat P-value Lower 95\% \multicolumn 1 r Upper 95\% Intercept -95.0614 26.9183 -3.5315 0.0015 -150.2009 -39.9218 Download 3.7297 0.4011 9.2992 0.0000 2.9082 4.5513 -Referring to Table 13-11, what are the lower and upper limits of the 95% confidence interval estimate for the mean change in revenue as a result of a one thousand increase in the number of downloads?

TABLE 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: Regression Statistics Multiple R 0.8691 R Square 0.7554 Adjusted R Square 0.7467 Standard Error 44.4765 Observations 30.0000 $\text { ANOVA }$ df SS MS F Significance F Regression 1 171062.9193 171062.9193 86.4759 0.0000 Residual 28 55388.4309 1978.1582 Total 29 226451.3503 Coefficients Standard Error t Stat P-value Lower 95\% \multicolumn 1 r Upper 95\% Intercept -95.0614 26.9183 -3.5315 0.0015 -150.2009 -39.9218 Download 3.7297 0.4011 9.2992 0.0000 2.9082 4.5513 -Referring to Table 13-11, what is the critical value for testing whether there is a linear relationship between revenue and the number of downloads at a 5% level of significance?

TABLE 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 }$ df SS MS F Significance F Regression 1 25.9438 25.9438 232.2200 4.3946-15 Residual 28 3.1282 0.1117 Total 29 29.072 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 Recorded 0.0126 0.0008 15.2388 4.3946-15 0.0109 0.0143 Note: 4.3946E-15 is 4.3946*10^-15 -Referring to Table 13-12, what percentage of the variation in the amount of time needed can be explained by the variation in the number of invoices processed?

TABLE 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: Regression Statistics Multiple R 0.8691 R Square 0.7554 Adjusted R Square 0.7467 Standard Error 44.4765 Observations 30.0000 $\text { ANOVA }$ df SS MS F Significance F Regression 1 171062.9193 171062.9193 86.4759 0.0000 Residual 28 55388.4309 1978.1582 Total 29 226451.3503 Coefficients Standard Error t Stat P-value Lower 95\% \multicolumn 1 r Upper 95\% Intercept -95.0614 26.9183 -3.5315 0.0015 -150.2009 -39.9218 Download 3.7297 0.4011 9.2992 0.0000 2.9082 4.5513 -Referring to Table 13-11, there is sufficient evidence that revenue and the number of downloads are linearly related at a 5% level of significance.

The Durbin-Watson D statistic is used to check the assumption of normality.

TABLE 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: Regression Statistics Multiple R 0.8691 R Square 0.7554 Adjusted R Square 0.7467 Standard Error 44.4765 Observations 30.0000 $\text { ANOVA }$ df SS MS F Significance F Regression 1 171062.9193 171062.9193 86.4759 0.0000 Residual 28 55388.4309 1978.1582 Total 29 226451.3503 Coefficients Standard Error t Stat P-value Lower 95\% \multicolumn 1 r Upper 95\% Intercept -95.0614 26.9183 -3.5315 0.0015 -150.2009 -39.9218 Download 3.7297 0.4011 9.2992 0.0000 2.9082 4.5513 -Referring to Table 13-11, which of the following is the correct null hypothesis for testing whether there is a linear relationship between revenue and the number of downloads?