Slope Ratio Method in Excel with Unistat

The Unistat statistics add-in extends Excel with Slope Ratio Method capabilities.

Further documentation is available at section 10.2 of the manual, Bioassay Analysis > Slope Ratio Method.

Sample output

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

Slope Ratio Method

Normality Tests

Smaller probabilities indicate non-normality.
* Lilliefors probability = 0.2 means 0.2 or greater.

Dose x Preparations	Valid Cases	Mean	Standard Deviation	Shapiro-Wilk Test	Probability	Kolmogorov-Smirnov Test	* Probability	Cramer-von Mises Test
0 x Blank	4	41.7500	3.3040	0.9157	0.5130	0.2521	0.2000	0.0443
0.5 x Standard	4	100.0000	3.5590	0.8947	0.4051	0.2500	0.2000	0.0518
1 x Standard	4	161.5000	4.9329	0.9646	0.8081	0.1939	0.2000	0.0304
0.5 x Test	4	85.0000	4.7610	0.9110	0.4877	0.2357	0.2000	0.0463
1 x Test	4	122.2500	1.2583	0.8949	0.4064	0.3287	0.1554	0.0676
Dose x Preparations	Probability	Anderson-Darling Test	Probability
0 x Blank	0.5124	0.2706	0.4502
0.5 x Standard	0.3989	0.3151	0.3280
1 x Standard	0.7840	0.1973	0.7044
0.5 x Test	0.4814	0.2783	0.4263
1 x Test	0.2335	0.3610	0.2343

Homogeneity of Variance Tests

	Test Statistic	Probability
Bartlett's Chi-square Test	4.3575	0.3598
Bartlett-Box F Test	1.1126	0.3498
Cochran's C (max var / sum var)	0.3372	0.8137
Hartley's F (max var / min var)	15.3684
Levene's F Test	3.3168	0.0390

Validity of Assay

Due To	Sum of Squares	DoF	Mean Square	F-Stat	Prob
Constant	208488.200	1	208488.200
Regression	31456.914	2	15728.457	1089.731	0.0000
Blanks	2.161	1	2.161	0.150	0.7043
Intercept	34.225	1	34.225	2.371	0.1444
Non-linearity	0.000	0
Standard Non-linearity	0.000	0
Test Non-linearity	0.000	0
Treatments	31493.300	4	7873.325
Residual	216.500	15	14.433
Total	31709.800	19	1668.937

Separate Regression

	Intercept	Slope	Residual SS	R-squared
Standard	38.5000	123.0000	111.0000	0.9855
Test	47.7500	74.5000	72.7500	0.9745

Common Regression

	Intercept	Slope	Residual SS	R-squared
Standard	42.1429	118.6286	252.8857	0.9920
Test		81.2286

Potency

Test Preparation	Assigned Potency	Estimated Potency	Lower 95%	Upper 95%	Variance	Weight	% Precision
Test	1.0000	0.6847	0.6464	0.7236	0.0003	3046.6783	94.3986

G	0.0021
C	1.0021