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