Exam 13: Simple Linear Regression

TABLE 13-8 It is believed that GPA (grade point average, based on a four point scale) should have a positive linear relationship with ACT scores. Given below is the Excel output for predicting GPA using ACT scores based a data set of 8 randomly chosen students from a Big-Ten university. $\text { Regressing GPA on ACT }$ Regression Statistics Multiple R 0.7598 R Square 0.5774 Adjusted R Square 0.5069 Standard Error 0.2691 Observations 8 $\text { ANOVA }$ df SS MS F Significance F Regression 1 0.5940 0.5940 8.1986 0.0286 Residual 6 0.4347 0.0724 Total 7 1.0287 Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 0.5681 0.9284 0.6119 0.5630 -1.7036 2.8398 ACT 0.1021 0.0356 2.8633 0.0286 0.0148 0.1895 -Referring to Table 13-8, the interpretation of the coefficient of determination in this regression is

When r = -1, it indicates a perfect relationship between X and Y.

If the correlation coefficient (r)= 1.00, then

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, suppose the director of cooperative education wants to construct a 95% 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 ________.

Testing for the existence of correlation is equivalent to

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 least squares estimate of the slope 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 standard error of the estimated slope coefficient is ________.

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 total sum of squares (SST)is ________.

You give a pre-employment examination to your applicants. The test is scored from 1 to 100. You have data on their sales at the end of one year measured in dollars. You want to know if there is any linear relationship between pre-employment examination score and sales. An appropriate test to use is the t test of the population correlation coefficient.

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 H₀: ρ = 0 against the two-sided alternative H₁: ρ ≠ 0. To test H₀: ρ = 0 against the one-sided alternative H₁: ρ < 0 at a significance level of 0.1, the p-value is

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

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, the null hypothesis for testing whether there is a linear relationship between revenue and the number of downloads is "There is no linear relationship between revenue and the number of downloads."

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 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. The p-value of the test is ________.

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 managers of the brokerage firm wanted to test the hypothesis that the number of new clients brought in did not affect the amount of sales generated. The value of the test statistic is ________.

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 population slope?

The residuals represent

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 population slope was equal to 3.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 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, suppose the managers of the brokerage firm want to construct a 99% confidence interval estimate for the mean sales made by brokers who have brought into the firm 24 new clients. The t critical value they would use 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 total sum of squares (SST)is ________.

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, what percentage of the variation in composite score can be explained by the variation in spending per student?