![]() |
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 |
Cutoff score for acceptance
Hi
x is the unknown. (x-500)/100 = -0.25 (x-500) = -25 (x-500) +500 = -25 + 500 x = -25 + 500 x = 475 -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music " wrote: 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 |
Cutoff score for acceptance
Try this:
=100*NORMSINV(1-A1) + 500 (Algebra rather than statistics!). Hope this helps. Pete On Aug 12, 10:34*pm, wrote: 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 |
Cutoff score for acceptance
On Aug 12, 5:55*pm, Wigi wrote:
Hi x is the unknown. (x-500)/100 = -0.25 (x-500) = -25 (x-500) +500 = -25 + 500 x = -25 + 500 x = 475 -- Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music " wrote: 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- Hide quoted text - - Show quoted text - Pete_UK, Thank you so much! I just could not get it. |
Cutoff score for acceptance
On Aug 12, 6:02*pm, wrote:
On Aug 12, 5:55*pm, Wigi wrote: Hi x is the unknown. (x-500)/100 = -0.25 (x-500) = -25 (x-500) +500 = -25 + 500 x = -25 + 500 x = 475 -- Wigihttp://www.wimgielis.be=Excel/VBA, soccer and music " wrote: 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- Hide quoted text - - Show quoted text - Pete_UK, Thank you so much! I just could not get it.- Hide quoted text - - Show quoted text - Wigi, thanks also. |
Cutoff score for acceptance
You're welcome - thanks for feeding back.
Pete On Aug 12, 11:02*pm, wrote: Pete_UK, Thank you so much! I just could not get it |
All times are GMT +1. The time now is 10:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com