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

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


"(E-Mail Removed)" 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
>

Try this:

=100*NORMSINV(1-A1) + 500

(Algebra rather than statistics!).

Hope this helps.

Pete

On Aug 12, 10:34*pm, pkara...@gmail.com 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

On Aug 12, 5:55*pm, Wigi <W...@discussions.microsoft.com> 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
>
>
>
> "pkara...@gmail.com" 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.

On Aug 12, 6:02*pm, pkara...@gmail.com wrote:
> On Aug 12, 5:55*pm, Wigi <W...@discussions.microsoft.com> 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
>
> > "pkara...@gmail.com" 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.

You're welcome - thanks for feeding back.

Pete

On Aug 12, 11:02*pm, pkara...@gmail.com wrote:
>
> Pete_UK, Thank you so much! I just could not get it