Please help me out. Thank you. While Measures of Center and Measures of Variatio
ID: 3069277 • Letter: P
Question
Please help me out. Thank you.
While Measures of Center and Measures of Variation areimportant and help us critically analyze large data sets, Measures of Relative Standing provide a positional ranking of a data set. To illustrate the concepts of Quartiles and Percentiles, consider the information in table 1 below. Each year, Oscars are awarded to the best Actress and Best Actor. Table 1 list the ages of those award recipients at the time of the awards ceremony. . Table 1 Acadeny Awards: Ages of 76 Best Actresses and Best Actors Best Actresses 22 37 28 63 32 26 31 27 27 28 29 24 38 25 29 41 30 35 35 33 29 54 24 25 46 41 28 40 39 9 27 31 29 25 35 60 43 35 34 34 27 37 42 41 36 32 41 33 31 74 33 50 38 61 21. 41 26 80 42 29 333545 49 39 34 26 25 33 35 35 28 30 26 Best Actor 44 4165241 34 34 1 3 38 34 32 40 4356 41' 39 4957 41 36 4252 4 2 1 31 47 37 49 56 38 57, 42 45 42 44 62 43 42 4 60 30 40 42 3676 39 53 45 36 62 43 51 32 42 54 52 37 38 32 45 60 46 40 36 47 29 43 Before Quartiles or Percentiles can be determined for a data set, the data must be put in order from smallest to largest. An easy way to help with the task of ordering the data is to create a stemplot.Explanation / Answer
1) input given data in ms-excel
2)now we can directly find the quartiles & percentiles by using following commands
3) for computing quartiles,
Syntax- =QUARTILE(Array, Quart)
4) for computing percentiles,
Syntax- =PERCENTILE(Array,percentile)
5) whenever we use these commands we dont need to arrange data smaller to larger. (MS-EXCEL automatically arrange the data & compute these values)
Quartiles of above data are:
For best actress-
Q1=28
Q2=33.5
Q3=39.25
For best actor-
Q1=37.75
Q2=42
Q3=49
Percentiles for best actress
10th= 25.5
20th= 27
30th=29
40th=31
50th= 33.5
60th=35
70th= 38
80th= 41
90th= 47.5
100th= 80
Percentiles for best actor
10th-34
20th-36
30th-39
40th-41
50th-42
60th-44
70th-47
80th-52
90th-56.5
100th-76
# otherwise we can use sort & filter function to sort given data in ascending or descending order.