Just do \"c\" Name Student Number 9. (3 markas),. A detailed study of a collecti
ID: 2922601 • Letter: J
Question
Just do "c" Name Student Number 9. (3 markas),. A detailed study of a collection of glaciers indicates a population men speed of 1.2 metre/day with a standard deviation of 0.1 metre/day There aze a ollection of Excel commands below. You may use any or all of them as appropriate to justify your answers to the following questions NORM.DIST(1.15,1.2,0.1,1)-0.31 ORM.DIST(1.45,1.2,0.1,1)-0.99 ORM.INV C0.25,1.2,0.1) 1.13 NORM.INV C0.50,1.2,0.1)-1.20 (a) What proportion of glaciers do you expect move slower than 1.15 metzres/day? (b) What proportion of glaciers do you expect to move faster than 1.45 mtr/day? (c) What is the interquartile range of glacier speeds? 8 of 8Explanation / Answer
c) Interquartile range of gladers speed
= Q3 - Q1
= NORM.INV(0.75, 1.2, 0.1, 1) - NORM.INV(0.25, 1.2, 0.1, 1)
= 1.27 - 1.13
= 0.14
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.