Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 1 You have observed a particular stock over the past year. Monthly returns have been as follows: - 7 % , - 7 %

QUESTION 1
You have observed a particular stock over the past year. Monthly returns have been as follows: -7%,-7%,11%,-8%,0%,2%,2%,-5%,-1%,-2%,-4%,11%. Using Excel, calculate the average monthly returns to the nearest hundredth of a percent (.01). The average function is =average().
QUESTION 2
You have observed a particular stock over the past year. Monthly returns have been as follows: 1%,-6%,9%,-7%,12%,-4%,-9%,-1%,11%,2%,-6%,-11%. Using Excel, calculate the standard deviation. For the standard deviation of a sample, use = stdev.s().
7.886986
8.005207
6.680478
6.939129
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

blur-text-image

Step: 3

blur-text-image

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

The Complete Direct Investing Handbook

Authors: Kirby Rosplock

1st Edition

1119094712, 978-1119094715

More Books

Students also viewed these Finance questions