Needing help with an Excel based analytics problem: According to the National Ed

Question

Needing help with an Excel based analytics problem:

According to the National Education Association (NEA), teachers generally spend more than 40 hours each week working on instrumental duties. The following data show the number of hours worked per week for a sample of 13 High school Science Teachers and a sample of 11 high School English Teachers:

HS Science Teachers 53 56 54 54 55 58 49 61 54 54 52 53 54

HS English Teachers 52 47 50 46 47 48 49 46 55 44 47

In Microsoft Excel, compute the following statistics both for the High School Science Teachers and High School English Teachers data: HS SCIENCE TEACHERS HS ENGLISH TEACHERS a. Median b. Mode c. Variance d. Standard Deviation e. Minimum Value f. Maximum Value g. First Quartile (Q) h. Second Quartile (Q2) i. Third Quartile (Q3) j. Interquartile Range (IR) k. Range

Create a boxplot for the High School Science Teachers and High School English Teachers data.

Explanation / Answer

Please note the data is C3 to C15 for Science teachers, and in D3 to D13 for English teachers.

Interquartile range = Q3-Q1

Range = max - min

Science English 53 52 56 47 54 50 54 46 55 47 58 48 49 49 61 46 54 55 54 44 52 47 53 54 a Median 54 47 b mode 54 47 c Variance 7.621302 8.743802 d Std. dev. 2.760671 2.956992 e Min 49 44 f Max 61 55 g First Quartile 53 46.5 h Second Quartile 54 47 i Third Quartile 55 49.5 j Interquartile Range 2 3 k Range 12 11

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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