3- use a function to calculate the average Open stock price of Mondays in cell...
60.1K
Verified Solution
Link Copied!
Question
Accounting
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
