Please help me to enter data in A3:B7 the color of 5nips and their total.

Then please Calculate the variancefor midterm scoresby breaking down the formula :

/(N-1). Where: is the mean, X_i is each scores of the variables, and N is the number of scores

Enter the following labels in the appropriate cells:

A9: Mean =

A10: N =

A11: Variance =

A12: Std Dev =

C2:=

D2:=

3.Enter the following fomula:

B9:=average(B3:B7)

B10:=count(B3:B7)

4.Enter the following formula:

C3: =B3-$B$9

Copy the formula up to C7.

5.Enter the formula:

D3:= C3^2

Copy the formula up to D7.

6.Enter the following formula:

D9:=sum(D3:D7) then

B12:=D9/(B10-1)

7.Enter the following formula:

B13:=sqrt(B12)

8.By now, you should have completed your table. For excel shortcuts:

A14:=min(B3:B7)

A15: =max(B3:B7)

A16:=mode(B3:B7)

A17:=median(B3:B7)

A18:=var(B3:B7)

A19:=stdev(B3:B7)

10. Formulate your conclusion

Manual Computation

For these 14 scores as shown in the table, solve the following:

a.Mean

b.Median

c.Mode

d.Range

e.sample variance

f.sample standard deviation.