MATH 221 LAB 06 FA 09

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

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 04/05/2011.

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