Daily high temperatures in St$.$ Louis for the last week were as follows: $92,92,95,95,97,90,93($yesterday$).$

a$)$ The high temperature for today using a $3-$day moving average $=$ degrees $($round your response to one decimal place$).$

b$)$ The high temperature for today using a $2-$day moving average $=91\mathrm{.}5$ degrees $($round your response to one decimal place$).$

c$)$ The mean absolute deviation based on a $2-$day moving average $=9$ degrees $($round your response to one decimal place$).$

d$)$ The mean squared error for the $2-$day moving average $=8\mathrm{.}4$ degrees ${?}^2($round your response to one decimal place$).$

e$)$ The mean absolute percent error $($MAPE$)$ for the $2-$day moving average $=2\mathrm{.}7\%($round your response to one decimal place$).$

d$)$ The mean squared error for the $2-$day moving average $=8\mathrm{.}4$ degrees ${?}^2($round your response to one decimal place$).$

e$)$ The mean absolute percent error $($MAPE$)$ for the $2-$day moving average $=2\mathrm{.}7\%($round your response to one decimal place$).$

I have attached my excel worksheet as well.