Mean, Median, Quartile 1 and 3, with IQR with Excel formula calculations assista
ID: 3297982 • Letter: M
Question
Mean, Median, Quartile 1 and 3, with IQR with Excel formula calculations assistance needed. I have attemped 4 times to get the formula's I have researched to match to MyStatLab with no luck. I am still waiting to hear back from my professor on these as well and would like some help. Please review the below question and my excel file attached and advise where I went wrong and could you help me correct the formula's in Excel to match MyStatLab and send the file back to me. I have Excel 2016 and I used the formulas in this video https://www.youtube.com/watch?v=eVYat7BVr5A
Assignments MBA 6300, Quantitative Business Analysis, Fall 1 2017 Online, C Lorie Paulin Homework: Chapter 3 Practice Problems Save Score: 9.38 of 25 pts 2014 (4 complete) HW Score: 70.83%, 70.83 of 100 pts 3.1.33 Question Help Use the data set below, which contains the 12-month returns (in percent) for a collection of mutual funds, to complete parts a) through d). The histogram for the data is shown to the right. 18853 10766 6.203 31.125 25.736 10.867 8.431 9.571 3.385 13.669 20.276 87.914 14.766 30.073 9.327 16.059 6.092 15.109 - 10.636 28.357-8.741 7.00713.971 24.649 0 20 40 60 80 Twelve-Month Return (%) The median is 13.820% (Round to three decimal places as needed.) Q1 = 6.605% (Round to three decimal places as needed.) Q3-22.463% (Round to three decimal places as needed.) b) Find appropriate measures of center and spread for these data Which of the following best describes the center and spread for these data? A. The median is 13.820 and the IQR is 15.858 ° C. The mean is 15.665 and the IQR is 15.858 B. The mean is 15.665 and the range is 98.550 D. The median is 15665 and the standard deviation is 19.166Explanation / Answer
Correct option is mean 15.665 and range is 98.55.
Answer shown in the image is not correct.
Medium 13.82 Q1 6.806 Q3 21.36925 interquartile 14.56325 Max 87.914 Min -10.636 Range 98.55 Mean 15.66529 Std. 19.16583