Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Acceptance"bands" on a line chart | Charts and Charting in Excel | |||
Text is cutoff in a cell | Excel Discussion (Misc queries) | |||
Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
Y Axis Label is Cutoff | Charts and Charting in Excel | |||
CUTOFF | Excel Discussion (Misc queries) |