# recitation3 - 1 Click on a blank cell in the spreadsheet 2...

This preview shows pages 1–3. Sign up to view the full content.

Review and Examples Mean Median Mode Percentiles Quartiles Boxplot The American Association of Individual Investors conducted an annual survey of discount brokers. The commissions charged by 24 discount brokers for broker-assisted trades of 100 shares at \$50 dollars per share can be found in the ﬁle Broker2.xlsx on K-State online. We will demonstrate how to use Excel to compute the mean, median, etc. To use Excel to compute the mean commission: 1. Open the ﬁle Broker2.xlsx. 2. Click on a blank cell in the spreadsheet. 3. Type in the cell the following: = average(B2:B25) This computes the average of the numbers in cells B2-B25. 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
4. Press Enter. To use Excel to compute the median commission: 1. Click on a blank cell in the spreadsheet. 2. Type in the cell the following: = median(B2:B25) This computes the median of the numbers in cells B2-B25. 3. Press Enter. To use Excel to compute percentiles:
This is the end of the preview. Sign up to access the rest of the 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

{[ snackBarMessage ]}

### Page1 / 3

recitation3 - 1 Click on a blank cell in the spreadsheet 2...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online