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...
NOT using Excel, please show all steps. A bank is planning to install a new computerized...
NOT using Excel, please show all steps.
A bank is planning to install a new computerized accounts
system. Bank management has determined the activities required to
complete the project, the precedence relationships of the
activities, and activity time estimates as follows: NOT using
Excel, please show all steps.
Activity
Description
Predecessor
a
m
b
a
Position recruiting
—
5
8
17
b
System development
—
3
12
15
c
System training
a
4
7
10
d
Equipment training
a
5...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1. Practice searching 2. Continue learning the significance of special cases! 3. Learning how to write...
- Prepare journal entries to record each of the following PURCHASES transactions for Pink Pagoda Co. Please...
- 1. Uncle Iroh’s just made a mass M of tea, but it comes off the kettle...
- Assignment Star Company has been manufacturing 10,000 units of Part 13 per month. At this level of...
- How would I write a code from this following word problem? 3. Use the pow() and...
- Give an example of a 2x2 matrix of numbers that represent the changes in the size...
- Every COBOL program I've browsed professionally has had Paragraph numbers. It is somewhat of Programmer Preference/Art...
ADVERTISEMENT