MAT-123 StatisticSI ININ e C Homework: Assignment 4 Save Score: 0 of 3 pts 2 of
ID: 3329038 • Letter: M
Question
MAT-123 StatisticSI ININ e C Homework: Assignment 4 Save Score: 0 of 3 pts 2 of 4 (2 complete) HW Score: 40%, 4 of 10 pts ard 3.2.7 Question Help * Listed below are the top 10 annual salaries (in millions of dollars) of TV personalities. Find the range, variance, and standard deviation for the sample data Given that these are the top 10 salaries, do we know anything about the variation of salaries of TV personalities in general? es Ro 40 38 37 29 19 17 15 1413.7 13.2 The range of the sample data is smillion. (Type an integer or a decimal)Explanation / Answer
Solution:We use excel for all findings.
Suppose I have entered data in excel sheet,
(a) Range,
Excel formula, =MAX(A2:A11)-MIN(A2:A11)
Range = 26.8
(b) Variance,
Excel formula, =VAR(A2:A11)
Variance = 124.67
(c) Stanndard deviation.
Excel formula, =STDEV(A2:A11)
Stanndard deviation = 11.17
Done
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.