Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #25: Percentiles, Quartiles, 5 Number Summary using Excel Functions

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn: 1) (00:12) What is a percentile: A Marker in a sorted list of numbers that divides the set into two parts: P% above the marker and 1=P% above the marker. 2) (01:04) Difference between the percentile and quartile functions in Excel: PERCENTILE.EXC: .EXC = Exclusive: Excludes 0% & 100% = Min and Max values cannot be found -- 0% and 100% are not allowed PERCENTILE.INC: .INC = Inclusive: Includes 0% & 100% = Min and Max values CAN be found 0% = Min & 100% = Max QUARTILE.EXC: .EXC = Exclusive: Min and Max values cannot be found -- can only enter 1, 2, 3 in second argument QUARTILE.INC: .INC = Inclusive: 0 = Min, 1 = Quartile 1, 2 = Quartile 2, 3 = Quartile 3, 4 = Max 3) (02:02) How the algorithms for each function work to calculate the position of the marker. 4) (09:14) Calculate the Five Number Summary for each of the functions to see which ones work and which do not work. 5) (11:09) Example of PERCENTILE.INC and QUARTILE.INC to create a five number summary. Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.