MATH 221 LAB 11 FA 09

MATH 221 LAB 11 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 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.
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 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 Right Arrow Icon
Ask a homework question - tutors are online