Microsoft Office Tutorials and References
In Depth Information
Case Study: Forecasting Using Regression Analysis
Case Study: Forecasting Using Regression Analysis
Suppose that you are responsible for forecasting the material needs
for a company that supplies roofing material. You have historical
trends of usage by year. You ve included past hurricane and reces-
sion data because those events caused extraordinary demand. Your
job is not only to predict how much roofing material you will sell,
assuming that there are no hurricanes, but how much you might want to
have lined up in case there are one, two, or three hurricanes. Here s
what you do:
11. As in the worksheet shown in Figure 14.18 , enter the actual data
in A4:D26. The sales in column D are the known_y's.
Search JabSto ::

Custom Search