0

# How do you use Excel to calulate the 75th percentile?

Updated: 11/11/2022

Wiki User

11y ago

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

Wiki User

11y ago

Wiki User

11y ago

You use the Percentile function. You specify the range of values and then the percentile in a decimal form. Say your values were in the cell range from B2 to D50, then the formula would be:

=PERCENTILE(B2:D50,0.75)

Earn +20 pts
Q: How do you use Excel to calulate the 75th percentile?
Submit
Still have questions?
Related questions

### You like to find 85 percentile rank of a series of Data in EXCEL?

Use =PERCENTILE(range,0.85) where range is the data that you want to analyse.

### How do you find decile on Excel?

You can use the percentile function with values that are multiples of .10 in the function. Say your values were in the cells A2 to A50, you could use these functions for some of the different deciles: =PERCENTILE(A2:A50,0.1) =PERCENTILE(A2:A50,0.2) =PERCENTILE(A2:A50,0.3) =PERCENTILE(A2:A50,0.4)

### What are five professons that use Microsoft Excel?

Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.

### Do hotels use Excel?

Any business can use Excel for a whole range of things.

### Why do you use MS Excel?

Many people use Microsoft Excel to perform calculations. They also use it to establish databases for their business. Excel makes people efficient.

### What format is Excel in?

MS Excel 2003 and earlier use the XLS format. MS Excel 2007 and later use the XLSX format.

### If you make 14 dollars an hour what is your salary?

Usually a company has a salary hours number they use to calulate a salary. Once you have this number you can calulate your salary. Example: 40 hours per week x 52 weeks = 2080 hours 2080 x \$14. = \$29,120.

### What will I learn with excel training?

You will learn exactly how to use excel and what it entails. Excel is a spreadsheet and datamangement program.

### How can you use Excel at home and at work?

go on to Microsoft excel and do what you want

### Can you use C plus plus with Excel spreadsheets?

This question is irrelative because C++ is a language and Excel is a software. The thing is that we can't use C++ with Excel, but we can write a program like excel in C++.

### Can you use the median to determine percentage?

The median is the 50% percentile.