Question: Suppose that you work for a major U.S. retail department store that has outlets nationwide. The store offers credit to customers in various forms, including
Suppose that you work for a major U.S. retail department store that has outlets nationwide. The store offers credit to customers in various forms, including store credit cards, and over the years has seen a substantial increase in credit purchases. The manager of credit sales is concerned about the degree to which consumers are using credit and has started to track the ratio of consumer installment credit to personal income. She calls this ratio the credit percent, or CP, and has asked that you forecast that series for year 8. The available data are:
Year CP
1…………………..12.96
2…………………..14.31
3…………………..15.34
4…………………..15.49
5…………………..15.70
6…………………..16.00
7…………………..15.62
a. Use the first naive model presented in this chapter to prepare forecasts of CP for years 2 through 8.
b. Plot the actual and forecast values of the series for the years 1 through 8. (You will not have an actual value for year 8 or a forecast value for year 1.)
c. Calculate the root-mean-squared error for your forecasts for years 2 through 7.
Year CP
1…………………..12.96
2…………………..14.31
3…………………..15.34
4…………………..15.49
5…………………..15.70
6…………………..16.00
7…………………..15.62
a. Use the first naive model presented in this chapter to prepare forecasts of CP for years 2 through 8.
b. Plot the actual and forecast values of the series for the years 1 through 8. (You will not have an actual value for year 8 or a forecast value for year 1.)
c. Calculate the root-mean-squared error for your forecasts for years 2 through 7.
Step by Step Solution
★★★★★
3.28 Rating (163 Votes )
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Document Format (1 attachment)
647-M-S-L-R (6186).xlsx
300 KBs Excel File
