Wesley McLaughlin Busn210Test03

Wesley McLaughlin Busn210Test03 -...

Info iconThis 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/10/2012 for the course BUSN 210 taught by Professor Girvin during the Winter '09 term at Des Moines CC.

Page1 / 7

Wesley McLaughlin Busn210Test03 -...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online