Technology operations management

[IWasRaisedOnEDM]

Year 3 years ago
Spring. 18
Summer. 10
Fall. 26
Winter. 42


Year 2 years ago
Spring. 26
Summer. 18
Fall. 34
Winter. 50


Year last year
Spring. 34
Summer 26
Fell. 42
Winter. 58


1.what is the centered moving average for each season
2.what is the season relative for each season
3. What is the linear regression trend line for these data (t=1 for spring three years ago)
4. What is this years seasonally adjusted forecast for each season


I believe I got the chart right for the first two, trying to learn this. Thanks in advance.

 

[stapel]

What did you do? What did you get? What do you mean by "the first two"? With what are you seeking assistance?

Please be complete. Thank you!

 

[IWasRaisedOnEDM]

What did you do? What did you get? What do you mean by "the first two"? With what are you seeking assistance?

Please be complete. Thank you!

I started a chart listing everything vertically. Then calculated what I thought my ma4 was. I though I has the answer to questions 1/2 but I am still lost. The questions numbered above are what I need help with. The data is above that. Thanks.