The number of cans of soft drinks sold in a machine each week is recorded below:
Weekly Period	1	2	3	4	5	6	7	8
Soft Drinks Sold	122	85	92	98	110	108	115	102
Weekly Period	9	10	11	12	13	14	15	16
Soft Drinks Sold	95	98	105	125	85	106	140	84
Weekly Period	17	18	19	20	21	22	23	24
Soft Drinks Sold	92	85	78	105	111	152	140	108
a. Using Excel, develop forecasts for periods of 1 to 24, using a trend line.
b.Calculate the MSE and MAD for your model.
c. Calculate the R statistic and intepret it.

Explain step by step how to solve and input using excel spreadsheet.