SUMMARY OUTPUT Regression Statistics Multiple R 0.960473 R Square 0.922509 Adjusted F 0.905288 Standard I 1.129804 Observati 12 ANOVA df Regression gnificance F 1E-05 S MS F 2 136.7619 68.38094 53.57089 Residual 9 11.48811 1.276457 Total 11 148.25 Coefficientsandord Err tStat P-value Lower 95%Upper 95%ɔwer 95.0%pper 95.0% Intercept 177.7025 35.42397 5.016447 0.000723 97.56788 257.8371 97.56788 257.8371 Advertisin -0.06789 0.036351 -1.86772 0.094643 0.15013 0.014338 -0.15013 0.014338 Increase it -2.28949 0.434127 -5.27377 0.000511 -3.27155 -1.30742 -3.27155 -1.30742 Questions: a. - Use the output shown above to write an equation that can be used to predict the number of computer sales - Interpret the coeffcients of the estimated regression equation that you found in part a. b. At 95% confidence, determine which variables are significant and which are not. If in a given day, the advertising cost were 844 million and the price per unit 17 million, what would you expect the number of computer sold be? c.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question
Please answer... I'm needed only 1 hours time to dd .... Thank u
SUMMARY OUTPUT
Regression Statisties
Multiple R 0.960473
R Square 0.922509
Adjusted F 0.905288
Standard I 1.129804
Observati
12
ANOVA
MS
gnificance F
df
2 136.7619 68.38094 53.57089
9 11.48811 1.276457
148.25
Regression
1E-05
Residual
Total
11
P-value tower 95%Upper 95%ɔwer 95.09pper 95.0%
Intercept 177.7025 35.42397 5.016447 0.000723 97.56788 257.8371 97.56788 257.8371
Coefficientsandard Err. tStat
Advertisin -0.06789 0.036351 -1.86772 0.094643 -0.15013 0.014338 -0.15013 0.014338
Increase it -2.28949 0.434127 -5.27377 0.000511 -3.27155 -1.30742 -3.27155 -1.30742
Questions:
a. - Use the output shown above to write an equation that can be used to predict the number
of computer sales
- Interpret the coefficients of the estimated regression equation that you found in part a.
At 95% confidence, determine which variables are significant and which are not.
If in a given day, the advertising cost were 844 million and the price per unit 17 million,
what would you expect the number of computer sold be?
b.
c.
Transcribed Image Text:SUMMARY OUTPUT Regression Statisties Multiple R 0.960473 R Square 0.922509 Adjusted F 0.905288 Standard I 1.129804 Observati 12 ANOVA MS gnificance F df 2 136.7619 68.38094 53.57089 9 11.48811 1.276457 148.25 Regression 1E-05 Residual Total 11 P-value tower 95%Upper 95%ɔwer 95.09pper 95.0% Intercept 177.7025 35.42397 5.016447 0.000723 97.56788 257.8371 97.56788 257.8371 Coefficientsandard Err. tStat Advertisin -0.06789 0.036351 -1.86772 0.094643 -0.15013 0.014338 -0.15013 0.014338 Increase it -2.28949 0.434127 -5.27377 0.000511 -3.27155 -1.30742 -3.27155 -1.30742 Questions: a. - Use the output shown above to write an equation that can be used to predict the number of computer sales - Interpret the coefficients of the estimated regression equation that you found in part a. At 95% confidence, determine which variables are significant and which are not. If in a given day, the advertising cost were 844 million and the price per unit 17 million, what would you expect the number of computer sold be? b. c.
1. A Computer store wants to know the effect of its advertising cost and computer price on
a number of computer sales over a period of 12 months. The following table provides
the data of the computer sales, advertising cost and price per unit computer:
Day
(y=
(xl=
(x2= Price
Computer
Advertising
per unit
Sales in
cost in
in
thousands)
millions)
millions)
1
98 860
10.0
97
855
10.5
3
95
850
10.7
4
94
840
10.7
5
95
845
11.0
6.
93
845
12.0
7
92
842
12.3
90
834
13.5
9.
88
835
14.0
10
90
800
15.0
11
88
785
16.0
12
87
780
16.5
The data is processed by using Excel and produce the following output:
Transcribed Image Text:1. A Computer store wants to know the effect of its advertising cost and computer price on a number of computer sales over a period of 12 months. The following table provides the data of the computer sales, advertising cost and price per unit computer: Day (y= (xl= (x2= Price Computer Advertising per unit Sales in cost in in thousands) millions) millions) 1 98 860 10.0 97 855 10.5 3 95 850 10.7 4 94 840 10.7 5 95 845 11.0 6. 93 845 12.0 7 92 842 12.3 90 834 13.5 9. 88 835 14.0 10 90 800 15.0 11 88 785 16.0 12 87 780 16.5 The data is processed by using Excel and produce the following output:
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Points, Lines and Planes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman