{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# recitation4 - Review and Examples Range IQR Variance and...

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

Review and Examples Range IQR Variance and Standard Deviation Shape of the Distribution z -scores Empirical Rule Covariance Correlation According to the 2003 Annual Consumer Spending Survey, the average monthly Bank of America Visa credit card charge was \$1838. A sample of monthly credit card charges provides the data found in Visa.xls. To use Excel to compute the range, we ﬁrst compute the minimum and maximum values and then take the diﬀerence: 1. Open the ﬁle Visa.xls. 2. Click on a blank cell in the spreadsheet. 1

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

View Full Document
3. Type in the cell the following: =MAX(A2:A16)-MIN(A2:A16) This computes the smallest and largest numbers in A2-A16 and subtracts the smallest from the largest. 4. Press Enter. To use Excel to compute the IQR, we ﬁrst compute the ﬁrst and third quar- tiles and then take Q 3 - Q 1 : 1. Click on a blank cell in the spreadsheet. 2. Type in the cell the following: =QUARTILE(A2:A16,3)-QUARTILE(A2:A16,1) This computes Q 3 and Q 1 and takes the diﬀerence. 3. Press Enter.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

recitation4 - Review and Examples Range IQR Variance and...

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

View Full Document
Ask a homework question - tutors are online