Question

use excel to find the requested percentiles for the following data set. you should be able to download the table of data and open in excel. use =percentile.exc and quartile.exc functions in excel to complete this question. do not use =percentile.inc or =percentile functions. given the following table of 32 observations, find the 25th, 35th, and 75th percentiles. do not round your results.
1 3 9 18 27 29 37 39
41 43 44 47 49 50 51 56
58 59 63 64 68 71 76 78
80 83 89 91 92 93 95 97
a) 25th percentile =
b) 35th percentile =
c) 75th percentile =
question help: video

Explanation:

Step1: Open Excel and input data

Input the given 32 - observation data set into an Excel sheet.

Step2: Calculate 25th percentile

In an empty cell, enter the formula =PERCENTILE.EXC(A1:A32, 0.25) (assuming data is in cells A1:A32).

Step3: Calculate 35th percentile

In another empty cell, enter the formula =PERCENTILE.EXC(A1:A32, 0.35).

Step4: Calculate 75th percentile

In a third empty cell, enter the formula =PERCENTILE.EXC(A1:A32, 0.75).

Answer:

a) The value obtained from the =PERCENTILE.EXC(A1:A32, 0.25) formula.
b) The value obtained from the =PERCENTILE.EXC(A1:A32, 0.35) formula.
c) The value obtained from the =PERCENTILE.EXC(A1:A32, 0.75) formula.