Question: Suppose that you work for a U.S. senator who is contemplating writing a bill that would put a national sales tax in place. Because the

Suppose that you work for a U.S. senator who is contemplating writing a bill that would put a national sales tax in place. Because the tax would be levied on the sales revenue of retail stores, the senator has asked you to prepare a forecast of retail store sales for year 8, based on data from year I through year 7. The data are:
Year Retail Store Sales
1…………………….$1,225
2. …………………….1,285
3………………………1,359
4………………………1,392
5………………………1,443
6………………………1,474
7………………………1,467
a. Use the first naive forecasting model presented in this chapter to prepare a forecast of retail store sales for each year from 2 through 8.
b. Prepare a time-series graph of the actual and forecast values of retail store sales for the entire period. (You will not have a forecast for year 1 or an actual value for year 8.)
c. Calculate the root-mean-squared error for your forecast series using the values for year 2 through year 7.

Step by Step Solution

3.39 Rating (177 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

blur-text-image
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)

Excel file Icon

647-M-S-L-R (6184).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!