How $dowe$ solve these steps using the excel sheet provided below

$1)$ Please compute the area and failure strength $($stress at failure$)$

$2$lease plot a cumulative $\%$ stronger than plot.

$3$Determine the standard deviation of the stress.

$4$Finally, discuss the level of stress that should be used in design based on this assessment and describe why you selected the value you chose.

This can be done by hand or can be done more easily in Excel or a spreadsheet software.

If you have not used Excel before please reach out and we can share some pointers.

$\backslash$table$[[$Sample Number,Width $($in$),$Thick $($in$),$orce $($kips$)],[1,0\mathrm{.}450,0\mathrm{.}134,3618\mathrm{.}0],[2,0\mathrm{.}439,0\mathrm{.}131,3318\mathrm{.}9],[3,0\mathrm{.}415,0\mathrm{.}124,3203\mathrm{.}5],[4,0\mathrm{.}461,0\mathrm{.}137,3937\mathrm{.}9],[5,0\mathrm{.}460,0\mathrm{.}137,3685\mathrm{.}5],[6,0\mathrm{.}453,0\mathrm{.}135,3629\mathrm{.}8],[7,0\mathrm{.}444,0\mathrm{.}132,3553\mathrm{.}4],[8,0\mathrm{.}431,0\mathrm{.}128,3075\mathrm{.}7],[9,0\mathrm{.}441,0\mathrm{.}131,3538\mathrm{.}1],[10,0\mathrm{.}466,0\mathrm{.}139,3811\mathrm{.}7],[11,0\mathrm{.}450,0\mathrm{.}134,3653\mathrm{.}4],[12,0\mathrm{.}460,0\mathrm{.}137,3984\mathrm{.}5],[13,0\mathrm{.}447,0\mathrm{.}133,3320\mathrm{.}6],[14,0\mathrm{.}465,0\mathrm{.}139,4163\mathrm{.}2],[15,0\mathrm{.}443,0\mathrm{.}132,3546\mathrm{.}1],[16,0\mathrm{.}449,0\mathrm{.}134,3455\mathrm{.}4],[17,0\mathrm{.}452,0\mathrm{.}135,3573\mathrm{.}7],[18,0\mathrm{.}458,0\mathrm{.}136,3788\mathrm{.}0],[19,0\mathrm{.}475,0\mathrm{.}141,4159\mathrm{.}2],[20,0\mathrm{.}429,0\mathrm{.}128,3102\mathrm{.}0],[21,0\mathrm{.}462,0\mathrm{.}138,3706\mathrm{.}3],[22,0\mathrm{.}439,0\mathrm{.}131,3432\mathrm{.}6],[23,0442,0\mathrm{.}132,3553]]$