Show all work. Partial credit will be given only for shown work. Show what you e
ID: 3050468 • Letter: S
Question
Show all work. Partial credit will be given only for shown work. Show what you entered into Excel to get your result. Copy any results from the screen which are pertinent to your answer. Give answers to 3 decimal places. Suppose X, through Xis are the following sample: 42 28 31 36 20 47 35 20 45 20 50 22 28 43 18 Using this data set, find: 1. interquartile range Quartieth's, 3)-Quote(ni,is 'I):2,5 a. variance-lanch, ihis): 123,452 b. 3 5, 3l4 c. coefficient of variation na, (tits)/ Aeror ( ··he) ] i 2 10 e. i- 5 15 (Xi-x)2, i- I 60th percentileExplanation / Answer
Q1 21 Q3 42.5 a) Interquartile Range Q3 - Q1 21.5 b) Variance 123.0952 c) Coefficient of variation 0.343139 d) Summation of 2 to 8 217 e) Summation of square of 5 to 10 6659 f) Summation of (Xi-mean)^2 1723.333 g) 60th percentile is 35 9th element