Please answer ASAP
b. The S & P 500 index rose at an annual rate of 10.819% over the 30-month period between May 2018 and November 2020. Did your stock perform better or worse than the S & P 500 index? Divide your data into subgroups. I suggest something on the order of six subgroups, but your data may demand a different number. Construct a grouped frequency and relative frequency distribution using the chart below. Class Limits Frequency Class Limits Frequency Class Limits Frequency 6. Construct a grouped histogram based on these data on the axes below and to the left. | not used - + - Math 154 Excel Project 5 (15 points) Name Chapters 5 and 6 Due: 2021 April 21 John Scalea Page 3 7. Construct a grouped relative frequency distribution using the chart below. Then, use the circle on the next page to construct a pie chart based on these data. Class Relative Central Class Relative Central Class Relative Central Limts Freq Angle | Limits Freq Angle Limits Freq AngleMath 154 Excel Project 5 (15 points) Name Chapters 5 and 6 Due: 2021 April 21 John Scalea Page 4 8. Plot your stock prices as a function of time on the axes below. Adjust the scales on the axes as appropriate to your data.Page 1 1. List the name of the stock you analyzed. Briefly describe the data you collected and your data source. 2. Enter your data elements in the table below. Adjust the table as necessary for your data. If you prefer, attach a separate sheet. Please list a minimum of 31 data elements. Date Price Date Price Date Price 3. Use Microsoft Excel to calculate the following statistics based on these data. For parts a, b, d and e, list the Excel command you used in addition to listing the result. a. Find the mean. b. Find the median. c. Find the mode(s). d. Find the range. e. Find the standard deviation. f. Find the first quartile. g. Find the third quartile. h. Draw a box and whisker plot of your data on the diagram below. Add coordinates to the horizontal line as appropriate to reflect your data. Math 154 Excel Project 5 (15 points) Name Due: 2021 April 21 Chapters 5 and 6 Page 2 John Scalea 4. a. Calculate annual the rate of return on one share of your stock for the period you chose. You may perform your calculation either by hand or using Excel. If you work by hand, use the continuous growth model (F = Pe" ).\f+---5---7---9--11---1---3---5---7---9--11---1---3---5---7---9--11 2018 2019 2020
