Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please calculate the mean, standard deviation, median (50 th percentile value), 5 th percentile value and the 1 st percentile value of monthly return rates,

Please calculate the mean, standard deviation, median (50th percentile value), 5th percentile value and the 1st percentile value of monthly return rates, and create a table with these values. (Use the = PERCENTILE.INC() function in MS excel to calculate percentile values.) image text in transcribed

High null Low Close Adi Close null Volume null Date 2017/12/1 2018/1/1 2018/2/1 2018/3/1 2018/4/1 2018/5/1 2018/6/1 2018/7/1 2018/8/1 2018/9/1 2018/10/1 2018/11/1 2018/12/1 2018/12/3 Open null 1187.32 1273.99 1187.32 1251.42 1251.420044 73366640000 1248.27 1258.88 1120.08 1201.87 1201.869995 79579410000 1202.46 1235.97 1131.98 1157.37 1157.369995 76349800000 1153.54 1192.22 1118.691160.73 1160.72998 1158.41 1206.85 1138.55 1188.911188.910034 75617280000 1194.91226.48 1182.93 1194.5 1188.68 1261.57 1185.61 1241.76 1241.76001 1246.28 1292.94 1236.41286.9 1286.90002469238220000 1284.52 1304.27 1267.62 1294.27 1294.27002 1300.38 1309.73 1159.55 1208.84 1208.839966 91327930000 1211.33 1253.12 1161.12 1225.19 1225.189941 80080110000 1240.01 1244.34 1231.92 1238.63 1238.630005 null null 69648590000 1194.5 77439710000 64542170000 62492080000 4186060000 0 0 0 0 1238.63 1238.630005

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

Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

11th Edition

1259277178, 978-1259277177

More Books

Students also viewed these Finance questions

Question

Write as a single integral in the form J, f(x) dx:

Answered: 1 week ago

Question

Name the four components of a database system. AppendixLO1

Answered: 1 week ago

Question

3. Give short, clear directions before, not during, transitions.

Answered: 1 week ago