Microsoft Office Tutorials and References
In Depth Information
Now, enter the other figures into this table. Be sure to double-check all of your
figures. If you have only one incorrect figure, you will not be able to obtain the
correct answer to this problem.
Now, widen columns B and C so that all of the information fits inside the cells. To do this,
click on both letters B and C at the top of these columns on your spreadsheet to highlight
all of the cells in columns B and C. Then, move the mouse pointer to the right end of the B
cell until you get a ‘‘cross’’ sign; then, click on this cross sign and drag the sign to the right
until you can read all of the words on your screen. Then, stop clicking! Both Column B
and Column C should now be the same width.
Then, center all information in the table except the top title by using the
following steps:
Left-click your mouse and highlight cells B5: C17. Then, click on the bottom
line, second from the left icon, under ‘‘Alignment’’ at the top-center of Home. All
of the information in the table should now be in the center of each cell.
E6:
Null hypothesis:
E8:
Research hypothesis:
E11:
Group
E12:
1 Region A
E13:
2 Region B
F11:
n
G11:
Mean
H11:
STDEV
Your spreadsheet should now look like Fig. 5.14 .
Fig. 5.14
Queen honeybees body length worksheet data for hypothesis testing
Now you need to use your Excel skills from Chap. 1 to fill in the sample sizes
(n), the Means, and the Standard Deviations (STDEV) in the Table in cells
Search JabSto ::




Custom Search