17.3.1.1 The One-Sample T-Test Dialog Box


Supporting Information

To open the One-Sample t-Test dialog box:

  1. With a worksheet active, click Statistics: Hypothesis Testing: One-Sample t-Test...

See Also:

Recalculate

Recalculate

Controls recalculation of analysis results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input

Input Data Form

Summarized Data

Enter value of mean, standard deviation and sample size data for sample(s), in the form as "mean SD N" (space separated numbers)

Raw Data

Enter column with range format. For help with range controls, see: Specifying Your Input Data
Input

Enter the input data.

t-Test for Mean

Test Mean The hypothetical mean to be tested. When you enter a value, null and alternate hypotheses are adjusted accordingly.
Null Hypothesis The null hypothesis to be tested.

(Mean = Test Mean)

Alternate Hypothesis The alternate hypothesis.

Options:

Mean <>Test Mean

Used for two-tailed test. Test whether the sample mean differs from the hypothesized mean.

Mean >Test Mean

Used for upper-tailed test. Test whether the sample mean is greater than the hypothesized mean.

Mean <Test Mean

Used for lower-tailed test. Test whether the sample mean is less than the hypothesized mean.
Significance Level Specify a significance level.
Effect Size Calculate Cohen's d value to show the effect size which is the magnitude of the difference between actual mean and test mean.
Confidence Interval(s) Compute confidence interval for the mean.

For computation details, see Algorithms (One-Sample T-Test).

Confidence Level(s) in % Specify space-separated confidence levels, (1-\sigma)%. Available when Confidence Interval(s) is selected.

Power Analysis

Minimal Difference of Interest Specify the minimum difference from the test mean you are interested in. Once you enter a value in this box, the Power Anlysis graph will show the minimum sample size to detect this difference in the different powers.
Actual Power Compute the power of the test (the probability of rejecting the null hypothesis when it is false).
Significance Level Only available when Hypothetical Power and/or Actual Power are checked. This is the significance level (alpha value) for power computation.
Hypothetical Power Compute the power of the test at various sample sizes.
Hypothetical Sample Size(s) Only available when Hypothetical Power is checked. Specify hypothetical sample size(s) for power computation.

Plots

Box Chart Plot a box chart.
Histogram Plot a histogram.
Arrange Plots of Same Type in One Graph Note that for histograms, the layers will be arranged vertically. For box charts, layers will be arranged horizontally.

Output

For help with the range controls, see: Output Results

Results Log Output

Select to output results to the Results Log.

Graphical Summary Report Create a summary graph report, including P value bar, effect size bar and data distribution graph. Three result tables will also been attached to the graph to show the statistical values.

The footnote after the summary graph will diagnose these statistical results.

Graphical Power Analysis Report Create a graphical power analysis report with power curve(s).

If no value has been set for Minimal Difference of Interest editbox, only the power curve of current sample size will be output; and the power at 60%, 70%, 80% and 90% will be tagged to show the difference at these power values. If a difference value has been set for Minimal Difference of Interest editbox, five power curves will be output: power curves at around 60%, 70%, 80% and 90% and current sample size; and the sample size to detect the minimal difference will be listed.

A footnote will be added after the power curve graph to show you the diagnosis results of power analysis. A power value of 80% is usually considered sufficient.

Output Plot Data Specify a worksheet for output of plotted data (Origin generates tabular data when plots are created).

This item is only available when the Input Data Form is Raw.

Output Results Specify the worksheet for output of test results.