ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cutoff score for acceptance (https://www.excelbanter.com/excel-worksheet-functions/198638-cutoff-score-acceptance.html)

[email protected]

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

Wigi

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


Pete_UK

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



[email protected]

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.

[email protected]

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.

Pete_UK

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