Question
In: Statistics and Probability
Please show all steps using data set below and excel. By using a bivariate regression trend...
Please show all steps using data set below and excel.
- By using a bivariate regression trend line model, forecast total houses sold for the next five years.
- Prepare a time series plot of these data (years are on the x axis, THS is on the y axis) that shows both actual and forecast THS for the next five years.
Total Houses Sold
| Year | Northeast | |
| 1996 | 74.00 | |
| 1997 | 78.00 | |
| 1998 | 81.00 | |
| 1999 | 76.00 | |
| 2000 | 71.00 | |
| 2001 | 66.00 | |
| 2002 | 65.00 | |
| 2003 | 79.00 | |
| 2004 | 83.00 | |
| 2005 | 81.00 | |
| 2006 | 63.00 | |
| 2007 | 65.00 | |
| 2008 | 35.00 | |
| 2009 | 31.00 | |
| 2010 | 31.00 | |
| 2011 | 21.00 | |
| 2012 | 29.00 | |
| 2013 | 31.00 | |
| 2014 | 28.00 | |
| 2015 | 24.00 | |
| 2016 | 32.00 |
Solutions
Expert Solution
The output is:
The formulas are:
The answer is:
| Period | Demand (y) | Period(x) | Forecast | |
| Period 1 | 74 | 1 | 87.12554 | |
| Period 2 | 78 | 2 | 83.86061 | |
| Period 3 | 81 | 3 | 80.59567 | |
| Period 4 | 76 | 4 | 77.33074 | |
| Period 5 | 71 | 5 | 74.0658 | |
| Period 6 | 66 | 6 | 70.80087 | |
| Period 7 | 65 | 7 | 67.53593 | |
| Period 8 | 79 | 8 | 64.271 | |
| Period 9 | 83 | 9 | 61.00606 | |
| Period 10 | 81 | 10 | 57.74113 | |
| Period 11 | 63 | 11 | 54.47619 | |
| Period 12 | 65 | 12 | 51.21126 | |
| Period 13 | 35 | 13 | 47.94632 | |
| Period 14 | 31 | 14 | 44.68139 | |
| Period 15 | 31 | 15 | 41.41645 | |
| Period 16 | 21 | 16 | 38.15152 | |
| Period 17 | 29 | 17 | 34.88658 | |
| Period 18 | 31 | 18 | 31.62165 | |
| Period 19 | 28 | 19 | 28.35671 | |
| Period 20 | 24 | 20 | 25.09177 | |
| Period 21 | 32 | 21 | 21.82684 | |
| Intercept | 90.39047619 | |||
| Slope | -3.264935065 | |||
| Forecast | 18.56190476 | 22 | ||
| 15.2969697 | 23 | |||
| 12.03203463 | 24 | |||
| 8.767099567 | 25 | |||
| 5.502164502 | 26 |
The plot is:
orchestra answered 1 year agoRelated Solutions
Both parts please, show work a) Run a regression analysis on the following bivariate set of...
Both parts please, show work
a) Run a regression analysis on the following bivariate set of
data with y as the response variable.
x
y
49.3
65.5
34.7
103.1
60.4
50.5
43.6
78.9
23.5
109.8
40.9
71.3
38.9
60.6
31.3
96.6
43
97.2
41.9
68.2
40.4
79.7
Verify that the correlation is significant at an ?=0.05?=0.05.
If the correlation is indeed significant, predict what value (on
average) for the explanatory variable will give you a value of
109.5 on the...
Using your calculator, run a regression analysis on the following bivariate set of data with y...
Using your calculator, run a regression analysis on the
following bivariate set of data with y as the response
variable.
x y
71.2 23.1
90.8 122.9
88.8 82.9
57.7 18.3
71.4 8.6
60.4 25.9
60.2 -43.1
88.5 77.4
68.2 -5.9
41.1 -83
61.4 -2.5
87.1 39.4
Find the correlation coefficient and report it accurate to three
decimal places. r =
What proportion of the variation in y can be explained by the
variation in the values of x? Report answer...
Use the data set which is labeled below and answer using regression output in excel i....
Use the data set which is labeled below and answer using
regression output in excel
i. Find the correlation coefficients between Y and X1, X2 and X3
and test the significance of population correlation coefficient
using the value of r calculated for X2 and X3.
ii. Estimate the regression equation for Y and X1, Y and X2 and
report the results and explain the intercept and slope
coefficients.
iii. Check the significance or insignificance of the independent
variables? and explain...
Show all calculation details by not using a calculator or Excel answers. Consider the data set:...
Show all calculation details by not using a calculator or Excel
answers. Consider the data set: (7,11), (10,0), (13,-2).
A. Compute and interpret the coefficient of correlation.
B. Compute the least squares line for this data (no need to
repeat computations from above).
a) Run a regression analysis on the following bivariate set of data with y as the...
a) Run a regression analysis on the following bivariate set of
data with y as the response variable.
x
y
10.7
81.6
13.7
81.5
36.7
56.5
4
72.1
50.7
23.2
47.6
-4.8
37.3
31.9
24.3
75.2
21.5
59.3
17.2
54.6
23.6
75.5
22.2
60.8
29.3
51
14
63.4
0.2
102.7
30.7
48.2
10.3
74.8
26.5
48.2
23.1
87
Verify that the correlation is significant at an ?=0.05?=0.05.
If the correlation is indeed significant, predict what value (on
average) for the...
Using the data below, calculate the appropriate test. Do this manually and show all steps. The...
Using the data below, calculate the appropriate test. Do
this manually and show all steps.
The data reflects word retention for older adults with early
onset Alzheimer's before a memory game was played and after the
game was played.
Before the Memory Game
After the Memory Game
4
8
5
9
2
6
5
7
6
9
5
9
3
6
4
6
3
7
5
9
8
9
7
6
6
9
5
10
7
9
6
7
9...
8. Run a regression analysis on the following bivariate set of data with y as the...
8. Run a regression analysis on the following bivariate set of
data with y as the response variable.
x
y
27.2
68.2
28.1
66.7
28.7
64.6
30.2
66.4
33.7
69.5
31.8
68.3
30.4
67.8
28.6
65.5
32.5
69.4
34.8
67.9
33.3
67.1
28
66.1
- Find the correlation coefficient and report it accurate to
three decimal places.
r =
- What proportion of the variation in y can be
explained by the variation in the values of x? Report
answer...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
15.5
58.8
25.4
62.9
53.7
68.8
46.5
78.6
28.5
57.5
5.7
68.1
-0.4
67.8
43.8
87.7
23.1
64.9
31.3
81.3
48.2
80.1
15.9
71.1
1) Find the correlation coefficient and report it accurate to
three decimal places.
r =
2) What proportion of the variation in y can be
explained by the variation in the values of x? Report
answer as...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
81
81.3
92.6
90.8
80.1
94.9
77.8
53.4
89.4
102.9
70.3
38.2
90.2
98
81.4
94.6
94.9
122.4
77.2
42.1
70.6
47.8
71
50.6
Find the correlation coefficient and report it accurate to three
decimal places.
r =
What proportion of the variation in y can be explained by
the variation in the values of x? Report answer as a
percentage...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data
with y as the response variable.
x
y
73
16.1
80
14.9
72.5
8.5
55.8
33.6
54.6
23.4
76.6
26.2
74.6
19.1
40.2
40.6
58.7
25.8
Find the correlation coefficient and report it accurate to three
decimal places.
What proportion of the variation in y can be explained by
the variation in the values of x? Report answer as a
percentage accurate to one decimal place. (If the answer...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- what effect would DNP have on ATP production? if added to culture media, which of the...
- - True to its name, computer networking technologies allow computers of many kinds to be connected...
- 1. (a) Kyan Barron has been made jobless from a managerial position in a financial institution...
- (Calculating the geometric and arithmetic average rate of return) The common stock of the Brangus Cattle...
- --- TURN this Code into Java Language --- #include <iostream> #include <string> using namespace std; //...
- The following bivariate data set contains an outlier. x y 53.3 151.7 37.1 -307.3 44.6 -469.7...
- Washington County’s Board of Representatives is considering the construction of a longer runway at the county...
ADVERTISEMENT