{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MATH 221 LAB 11 FA 09

# MATH 221 LAB 11 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 11 Student Name Section © Copyright 2009 by P.E.P. Page 1 of 2 Instructor Due Date PROJECT Simulation Modeling ( 100 points ) Objective To use various MS Excel functions for mathematical modeling. PROJECT DESCRIPTION Use various MS Excel functions for mathematical modeling. Information About This Project MS Excel functions for mathematical modeling can be utilized to demonstrate analysis of a given problem. Steps To Complete This Project Project ONE ( Percent Rank ) 25 Points _____ score Use the Excel PERCENTRANK function to find how an aptitude score of 80 ranks among all scores for a test, listed below. Express your answer as a percent. 82 54 59 92 99 80 14 63 33 22 83 53 87 21 54 83 To determine what arguments the PERCENTRANK function requires, click the cell for which you wish to display the answer to the above problem, then, in this same cell type the following: = PERCENTRANK ( Then, as shown below, click the Edit button on the formula bar. What now appears is the screen shown below.

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