in this video we'll see how to calculate a five number summary using spreadsheet software with the data in the spreadsheet we'll find the men q1 the median Q3 in the max if the Min is not obvious Excel has a function to find it equals minin parentheses then select the data then close the parentheses for q1 we had equals then quartile open parentheses then select the data then comma then one for first quartile for the median hit equals me I an open parentheses select the data close parentheses for Q3 it equals then quartile open parentheses select the data comma three close parenthesis for the maximum number if it's not obvious it equals Max open parenthesis select the data close parenthesis we now have the five number summary