Find IQR, median value and describe in terms of the problem, statistics homework help
Statistics

Tutor: None Selected  Time limit: 1 Day 
Let W be the number of games that are played per best of seven World Series. Results from the last 107 World Series, which can be assumed to be enough, follow:
No. of games played in a best of seven World Series (w)  World Series 

4  19 
5  27 
6  24 
7  36 
8  1 
Use the above table to answer:
 Find its IQR.
 Find its median value and describe it in terms of the problem
 Find its standard deviation
 How likely is it that the 2016 World Series will last any number of games within the IQR, inclusive?
Thank you for the opportunity to help you with your question!
1. IQR= 23.33
2. Median = 24. Median is one of the statistical measures of central tendency. It is the middle number of a data set that has first been arranged in ascending order. The median of the world series score is 24 i.e. 2 scores lower than 24 and 2 scores higher than 24
3. The standard deviation is 12.97
4. The mean score is 21.4. Assuming a 95% confidence level, the world series score will be 21.4 ±11.37 i.e. between 10.03 and 32.77. Therefore, it is likely that the 2016 world series will last within the IQR since the IQR is within the range of 10.03 and 32.77Please let me know if you need any clarification. I'm always happy to answer your questions.
I apologize for not including the workings. They are herein below done in excel showing the formulas.
Question 1,2 and three workings
Cell number 
A 
B 
No. of games played in a best of seven World Series (w) 
World Series arranged in ascending order 

1 
8 
1 
2 
4 
19 
3 
6 
24 
4 
5 
27 
5 
7 
36 
IQR 
Formula: =TRIMMEAN(B1:B5, 0.5) 
23.33 
MEAN 
Formula:= MEDIAN(B1:B5) 
24 
STANDARD DEVIATION 
Formula: =STDEV(B1:B5) 
12.97 
Q 4. workings
A 
B 

CELL NO. 
DATA 
DESCRIPTION 
1 
0.05 
Significance level 
2 
12.97 
Std. deviation of the sample 
3 
5 
Sample size 
CONFIDENCE INTERVAL 
FORMULA = CONFIDENCE(B1,B2,B3) 
11.37 
Secure Information
Content will be erased after question is completed.