need all answers

CORREL function - Office Suppor X C Chegg eReader C Financial res 99.com/homework-help/financial analysis-with-microsoft excel-7th-edition-chapter-15-problem-4p-soluti hegg Study Textbook Solutions Expert Q&A Study Pack Practice NEW E Chapter 15, Problem 4P Bookmark Show all steps: ON Problemi Financial researchers have found various violations of market efficiency that are referred to as *calendar effects." Using the S&P 500 1950 to 2013 Daily.xlsx file from the official website: a. Create a pivot table and pivot chart that shows the average percentage change by day of the week for the entire period. Are the average returns different for each day? If so, which are the best and worst days of the week? b. Now add the Decade field to the Row area of your pivot table. Are there any decades in which Mondays had a positive average return? c. Change your pivot table to show the average daily return by month for the entire period. What is the best month on average? Which is the worst? Does this vary by decade? d. What was the best decade in which to invest based on average daily return? What was the sum of the daily returns in each decade (ignore compounding of returns)? Step-by-step solution CORREL function - Office Suppor X C Chegg eReader C Financial res 99.com/homework-help/financial analysis-with-microsoft excel-7th-edition-chapter-15-problem-4p-soluti hegg Study Textbook Solutions Expert Q&A Study Pack Practice NEW E Chapter 15, Problem 4P Bookmark Show all steps: ON Problemi Financial researchers have found various violations of market efficiency that are referred to as *calendar effects." Using the S&P 500 1950 to 2013 Daily.xlsx file from the official website: a. Create a pivot table and pivot chart that shows the average percentage change by day of the week for the entire period. Are the average returns different for each day? If so, which are the best and worst days of the week? b. Now add the Decade field to the Row area of your pivot table. Are there any decades in which Mondays had a positive average return? c. Change your pivot table to show the average daily return by month for the entire period. What is the best month on average? Which is the worst? Does this vary by decade? d. What was the best decade in which to invest based on average daily return? What was the sum of the daily returns in each decade (ignore compounding of returns)? Step-by-step solution