Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3- use a function to calculate the average Open stock price of Mondays in cell K2. Copying this function down in column K should create
3- use a function to calculate the average Open stock price of Mondays in cell K2. Copying this function down in column K should create the average Open price for each weekday throughout the year.
4- Repeat step 3 for columns High, Low, Close, and Adj Close to calculate weekday averages for all these columns.
5- For Volume in column "P" calculate the total for each day.
Date | Open | High | Low | Close | Adj Close | Volume | Weekday | Weekday | Open | High | Low | Close | Adj Close | Volume | |||||||||||
7/13/20 | 135.220001 | 139.5 | 134.050003 | 135.130005 | 133.834274 | 1064000 | Monday | Monday | |||||||||||||||||
7/14/20 | 134.970001 | 139.580002 | 133.539993 | 138.580002 | 137.251205 | 1069800 | Tuesday | Tuesday | |||||||||||||||||
7/15/20 | 140.800003 | 143.970001 | 140.220001 | 143.679993 | 142.302307 | 912000 | Wednesday | Wednesday | |||||||||||||||||
7/16/20 | 143.470001 | 147.559998 | 142.979996 | 145.350006 | 143.956284 | 941400 | Thursday | Thursday | |||||||||||||||||
7/17/20 | 146.199997 | 146.220001 | 143.029999 | 144.860001 | 143.470978 | 386500 | Friday | Friday |
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