Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

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

Bicomplex Holomorphic Functions The Algebra, Geometry And Analysis Of Bicomplex Numbers

Authors: M Elena Luna Elizarrarás, Michael Shapiro, Daniele C Struppa, Adrian Vajiac

1st Edition

3319248685, 9783319248684

More Books

Students also viewed these Mathematics questions