Rand() to form other random numbers and outcomes.The following work sheet shows Y =
RAND() in A2 expressed in 3 decimal-point precision.Using the value in A2, generate the following random numbers.
a.Y1 in B2 that is uniformly distributed over [-0.5, 0.5) in 3-digit precision.
b.Y2 in C2 that is uniformly distributed over [-2,3)
c.Y3 in D2 simulates a fair coin flip experiment with outcome "H" for head and "T" for tail.
d.Y4 in E2 simulates a fair die toss experiment with outcome 1 to 6.
$$\begin{array} { | c | c | c | c | c | c | }
\hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \
\hline 1 & Y & \mathrm { Y } 1 & \mathrm { Y } 2 & \mathrm { Y } 3 & \mathrm { Y } 4 \
\hline 2 & 0.137 & - 0.363 & - 1.817 & \mathrm {~T} & 1 \
\hline
\end{array}$$

Question

Rand() to form other random numbers and outcomes.The following work sheet shows Y =
RAND() in A2 expressed in 3 decimal-point precision.Using the value in A2, generate the following random numbers.
a.Y1 in B2 that is uniformly distributed over [-0.5, 0.5) in 3-digit precision.
b.Y2 in C2 that is uniformly distributed over [-2,3)
c.Y3 in D2 simulates a fair coin flip experiment with outcome "H" for head and "T" for tail.
d.Y4 in E2 simulates a fair die toss experiment with outcome 1 to 6.
 $$\begin{array} { | c | c | c | c | c | c | } 
\hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \
\hline 1 & Y & \mathrm { Y } 1 & \mathrm { Y } 2 & \mathrm { Y } 3 & \mathrm { Y } 4 \
\hline 2 & 0.137 & - 0.363 & - 1.817 & \mathrm {~T} & 1 \
\hline
\end{array}$$

Quizplus · Accepted Answer

The Answer is

\begin{array} { | c | c | c | c | c | c | } \hline & ext { A } & ext { B } & ext { C } & ext { D } & ext { E } \\hline 1 & Y & ext { Y1 } & ext { Y2 } & ext { Y3 } & ext { Y4 } \\hline 2 & = ext { RAND( } ) & = A 2 - 0.5 & = 5 ^ { * } A 2 - 2.5 & = ext { IF(A2<0.5, "T", "H") } & = ext { CEILING } ( 6 * A 2,1 ) \\hline\end{array}

Rand() to Form Other Random Numbers and Outcomes