Skip to content

Home / Statistical Tools / Hypothesis Tests / Attribute Tests / One Sample Poisson Rate Test

One Sample Poisson Rate Test

From Excel click...

QXL Stat Tools Tab > Hypothesis Tests > Attribute Tests > One Sample Poisson Rate

Test type: Compare one rate to reference
Data: Attribute -- Counts
Number of Variables: 1
Number of Groups: 1
Assumptions: One sample of count data, Total Occurrences > 10

The One Sample Poisson Rate Test is a hypothesis test used for testing rate equality between a population and a reference. It assumes one sample of count data with 10 or more total observations.

Hypothesis tested:

H0 : Rate1 = Reference
H1 : Rate1 ≠ Reference

where Rate1 is the population's rate.

Step #1: Select data source for One Sample Poisson Rate Test.

Data for the One Sample Poisson Rate Test can come from an Excel spreadsheet, SQL data source, or it can be entered manually.

One Sample Rate Data

Step #2: Options.

Standard options

  • 'Not equal to' option. Select this option to run a two-tailed test. The null hypothesis is that the rates are equal.

  • 'Less Than' option. Select this option to run a lower-tailed test. The alternative hypothesis is that the rate of the first dataset is smaller than the rate of the second dataset.

  • 'Greater Than' option. Select this option to run an upper-tailed test. The alternative hypothesis is that the rate of the first dataset is greater than the rate of the second dataset.

  • 'Hypothesized Rate': Enter a reference rate.

One Sample Rate Results

Example

  • Open one sample Poisson rate worksheet.

  • Run Quantum XL > Hypothesis Tests > Attribute Tests > One Sample Poisson Rate.

  • In the Options dialog, select 'Not equal to' test and enter the hypothesized rate.

Update

The One Sample Poisson Rate Test is updatable. After you create the analysis, you can change its data source or add new data to the data source and simply update the analysis.

  • Update: Quantum XL > Statistical Tools > Update Sheet

  • Change settings: Quantum XL > Statistical Tools > Modify Analysis