Homework Answers
| Period | Price |
| 1 | 82.87 |
| 2 | 83 |
| 3 | 83.61 |
| 4 | 83.15 |
| 5 | 82.84 |
| 6 | 83.99 |
| 7 | 84.55 |
| 8 | 84.36 |
| 9 | 85.53 |
| 10 | 86.54 |
| 11 | 86.89 |
| 12 | 87.77 |
| 13 | 87.29 |
| 14 | 87.99 |
| 15 | 88.8 |
| 16 | 88.8 |
| 17 | 89.11 |
| 18 | 89.1 |
| 19 | 88.9 |
| 20 | 89.21 |
a) Using Excel, go to Data, select Data Analysis, choose Regression. Put period in X input range and Price in Y input range. Tick Residuals.
| SUMMARY OUTPUT | |||||
| Regression Statistics | |||||
| Multiple R | 0.970857528 | ||||
| R Square | 0.94256434 | ||||
| Adjusted R Square | 0.93937347 | ||||
| Standard Error | 0.603819028 | ||||
| Observations | 20 | ||||
| ANOVA | |||||
| df | SS | MS | F | Significance F | |
| Regression | 1 | 107.6999465 | 107.6999 | 295.3942 | 1.29551E-12 |
| Residual | 18 | 6.562753534 | 0.364597 | ||
| Total | 19 | 114.2627 | |||
| Coefficients | Standard Error | t Stat | P-value | ||
| Intercept | 81.98942105 | 0.280492932 | 292.3048 | 1.51E-34 | |
| Period | 0.40243609 | 0.023415098 | 17.18703 | 1.3E-12 |
Price = 81.989 + 0.402*Period
b) For December 2, Period = 21
Forecast of 2nd December = 81.989 + 0.402*21 = 90.43
c) Durbin Watson
Using Excel:
Durbin Watson = SUMXMY2(F26:F44,F25:F43)/SUMSQ(F25:F44) = 0.798
dL = 1.2, dU = 1.41
H0: There is auto-correlation
H1: There is no auto-correlation
Since 0.798 falls between dL and dU, we do not reject the null hypothesis and conclude that auto-correlation is present.
Add Answer to:
83.99 14.55 8436 85.53 Date Now Nov, a Now, 7 Now Nov.9 Nov. 10 Nov. 11...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data. Compute the error of each forecast and then determine the mean absolute deviation of error for the forecast. B. Use exponential smoothing and a = 0.2 to forecast the data through 2006. Let the forecast for 1981 equal the actual value for 1980. Compute the error of each forecast and then determine the mean absolute deviation of error for...
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure,...
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking relate to the risk of strokes. Data from a portion of this study follow. Risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10-year period. For the smoker variable, 1 indicates a smoker and 0 indicates a nonsmoker. Risk Age Blood Pressure Smoker 14 58 201 0 23 82 98 1 25 74...
Risk Age Blood Pressure Smoker 10 59 220 1 33 67 129 0 14 68 170...
Risk
Age
Blood Pressure
Smoker
10
59
220
1
33
67
129
0
14
68
170
0
59
63
198
0
30
65
173
0
52
74
172
1
9
77
159
0
28
73
173
0
32
68
117
1
20
80
209
1
40
62
176
1
41
82
110
0
25
67
151
1
56
55
191
0
36
61
208
1
32
61
112
1
26
78
125
0
28
75
129
0
18
90
184...
A sample containing years to maturity and yield () for corporate bonds are contained in the...
A sample containing years to maturity and yield () for corporate
bonds are contained in the table below.
Company Ticker
Years
Yield
GE
1.00
0.767
MS
1.10
1.716
WFC
1.35
0.897
TOTAL
1.75
1.378
TOTAL
3.25
1.748
GS
3.75
3.558
MS
4.00
4.413
JPM
4.25
2.310
C
4.75
3.332
RABOBK
4.75
2.805
TOTAL
5.00
2.069
MS
5.00
4.739
AXP
5.00
2.181
MTNA
5.00
4.366
BAC
5.00
3.699
VOD
5.00
1.855
SHBASS
5.00
2.861
AIG
5.00
3.452
HCN
7.00
4.184
MS...
A 10-year study conducted by the American Heart Association provided data on how age, blood press...
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking relate to the risk of strokes. Data from a portion of this study follow. Risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10-year period. For the smoker variable, 1 indicates a smoker and 0 indicates a nonsmoker Click on the datafile logo to reference the data. DATA file Risk Blood Pressure Smoker...
* 1 10 7 23 19 4450 4456 10 20 a. Choose the correct scatter diagram...
* 1 10 7 23 19 4450 4456 10 20 a. Choose the correct scatter diagram for these data: ayl 60+ 10 20 30 40 50 60 10 20 30 40 50 60 Cy! 20. - 10 20 30 40 50 60 10 20 30 40 50 60 b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? There appears to be a - Select your answer - linear relationship between 2...
What is the relationship between the price of crude oil and the price you pay at...
What is the relationship between the price of crude oil and the price you pay at the pump for gasoline? The accompanying table shows the prices of crude oil and the price you pay at the pump for 24 consecutive months. Complete parts (a) through (h) below. Month Crude_Oil Gasoline 1 75 1.858 2 76 1.477 3 75 1.372 4 76 1.204 5 75 2.344 6 75 2.424 7 78 1.399 8 81 1.296 9 74 1.496 10 79 1.196...
i just beed help with part d on this problem. i do not understand why i...
i just beed help with part d on this problem. i do not
understand why i got the answer wrong. thank you in advance
b. Develop the estimated regression equation that could be used to predict the selling price given the number of square feet of living space (to 3 decimals). 1 required enter negative values as negative numbers. 9-59.011 115.09 c. At the os level, is there a significant relationship between the two variables? p-value is .000 less thanos...
Wins Data B C A Three-Point Field Goal % Field Goal % 1 Wins 38.9 56...
Wins Data B C A Three-Point Field Goal % Field Goal % 1 Wins 38.9 56 45.3 2 43.2 33.8 3 43 32.4 49 45.5 4 30.6 42.5 34 47 36.5 44.7 47 36.1 44.8 8 70 47.9 39,7 42 42.8 33.5 10 51 44.5 35.6 11 65 47.2 38.3 12 43.6 34.6 44 13 41 42.7 34,9 14 60 46.3 36.5 15 39 43.2 34.7 16 54 45.1 33.5 17 63 46.9 34.1 18 51 45.2 35.2 19 56...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data. Compute the error of each forecast and then determine the mean absolute deviation of error for the forecast. B. Use exponential smoothing and a = 0.2 to forecast the data through 2006. Let the forecast for 1981 equal the actual value for 1980. Compute the error of each forecast and then determine the mean absolute deviation of error for...
Risk
Age
Blood Pressure
Smoker
10
59
220
1
33
67
129
0
14
68
170
0
59
63
198
0
30
65
173
0
52
74
172
1
9
77
159
0
28
73
173
0
32
68
117
1
20
80
209
1
40
62
176
1
41
82
110
0
25
67
151
1
56
55
191
0
36
61
208
1
32
61
112
1
26
78
125
0
28
75
129
0
18
90
184...
A sample containing years to maturity and yield () for corporate
bonds are contained in the table below.
Company Ticker
Years
Yield
GE
1.00
0.767
MS
1.10
1.716
WFC
1.35
0.897
TOTAL
1.75
1.378
TOTAL
3.25
1.748
GS
3.75
3.558
MS
4.00
4.413
JPM
4.25
2.310
C
4.75
3.332
RABOBK
4.75
2.805
TOTAL
5.00
2.069
MS
5.00
4.739
AXP
5.00
2.181
MTNA
5.00
4.366
BAC
5.00
3.699
VOD
5.00
1.855
SHBASS
5.00
2.861
AIG
5.00
3.452
HCN
7.00
4.184
MS...
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking relate to the risk of strokes. Data from a portion of this study follow. Risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10-year period. For the smoker variable, 1 indicates a smoker and 0 indicates a nonsmoker Click on the datafile logo to reference the data. DATA file Risk Blood Pressure Smoker...
* 1 10 7 23 19 4450 4456 10 20 a. Choose the correct scatter diagram for these data: ayl 60+ 10 20 30 40 50 60 10 20 30 40 50 60 Cy! 20. - 10 20 30 40 50 60 10 20 30 40 50 60 b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? There appears to be a - Select your answer - linear relationship between 2...
i just beed help with part d on this problem. i do not
understand why i got the answer wrong. thank you in advance
b. Develop the estimated regression equation that could be used to predict the selling price given the number of square feet of living space (to 3 decimals). 1 required enter negative values as negative numbers. 9-59.011 115.09 c. At the os level, is there a significant relationship between the two variables? p-value is .000 less thanos...
Wins Data B C A Three-Point Field Goal % Field Goal % 1 Wins 38.9 56 45.3 2 43.2 33.8 3 43 32.4 49 45.5 4 30.6 42.5 34 47 36.5 44.7 47 36.1 44.8 8 70 47.9 39,7 42 42.8 33.5 10 51 44.5 35.6 11 65 47.2 38.3 12 43.6 34.6 44 13 41 42.7 34,9 14 60 46.3 36.5 15 39 43.2 34.7 16 54 45.1 33.5 17 63 46.9 34.1 18 51 45.2 35.2 19 56...
Most questions answered within 3 hours.
-
Required information
[The following information applies to the questions
displayed below.]
Satellite Systems modified its model...
asked 8 minutes ago -
When one molecule of methane combusts with oxygen, 5.74 X
10-21 J is released as heat....
asked 14 minutes ago -
High Normal blood pressure is categorized as which of
the following?
140-159/90-99
120/80
130-139/85-89
160/100
asked 16 minutes ago -
Please I need help with MATLAB .. PLease help me . Thankyou
Write Matlab code to...
asked 14 minutes ago -
You are saving towards purchasing a house and currently have
$20,000 in an account that earns...
asked 24 minutes ago -
Draw three resonance structures for each of
the following:
(a) -CH2NO2 (b) CH3CO2CH3
(c) -CH2CO2- (d)...
asked 31 minutes ago -
There has been discussion about people moving from Earth to Mars
in the future. An organization...
asked 30 minutes ago -
Starting Out with c++ Student Line Up Using Files A teacher has
asked all her students...
asked 32 minutes ago -
Two point charges totaling 9.00 µC exert a repulsive force of
0.200 N on one another...
asked 33 minutes ago -
In Visual Studio 2017
Populate a two-dimensional array with the following prices in
this table order:...
asked 43 minutes ago -
Answer below in detail
1. Reverse Logistics - Introduction
2. The world before and after reverse...
asked 48 minutes ago -
Find the area of the shaded region. The graph to the right
depicts IQ scores of...
asked 59 minutes ago