Question

60 POINTS BRAINLIES
PLEASE WORKOUT QUESTIONS a b & c
PHOTO OF GRAPH ATTACHED BELOW

a) Calculate the median number of medals for each medal type, stating the formula you would use for determining the median for the gold medals.


b) Calculate the mean number of medals for each of the 3 medal types, stating the formula you would use for determining the mean for the bronze medals.


c) Calculate the standard deviation of the total medals awarded to each country
(column F) using the formula below.
Show all the steps ( show your work ).

USE the STDEV.P function to cross-check your final answer.

Answer 1

Answer:

see below

Step-by-step explanation:

a)  median : re-arranged the numbers in order. i.e. min to max

gold:          147 , 147 , 175 , 206 , 212 , 227 , 263 , 275 , 440 , 1022

                 212  + 227    =  219.50

                        2

silver:       147 , 163 , 165 , 170 , 178 , 241 , 295 , 313 , 357 , 794

                178 + 241     =  209.50

                       2

bronze:    151 , 169 , 179 , 187 , 193 , 260 , 289 , 325 , 349 , 704

                193  +  260  =  226.50

                        2

b)  mean : sum of all numbers divide by n, where n=10  

gold:        =   (147 , 147 , 175 , 206 , 212 , 227 , 263 , 275 , 440 , 1022 ) / 10

               =  311.40

silver:      =   (147 , 163 , 165 , 170 , 178 , 241 , 295 , 313 , 357 , 794 ) / 10

              =  282.30

bronze:   =  (151 , 169 , 179 , 187 , 193 , 260 , 289 , 325 , 349 , 704 ) / 10

               =  280.60

c) standard deviation on population (STDEV.P)

Australia          = 16.44

china               = 33.03

france              = 19.74

germany          = 30.21

great britain    = 13.89

hungary           = 12.04

italy                  = 11.44

soviet union    = 48.46

sweden           = 13.47

united states   = 133.84