Axial Strain Strain 0.00E+00 1 2 3 4 5 6 7 8 9 9 Mean 1.73E-06 0.000129956 0.000256637 0.000377329 0.000501159 0.000620653 0.000729995 0.000859699 0.000978794 0.00109658 0.00121562 0.0011093 0.00098216 0.000873502 0.000747905 0.000625444 0.00050498 0.000378185 0.000241351 0.000133321 3.67E-06 Standard Deviation Load 6.05E-06 6.57E-06 0.000127488 8.80E-06 0.000253248 9.41E-06 0.000374653 7.65E-06 0.000494502 5.77E-06 0.000613765 6.81E-06 0.000733973 5.77E-06 0.000856749 7.89E-06 0.000982982 6.39E-06 0.00110199 5.56E-06 0.00121882 5.64E-06 0.00110452 5.85E-06 Chart Area 7 6.89E-06 0.0000 75902 6.65E-06 0.000741851 5.76E-06 0.000617244 7.44E-06 0.000500742 5.92E-06 0.000378477 6.70E-06 0.000256939 7.94E-06 0.000129985 6.50E-06 7.58E-06 5.34E-06 10 9 8 7 6 LC 5 5 4 3 3 2 1 0.00E+00 1. (a) Plot the calculated axial stress (y-axis) vs. the measured axial strain (x-axis) for the ascending order of measurements (graph 1) and the descending order of measurements (graph 2) in one chart, and show the hysteresis of the strain measurement. (b) Use the statistical analysis in Excel to obtain the linear regression parameters (slope, intercept, and standard deviations) for all data points in this chart (21 data points). (c) Report the stress-strain equation as follows: o = do + 018 2. Report the 95% confidence interval of the obtained modulus of elasticity. The confidence interval of the modulus of elasticity is given by tv,95%Saz: Axial Strain Strain 0.00E+00 1 2 3 4 5 6 7 8 9 9 Mean 1.73E-06 0.000129956 0.000256637 0.000377329 0.000501159 0.000620653 0.000729995 0.000859699 0.000978794 0.00109658 0.00121562 0.0011093 0.00098216 0.000873502 0.000747905 0.000625444 0.00050498 0.000378185 0.000241351 0.000133321 3.67E-06 Standard Deviation Load 6.05E-06 6.57E-06 0.000127488 8.80E-06 0.000253248 9.41E-06 0.000374653 7.65E-06 0.000494502 5.77E-06 0.000613765 6.81E-06 0.000733973 5.77E-06 0.000856749 7.89E-06 0.000982982 6.39E-06 0.00110199 5.56E-06 0.00121882 5.64E-06 0.00110452 5.85E-06 Chart Area 7 6.89E-06 0.0000 75902 6.65E-06 0.000741851 5.76E-06 0.000617244 7.44E-06 0.000500742 5.92E-06 0.000378477 6.70E-06 0.000256939 7.94E-06 0.000129985 6.50E-06 7.58E-06 5.34E-06 10 9 8 7 6 LC 5 5 4 3 3 2 1 0.00E+00 1. (a) Plot the calculated axial stress (y-axis) vs. the measured axial strain (x-axis) for the ascending order of measurements (graph 1) and the descending order of measurements (graph 2) in one chart, and show the hysteresis of the strain measurement. (b) Use the statistical analysis in Excel to obtain the linear regression parameters (slope, intercept, and standard deviations) for all data points in this chart (21 data points). (c) Report the stress-strain equation as follows: o = do + 018 2. Report the 95% confidence interval of the obtained modulus of elasticity. The confidence interval of the modulus of elasticity is given by tv,95%Saz
