MATH221LAB02FA09

# MATH221LAB02FA09 - 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 2 Student Name Section © Copyright 2006 by P.E.P. Page 1 of 2 Instructor Due Date PROJECT Mean, Median and Mode Value 100 Points _____ your score Objective To compute various measures of central tendency. PROJECT DESCRIPTION Construct a worksheet that computes various measures of central tendency including the arithmetic mean, the mode and the median. Information About This Project Some Excel functions that measure the central tendency of a set of numbers are: Measure Type Description Excel Function and Format Arithmetic Mean " traditional " average = AVERAGE ( number1 , number2 , . .. ) Median " center - most " number = MEDIAN ( number1 , number2 , . .. ) Mode most frequently occurring number = MODE ( number1 , number2 , . .. ) Geometric Mean the " multiplicative " mean = GEOMEAN ( number1 , number2 , . .. ) Harmonic Mean the " harmonious " mean = HARMEAN ( number1 , number2 , . .. ) Steps To Complete This Project STEP 1 Open MS Excel Open, on your computer, the electronic spreadsheet software program MS Excel, which is part of the Microsoft Office suite. STEP 2

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.

## This document was uploaded on 04/05/2011.

### Page1 / 2

MATH221LAB02FA09 - 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