Question

In: Statistics and Probability

Calculate Percentile in Excel for DIS, DAX, Nikkei225 and FTSE100. Please also plot a histogram in...

Calculate Percentile in Excel for DIS, DAX, Nikkei225 and FTSE100.

Please also plot a histogram in your Excel file.

Date

DIS

DAX

Nikkei225

FTSE100

7/1/18

102.54

27.46

22304.51

7636.90

7/2/18

103.05

27.32

21811.93

7547.90

7/3/18

101.79

27.41

21785.54

7593.30

7/4/18

101.79

27.41

21717.04

7573.10

7/5/18

103.06

27.87

21546.99

7603.20

7/6/18

103.33

27.95

21788.14

7617.70

7/7/18

103.33

27.95

21788.14

7617.70

7/8/18

103.33

27.95

21788.14

7617.70

7/9/18

104.56

28.15

22052.18

7688.00

7/10/18

104.57

28.30

22196.89

7692.00

7/11/18

106.55

27.70

21932.21

7592.00

7/12/18

106.76

27.89

22187.96

7651.30

7/13/18

108.48

27.83

22597.35

7661.90

7/14/18

108.48

27.83

22597.35

7661.90

7/15/18

108.48

27.83

22597.35

7661.90

7/16/18

108.68

28.13

22597.35

7600.50

7/17/18

108.78

28.28

22697.36

7626.30

7/18/18

109.16

28.32

22794.19

7676.30

7/19/18

110.58

28.16

22764.68

7684.00

7/20/18

109.94

28.09

22697.88

7678.80

7/21/18

109.94

28.09

22697.88

7678.80

7/22/18

109.94

28.09

22697.88

7678.80

Solutions

Expert Solution


Related Solutions

Calculate Quantiles and Percentile in Excel for DIS, DAX, Nikkei225 and FTSE100. Please also plot a...
Calculate Quantiles and Percentile in Excel for DIS, DAX, Nikkei225 and FTSE100. Please also plot a histogram in your Excel file. Date DIS DAX Nikkei225 FTSE100 7/1/18 102.54 27.46 22304.51 7636.90 7/2/18 103.05 27.32 21811.93 7547.90 7/3/18 101.79 27.41 21785.54 7593.30 7/4/18 101.79 27.41 21717.04 7573.10 7/5/18 103.06 27.87 21546.99 7603.20 7/6/18 103.33 27.95 21788.14 7617.70 7/7/18 103.33 27.95 21788.14 7617.70 7/8/18 103.33 27.95 21788.14 7617.70 7/9/18 104.56 28.15 22052.18 7688.00 7/10/18 104.57 28.30 22196.89 7692.00 7/11/18 106.55 27.70 21932.21...
Using Excel to Plot a Histogram This exercise is to be completed using Microsoft Excel and...
Using Excel to Plot a Histogram This exercise is to be completed using Microsoft Excel and will be turned in on Thursday, September 20th in class. You are to follow the steps we used in class on 9-13-2018 to construct the histogram for the data consisting of the ages of the 50 most powerful women in the world from 2012 (Source: Page 39 of textbook via Forbes Magazine). Your work should have columns for: 1. the raw data; 2. the...
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on...
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on return rates appear normally distributed? On the basis of z-scores do you find evidence of outliers? Hint: the formula for a return is (Current Price – Previous price)/Previous price multiplied by 100. Date Weekly Return BIT 11/3/13 -46.16 18/3/13 -0.01 25/3/13 39.23 1/4/13 13.07 8/4/13 23.93 15/4/13 41.36 22/4/13 26.5 29/4/13 20.39 6/5/13 25.5 13/5/13 42.52 20/5/13 37.88001 27/5/13 15.66 3/6/13 20.98 10/6/13 25.28...
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on...
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on return rates appear normally distributed? On the basis of z-scores do you find evidence of outliers? Hint: the formula for a return is (Current Price – Previous price)/Previous price multiplied by 100. Date BIT 11/3/13 52.06 18/3/13 53.84 25/3/13 99.99 1/4/13 139.23 8/4/13 113.07 15/4/13 123.93 22/4/13 141.36 29/4/13 126.5 6/5/13 120.39 13/5/13 125.5 20/5/13 142.52 27/5/13 137.88 3/6/13 115.66 10/6/13 120.98 17/6/13 125.28...
v Create a graph (either a histogram, box plot or stem and leaf plot … pick...
v Create a graph (either a histogram, box plot or stem and leaf plot … pick just one). Your graph could have either 5, 6 or 7 classes, depending on how you set it up. Create a table and list the class boundaries and the frequency in each class. You must explain to me in detail if you used fewer than 5 classes or more than 7 classes.
Please attach R code: Use library(nycflights13) a. plot histogram for distance where carrier is "FL". Print...
Please attach R code: Use library(nycflights13) a. plot histogram for distance where carrier is "FL". Print graph(s). b. plot Two box plots side by side for distance where carrier are "FL" and “US”. Print graph(s). c. plot two histograms and two box plots in one graph where carrier are "FL" and “US”, equal scale for each box plot pair. Print graph(s).
Create a histogram of this data with 15 bins. Create a box plot of this data.
7, 9, 8, 11, 14, 7, 11, 17, 18, 12, 10, 9, 16, 17, 15, 13, 7, 12, 7, 8, 14, 16, 20, 12, 11, 14, 22, 8, 10, 14, 15, 20, 17, 14, 12, 22, 12, 15, 17, 16, 9, 11, 16, 18, 11, 12, 11, 9, 11, 9, 13, 7, 12, 9, 19, 9, 8, 15, 12, 16, 16, 20, 21, 9, 11, 17, 17, 8, 11, 7, 10, 17, 13, 15, 14, 11, 19,10, 11, 11, 9,...
Let Excel choose the classes and do a frequency distribution and histogram for HEADLEN. Let Excel...
Let Excel choose the classes and do a frequency distribution and histogram for HEADLEN. Let Excel find the descriptive statistics for the column HEADLEN. An anthropologist found what appears to be a prehistoric bear skull. How could he use this data on headlengths taken from bears to assess his find? Identify at least two other professional fields that might use similar sets of measurements in conducting research. HEADLEN 17.0 16.5 16.5 16.0 16.0 16.0 15.5 15.5 15.5 15.5 15.5 15.0...
What are the advantages and dis-advantages of the measures of economic efficiency. Also, what are the...
What are the advantages and dis-advantages of the measures of economic efficiency. Also, what are the strengths and weaknesses of each of the measures of economic efficiency as they relate to capital allocation and decision making.
For the next two questions please ensure that you plot graphs in excel and paste them...
For the next two questions please ensure that you plot graphs in excel and paste them and the solver output in a word document. I do not need to see your excel files. 4. Use the information below to find the implied volatilities for Exxon Mobil May call prices. Plot the implied volatilities versus the strike prices. What are your inferences from the shape of the implied volatility curve? Exxon Mobil (XOM) 04/29/2010 call prices Current Stock Price Strike Price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT