Question description:
This user has given permission to use the problem statement for this
blog.
There is a
62â??% chance that
X is above whatâ?? value?
if n =25
mean = 100
STD =25
Solved by T. J. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
11/09/2018 - 12:02
Hi
Excelchat Expert
11/09/2018 - 12:02
Welcome to Got it Pro
Excelchat Expert
11/09/2018 - 12:03
Please tell a bit more about the requirement so that i can help better
User
11/09/2018 - 12:03
Hi Dianne.
User
11/09/2018 - 12:03
I need to find bar X
Excelchat Expert
11/09/2018 - 12:04
Do you have the graph for normal distribution?
User
11/09/2018 - 12:05
no I do not know how to use it, can you step by step help me set it up on excel
Excelchat Expert
11/09/2018 - 12:08
Do you know this formula Z = (x-mean)/StdDev
User
11/09/2018 - 12:10
yes, but when I uses it on this part of the problem it do not work
Excelchat Expert
11/09/2018 - 12:13
Do you have z table with you?
User
11/09/2018 - 12:14
I do
Excelchat Expert
11/09/2018 - 12:14
so what is the z value when probability is 62%?
Excelchat Expert
11/09/2018 - 12:15
i think it would be nearly 0.4
Excelchat Expert
11/09/2018 - 12:15
what do you see?
User
11/09/2018 - 12:16
I dont know how to read it on the positive or negative side
Excelchat Expert
11/09/2018 - 12:16
there is value for Z and then there is column which says 00
Excelchat Expert
11/09/2018 - 12:16
value in column 00 should be nearly 65%
Excelchat Expert
11/09/2018 - 12:17
and see z value against it
User
11/09/2018 - 12:18
0.31
Excelchat Expert
11/09/2018 - 12:22
-0.31 = (xbar - 100)/(25/sqrt(25))
Excelchat Expert
11/09/2018 - 12:22
Do you see this formula now?
Excelchat Expert
11/09/2018 - 12:22
Just get x bar from this
Excelchat Expert
11/09/2018 - 12:23
once you get the z value just equate it to this formula
Excelchat Expert
11/09/2018 - 12:23
Let me know if you understand
Excelchat Expert
11/09/2018 - 12:23
98.45% probability
Excelchat Expert
11/09/2018 - 12:24
See on spreadsheet on right
Excelchat Expert
11/09/2018 - 12:24
Let me know if that helps you out
User
11/09/2018 - 12:25
what I do not get is the reading of the chart, why not use 38 since 100-62 = 38
User
11/09/2018 - 12:26
where did the xbar come from - 100 that the number I need to know how to get
Excelchat Expert
11/09/2018 - 12:26
100 is mean
Excelchat Expert
11/09/2018 - 12:26
that is a formula
Excelchat Expert
11/09/2018 - 12:27
Z value = (xbar - mean)/(STD/sqrt(n))
Excelchat Expert
11/09/2018 - 12:27
This is the formula for normal distribution
User
11/09/2018 - 12:28
the xbar what number do you use to get that. I put in and it didnot come out to 98.45
Excelchat Expert
11/09/2018 - 12:28
so if mean is 100 there is 62% probability that X is above 98.45
Excelchat Expert
11/09/2018 - 12:28
I have found out x bar
Excelchat Expert
11/09/2018 - 12:29
-0.31 = (xbar - 100)/(25/sqrt(25))
Excelchat Expert
11/09/2018 - 12:29
This is the equation
Excelchat Expert
11/09/2018 - 12:29
-0.31= (xbar - 100)/(25/5)
Excelchat Expert
11/09/2018 - 12:29
-0.31= (xbar - 100)/(5)
Excelchat Expert
11/09/2018 - 12:30
-0.31*5= (xbar - 100)
Excelchat Expert
11/09/2018 - 12:30
X bar = 100-0.31*5
Excelchat Expert
11/09/2018 - 12:30
Do you get it now?
Excelchat Expert
11/09/2018 - 12:31
Please let me know if this helps you out?
Excelchat Expert
11/09/2018 - 12:31
Are you there?
Excelchat Expert
11/09/2018 - 12:31
Looking forward to good ratings and reviews from you
User
11/09/2018 - 12:31
I'm trying to work it now to see
Excelchat Expert
11/09/2018 - 12:31
Sure please try
User
11/09/2018 - 12:32
It help thank you
Excelchat Expert
11/09/2018 - 12:33
Thanks
Excelchat Expert
11/09/2018 - 12:33
Please do give good rating and reviews when you end the session
Excelchat Expert
11/09/2018 - 12:33
It will really mean a lot
Excelchat Expert
11/09/2018 - 12:33
Have a great day
Excelchat Expert
11/09/2018 - 12:33
Take Caare
Excelchat Expert
11/09/2018 - 12:33
Care*
Excelchat Expert
11/09/2018 - 12:35
Are you there?
Excelchat Expert
11/09/2018 - 12:36
You can end the session to provide your ratings
User
11/09/2018 - 12:36
yes, you help out
Excelchat Expert
11/09/2018 - 12:36
Thanks
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.