ZuoTi.Pro
Question

For this and the next 4 questions: Please use the following data to answer the questions...

For this and the next 4 questions: Please use the following data to answer the questions that follow. You may copy over the data to Excel and use spreadsheet functions to perform the required analyses. Calculate the covariance between the Market and Stock A. Be sure to correct for sample.

Year

Market

Stock A

Stock B

1

-0.10

-0.17

0.057

2

0.08

0.20

0.057

3

0.05

0.10

0.057

4

0.15

0.25

0.057

5

0.06

0.07

0.057

0.0145

-0.00268

0.0000

0.976

None of the above

2.

Calculate the COVARIANCE BETWEEN STOCK B AND MARKET.

0.0145

-0.00268

0.0000

0.976

None of the above

What is the VARIANCE OF STOCK A?

0.0084

0.0265

0.0000

None of the above

What is the STANDARD DEVIATION OF THE MARKET?

0.0915

0.1626

0.0000

None of the above
business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Market Stock A 0.17 0.2 Year 0.08 0.05 0.15 0.06 Stock B 0.057 0.057 0.057 0.057 0.057 0.25 0.07 7 5 8 9 Covariance 10 Variance 11 Standard deviation 12 13 1 -COVARIANCE.S(C3:C7,B3:B7) -VAR.S(C3:C7) -COVARIANCE.S(D3:D7,B3:B7) STDEV.S(B3:B7) -C9 15 2 16 17 18 19 4 20 21 -D9 C10 -B11

0 0
Add a comment
Know the answer?
Add Answer to:
For this and the next 4 questions: Please use the following data to answer the questions...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • For this and the next 4 questions: Please use the following data to answer the questions...

    For this and the next 4 questions: Please use the following data to answer the questions that follow. You may copy over the data to Excel and use spreadsheet functions to perform the required analyses. 1. Calculate the covariance between the Market and Stock A. 2. Calculate the COVARIANCE BETWEEN STOCK B AND MARKET. 3. What is the VARIANCE OF STOCK A? 4. What is the STANDARD DEVIATION OF THE MARKET? Year Market Stock A Stock B 1 -0.10 -0.17...

  • Thank you... Using the data from the table what is the volatility of an equally weighted...

    Thank you... Using the data from the table what is the volatility of an equally weighted portfolio of Alaska Air (ALK), Kellogg (K), and Microsoft (MSFT) stock? Hint Make sure to round all intermediate calculations to at least four decimal places. The volatility of an equally weighted portfolio of the three stocks is %. (Round to two decimal places.) Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) General Mills 179% Historical Annual...

  • Use the data shown below to answer the questions in the spaces provided: WEIGHTS 0.50 0.50...

    Use the data shown below to answer the questions in the spaces provided: WEIGHTS 0.50 0.50 Year Market Bake Date HomeChef PORTFOLIO 0.37 0.26 0.47 0.30 -0.54 -0.20 0.15 0.07 0.00 0.15 0.07 -0.14 0.18 -0.04 -0.15 -0.22 4 -0.13 -0.28 0.02 -0.14 0.11 0.40 0.10 -0.18 6 0.30 0.17 -0.23 0.26 -0.10 0.42 7 0.04 0.30 8 -0.18 -0.04 -0.32 -0.03 0.52 0.75 0.28 0.38 10 0.0780 0.0920 0.0640 0.0800 0.2295 avg stdev 0.3660 0.2390 0.1908 2.9429 3.978 3.734...

  • Use the following information to answer the next FOUR (4) questions: The following data are available...

    Use the following information to answer the next FOUR (4) questions: The following data are available relating to the performance of Zeta Stock Fund and the market portfolio: Zeta Market Average Return 0.13 0.15 Std. Dev. of Returns 0.35 0.3 Beta 0.9 Tracking Error 0.11 Average PE The risk-free rate during the sample periods was 0.07 18 18. Calculate the Jensen measure of performance for Zeta Fund. 19. Calculate the Treynor measure of performance for Zeta Fund. 20. Calculate the...

  • Please calculate the chemical shift for Ha using the "Aromatic Proton Shift Calculation" Table. Ha H3C02C...

    Please calculate the chemical shift for Ha using the "Aromatic Proton Shift Calculation" Table. Ha H3C02C CN MezN Hb Hc Answer: Fr Jump to... CHEM 308 Class 15.04.2024 CHEM 308 AROMATIC PROTONS CHEMICAL SHIFT CALCULATION SHEET H Zomo DAH = 7.36 + Zorme + Zmeta + Zpara Z mets Zpara Zi for R (ppm) Substituent R Zortho Zmeta Zpara Zmet Zpara H CH, 0.0 -0.18 0.02 0.02 -0.07 C(CH3) CHCI CH,OH 0.0 -0.11 -0.08 -0.01 -0.07 Zi for R (ppm)...

  • Please answer the NMR tables for wintergreen and Pear, can you please make it as neat...

    Please answer the NMR tables for wintergreen and Pear, can you please make it as neat as possible thanks! WINTERGREEN Pear The procedure below is written as if you were conducting this experiment in the lab. You will nee to read through it carefully to complete the lab report and answer the questions appropriately For NMR analyses, complete the spectral assignments as shown in the example below. Example of a 'H-NMR analysis table: HoHo Ha Iodomethane Há На Chemical Shift...

  • Use the data provided below to answer the following questions: 0.50 WEIGHTS 0.50 HomeChef PORTFOUO Market...

    Use the data provided below to answer the following questions: 0.50 WEIGHTS 0.50 HomeChef PORTFOUO Market Bake Date Year 0.26 0.15 -0.14 -0.15 0.02 -0.18 0.42 0.30 0.47 -0.54 0.37 1 0.07 2 -0.20 0.18 0.15 0.07 -0.28 0.40 0.00 0.22 -0.04 -0.14 0.10 0.26 -0.13 6 0.11 0.17 -0.23 0.30 8 0.30 -0.10 0.04 -0.03 0.38 -0.32 -0.18 -0.04 0.28 0.0640 0.2390 0.75 10 0.52 avg stdev 0.0800 0.0920 0.0780 0.2295 0.1908 0.3660 CV 3.978 2.386 3.734 2.9429 НС...

  • Use the following information to answer questions 7 - 8: The Old Folks Tour Bus drives...

    Use the following information to answer questions 7 - 8: The Old Folks Tour Bus drives people to the casino every day and monitors how much they won/lost every day. They have come up with the following table to describe the winning/losing tendencies of gamblers at the casino. Win Loss -S1,000 -$500 -$200 $0 $100 $400 S800 Amount Probability 0.10 0.15 0.10 0.20 0.25 0.15 0.05 7. What is the expected value of this distribution? (In other words, what is...

  • Page 4 of 5 Use the following table of reaction time data below to answer questions...

    Page 4 of 5 Use the following table of reaction time data below to answer questions 16-21. Random With Warning Regular With Distraction Auditory Cue 0.13 0.13 0.1 0.15 0.39 0.13 0.1 0.13 0.58 0.1 0.22 0.07 0.2 0.2 0.14 0.09 0.49 0.2 0.18 0.26 0.19 0.09 0.34 0.13 0.17 0.16 0.14 0.23 0.13 0 0.3 0.21 0.2 0.11 0 0.4 0.14 0.12 0 0.14 Мean 0.16 0.15 0.06 16. How do distractions affect reaction time? 0.36 0.18 T4 takis...

  • # Use the following table to answer questions 18 through 19 Number of bananas Total utility...

    # Use the following table to answer questions 18 through 19 Number of bananas Total utility $0.30 0.45 0.55 0.63 0.70 18. Suppose the table above show the total utility a consumer can get from buying and eating bananas. How much is his marginal utility from consuming the 3rd banana. A. $0.45 B. $0.20 C. $0.15 D. $0.10 5 19. If the market price of banana is $0.08 each, based on the optimal decision rule, how many bananas should he...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT