Microsoft Office Tutorials and References

In Depth Information

Fig. 5.15

Queen honeybees body length formula labels for the two-group t-test

You now need to use your Excel skills to compute the values of the above

formulas in the following cells:

H16: the result of the formula needed to compute cell E16 (use 2 decimals)

H19: the result of the formula needed to compute cell E19 (use 2 decimals)

H22: the result of the formula needed to compute cell E22

H25: the result of the formula needed to compute cell E25 (use 2 decimals)

H28: =SQRT(((H16 ? H19)/H22)*H25)

Note the three open-parentheses after SQRT, and the three closed parentheses

on the right side of this formula. You need three open parentheses and three closed

parentheses in this formula or the formula will not work correctly.

The above formula gives a standard error of the difference of the means equal to

0.51 (two decimals) in cell H28.

Search JabSto ::

Custom Search