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

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

View Full Document Right Arrow Icon
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 first compute the minimum and maximum values and then take the difference: 1. Open the file Visa.xls. 2. Click on a blank cell in the spreadsheet. 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 first compute the first 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 difference. 3. Press Enter.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the 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.

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 Right Arrow Icon
Ask a homework question - tutors are online