Microsoft Office Tutorials and References

In Depth Information

Fig. 4.1
Sample Survey Item for Item #7 of the AIBS Survey (Practical Example)

called
BioScience
. Its Website links to Career Possibilities for biologists in

academics, government, and private industry. Let’s suppose that AIBS has sent

an Internet survey to its members asking them to evaluate its Website in terms of its

career possibilities section.

The survey contains a number of items, but suppose a hypothetical Item #7 is the

one in Fig.
4.1
:

Suppose further, that you have decided to analyze the data from members using

the one-group t-test.

Important note:
You would need to use this test for each of the survey items

separately.

Suppose that the hypothetical data for Item #7 of the AIBS Website were based

on a sample size of 124 members who had a mean score on this item of 6.58 and a

standard deviation on this item of 2.44.

Objective
: To analyze the data for each question separately using

the one-group t-test for each survey item.

Create an Excel spreadsheet with the following information:

B11: Null hypothesis:

B14: Research hypothesis:

Note:
Remember that when you are using a rating scale item, both the null

hypothesis and the research hypothesis refer to the “middle of the scale.” In the

10-point scale in this example, the middle of the scale is 5.5 since ﬁve numbers are

below 5.5 (i.e., 1-5) and ﬁve numbers are above 5.5 (i.e. 6-10). Therefore, the

hypotheses for this rating scale item are:

H
0
:

m
═

5.5

H
1
:

m
6¼

5.5

B17: n

B20: mean

B23: STDEV

B26: s.e.

B29: critical t

B32: t-test

B36: Result:

B41: Conclusion:

Search JabSto ::

Custom Search