To use this function, choose .
Conducts the Freeman-Tukey transformation to stabilize variance for Poisson data (counts). For example, you can transform attribute data so that the assumptions of the regression or ANOVA model are met.
Syntax
FTC(Count)
For Count, specify a column or stored constant that contains only nonnegative integers.
Example
An editor tracks the number of typographical errors per issue over the course of the year (52 issues). For each error frequency she finds (0-4), the editor records the number of issues, which results in a Poisson distribution. To stabilize the variance before conducting regression, the editor transforms the counts. The editor enters the expression FTC(C1) and stores the results in C3.
| C1 | C2 | C3 |
|---|---|---|
| Number of errors | Issues | Transform counts |
| 0 | 7 | 0.50000 |
| 1 | 12 | 1.20711 |
| 2 | 15 | 1.57313 |
| 3 | 10 | 1.86603 |
| 4 | 8 | 2.11803 |
Formula
Bisgaard, Soren and Howard T. Fuller (1994) Quality Quandaries, Analysis of Factorial Experiments with Defects or Defectives as the Response, Quality Engineering, 7(2), 429–443.
