$30.00 A review of the different retailer companies' annual sales and annual profits by
Found in Education: General-EducationChapter 1, # 0
Rating (59):C-
Questions Asked: 3
Tutorials Posted: 761,
Blog Posts: 1,
Earned: $7,957.43
(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)
- This tutorial was purchased 3 times and rated A+ by students like you.
- Posted on Feb. 23, 2012 at 12:59:19AM