Normal - COMPUTE Page 1 Normal Probabilites Common DaTa...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
COMPUTE Page 1 Normal Probabilities Common Data Mean 7 Standard Deviation 6 Probability for X <= X Value 7 Z Value 0 P(X<=7) 0.5000 Probability for X > X Value 9 Z Value 0.33333333 P(X>9) 0.3694 Probability for X<7 or X >9 P(X<7 or X >9) 0.8694 Probability for a Range From X Value 5 To X Value 9 Z Value for 5 -0.3333333 Z Value for 9 0.33333333 P(X<=5) 0.3694 P(X<=9) 0.6306 P(5<=X<=9) 0.2611 Find X and Z Given a Cum. Pctage. Cumulative Percentage 10.00% Z Value -1.28 X Value -0.69 Find X Values Given a Percentage Percentage 95.00% Z Value -1.96 Lower X Value -4.76 Upper X Value 18.76
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
COMPUTE_FORMULAS Page 2 Normal Probabilities Common Data Mean 7 Standard Deviation 6 Probability for X <'= X Value 7 Z Value =STANDARDIZE(B8, B4, B5) ="P(X<="&B8&")" =NORM.DIST(B8, B4, B5, TRUE) Probability for X > X Value 9 Z Value =STANDARDIZE(B13, B4, B5) ="P(X>"&B13&")" =1 - NORM.DIST(B13, B4, B5, TRUE) ="Probability for X<"&B8&" or X >"&B13 ="P(X<"&B8&" or X >"&B13 & ")" =B10 + B15 Probability for a Range From X Value 5 To X Value 9 ="Z Value for " &B21 =STANDARDIZE(B21, B4, B5) ="Z Value for " & B22 =STANDARDIZE(B22, B4, B5) ="P(X<="&B21&")" =NORM.DIST(B21, B4, B5, TRUE) ="P(X<="&B22&")" =NORM.DIST(B22, B4, B5, TRUE) ="P("&B21&"<=X<="&B22&")"
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern