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...

70.2K

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

Basic Math
1.2K views

1. For the equation x2+y2?2x?4y?11=0, do the following. (a) Find the center (h,k) and radius r of...

Medical Sciences
1.2K views

Explain the full mechanism by which our heart pumps blood to the rest of the body...

Geometry
1.2K views

EM V Round your answer to the ne 2 S 13 5 The diagonal of...

Geometry
1.2K views

Three out of nine students in the computer club are getting prizes for first second...

Statistics
1.2K views

A 99 8 confidence interval for the mean number of personal computers is 2 703...

Algebra
1.2K views

Jill makes a blend of brownies for the garage sale The double chocolate brownies are...

Algebra
1.2K views

1 f x 4x 2 Find f 0

Accounting
1.2K views

3. Which of the following is true? a. Any realized loss in like-kind exchange is...

Accounting
1.2K views

The cost of an asset is $1,030,000, and its residual value is $140,000. Estimated useful...

Accounting
1.2K views

Use the following to answer questions 11-13 The Cardinals purchased new equipment at a cost...

Accounting
1.2K views

Cash Flows from Operating ActivitiesIndirect Method Staley Inc. reported the following data: ...

Accounting
1.2K views

Benjamin and Chloe (MFJ) have pension income (fully taxable) of $50,000 and tax-exempt interest of$4,000....