Percentiles and Excel Functions

This video tutorial explains how to calculate percentiles using both manual formulas and Excel. It covers the calculation of the 46th percentile (P46), the 3rd quartile (Q3), and the 9th decile (D9). The tutorial provides a detailed step-by-step guide on arranging data, using locator formulas, and calculating percentiles manually. It also demonstrates how to use Excel functions like Percentile.EXC and Quartile to achieve the same results. The video aims to help viewers understand and apply percentile calculations in different contexts.

What is the main focus of the video tutorial?

• Calculating median

• Calculating standard deviation

• Calculating averages

• Calculating percentiles using formulas and Excel

What is the 46th percentile referred to as?

• P90

• D9

• Q3

• P46

How many observations are in the given data set?

• 12

• 11

• 13

• 10

What is the locator formula used for?

• Finding the median

• Finding the mean

• Calculating the range

• Locating the position of a percentile

What is the calculated value of the 46th percentile?

• 25.56

• 24.56

• 22.56

• 23.56

What is the 75th percentile also known as?

• Q3

• P46

• D9

• P90

What is the value of the 75th percentile in the data set?

• 32

• 31

• 33

• 30

What is the 90th percentile also referred to as?

• P90

• P46

• Q3

• D9

What is the calculated value of the 90th percentile?

• 36.8

• 37.8

• 39.8

• 38.8

Which Excel function is used to calculate percentiles?

• MODE

• AVERAGE

• PERCENTILE.EXC

• MEDIAN