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

Essay

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}$