Exam 13: Simple Linear Regression

If you wanted to find out if alcohol consumption (measured in fluid oz.) and grade point average on a 4-point scale are linearly related, you would perform a

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. Broker Cliente 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 Table 13-4, the prediction for the amount of sales (in $1,000s) for a person who brings 25 new clients into the firm is _____.

TABLE 13-01 A large national bank charges local companies for using their services. A bank official reported the results of a regression analysis designed to predict the bank's charges $E(Y)=\beta_{0}+\beta_{1} X$ The results of the simple linear regression are provided below. $\hat{Y}=-2,700+20 X, \mathrm{~S}_{Y X}=65, \text { two-tailed } p \text { value }=0.034\left(\text { for testing } \beta_{1}\right)$ (Y) -- measured in dollars per month -- for services rendered to local companies. One independent variable used to predict service charge to a company is the company's sales revenue (X) -- measured in millions of dollars. Data for 21 companies who use the bank's services were used to fit the model: -Referring to Table 13-1, interpret the estimate of a, the standard deviation of the random error term (standard error of the estimate) in the model.

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. Broker Cliente 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 Table 13-4, the managers of the brokerage firm wanted to test the hypothesis that the number of new clients brought in had a positive impact on the amount of sales generated. At a level of significance of 0.01, the decision that should be made implies that the number of new clients brought in______ (had or did not have) a positive impact on the amount of sales generated.

Which of the following assumptions concerning the probability distribution of the random error term is stated incorrectly?

TABLE 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 Table 13-10, what is the value of the t test statistic when testing whether the number of customers who make purchase affects weekly sales?

If the correlation coefficient (r) = 1.00, then

TABLE 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 Table 13-10, the average weekly sales will increase by an estimated $10 for each additional purchasing customer.

The strength of the linear relationship between two numerical variables may be measured by the

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 director of cooperative education wanted to test the hypothesis that the true slope was equal to 0. For a test with a level of significance of 0.05, the null hypothesis should be rejected if the value of the test statistic is ________.

TABLE 13-4 The managers of a brokerage firm are interested in finding out if the number of new clients a broker brings intothe firm affects the sales generated by the broker. Theysample 12 brokersand determine the numberof new clients they have enrolled in the last year and their sales amountsin thousandsof 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 Table 13-4, the coefficient of determination is ______.

TABLE 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 Table 13-10, what are the degrees of freedom of the t test statistic when testing whether the number of customers who make purchase affects weekly sales?

TABLE 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 Table 13-10, what are the degrees of freedom of the F test statistic when testing whether the number of customers who make purchases is a good predictor for weekly sales?

Assuming a linear relationship between X and Y, if the coefficient of correlation (r) equals - 0.30,

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's Data Analysis tool 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 d f 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 Coefficients Standard Error t Stat p -value Intercept 3.962 1.440 2.75 0.016 Industry 0.040451 0.008048 5.03 0.000 -Referring to Table 13-5, the standard error of the estimate is _____ .

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____ .

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

TABLE 13-9 It is believed that, the average numbers of hours spent studying per day (HOURS) during undergraduate education should have a positive linear relationship with the starting salary (SALARY, measured in thousands of dollars per month) after graduation. Given below is the Excel output from regressing starting salary on number of hours spent studying per day for a sample of 51 students. NOTE: Some of the numbers in the output are purposely erased. Regression Stedistics Multiple R 0.8857 R Square 0.7845 Adjusted R Square 0.7801 Standard Error 1.3704 Observations 51 $\text { ANOVA }$ df SS MS F Significance F Regression 1 335.0472 335.0473 178.3859 Residual 1.8782 Total 50 427.0798 Coefficients Standard Enror t Stat p -value Lower 95\% Upper 95\% Intercept -1.8940 0.4018 -4.7134 2.051-05 -2.7015 -1.0865 Hours 0.9795 0.0733 13.3561 5.944-18 0.8321 1.1269 -Referring to Table 13-9, the error sum of squares (SSE) of the above regression is

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 director of cooperative education wanted to test the hypothesis that the true slope was equal to 3.0. The p-value of the test is between ______ and_____

TABLE 13- 11 A company that has the distribution rights to home video sales of previously released movies would like to use the box office gross (in millions of dollars) to estimate the number of units (in thousands of units) that it can expect to sell. 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 movie titles: Regression Statistics Multiple R 0.8531 RSquare 0.7278 Adjusted R Square 0.7180 Standard Error 47.8668 Observations 30 ANOVA d f SS MS F Significance F Regression 1 171499.78 171499.78 74.8505 2.1259E-09 Residual 28 64154.42 2291.23 Total 29 235654.20 Coefficients Standard Error t Stat p -value Lower 95\% Upper 95\% Intercept 76.5351 11.8318 6.4686 5.24-07 52.2987 100.7716 Gross 4.3331 0.5008 8.6516 2.13-09 3.3072 5.3590 -Referring to Table 13-11, there appears to be autocorrelation in the residuals.