AGEFRST CO_BASE 16 14 14 18 12 11 13 36.5 13 46 14 38.5 12 19.5 14 28 16 26.5 25 11 18 31 23 18.5 13 32 14 23 18 24 14 34 17 59 12 32 8 14 21 23 19 19.5 16 21.5 11 30 12 17 11 28.5 1. Using Microsoft Excel, compute the mean, median, variance, standard deviation and SS of the AGEFRST and CO_BASE data sets. 2. Using Microsoft Excel, construct a relative frequency distribution for the 2 data sets. 3. Using Microsoft Excel, graph the relative frequency distributions. 4. Assume that CO_BASE is normally distributed with a mean = 25 and std dev = 10. What is the percentile rank of each of the scores? Use Microsoft Excel to do this problem.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.3: Measures Of Spread

Problem 1GP

See similar textbooks

Related questions

Question

AGEFRST CO_BASE
16 14
14 18
12 11
13 36.5
13 46
14 38.5
12 19.5
14 28
16 26.5
25 11
18 31
23 18.5
13 32
14 23
18 24
14 34
17 59
12 32
8 14
21 23
19 19.5
16 21.5
11 30
12 17
11 28.5

1. Using Microsoft Excel, compute the mean, median, variance, standard deviation and SS of the AGEFRST and CO_BASE data sets.

2. Using Microsoft Excel, construct a relative frequency distribution for the 2 data sets.

3. Using Microsoft Excel, graph the relative frequency distributions.

4. Assume that CO_BASE is normally distributed with a mean = 25 and std dev = 10. What is the percentile rank of each of the scores? Use Microsoft Excel to do this problem.

Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.

Expert Solution