UNISTAT - the ultimate Excel statistics add-in

Sample Size and Power Estimation: Phi Distribution in Excel with Unistat

The Unistat statistics add-in extends Excel with Sample Size and Power Estimation: Phi Distribution capabilities.

Further documentation is available at section 6.7.8 of the manual, Sample Size and Power > Phi Distribution.

Sample output

Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.

Sample Size and Power Estimation: Phi Distribution

Phi Distribution

Phi 3.0000
Numerator Degrees of Freedom 4.0000
Denominator Degrees of Freedom 20.0000
Confidence Level 0.9900
Power of the Test 0.9899

Sample Size and Power Estimation: Phi Distribution

Inverse Phi Distribution

Power of the Test 0.9050
Numerator Degrees of Freedom 7.0000
Denominator Degrees of Freedom 12.0000
Confidence Level 0.9500
Phi 1.9980