Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 3- use a function to calculate the average open st

3- use a function to calculate the average Open stock price of Mondays in cell...

60.1K

Verified Solution

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!
Become a Member

Other questions asked by students

Accounting
1.2K views

Waterway Family Instruments makes cellos. During the past year, the company made 6,380 cellos even though...

Physics
1.2K views

c KE per unit volume d KE per unit mass 5 The average kinetic energy...

Basic Math
1.2K views

A regular heptagon with 7 sides is inscribed in a circle with radius 9 millimeters....

Algebra
1.2K views

6 6pts A population is currently 7 000 and is increasing by 1 2 per...

Accounting
1.2K views

16- ill...

Accounting
1.2K views

Sports Spectacular purchased 1,000 shares of stock in The Athletic Warehouse for $30 per share....

Accounting
1.2K views

Highland Company produces a lightweight backpack that is popular with college students. Standard variable costs...

Accounting
1.2K views

The company's past experience indicates that 70% of the accounts receivable are collected in the...

Accounting
1.2K views

20) An equipment supply manager at a large outlet needs to prepare a Direct Labor...

Accounting
1.2K views

Which of the following statements is true when providing non-audit services to an IESBA audit...

Accounting
1.2K views

Saved A company has an overhead application rate of 121% of direct labor costs. How...

Accounting
1.2K views

Question 55 of 75. Luke was physically present in the United States for 110 days...