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
- Fall '10
- Mean, Median, Mode, Quartile, $50, Quantile, Blank cell