Calculate the measures of central tendency (mean, median, and mode) and the measures of dispersion (range, mean, standard deviation, and variance) in the examples:

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
100%
SOLVE IN EXCEL PLEASE
STEP BY STEP
INSTRUCTIONS:
Calculate the measures of central tendency (mean, median, and mode)
and the measures of dispersion (range, mean, standard deviation, and
variance) in the examples:
7. The monthly salaries (in dollars) of a group of teachers at a
university are as follows: 240, 600, 320, 450, 600, 240, 240, 320. Find
the range of the dispersion, the arithmetic mean, and the deviation.
population standard of these data.
Xi
240
320
450
600
Tip: We write down in a table the given data arranged in
ascending order, the calculations and the results obtained:
fi
3
Σ=
3.5
3
2.5
2
1.5
1
0.5
O
O=
fi/n
3/8 = 0,375
Σ=
fi
The range of the dispersion is: r =
The arithmetic mean is: x =
240
The population mean deviation is:
xifi
720
320
x₁ - x
376,25 -136,25
X
450
Dollars.
Dollars.
Dollars
(x₁ - x)²
18564,0625
600
Xi
(x₁ - x)² fi/n
6961,52
Σ=20948,44
Transcribed Image Text:SOLVE IN EXCEL PLEASE STEP BY STEP INSTRUCTIONS: Calculate the measures of central tendency (mean, median, and mode) and the measures of dispersion (range, mean, standard deviation, and variance) in the examples: 7. The monthly salaries (in dollars) of a group of teachers at a university are as follows: 240, 600, 320, 450, 600, 240, 240, 320. Find the range of the dispersion, the arithmetic mean, and the deviation. population standard of these data. Xi 240 320 450 600 Tip: We write down in a table the given data arranged in ascending order, the calculations and the results obtained: fi 3 Σ= 3.5 3 2.5 2 1.5 1 0.5 O O= fi/n 3/8 = 0,375 Σ= fi The range of the dispersion is: r = The arithmetic mean is: x = 240 The population mean deviation is: xifi 720 320 x₁ - x 376,25 -136,25 X 450 Dollars. Dollars. Dollars (x₁ - x)² 18564,0625 600 Xi (x₁ - x)² fi/n 6961,52 Σ=20948,44
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE 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