Question

# \$30.00A review of the different retailer companies' annual sales and annual profits by

Found in Education: General-Education
Chapter 1, # 0
Posted by :

Rating (59):C-
Tutorials Posted: 761,
Blog Posts: 1,
Earned: \$7,957.43

Q:

(TCO E and F) A review of the different retailer companies' annual sales and annual profits by Fortune Magazine was performed to determine whether there is a correlation between the two variables. The analysis revealed the following:

Refer to the Minitab output below to answer questions A through G.

 Regression Equation Profits (billions of dollars) = 0.286133 + 0.0351855 Sales (billions of dollars) Coefficients Term Coef SE Coef T P 95% CI Constant Constant 0.286133 0.626256 0.45690 .0664 (-1.24626, 1.8185) Sales (billions of dollars) 0.035185 0.005166 6.81084 0.000 (0.02254, 0.04783)

 Summary of Model S = 1.35441 R-Sq = 88.55% R-Sq(adj) = 86.64% PRESS = 26.6328 R-Sq(pred) = 72.29%

 Analysis of Variance Source DF Seq SS Adj SS Adj MS F Regression 1 85.0941 85.0941 85.0941 46.3876 Sales (billions of dollars) 1 85.0941 85.0941 85.0941 46.3876 Error 6 11.0065 11.0065 1.8344 Total 7 96.1006 Source P Regression 0.0004912 Sales (billions of dollars) 0.0004912 Error Total

 Predicted Values for New Observations New Obs Fit SE Fit 95% CI 95% PI 1 3.80468 0.492009 (2.60078, 5.00859) (0.278677, 7.33069)

 Values of Predictors for New Observations New Obs Sales (billions of dollars) 1 100

(A) Analyze the above output to determine the regression equation. (10 points)
(B) What conclusions are possible using the meaning of b0 (intercept) and b1 (regression coefficient) in this problem? (That is, explain the meaning of the coefficients.) (10 points)
(C) What conclusions are possible using the coefficient of determination (r-squared)? (6 points)
(D) Calculate the coefficient of correlation. Interpret this value. (6 points)
(E) Does this data provide significant evidence (a=0.05) that the companies' profits are related to the amount of sales? Find the p-value and interpret. (6 points)
(F) Predict the average annual profits for annual sales of 100 billion dollars. (6 points)
(G) What is the 95% confidence interval for annual profits for annual sales of 100 billion dollars? What conclusion is possible using this interval? (6 points)

(Points : 50)

Tutorial

\$30.00
A review of the different retailer companies' annual sales and annual profits by
• This tutorial was purchased 3 times and rated A+ by students like you.
• Posted on Feb. 23, 2012 at 12:59:19AM
A:
Preview: ... dollars? What conclusion is possible using this interval? (6 points) (Points : 50)Â  1. (TCO E and F) A review of the different retailer companies' annual sales and annual profits by Fortune Magazine was performed to determine whether there is a correlation between the two variables. The analysis revealed the following: Refer to the Minitab output below to answer questions A through G. Regression Equation Â  Profits (billions of dollars) = 0.286133 + 0.0351855 Sales (billions of dollars) Â  Coefficients Â  Term Coef SE Coef T P 95% CI Constant Constant 0.286133 0.626256 0.45690 .0664 (-1.24626, 1.8185) Sales (billions of dollars) 0.035185 0.005166 6.81084 0.000 (0.02254, 0.04783) Â  Summary of Model Â  S = 1.35441 R-Sq = 88.55% R-Sq(adj) = 86.64% PRESS = 26.6328 R-Sq(pred) = 72.29% Â  Â  Analysis of Variance Â  Source DF Seq SS Adj SS Adj MS F Regression 1 85.0941 85.0941 85.0941 ...

The full tutorial is about 801 words long .