{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Wesley McLaughlin Busn210Test03

Wesley McLaughlin Busn210Test03 - question Description...

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

View Full Document Right Arrow Icon
770f80071ba37602ca5f8b9a2c57b434a5f2a176.xls s question Description Answer Your Answer Comments Your score 1 calculate your z1 value in the green cell to the left ==> -2.6734693878 -2.6734693878 2.5 2.5 calculate your z2 value in the green cell to the left ==> 3.3469387755 3.3469387755 2.5 2.5 0.9958378974 0.9958378974 2.5 2.5 0.9958378974 0.9999999991 2.5 0 Type a conclusion in the green cell below 2.5 2.5 2 calculate your z1 value in the green cell to the left ==> -2.9148471616 -2.9148471616 2.5 2.5 0.0017793139 0.0017793139 2.5 2.5 0.0017793139 0.0017793139 2.5 2.5 Type a conclusion in the green cell below 2.5 2.5 3 calculate your z1 value in the green cell to the left ==> -0.5 -0.5 2.5 2.5 0.3085375387 0.3085375387 2.5 2.5 0.3085375387 0.3085375387 2.5 2.5 Type a conclusion in the green cell below 30.8538% of the invoices get paid within 15 days 2.5 2.5 4 1.7506860713 1.7506860713 2.5 2.5 587.5343035626 587.5343035626 2.5 2.5 Type a conclusion in the green cell below 2.5 2.5 5 10 10 2.5 2.5 6.8 6.8 2.5 2.5 6.8 6.8 2.5 2.5 the two are the same 2.5 2.5 Total 50 47.5 Possible score Create a formula using the NORMDIST function that calculates the area under the curve in the green cell to the left (Do not round your answer) ==> Create a formula using the NORMSDIST function that calculates the area under the curve in the green cell to the left (Do not round your answer) ==> 99.5838% of the distribution will lie between 907 hours and 612 hours By using the normdist function there is more room for error because we are using a larger formula which allows the number to vary farther away from one rather than using the normsdist function which allows us to use only two numbers being the z- values. Since there are two x-values the normdist function is less accurate. Create a formula using the NORMDIST function that calculates the area under the curve in the green cell to the left (Do not round your answer) ==> Create a formula using the NORMSDIST function that calculates the area under the curve in the green cell to the left (Do not round your answer) ==> The percentage of executives that have an income of $1,093.00 or less is 00.1779% Since there is only one x-value there is no variance in the answers between the normdist function and the normsdist function. Create a formula using the NORMDIST function that calculates the area under the curve in the green cell to the left (Do not round your answer) ==> Create a formula using the NORMSDIST function that calculates the area under the curve in the green cell to the left (Do not round your answer) ==> Since there is only one x-value there is no variance in the answers between the normdist function and the normsdist function. Using the appropriate Excel built-in Function, calculate what z is equal to in the green cell to the left ==> Create a formula that calculate what X is in the green cell to the left ==> The lowest score you can earn and get the position is 587.53 points The lowest score a college graduate must earn to qualify for a responsible position is a 587.534304.
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
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