Question

Respond to the following in a minimum of 175 words: The most frequently used measures of...

Respond to the following in a minimum of 175 words:

The most frequently used measures of central tendency for quantitative data are the mean and the median. The following table shows civil service examination scores from 24 applicants to law enforcement jobs:

83        74        85        79

82        67        78        70

18        93        64        27

93        98        82        78

68        82        83        99

96        62        93        58

Using Excel, find the mean, standard deviation, and 5-number summary of this sample.

  • Construct and paste a box plot depicting the 5-number summary.
  • Does the dataset have outliers? If so, which one(s)?
  • Would you prefer to use the mean or the median as this dataset’s measure of central tendency? Why?

Homework Answers

Answer #1

Mean value for given data is

Create the following table.

data data-mean (data - mean)2
83 7.5 56.25
74 -1.5 2.25
85 9.5 90.25
79 3.5 12.25
82 6.5 42.25
67 -8.5 72.25
78 2.5 6.25
70 -5.5 30.25
18 -57.5 3306.25
93 17.5 306.25
64 -11.5 132.25
27 -48.5 2352.25
93 17.5 306.25
98 22.5 506.25
82 6.5 42.25
78 2.5 6.25
68 -7.5 56.25
82 6.5 42.25
83 7.5 56.25
99 23.5 552.25
96 20.5 420.25
62 -13.5 182.25
93 17.5 306.25
58 -17.5 306.25

Find the sum of numbers in the last column to get.

So

The minimum is the smallest value in a data set.

Ordering the data from least to greatest, we get:

18   27   58   62   64   67   68   70   74   78   78   79   82   82   82   83   83   85   93   93   93   96   98   99   

So, the minimum is 18.

The first quartile (or lower quartile or 25th percentile) is the median of the bottom half of the numbers. So, to find the first quartile, we need to place the numbers in value order and find the bottom half.

18   27   58   62   64   67   68   70   74   78   78   79   82   82   82   83   83   85   93   93   93   96   98   99   

So, the bottom half is

18   27   58   62   64   67   68   70   74   78   78   79   

The median of these numbers is 67.5.

planation

The median is the middle number in a sorted list of numbers. So, to find the median, we need to place the numbers in value order and find the middle number.

Ordering the data from least to greatest, we get:

18   27   58   62   64   67   68   70   74   78   78   79   82   82   82   83   83   85   93   93   93   96   98   99   

As you can see, we do not have just one middle number but we have a pair of middle numbers, so the median is the average of these two numbers:

Median=

The third quartile (or upper quartile or 75th percentile) is the median of the upper half of the numbers. So, to find the third quartile, we need to place the numbers in value order and find the upper half.

18   27   58   62   64   67   68   70   74   78   78   79   82   82   82   83   83   85   93   93   93   96   98   99   

So, the upper half is

82   82   82   83   83   85   93   93   93   96   98   99   

The median of these numbers is 89.

The maximum is the greatest value in a data set.

Ordering the data from least to greatest, we get:

18   27   58   62   64   67   68   70   74   78   78   79   82   82   82   83   83   85   93   93   93   96   98   99   

So, the maximum is 99.

Hence there are 2 outliers: 18 and 27

As there are outliers so median is to used for measure of central tendency

------------------------------------------------------------------------

DEAR STUDENT,

IF YOU HAVE ANY QUERY ASK ME IN THE COMMENT BOX,I AM HERE TO HELPS YOU.PLEASE GIVE ME POSITIVE RATINGS

*****************THANK YOU*****************

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Respond to the following in a minimum of 175 words: The most frequently used measures of...
Respond to the following in a minimum of 175 words: The most frequently used measures of central tendency for quantitative data are the mean and the median. The following table shows civil service examination scores from 24 applicants to law enforcement jobs: 83 74 85 79 82 67 78 70 18 93 64 27 93 98 82 78 68 82 83 99 96 62 93 58 Using Excel, find the mean, standard deviation, and 5-number summary of this sample. Construct...
The following weights in kilograms were recorded for a hockey team: 73 75 76 77 78...
The following weights in kilograms were recorded for a hockey team: 73 75 76 77 78 86 81 75 100 92 82 73 85 79 84 92 80 78 77 81 83 74 80 69 92 79 72 76 a) Find the mean, mode, and median weights. b) Which of these three measures of central tendency is the least representative of the set of weights? Why?
1. The following resting data were collected from three different sports teams (hockey, rugby and football)....
1. The following resting data were collected from three different sports teams (hockey, rugby and football). Ignoring the sport played, run a Kolmogorov–Smirnov test on the age variable. What is the correct expression for the result? ID Sport Age (y) Body mass (kg) Stature (m) Resting heart rate (bpm) Resting systolic blood pressure (mmHg) Resting diastolic blood pressure (mmHg) Resting mean arterial pressure (mmHg) 1 Hockey 18 79 1.83 65 121 79 93 2 Hockey 20 79.9 1.78 50 127...
16. The following resting data were collected from three different sports teams (hockey, rugby and football)....
16. The following resting data were collected from three different sports teams (hockey, rugby and football). Ignoring the sport played, run a Kolmogorov–Smirnov test on the age variable. What is the correct expression for the result? ID Sport Age (y) Body mass (kg) Stature (m) Resting heart rate (bpm) Resting systolic blood pressure (mmHg) Resting diastolic blood pressure (mmHg) Resting mean arterial pressure (mmHg) 1 Hockey 18 79 1.83 65 121 79 93 2 Hockey 20 79.9 1.78 50 127...
QUESTION 1 [13 MARKS] Write down only the letter corresponding to your choice next to the...
QUESTION 1 [13 MARKS] Write down only the letter corresponding to your choice next to the question number. 1.1. A random variable that can assume only a finite number of values is referred to as a a) Infinite sequence b) Finite sequence c) Discrete random variable d) Discrete probability function e) All of the above 1.2 Which one of the following statements is incorrect? a) A data set provides information about people, objects or other entities. b) If the possible...
Pat.# Before After 1 195 125 To the left is 2 datasets measured for a sample...
Pat.# Before After 1 195 125 To the left is 2 datasets measured for a sample of 107 patients with the high cholesterol level before and after taking medication. Obtain the following for both sets: 2 208 164 3 254 152 1- the mean, mode and median 4 226 144 5 290 212 2- the variance and standard deviation 6 239 171 7 216 164 3- First, second and third quartiles 8 286 200 9 243 190 10 217 130...
1. A city official claims that the proportion of all commuters who are in favor of...
1. A city official claims that the proportion of all commuters who are in favor of an expanded public transportation system is 50%. A newspaper conducts a survey to determine whether this proportion is different from 50%. Out of 225 randomly chosen commuters, the survey finds that 90 of them reply yes when asked if they support an expanded public transportation system. Test the official’s claim at α = 0.05. 2. A survey of 225 randomly chosen commuters are asked...
A loan made on March 14 is due September 13 of the following year. Find the...
A loan made on March 14 is due September 13 of the following year. Find the exact time for the loan in a​ non-leap year and a leap year. days. The exact time in a​ non-leap year is ? days The exact time in a leap year is ? days. Data Table Sequential Numbers for Dates of the Year Day of Month Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 1 1 32 60 91 121...
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel...
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel to check your answers before submitting. Q2 assesses your general understanding of probability and linear associations using Excel to analyse a large dataset. Question 1       Covariance and Correlation The table below shows a set of sample bivariate data. Calculate the covariance and correlation coefficient by completing the below table. Show all working. X Y (X - ) (Y - ) (X - )(Y -...