Procedure: Regression with Replicates
UNISTAT statistical package extends Excel with Regression with Replicates support.
Sample output
Here we provide annotated example report output from the UNISTAT Excel 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 To | Sum of Squares | DoF | Mean Square | F-Stat | Signif |
|---|
| 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 To | Sum of Squares | DoF | Mean Square | F-Stat | Signif |
|---|
| 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 | | |
|---|