Please workout problem in Microsoft Excel. The answer is either a, b, or c shown
ID: 3183009 • Letter: P
Question
Please workout problem in Microsoft Excel. The answer is either a, b, or c shown below.
Calculate an upper confidence bound with confidence level 95% for the population standard deviation of maximum pressure.
The article "Concrete Pressure on Formwork" (Mag. Of Concrete Res. 2009: 407-417) gave the following observations on maximum concrete pressure (kN/m2) Calculate an upper confidence bound with confidence level 95% for the population standard deviation of maximum pressure. a) Upper CI = 2.005 b) Upper CI = 1.9760 c) Upper CI = 3.7536Explanation / Answer
from above
for 95% CI and 14 degree of freedom X20.95,14 =6.5706
hence upper bound =((n-1)s2/ X20.95,14 )1/2 =3.7536
hence option C is correct
X 33.2 41.8 37.3 40.2 36.7 39.1 36.2 41.8 36 35.2 36.7 38.9 35.8 35.2 40.1 mean 37.613 std deviation(S) 2.572