LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default Cutoff score for acceptance

Good afternoon, this is not a homework question, I am trying to brush
up on statistics for my job. I am having a problem with a question. A
4 year college will accept any student ranked in the top 60% on a
National Examination. If the test score is normally distributed with a
mean of 500 and a standard deviation of 100, what is the cutoff score
for acceptance?

The book says 475. If I take =NORMSINV(1-A1) where A1 houses 0.6 it
gives me -0.25 the z-score but how do I come up with 475? If I check
the equasion with the answer =(475-500)/100 it will give me -0.25. How
do I solve the unknown?

Thanks in advance
PJ
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Acceptance"bands" on a line chart Charles Pearsall Charts and Charting in Excel 1 December 26th 07 05:49 PM
Text is cutoff in a cell Jessica Excel Discussion (Misc queries) 5 September 6th 07 03:26 AM
Make a sheet to enter score and score is copy to the proper cell.. Yan Excel Worksheet Functions 0 June 8th 07 02:41 PM
Y Axis Label is Cutoff anagaraj1 Charts and Charting in Excel 0 June 29th 06 02:40 PM
CUTOFF Ahmad Excel Discussion (Misc queries) 5 March 5th 05 08:32 PM


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"