Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The file P03_44.xisx contains dally values of the S&P Index from 1970 to mid-2015. It also contains percentage changes in the Index from each day
The file P03_44.xisx contains dally values of the S&P Index from 1970 to mid-2015. It also contains percentage changes in the Index from each day to the next. Create a pivot table with 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 you explore how you can group 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 automatically.) a. Group by Month. Month with Minimum Average of % change is September v. Month with Maximum Average of % change Is |December | O. b. Group by Year. Year with Minimum Average of % change is X 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 X d. Group by Quarter. Quarter with Minimum Average of % change Is Quarter3 Quarter with Maximum Average of % change is Quarter4 v . e. Group by Month and Quarter. Month with Minimum Average of % change for Quarter2 is | June | Month with Maximum Average of % change for Quarter2 is April f. Group by Quarter and Year. Year with Minimum Average of % change for Quarter2 is X Year with Maximum Average of % change for Quarter2 is g. Group by Month, Quarter, and Year. Month with Minimum Average of % change for Quarter4 of 1970 is |October V O Month with Maximum Average of % change for Quarter4 of 1970 is December P02_56 (1).xIsx
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started