P$($Profit $<mtext></mtext><mn>1</mn><mn>1</mn><mn>0</mn><mn>0</mn><mi>)</mi>$

Task $2.$ Draw three boxplots in the same space, one for each column of simulated profits.

Task $3.$ Answer the following questions based on the statistics calculated in Task $1.$

If he buys $100$ ft $,$ there is about a $5\%$ chance that his profit will be greater than

based

on the number in cell address

$($Example cell address format: A$10)$

If he buys $80$ ft $,$ there is about a $50\%$ chance that his profit will be greater than

based

on the number in cell address

Let us assume that he bought $80$ ft of wire after the analysis. At an extra cost of $$120,$ he can get $20$

additional feet of wire. Would you recommend him to do so$?$ Why or Why not? Explain below using

the cell address in your statistics table. $($For example, his average profit when he purchases $80$ ft of

wire is $$12,345$ which is in G$5....)$