Problem $3-14($Algo$)$

A tourist center is open on weekends $($Friday$,$ Saturday, and Sunday$).$ The ownermanager hopes to improve scheduling of part$-$time employees by determining seasonal relatives for each of these days. Data on recent traffic at the center have been tabulated and are shown in the following table:

$\backslash$table$[[,$Week$],[,1,2,3,4,5,6,],[$Friday$,147,157,157,157,162,167,],[$Saturday$,257,257,267,267,282,282,],[$Sunday$,167,167,177,177,177,187,]]$

Click here for the Excel Data File

a$.$ Develop seasonal relatives for the shop using the centered moving average method.

Note: Round your intermediate calculations and final answers to $2$ decimal places.