UNISTAT - the ultimate Excel statistics add-in

Regression with Replicates in Excel with Unistat

The Unistat statistics add-in extends Excel with Regression with Replicates capabilities.

Further documentation is available at section 7.4.4 of the manual, Regression with Replicates.

Sample output

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

Regression with Replicates

For Coded Data, classified by Formulation

Constant 0.2500
Slope 0.0000
R-squared 0.0033
Standard Error 5.4123

ANOVA of Regression

Due ToSum of SquaresDoFMean SquareF-StatSignif
Regression 2.251 1 2.251 0.077 0.7841
Error 673.749 23 29.293
Total 676.000 24 28.167

Test of linearity

Due ToSum of SquaresDoFMean SquareF-StatSignif
Among groups 330.000 4 82.500 4.769 0.0073
Regression 2.251 1 2.251 0.130 0.7221
Error 327.749 3 109.250 6.315 0.0034
Within Groups 346.000 20 17.300
Total 676.000 24 28.167