Hey I have another business analytics assignment that is due on Sunday. Can you let me know if you can do it and the price. I also attached the files
Here are the instructions:
Time Series Lab Activity
1) Consider the following time series data:
Week
1
2
3
4
5
6
Value
18
13
16
11
17
14
Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:
Mean absolute error
Mean squared error
Mean absolute percentage error
What is the forecast for week 7?
2) Use the same data in Q 1 but with the average of all historical data method, obtain the
Mean absolute error
Mean squared error
Mean absolute percentage error
What is the forecast for week 7?
3)
Consider the following time series data:
Week
1
2
3
4
5
6
Value
18
13
16
11
17
14
Construct a time series plot. What type of pattern exists in the data? You can use JMP to obtain the plot or Excel
Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Example in tutorial video
Use alpha=.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Example in tutorial video
Compare the three-week moving average forecast with the exponential smoothing forecast . Which appears to provide the better forecast based on MSE? Explain.
Practice Activities
Use the MortgageDefault Dataset for Q1 and Q2: MortgageDefault.xlsx Download MortgageDefault.xlsx
Q1)
Formulate a hypothesis on the relationship between Annual Income and Mortgage Amount.
What is your null hypothesis?
What is your dependent and independent variable?
Create a Scatter plot to assess the bi-variate relationship between Annual Income and Mortgage Amount.
What is the correlation coefficient?
Are the two variable correlated?
Add a fit line to the scatter plot
What is the regression equation for the two variable?
Interpret the result (regression equation) See example below
What is the RSquare of the model?
Describe the fit of the model?
What is the p-value?
Do you reject or accept your null hypothesis?
Q2
Formulate a hypothesis on the relationship between Marital Status and DefaultonMortgage
What is your null hypothesis?
What is your dependent and independent variable?
Create cross tabulation of the relationship between Marital Status and DefaultonMortgage
What is the Chi square value
Are the two variable related?
Do you reject your null hypothesis?
What is the p-value?
PLACE THIS ORDER OR A SIMILAR ORDER WITH Nursing League TODAY AND GET AN AMAZING DISCOUNT
