The female students in an undergraduate engineering core course at a university

Question

The female students in an undergraduate engineering core course at a university self- reported their heights to the nearest inch. The data are below: 67.8 54.5 26.8 37.1 65.2 38.9 21.1 22.8 69.2 48.3 33.6 55.9 77.9 65.8 66.1 25.9 55.6 67.8 62.3 55.9 55.8 29.3 66.4 65.2 72.9 36.2 62.4 48.3 68.1 56.3 71.2 65.1 a) Calculate first quartile, second quartile & third quartile of the height b) Calculate the sample mean, median & sample standard deviation of the c) Do ^tabulations in parts (a) and (b) using Excel.

Explanation / Answer

the given 32 numbers are written in the first column from A1 to A32

a) first quartile = =PERCENTILE(A1:A32,0.25) = 38.45

second quartile = =PERCENTILE(A1:A32,0.5) = 56.1

third quartile = =PERCENTILE(A1:A32,0.75) = 66.175

b)sample mean =AVERAGE(A1:A32) = 53.61563

median = PERCENTILE(A1:A32,0.5) = 56.1

standard deviation = =SQRT(VAR(A1:A32)) = 16.56732

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.