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

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman