Question: PLEASE TYPE ANSWER IN THE EXCEL FORMULA. You've observed the following returns on Pine Computer's stock over the past five years: 8 percent, -12 percent,

PLEASE TYPE ANSWER IN THE EXCEL FORMULA.

You've observed the following returns on Pine Computer's stock over the past five years: 8 percent, -12 percent, 14 percent, 21 percent, and 16 percent. What was the arithmetic average return on the company's stock over this five-year period? What was the variance of 2 the company's returns over this period? The standard deviation? Input area: (Use cells A6 to B11 from the given information to complete this question. You must use the builtfunction to answers this question. Make sure to use the "sample" Excel formulas.)

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 Accounting Questions!

Sorry to bother you! When calculating the variance in the second question of this question, why is the denominator n-1? Is there a more intuitive way to understand this? Chapter 12 on 9. Calculating...

PLEASE type excel formual for the answer. You've observed the following returns on Pine Computer's stock over the past five years: 8 percent, -12 percent, 14 percent, 21 percent, and 16 percent. What...

You ve observed the following returns on Pine Computer's stock over the past five years: 8 percent, 12 percent, 14 percent, 21 percent, and 16 percent. Suppose the average inflation rate over this...

You own a portfolio invested 13.68% in Stock A, 13.75% in Stock B, 25.3% in Stock C, and the remainder in Stock D. The beta of these four stocks are 0.87, 0.65, 0.89, and 1.39. What is the portfolio...

You ve observed the following returns on Pine Computer's stock over the past five years: 13 percent, -13 percent, 20 percent, 25 percent, and 10 percent. Suppose the average Inflation rate over this...

Please explain each step very detail. Thank you. You've observed the following returns on Pine Computer's stock over the past five years: 10 percent, 11 percent, 18 percent, 19 percent, and 10...

12-10 Calculating Real Returns and Risk Premiums [LO1] Youve observed the following returns on Pine Computers stock over the past five years: 14 percent, 14 percent, 16 percent, 26 percent, and 10...

Youve observed the following returns on Pine Computers stock over the past five years: 25.5 percent, 14 percent, 31 percent, 2.5 percent, and 21.5 percent. The average inflation rate over this period...

Youve observed the following returns on Pine Computers stock over the past five years: 18 percent, 14 percent, 20 percent, 22 percent, and 10 percent. Suppose the average inflation rate over this...

I know the first answer is 11.80%. Can you help me find the answer to part A and B? You've observed the following returns on Doyscher Corporation's stock over the past five years: -12 percent, 21...

Select a company that competes in an industry in which you are interested. What are some of the recent demands that stakeholders have placed on this company? Can you find examples of how the company...

Write a FORTRAN 90 program to generate the matrix below :( use format statement to print the results). [0.00 1.00 4.00 1.50 0.00 16.00 25.00 9.00 B 1.25 0.75 0.00 [1.00 0.50 %3D 36.00 0.25 0.00

Which of the following is false? - when a firm has leverage conflict of interest and if investment doesn t have different - over investment problem occurs When shareholder

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

4-11 This project will help develop your Internet skills for using the privacy protection features of leading Web browser software. Examine the privacy protection features and settings for two...

4-15 Describe the weaknesses of Facebooks privacy policies and features. What management, organization, and technology factors have contributed to those weaknesses? Over the course of less than a...

4-7 Discuss the pros and cons of allowing companies to amass personal data for behavioral targeting.