Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 27, 2023

Below are the daily price for ABC stock in the month June 2021. There are 30 observations. Write a VBA subroutine to calcualte the

Below are the daily price for ABC stock in the month June 2021. There are 30 observations. Write a VBA subroutine to calcualte the mean price and display the result in the blue cell. Date 01-06-2021 02-06-2021 03-06-2021 04-06-2021 05-06-2021 06-06-2021 07-06-2021 08-06-2021 09-06-2021 10-06-2021 11-06-2021 12-06-2021 13-06-2021 14-06-2021 15-06-2021 Price 22 12 13 12 12 12 16 15 14 16 17 17 17 18 18 19 Average()worksheet function: Average with VBA For Loop: 17.5333333

Step by Step Solution

★★★★★

3.44 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

VBA subroutine that calculates the mean price for the given daily prices and displays the result in ... blur-text-image

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

Recommended Textbook for

Complete Business Statistics

Authors: Amir Aczel, Jayavel Sounderpandian

7th Edition

9780071077903, 73373605, 71077901, 9780073373607, 77239695, 978-0077239695

More Books

Students also viewed these Finance questions

Question

★★★★★

The following data are from Gennings, Chinchilli, and Carter, (1989). An in vitro toxicity study of isolated hepatocyte suspensions was conducted to study the impact of combining carbon tetrachloride...

Answered: 1 week ago

Question

★★★★★

Lets create a computer called the Simpletron. As its name implies, its a simple machine, but powerful. The Simpletron runs programs written in the only language it directly understands: Simpleton...

Answered: 1 week ago

Question

★★★★★

The management of Mega Company, Inc. is considering the addition of a forceful quality management system in their strategic management plan for the next ten years of their operations as a...

Answered: 1 week ago

Question

★★★★★

Ag Bio Tech (ABT) was organized on January 1, 2013, by four friends. Each organizer invested $10,000 in the company and, in turn, was issued 8,000 shares of common stock. To date, they are the only...

Answered: 1 week ago

Question

★★★★★

The Yukon Corvelius Corporation needs to raise $45 million to finance its expansion into new markets. The company will sell new shares of equity via a general cash offering to raise the needed funds....

Answered: 1 week ago

Question

★★★★★

Using the compact storage technique described in Section 6.8, determine the vectors DIAG, OFFDIAG, COL, and ROW for the following matrix: S= 17 -9.1 25 0 -8.1 0 -1.1 -6.1 -9.1 -2.1 -7.1 0 0 -8.1 9 0...

Answered: 1 week ago

Question

★★★★★

When a car passes through a traffic junction, the delay (in minutes) caused by the red light in the traffic lights is a random variable X with distribution function (i) Explain why this is a mixed...

Answered: 1 week ago

Question

★★★★★

This was Joel Craig's first visit to the controller's corner office since being recruited for the senior accountant position in May. Because he'd been directed to bring with him his preliminary...

Answered: 1 week ago

Question

★★★★★

The three security requirements for hash functions are one - wayness, second preimage resistance and collision resistance.

Answered: 1 week ago

Question

★★★★★

Butler, Inc., operates at capacity and makes wooden playground equipment. Although Butlers swing sets and play forts are a matching set, they are sold individually and so the sales mix is not 1:1....

Answered: 1 week ago

Question

★★★★★

9. The Cost of Capital: Weighted Average Cost of Capital cost of new common stock should be used in the firm's WACC calculation. as its source of common equity? Do not round intermediate...

Answered: 1 week ago

Question

★★★★★

Scenario 1 Danielle is the office manager of a large business in the city. She is the only female staff member at the management level. The CEO (who is significantly older than her) often refers to...

Answered: 1 week ago

Question

★★★★★

987 Co. grants 123 Limited a sole license for the 987 CRM Software. Who may use the 987 CRM Software? O a. Only 123 O b. Only 987 O c. 123 and other licensees O d. 987 and the licensee

Answered: 1 week ago

Question

★★★★★

Risk preferences Investment 1 has a 50% chance of paying $100 and a 50% chance of paying $200. Investment 2 has a 50% chance of paying $50 and a 50% chance of paying $250. Both investments cost $130...

Answered: 1 week ago

Question

★★★★★

During the Covid-19 outbreak and Movement Restriction Order (MRO), daily routines of Malaysian has changed. Many business could not operate according to their normal routines and many business...

Answered: 1 week ago

Question

★★★★★

Below is a poorly written email. Rewrite it so that it includs the required points that define a professional business email. ( 1 0 marks ) Subject: URGENT Payment Issue Hey, I cannot believe you...

Answered: 1 week ago

Question

★★★★★

I need help finding the second answer FUTA taxes represent a substantial cost burden to companies. This is particularly the case where mass tayoffs are likely to increase the tax rate. Also. For...

Answered: 1 week ago

Question

★★★★★

For each equation, (a) Write it in slope-intercept form (b) Give the slope of the line (c) Give the y-intercept (d) Graph the line. 7x - 3y = 3

Answered: 1 week ago

Question

★★★★★

Refer to problem 3-7. Suppose that hedge funds must withhold $300 million from the income of the manager and an additional 5% of the remaining income. Find the expected net income of a manager in...

Answered: 1 week ago

Question

★★★★★

For problem 8-55, give a 95% confidence interval for the difference in proportion of theaters nationwide where one movie will be preferred over the other. Is the point 0 contained in the interval?...

Answered: 1 week ago

Question

★★★★★

Refer to problem 8-68. Give a 95% confidence interval for the difference in the proportions of defective items made by suppliers A and B. In problem, A company that makes electronic devices for use...

Answered: 1 week ago

Question

★★★★★

2. Explain how your research project minimizes risk and enhances benefits to participants.

Answered: 1 week ago

Question

★★★★★

13. There are key differences, as well as similarities, between quantitative and qualitative research.

Answered: 1 week ago

Question

★★★★★

4. Design a research project that demon- strates beneficence, respect for persons, and justice.

Answered: 1 week ago

Previous Question Next Question