How to Find Upper & Lower Quintiles in Excel : MS Excel Tips

preview_player
Показать описание
Subscribe Now:

Watch More:

Finding upper and lower quintiles in Excel is something that you can do with a very specific function built into the program. Find upper and lower quintiles in Excel with help from a software expert in this free video clip.

Expert: Brie Clark
Filmmaker: Alexis Guerreros

Series Description: Microsoft Excel is still one of the most advanced spreadsheet creation and maintenance tools on the planet. Get Excel tips with help from a software expert in this free video series.
Рекомендации по теме
Комментарии
Автор

The 0.8 is used because calculating the upper quartile in a set of data is by finding 80% of the data. This is also why when calculating the lower quartile she used 0.2, as it’s calculated by finding 20% of a set of data.

smithajacob
Автор

1:15 why is it 0.8?? Where does that value come from?

briancunningham_
Автор

Excellent. Straight. And Simple. Appreciate your work, Brie. - AVS, Bangalore, India.

astroseeker
Автор

I have been trying to do this for the past few weeks. this was amazing!

randycoswellp
Автор

dont get it not explained very well where the 0.8 comes from sorry?

Missworld-
Автор

0.8 ? don't make a vid and not explain

GabrielPerez-jtds