answersLogoWhite

0


Best Answer

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)

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

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)

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you use Excel to calulate the 75th percentile?
Write your answer...
Submit
Still have questions?
magnify glass
imp
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 radiological technician use Microsoft Excel?

Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.


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.