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.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago