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
icon
Related questions
Question
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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax