Formulas with random time sequence with index starting with i=0 and conditional formatting. The following worksheet computes 10 random values using RAND() and finds the average,variance and standard deviation.
a.What is the formula in E2?
b.What is the formula in E4?
c.What is the formula in E6?
d.The cells in Column B that are less than the ________ are highlighted using conditional
formatting.
$\begin{array}{|l|l|l|l|l|l|}
\hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{E} \
\hline 1 & \mathrm{I} & \mathrm{Y}_{\mathrm{i}} & & & \
\hline 2 & 0 & 0.974928 && \text { Aue }(Y)= & 0.43504 \
\hline 3 & 1 & 0.510697 & & \
\hline 4 & 2 & 0.135691 && \text { VarIYI= } & 0.096131 \
\hline 5 & 3 & 0.138395 & & \
\hline 5 & 4 & 0.78206 && 5 D(Y)= & 0.31005 \\hline 7 & 5 & 0.249 \
\hline 8 & 5 & 0.16439 \
\hline 9 & 7 & 0.69363 \
\hline 10& 8 & 0.149533 \
\hline 11 & 9 & 0.552078 \
\hline
\end{array}$

Question

Formulas with random time sequence with index starting with i=0 and conditional formatting. The following worksheet computes 10 random values using RAND() and finds the average,variance and standard deviation.
a.What is the formula in E2?
b.What is the formula in E4?
c.What is the formula in E6?
d.The cells in Column B that are less than the ________ are highlighted using conditional
formatting.
 $\begin{array}{|l|l|l|l|l|l|}
\hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{E} \
\hline 1 & \mathrm{I} & \mathrm{Y}_{\mathrm{i}} & & & \
\hline 2 & 0 & 0.974928 && \text { Aue }(Y)= & 0.43504 \
\hline 3 & 1 & 0.510697 & & \
\hline 4 & 2 & 0.135691 && \text { VarIYI= } & 0.096131 \
\hline 5 & 3 & 0.138395 & & \
\hline 5 & 4 & 0.78206 && 5 D(Y)= & 0.31005 \\hline 7 & 5 & 0.249 \
\hline 8 & 5 & 0.16439 \
\hline 9 & 7 & 0.69363 \
\hline 10& 8 & 0.149533 \
\hline 11 & 9 & 0.552078 \
\hline
\end{array}$

Quizplus · Accepted Answer

The Answer of Formulas with random time sequence with index starting with i=0 and conditional formatting. The following worksheet computes 10 random values using RAND() and finds the average,variance and standard deviation.
a.What is the formula in E2?
b.What is the formula in E4?
c.What is the formula in E6?
d.The cells in Column B that are less than the ________ are highlighted using conditional
formatting.
 $\begin{array}{|l|l|l|l|l|l|}
\hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{E} \
\hline 1 & \mathrm{I} & \mathrm{Y}_{\mathrm{i}} & & & \
\hline 2 & 0 & 0.974928 && \text { Aue }(Y)= & 0.43504 \
\hline 3 & 1 & 0.510697 & & \
\hline 4 & 2 & 0.135691 && \text { VarIYI= } & 0.096131 \
\hline 5 & 3 & 0.138395 & & \
\hline 5 & 4 & 0.78206 && 5 D(Y)= & 0.31005 \\hline 7 & 5 & 0.249 \
\hline 8 & 5 & 0.16439 \
\hline 9 & 7 & 0.69363 \
\hline 10& 8 & 0.149533 \
\hline 11 & 9 & 0.552078 \
\hline
\end{array}$

Formulas with Random Time Sequence with Index Starting with I=0