{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MATH 221 LAB 06 FA 09

# MATH 221 LAB 06 FA 09 - M ATH 221 Student Name Instructor...

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

MATH 221 Statistics for Decision Making LAB 6 Student Name Section © Copyright 2009 by P.E.P. Page 1 of 2 Instructor Due Date PROJECT Computing Quartiles 100 Points ( ____ your score ) Objective To use a spreadsheet to compute statistical variables. PROJECT DESCRIPTION Using the instructions which follow, investigate the statistical values known as quartiles Information About This Project In statistics, a quartile is any of the three values which divide the sorted data set into four equal parts, such that each part represents 1 / 4 th of the sample or population. The first quartile ( designated Q 1 ) is also called the lower quartile and separates the lowest 25 % of the data. The second quartile ( designated Q 2 ) is also called the median and separates the data set in half. The third quartile ( designated Q 3 ) is the upper quartile and separates the highest 25 % of data, or lowest 75 %. The difference between the upper and lower quartiles is called the interquartile range. The average of the upper and lower quartiles is called the midquartile. In MS Excel, quartiles can be computed using the following format: = QUARTILE ( array , quart ) Where " array " represents the set of values for which you wish to determine a quartile and " quart " can be either 1 , 2 or 3 , i.e. representing the first, second and third quartile. Also, " quart " can equal 0 to return the minimum value of the data and 4 to return the maximum value.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

MATH 221 LAB 06 FA 09 - M ATH 221 Student Name Instructor...

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

View Full Document
Ask a homework question - tutors are online