Question

Mix No.	Water-cement ratio	Cementitious Content	Fine Aggregate ratio	28-day Compressive strength
1	0.38	350	0.35	39.7
2			0.4	38.8
3			0.45	39.1
4		375	0.35	34.1
5			0.4	38.2
6			0.45	40.6
7		400	0.35	34.2
8			0.4	39.3
9			0.45	39.8
10	0.43	350	0.35	27.9
11			0.4	37.4
12			0.45	38.5
13		375	0.35	31.9
14			0.4	37.1
15			0.45	33.9
16		400	0.35	26.5
17			0.4	30.7
18			0.45	26.5
19	0.48	350	0.35	30
20			0.4	32.1
21			0.45	30.5
22		375	0.35	20.7
23			0.4	27.5
24			0.45	39.9
25		400	0.35	25.4
26			0.4	31
27			0.45	25.3
Shamsad A., Saeid A. Alghamdi (2014), "A Statistical Approch to Optimizing Concrete Mixture Design", Hindawi Publishing Corporation, The Scientific World Journal, Volume 2014.

I want  ANOVA hand calculation and if possible output of any design analysis software and find the Normal Probability check of original data and residual, Model regression, Validity of models and Hypothesis testing of coefficient significant

NOTE: I need hand calculation

Thank you

Answer 1