This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: 1. Click on a blank cell in the spreadsheet. 2. To compute the p th percentile, type = percentile(B2:B25, p /100) in the blank cell. To compute the 35th percentile for commission type = percentile(B2:B25,35/100) or = percentile(B2:B25,0.35) 3. Press Enter. To use Excel to compute the quartiles: 1. Click on a blank cell in the spreadsheet. 2 2. To compute Q i type the following in the cell = quartile(B2:B25, i ) So for the ﬁrst quartile: = quartile(B2:B25,1) For the third quartile: = quartile(B2:B25,3) Note : What you obtain from Excel for percentiles and quartiles may be slightly diﬀerent that what you obtain doing these calculations by hand. Diﬀerent computer programs frequently have slightly diﬀerent formulas for computing percentiles and quartiles. Now using the information from Excel to make a boxplot by hand: 3...
View
Full
Document
This note was uploaded on 01/24/2011 for the course STATISTICS 19897 taught by Professor Jager,abigaill during the Fall '10 term at Kansas State University.
 Fall '10
 Jager,AbigailL
 Mean, Median, Mode

Click to edit the document details