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 2 years 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...
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
- Write a Java Program using the following instruction: Create the following 3 methods that calculate and...
- How would the S/D curves shift if a $3 tax was imposed on suppliers for each...
- Why should a time-based authentication system invalidate the current password on a successful authentication?
- Explain the difference between a market penetration strategy and a market development strategy.
- QUESTION 4 Discuss the sanctity of life versus the quality of life debate as presented by...
- 0.560 g He, 20.482 g F2, and 13.960 g Ar are placed in a 18.4-L container...
- Let X ∼ Pois(4), Y ∼ Pois(12), U ∼ Pois(3) be independent random variables. a) What...
ADVERTISEMENT