use excel to find the requested percentiles for the following data set. you should be able to download the…

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.\n1 3 9 18 27 29 37 39\n41 43 44 47 49 50 51 56\n58 59 63 64 68 71 76 78\n80 83 89 91 92 93 95 97\na) 25th percentile =\nb) 35th percentile =\nc) 75th percentile =\nquestion help: video

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.\n1 3 9 18 27 29 37 39\n41 43 44 47 49 50 51 56\n58 59 63 64 68 71 76 78\n80 83 89 91 92 93 95 97\na) 25th percentile =\nb) 35th percentile =\nc) 75th percentile =\nquestion help: video

Answer

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.