Question
In: Statistics and Probability
Consider the applications for home mortgages data in the file of P12_04.xlsx. Create a time series...
- Consider the applications for home mortgages data in the file of P12_04.xlsx.
- Create a time series chart of the dat
- Use simple exponential smoothing to forecast these data, using the default smoothing constant of 0.1
- Calculate the three types of forecast errors, RMSE, MAE, and MAPE
- Use the solver function in excel to optimize the smoothing constant in order to generate a minimum MAPE value.
- Use multiple regression to develop an equation that can be used to predict future applications for home mortgages (hint: use dummy variables for the quarters and create a time variable for the quarter numbers)
| Quarter | Year | Applications |
| 1 | 1 | 96 |
| 2 | 1 | 114 |
| 3 | 1 | 112 |
| 4 | 1 | 81 |
| 1 | 2 | 97 |
| 2 | 2 | 103 |
| 3 | 2 | 120 |
| 4 | 2 | 99 |
| 1 | 3 | 105 |
| 2 | 3 | 110 |
| 3 | 3 | 117 |
| 4 | 3 | 96 |
| 1 | 4 | 74 |
| 2 | 4 | 94 |
| 3 | 4 | 100 |
| 4 | 4 | 96 |
| 1 | 5 | 95 |
| 2 | 5 | 122 |
| 3 | 5 | 113 |
| 4 | 5 | 100 |
| 1 | 6 | 102 |
| 2 | 6 | 96 |
| 3 | 6 | 116 |
| 4 | 6 | 98 |
Solutions
orchestra answered 2 years agoRelated Solutions
Consider the applications for home mortgages data in the file of P12_04.xlsx. Use multiple regression to...
Consider the applications for home mortgages data in the file of
P12_04.xlsx. Use multiple regression to develop an equation that
can be used to predict future applications for home mortgages
(hint: use dummy variables for the quarters and create a time
variable for the quarter numbers)
Quarter
Year
Applications
1
1
96
2
1
114
3
1
112
4
1
81
1
2
97
2
2
103
3
2
120
4
2
99
1
3
105
2
3
110
3...
Consider the following time series data.
Consider the following time series data. Week123456Value181516131716a. Choose the correct time series plot.What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616 MSE: The forecast for week 7: c. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616MSE: The...
Consider the following time series data.
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
5
8
10
2
2
4
8
3
1
4
6
4
3
6
8
(b)
Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise.
If required,...
Consider a text file that you will create named “employees.txt”. The file contains data organized according...
Consider a text file that you will create named “employees.txt”.
The file contains data organized according to the following
format:John Smith 10 15Sarah Johnson 40 12Mary Taylor 27 13Jim
Stewart 25 8For instance, “John” is the first name, “Smith” is the
last name, “10” is the number of hours per week, and “15” is the
hourly rate.Write a program that computes the weekly salary of each
employee. The program prints the first name, last name, and weekly
salary of each...
(a) Create the correct time series plot. Which type of pattern exists in the data?
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
4
6
7
2
0
1
4
3
3
5
6
4
5
7
8
(a) Create the correct time series plot. Which type of pattern
exists in the data?
(b) Use a multiple regression model with dummy variables as
follows to develop an equation to account for seasonal effects in
the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter...
Consider the following time series data. Excel File: data17-35.xls Quarter Year 1 Year 2 Year 3...
Consider the following time series data.
Excel File: data17-35.xls
Quarter
Year 1
Year 2
Year 3
1
4
6
7
2
2
3
6
3
3
5
6
4
5
7
8
b. Show the four-quarter and centered moving
average values for this time series (to 3 decimals if
necessary).
Year
Quarter
Time Series Value
Four-Quarter Moving Average
Centered Moving Average
1
1
4
2
2
3.25
3
3
________
4
4
5
_______
_________
2
1
6
_________
4.75...
Consider the following gasoline time series data. Click on the datafile logo to reference the data....
Consider the following gasoline time series data. Click on the
datafile logo to reference the data. show the exponential smoothing
forecasts using = 0.1. Applying the MSE measure of forecast
accuracy, would you prefer a smoothing constant of = .1 or = .2 for
the gasoline sales time series (to 2 decimals)? MSE for = .1 9.25
MSE for = .2 8.98 Are the results the same if you apply MAE as the
measure of accuracy (to 2 decimals)? MAE...
Consider the following time series.
Consider the following time series.
t
1
2
3
4
5
yt
5
10
10
15
14
(a)
Choose the correct time series plot.
(i)
(ii)
(iii)
(iv)
- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item
1
What type of pattern exists in the data?
- Select your answer -Positive trend patternHorizontal
stationary patternVertical stationary patternNegative trend
patternItem 2
(b)
Use simple linear regression analysis to find the parameters
for the line that minimizes MSE for this time series....
The file HW_05.xlsx contains data from a survey of 105 randomly selected households. a. Interpret the...
The file HW_05.xlsx contains data from a survey
of 105 randomly selected households.
a. Interpret the ANOVA table for this model. In particular, does
this set of independent variables provide at least some power in
explaining the variation in the dependent variable? Report the F
ratio statistics and p- value for this hypothesis
test.
b. Interpret coefficients of independent variables in the
model.
c. Using the regression output, determine which of the
independent variables should be excluded from the regression...
Consider the following time series. (a) Choose the correct time series plot. (i)...
Consider the following time series.
(a)
Choose the correct time series plot.
(i)
(ii)
(iii)
(iv)
- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1
What type of pattern exists in the data?
- Select your answer - Horizontal PatternDownward Trend PatternUpward Trend PatternItem 2
(b)
Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.
Do...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are...
- What is the potential of a cell made up of Zn|Zn2+ and Cu|Cu2+ half-cells at 25o...
- 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...
ADVERTISEMENT