Question

A regression model relating x, number of salespersons at a branch office, to y, annual sales...

A regression model relating x, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where n total=26.

a. Write the estimated regression equation (to whole number).

y=_____+_____x

b. Compute the F statistic and test the significance of the relationship at a .05 level of significance. (to 2 decimals)

F-value ____

p-value is _______, we _________ h0

c. Compute the statistic and test the significance of the relationship at a .05 level of significance. (to 2 decimals)

T - Stat =____

d. Predict the annual sales at the Memphis branch office. This branch employs 14 salespersons. (to whole number)

ANOVA
df SS MS F Significance F
Regression 6545.1
Residual
Total 8597.7
Coefficients Standard Error Stat P-value
Intercept 76 10.453
Number of Salespersons 43 5.799
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) y=76+43*x

b) F-value =MSR/SSE =(6545.1/1)/(2052.6/24)=76.53

p-value is =0.0000

we _reject___ h0

c)

t stat =43/5.799 =7.42

d)

Predicted annual sales =76+43*14=678

Add a comment
Know the answer?
Add Answer to:
A regression model relating x, number of salespersons at a branch office, to y, annual sales...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A regression model relating number of salespersons at a branch office, to y, annual sales at...

    A regression model relating number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where th =26. ANOVA SS MS F Significance F u Significance Regression Residual Total 8756.4 p-value 510 s.com Coefficients Standard Error Stat Intercept 7 7.0 10.723 Number of 5.609 Salespersons Write the estimated regression equation (to whole number). V= b. Compute the statistic and test the...

  • A regression model relating 3, number of salespersons at a branch office, to y, annual sales...

    A regression model relating 3, number of salespersons at a branch office, to y, annual sales at the office in thousands of dollars) provided the following computer output from a regression analysis of the data. Where ntotal = 32. ANOVA df MSF Significance F SS 6863.5 Regression Residual Total 9342.6 Stat P-value Intercept Number of Salespersons Coefficients 88.0 54.0 Standard Errort 12.175 5.865 a. Write the estimated regression equation (to whole number). y= Xx b. Compute the F statistic and...

  • A regression model relating 2, number of salespersons at a branch office, to y, annual sales...

    A regression model relating 2, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where Miotal = 30. 0 ANOVA 0 MSF Significance F SS 6361.5 Regression Residual Total 8844.6 P-value 85.0 5.418 Coefficients Standard Error Stat Intercept 10.553 Number of 43.0 Salespersons a. Write the estimated regression equation (to whole number). y= + b. Compute the F statistic...

  • for b. the p-value is (less than 0.01, between 0.01 and 0.025, between 0.025 and 0.05, between 0.05 and 0.10, or greate...

    for b. the p-value is (less than 0.01, between 0.01 and 0.025, between 0.025 and 0.05, between 0.05 and 0.10, or greater than 0.10), we (Reject, Accept) H0 for c. the p-value is (less than 0.01, between 0.01 and 0.025, between 0.025 and 0.05, between 0.05 and 0.10, or greater than 0.10), we (Reject, Accept) H0 Check My Work (3 remaining) eBook A regression model relating 2, number of salespersons at a branch office, to y, annual sales at the...

  • The commercial division of a real estate firm is conducting a regression analysis of the relationship...

    The commercial division of a real estate firm is conducting a regression analysis of the relationship between 2, annual gross rents (in thousands of dollars), and y selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y=20.0 +7.22 X Predictor Constant Coef 20.000 7.220 SE Coef 3.2213 1.3625 T 6.21 SS Analysis of Variance SOURCE Regression Residual Error 41,587.3 Total 51,984.4...

  • A shoe store developed the following estimated regression equation relating sales to inventory investment and advertising...

    A shoe store developed the following estimated regression equation relating sales to inventory investment and advertising expenditures where 1inventory investment ($1000s) = advertising expenditures ($1000s) y sales ($1000s) The data used to develop the model came from a survey of 10 stores; for those data, SST 16,000 and SSR a. Compute SSE, MSE, and MSR (to 2 decimals, if necessary) 12,000 SSE MSE MSR b. Use an F test and α .05 level of significance to determine whether there is...

  • The commercial division of a real estate firm is conducting a regression analysis of the relationship...

    The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y=20.0 + 7.21 X Predictor Constant Coef 20.000 7.210 SE Coef 3.2213 1.3625 T 6.21 5.29 Analysis of Variance SOURCE Regression Residual Error Total SS...

  • The commercial division of a real estate firm is conducting a regression analysis of the relationship...

    The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y =20.0 + 7.21 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X 7.210 1.3628 5.29 Analysis of Variance SOURCE DF SS Regression...

  • The commercial division of a real estate firm is conducting a regression analysis of the relationship...

    The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y = 20.0 + 7.23 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X   7.230 1.3625 5.29 Analysis of Variance SOURCE DF SS...

  • A real estate research firm has developed a regression model relating list price (Y in 1,000)...

    A real estate research firm has developed a regression model relating list price (Y in 1,000) with two independent variables. The two independent variables are number of bedrooms and size of the property. Part of the regression results are shown below. ANOVA MS Regression 256881.37 128440.68 Residual 42 726699.96 17302.38 Coefficients Standard Error Star Intercept 54.298 # Bedrooms 53.634 71.326 5.271 33.630 Acres 21.458 1. What has been the sample size? (2 Points) 2. What is the value of the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT