a Compute the mean and median of the commuting times for workers in Los Angeles.

Question

a Compute the mean and median of the commuting times for workers in Los Angeles.

b Repeat part a for New York workers.

c Summarize your findings.

Done in Excel!

Los Angeles New York 20 40 30 29 31 22 21 40 15 22 85 28 27 26 29 25 13 26 25 38 28 42 27 33 39 32 26 31 21 27 28 27 37 35 24 29 34 22 34 26 19 20 16 34 23 36 16 30 37 27 35 28 40 35 32 31 29 35 22 36 25 38 27 35 20 38 13 39 35 28 17 31 31 27 21 25 26 30 33 36 39 32 17 30 28 42 27 34 9 18 17 40 27 31 21 28 15 36 24 18 33 38 36 39 36 36 22 28 14 37 16 29 30 18 27 26 75 35 31 28 29 27 25 29 22 39 16 29 24 21 30 43 32 44 14 40 15 27 30 47 21 31 20 55 33 36 32 37 34 26 25 38 13 32 19 26 32 42 15 32 18 31 22 32 26 35 32 31 12 38 29 26 28 28 32 50 22 35 18 25 25 35 33 31 15 26 17 30 26 24 32 36 19 32 14 27 29 10 48 32 28 37 23 11 41 21 37 37 25 26 29 16 33 39 28 25 30 28 31 32 31 24 28 30 32 27 20 36 28 29 21 39 41 27 45 35 28 28 24 34 32 23 13 31 27 31 37 33 31 32 28 30 17 22 21 17 27 26 23 28 22 28 27 34 25 16 28 21 31 38 27 29 23 42 42 28 21 45 25 24 27 35 28 38 25 25 11 22 46 26 33 29 22 33 33 39 33 32 51 27 12 41 26 34 25 28 17 25 35 32 26 37 24 24 18 46 33 39 17 40 31 23 27 38 26 18 26 39 22 20 24 26 23 26 7 33 26 33 30 35 31 38 23 27 27 17 21 32 39 35 28 24 36 35 37 27 24 30 27 29 32 42 26 28 14 34 20 32 17 30 30 22 16 46 25 21 25 27 22 23 23 20 38 39 26 37 18 45 28 24 30 6 31 26 16 31 32 32 45 39 22 28 18 34 27 31 26 40 12 34 29 14 24 23 15

Explanation / Answer

A ) By using EXCEL we can calculate the mean and median as

Put all the data in excel worksheet then use following command

For MEAN =AVERAGE( select all the data )

  For MEDIAN =MEDIAN( select all the data )

we get

For LOS ANGELES

Mean = 26.80 and Median = 9.42

B ) For NEW YORK

Mean = 30.94 and Median = 7.19

C) average amount of time spent commuting to work for New YORK is greater than Los Angeles.

Mean of New York > Mean of Los Angeles

and median of Los angeles > median of New York

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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