Below are the income per capita of a sample of different households. Per Capita Income 21,500 37,325 25,049 18,998 24,122 23,615 25,771 25,922 21,551 24,447 21,708 25,028 23,152 25,106 21,385 20,247 25,239 21,096 20,393 26,210 23,002 24,786 21,056 24,217 27,579 21,080 30,023 27,360 24,775 27,489 28,821 28,976 32,902 29,219 26,889 28,066 37,700 24,302 25,979 33,953 26,924 19,373 29,932 24,007 27,667 20,008 21,387 25,184 Determine each of the following measures for the sample of income by using the appropriate Excel function. Place your answers in the highlighted cells. (a) mean (b) median (c) variance (d) standard deviation
Below are the income per capita of a sample of different households. Per Capita Income 21,500 37,325 25,049 18,998 24,122 23,615 25,771 25,922 21,551 24,447 21,708 25,028 23,152 25,106 21,385 20,247 25,239 21,096 20,393 26,210 23,002 24,786 21,056 24,217 27,579 21,080 30,023 27,360 24,775 27,489 28,821 28,976 32,902 29,219 26,889 28,066 37,700 24,302 25,979 33,953 26,924 19,373 29,932 24,007 27,667 20,008 21,387 25,184 Determine each of the following measures for the sample of income by using the appropriate Excel function. Place your answers in the highlighted cells. (a) mean (b) median (c) variance (d) standard deviation
Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
ChapterCSR: Contents Of Student Resources
Section: Chapter Questions
Problem 11.1EP
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 3 images
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill