Problem $3-44($Pivot Tables$)$

The file P$03\_44.$xIsx contains daily values of the S&P Index from $1970$ to mid$-2015.$ It also contains percentage changes in the index from each day to $t$ average of $\%$ Change in the Values area and Date in the Rows area. You will see every single date, with no real averaging taking place. This problem lets naturally on a date variable. For each part below, explain the result briefly. $($Note that if you are using Excel $2016,$ grouping by date will be done automa

a$.$ Group by Month.

Month with Minimum Average of $\%$ change is

Month with Maximum Average of $\%$ change is

b$.$ Group by Year.

Year with Minimum Average of $\%$ change is

Year with Maximum Average of $\%$ change is

c$.$ Group by Month and Year.

Year with Minimum Average of $\%$ change for September is

Year with Maximum Average of $\%$ change for September is

d$.$ Group by Quarter.

Quarter with Minimum Average of $\%$ change is

Quarter with Maximum Average of $\%$ change is

e$.$ Group by Month and Quarter.