This preview shows pages 1–3. Sign up to view the full content.
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 dierent that what you obtain doing these calculations by hand. Dierent computer programs frequently have slightly dierent formulas for computing percentiles and quartiles. Now using the information from Excel to make a boxplot by hand: 3...
View Full Document
- Fall '10
- Mean, Median, Mode