Construction contractor made five distinct concrete mixes, each with a different amount of cement, admixtures, water, and so on. Each mix received 5 samples, which were then submitted to compressive and tensile testing to assess concrete strength. We assume that the data are normally distributed, and that the standard deviation calculated for each sample is ?. Do the following below using excel formulas and excel only.

1. Find the average value along with a 95% confidence interval of this average value.
2. Separate modeling efforts indicated that the ideal mix must have a compressive strength greater than 800 psi. Using the hypothesis testing framework, write null and alternative hypotheses and then test each mix. Report the hypothesis testing results, along with the p-value.

Mix 1 Mass (g) Compress (psi) Tensile (psi) 192.8 857 170.5 189.4 814 165.6 189.6 688 193.1 181.4 777 144.1 188.2 163.3 AVERAGE 784 167 Mix 2 Mass (g) Compress (psi) Tensile (psi) 171.0 667 160.7 177.3 649 159.5 175.2 792 124.1 177.3 673 145.1 176.3 750 AVERAGE 706.20 147.36 Mix 3 Mass (g) Compress (psi) Tensile (psi) 183.8 675 139.2 175.9 738 191.4 175.8 633 181.0 182.0 773 119.8 176.2 690 AVERAGE 701.80 157.84 Mix 4 Mass (g) Compress (psi) Tensile (psi) 188.0 1057 214.7 183.8 1142 175.8 194.5 1334 208.4 182.8 1336 196.9 183.1 973 163.9 AVERAGE 1168.40 191.94 Mix 5 Mass (e) Compress ( Tensile (psi) 168.8 1047 200.2 187.8 1095 212.4 174.4 1028 215.3 184.6 1189 257.0 171.5 591 210.2 AVERAGE 990.00 219.03