Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The file P03_44.xlsx contains daily 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.xlsx 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 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 Month with Maximum Average of % change Is December 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 Quarter3 v Quarter with Maximum Average of % change is Quarter4 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 Year with Maximum Average of % change for Quarter2 is g. Group by Month, Quarter, and Year. x Month with Minimum Average of % change for Quarter4 of 1970 is October Month with Maximum Average of % change for Quarter4 of 1970 is December

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Basic For Beginners

Authors: Kavishankar Panchtilak

1st Edition

979-8860644588

More Books

Students also viewed these Accounting questions