Exam 12: Simple Linear Regression

SCENARIO 12-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 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 Predictor Coef StdError tStat P-value Intercept 3.962 1.440 2.75 0.016 Industry 0.040451 0.008048 5.03 0.000 $\text { Durbin-Watson Statistic } \quad 1.59$ -Referring to Scenario 12-5, the correlation coefficient is _.

If the correlation coefficient (r) = 1.00, then

SCENARIO 12-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. Broker Clients Sales 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 12-4, suppose the managers of the brokerage firm want to construct a 99% prediction interval for the sales made by a broker who has brought into the firm 18 new clients.The prediction interval is from to _.

SCENARIO 12-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 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 0.0126 0.0008 15.2388 0.0000 0.0109 0.0143 Recorded 12-46 Simple Linear Regression Simple Linear Regression 12-47 -Referring to Scenario 12-12, the degrees of freedom for the F test on whether the number of load applications recorded affects the amount of time are

SCENARIO 12-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 StandardError 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 12-7, to test whether the prison stocks portfolio is negatively related to the S&P 500 index, the p-value of the associated test statistic is

SCENARIO 12-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 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 Predictor Coef StdError tStat P-value Intercept 3.962 1.440 2.75 0.016 Industry 0.040451 0.008048 5.03 0.000 $\text { Durbin-Watson Statistic } \quad 1.59$ -Referring to Scenario 12-5, the value of the quantity that the least squares regression line minimizes is _.

SCENARIO 12-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. Broker Clients Sales 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 12-4, the managers of the brokerage firm wanted to test the hypothesis thatthe population slope was equal to 0.The denominator of the test statistic is s $b$ 1.The value of s1 $b$ in this sample is _.

The sample correlation coefficient between X and Y is 0.375.It has been found out that the p- value is 0.256 when testing H0 : $\rho$ =0 against the two-sided alternative H1 : $\rho$ $\neq$ 0 .To testH0 : $\rho$ = 0 against the one-sided alternative H1 : $\rho$ $\gt$ 0 at a significance level of 0.1, the p-value is

Data that exhibit an autocorrelation effect violate the regression assumption of independence.

SCENARIO 12-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 ANOVA df SS MS F Significance F Regression 1 171062.9193 171062.9193 86.4759 0.0000 Residual 28 55386.4309 1978.1582 Total 29 226451.3503 Coefficients Standard Error t Stat P-value Lower 95\% 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 Simple Linear Regression 12-41 -Referring to Scenario 12-11, the normality of error assumption appears to have been violated.

SCENARIO 12-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 Scenario 12-10, what is the value of the F test statistic when testing whether the number of customers who make purchases is a good predictor for weekly sales?

SCENARIO 12-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 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 0.0126 0.0008 15.2388 0.0000 0.0109 0.0143 Recorded 12-46 Simple Linear Regression Simple Linear Regression 12-47 -Referring to Scenario 12-12, the 90% confidence interval for the mean change in the amount of time needed as a result of recording one additional loan application is

SCENARIO 12-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 Coop Jobs Job Offer 1 1 4 2 2 6 3 1 3 4 0 1 -Referring to Scenario 12-3, suppose the director of cooperative education wants to construct a95% confidence interval estimate for the mean number of job offers received by students who have had exactly one cooperative education job.The confidence interval is from to_.

SCENARIO 12-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: $\begin{array}{llr}\text { City}&\text { Price(\$)}&\text { Sales }\\\hline\text { River Falls } & 1.30 & 100 \\\text { Hudson } & 1.60 & 90 \\\text { Ellsworth } & 1.80 & 90 \\\text { Prescott } & 2.00 & 40 \\\text { Rock Elm } & 2.40 & 38 \\\text { Stillwater } & 2.90 & 32\end{array}$ -Referring to Scenario 12-2, what is the estimated slope for the candy bar price and sales data?

The least squares method minimizes which of the following?

SCENARIO 12-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: $\begin{array}{llr}\text { City}&\text { Price(\$)}&\text { Sales }\\\hline\text { River Falls } & 1.30 & 100 \\\text { Hudson } & 1.60 & 90 \\\text { Ellsworth } & 1.80 & 90 \\\text { Prescott } & 2.00 & 40 \\\text { Rock Elm } & 2.40 & 38 \\\text { Stillwater } & 2.90 & 32\end{array}$ -Referring to Scenario 12-2, what is the estimated mean change in the sales of the candy bar if price goes up by $1.00?

SCENARIO 12-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 ANOVA df SS MS F Significance F Regression 1 171062.9193 171062.9193 86.4759 0.0000 Residual 28 55386.4309 1978.1582 Total 29 226451.3503 Coefficients Standard Error t Stat P-value Lower 95\% 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 Simple Linear Regression 12-41 -Referring to Scenario 12-11, the null hypothesis that there is no linear relationship between revenue and the number of downloads should be rejected at a 5% level of significance.

SCENARIO 12-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. Broker Clients Sales 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 12-4, the error or residual sum of squares (SSE) is .

SCENARIO 12-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 Coop Jobs Job Offer 1 1 4 2 2 6 3 1 3 4 0 1 -Referring to Scenario 12-3, the director of cooperative education wanted to test the hypothesisthat the population slope was equal to 0.The denominator of the test statistic is s $b$ 1.The value ofs in this sample is _. $b$ 1

SCENARIO 12-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. Broker Clients Sales 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 12-4, the standard error of estimate is .