Question: Year Return 1 35% 2 13% 3 9% 4 -12% 5 29% 6 16% 7 11% 8 -9% 9 46% 10 21% 11 -3% 12

Year Return
1 35%
2 13%
3 9%
4 -12%
5 29%
6 16%
7 11%
8 -9%
9 46%
10 21%
11 -3%
12 7%
13 19%
14 7%
15 5%
16 24%
17 6%
18 17%
19 -18%
20 16%
21 9%
22 15%
23 13%
24 6%
25 -20%

A) What is the Average Arithmetic Return?

B) What is the Average Geometric Return?

C) What is the variance?

D) What is the standard deviation?

E) What is the probability that the return will be greater than 12%?

Please use Excel functions.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Refer to the gasoline sales time series data in Table below to answer the following (Copy the file to Excel when done submit here) 1. Compute two- week , three-week and four-week moving averages for...

Q:

Using data from the past 25 years, an investor wants to test whether the average return on a stock is greater than 12%. Assume returns are normally distributed with a population standard deviation of...

Q:

Data presented on the table below are the returns of Growth and Value mutual funds 2017 Percentage Return Growth Value 10 but less than 20 2 2 20 but less than 30 9 9 30 but less than 40 13 20 40 but...

Q:

Data presented on the table below are the returns of Growth and Value mutual funds 2017 Percentage Return Growth Value 10 but less than 20 2 2 20 but less than 30 9 9 30 but less than 40 13 20 40 but...

Q:

Data presented on the table below are the returns of Growth and Value mutual funds 2017 Percentage Return Growth Value 10 but less than 20 2 2 20 but less than 30 9 9 30 but less than 40 13 20 40 but...

Q:

This assignment is for a Quantitative Methods in Finance class. We require just the final part of the project to be done. Specifically: For each stock, you need to use a word file to summarize your...

Q:

3. Use the Emergency room wait spreadsheet in file Chpt 6-2.xls. a. Draw a simple random sample of 60 records, using any method you choose. b. Test the null hypothesis at the 95 percent level of...

Q:

3. Use the Emergency room wait spreadsheet in file Chpt 6-2.xls. a. Draw a simple random sample of 60 records, using any method you choose. b. Test the null hypothesis at the 95 percent level of...

Q:

3. Use the Emergency room wait spreadsheet in file Chpt 6-2.xls. a. Draw a simple random sample of 60 records, using any method you choose. b. Test the null hypothesis at the 95 percent level of...

Q:

3. Use the Emergency room wait spreadsheet in file Chpt 6-2.xls. a. Draw a simple random sample of 60 records, using any method you choose. b. Test the null hypothesis at the 95 percent level of...

Q:

What specific audit procedures might have led to the detection of Accuhealths fraudulent cash and inventory schemes?

Q:

Sapling, Inc. is a 95%-owned subsidiary of Fir Enterprises. Fir Enterprises sells Sapling an industrial wood chipper for $10,000 on January 1, 20x8. Fir Enterprises paid $17,000 for the wood chipper...

Q:

Which of the following could be an effective tax planing strategy? Placing investments in the name of the higher earning spouse Selling assets in a year when the investor has significant other income...

Q:

The determination of specific, measurable, and verifiable objectives is the foundation of management by objectives. Group of answer choices True False

Q:

Discuss the concept of ethics in the management of human resources.

Q:

Define organizational culture.

Q:

Describe the link between an organizations culture and health and safety in the workplace.