ISC 191, Summer 2014, Garren
-------------------------------------------------------------------------
Let Z ~ N( μ = 0, σ = 1 ), and let X ~ N( μ = 60, σ = 5 ).
-------------------------------------------------------------------------
(A) Use Excel for each of the following.
(1) Compute P(Z < −1.2).
(2) Compute P(Z > 1.5).
(3) Compute P( −1.96 < Z < 1.96).
(4) Compute P(X > 53).
(5) Compute P(X < 49).
(6) Compute P(58 < X < 66).
(7) Find t such that P(Z < t)=0.95.
(8) Find t such that P(Z > t)=0.7.
(9) Find t such that P(X < t)=0.85.
(10) Find t such that P(X > t)=0.32.
-------------------------------------------------------------------------
(B) Clearly label each of your ten parts in part (A).
-------------------------------------------------------------------------
(C) Use Excel to randomly generate 500 values of X, and construct a histogram of these 500 values.
-------------------------------------------------------------------------
(D) In your output, use Excel to write your name.
(E) Although you are allowed to receive help from others, list the names of those who helped you and the names of those whom you helped, as well as what type of help was given. If you did not give or receive help, then write "No help."
(F) Send your homework to me using Canvas.
Return to Dr. Garren's home page.