1. No category

Appendix 8.2
One-Sample Hypothesis Testing Using MegaStat
1
Appendix 8.2 ■ One-Sample Hypothesis Testing Using MegaStat
The instructions in this section begin by describing the entry of data into an Excel worksheet. Alternatively, the
data may be downloaded from this book’s website. Please refer to Appendix 1.1 for further information about
entering data and saving and printing results in Excel. Please refer to Appendix 1.2 for more information about
using MegaStat.
Hypothesis test for a population mean:
•
Enter the interest rate data into cells A2:A16
with the label Rate in cell A1.
•
Select Add-Ins : MegaStat : Hypothesis Tests :
Mean vs. Hypothesized Value
•
In the “Hypothesis Test: Mean vs. Hypothesized Value” dialog box, click on “data
input” and use the autoexpand feature to
enter the range A1: A16 into the Input
Range window.
•
Enter the hypothesized value (here equal to
18.8) into the Hypothesized Mean window.
•
Select the desired alternative (here “less
than”) from the drop-down menu in the
Alternative box.
•
Click on t-test and click OK in the “Hypothesis
Test: Mean vs. Hypothesized Value” dialog
box.
•
A hypothesis test employing summary data
can be carried out by clicking on “summary
data,” and by entering a range into the
Input Range window that contains the
following—label; sample mean; sample
standard deviation; sample size n.
A z test can be carried out (in the unlikely event
that the population standard deviation is known)
by clicking on “z-test.”
Hypothesis test for a population proportion. Consider
testing H0: p ⫽ .05 versus Ha: p ⬎ .05, where n ⫽ 250
and ˆ
p ⫽ .16.
•
Select Add-Ins : MegaStat : Hypothesis Tests :
Proportion vs. Hypothesized Value
•
In the “Hypothesis Test: Proportion vs.
Hypothesized Value” dialog box, enter the
hypothesized value (here equal to 0.05) into
the “Hypothesized p” window.
•
Enter the observed sample proportion (here
equal to 0.16) into the “Observed p” window.
•
Enter the sample size (here equal to 250) into
the “n” window.
•
Select the desired alternative (here “greater
than”) from the drop-down menu in the
Alternative box.
•
Check the “Display confidence interval”
checkbox (if desired), and select or type the
appropriate level of confidence.
•
Click OK in the “Hypothesis Test: Proportion vs.
Hypothesized Value” dialog box.
2
Chapter 8
Hypothesis Testing
Hypothesis test for a population variance in the
camshaft situation:
•
Enter a label (in this case Depth) into cell A1,
the sample variance (here equal to .0885)
into cell A2, and the sample size (here equal
to 30) into cell A3.
•
Select Add-Ins : MegaStat : Hypothesis Tests :
Chi-square Variance Test
•
•
Click on “summary input.”
•
Enter the hypothesized value (here equal to
0.2209) into the “Hypothesized variance”
window.
•
Select the desired alternative (in this case
“less than”) from the drop-down menu in
the Alternative box.
•
Check the “Display confidence interval”
checkbox (if desired) and select or type the
appropriate level of confidence.
•
Click OK in the “Chi-square Variance Test”
dialog box.
•
A chi-square variance test may be carried
out using data input by entering the
observed sample values into a column in the
Excel worksheet, and by then using the
autoexpand feature to enter the range
containing the label and sample values into
the Input Range window.
Enter the range A1:A3 into the Input Range
window—that is, enter the range containing
the data label, the sample variance, and the
sample size.