17.9k views
0 votes
Is this better?

3. Calculate a Nine Week Simple Moving Average
4. Plot your Nine Week Simple Moving Average on same worksheet as your original forecast
Products Sold Per Week [ 800 ] [ 600 ] [ 200 ] 3/1

1 Answer

1 vote

Final answer:

Using the linear regression model, the sales predictions for day 60 and day 90 are $250.12k and $324.52k, respectively, when substituting the days into the equation îy = 101.32 + 2.48x.

Step-by-step explanation:

To calculate sales predictions for specific days using the provided linear regression model, îy = 101.32 + 2.48x, where îy represents the sales in thousands of dollars, and x is the day within the 90-day period. To predict the sales on day 60, we substitute x with 60 and for day 90, we replace x with 90 in the linear model.

To calculate the sales prediction for day 60:

  • îy = 101.32 + 2.48(60)
  • îy = 101.32 + 148.80
  • îy = 250.12
  • To calculate the sales prediction for day 90:
    îy = 101.32 + 2.48(90)
  • îy = 101.32 + 223.20
  • îy = 324.52

The sales predictions in thousands of dollars for day 60 and day 90 are $250.12k and $324.52k, respectively.

User Adam Hyland
by
7.3k points