Make sure there is no error message in the table you obtained. If there are error messages, it probably means that you didn't make an absolute reference to a cell when it was necessary. What is the mean refund amount?

Type your answer...

$2$ points

In cell H$14,$ we want to calculate the number of times Gear paid more than a $$50$ refund for a tire. Which one do we write in cell $H14$ that number?

$=$COUNTIF$($E$11$:E$1010,"<mn\; id="EditorElement\_1824024">5</mn><mn\; id="EditorElement\_1824025">0</mn><mi\; id="EditorElement\_1824026">"</mi><mi\; id="EditorElement\_1824027">)</mi>$

$=$COUNTIF$($E$11$:E$1010,">50")$

$=$COUNTIF$($E$11$:E$1010,"<mn\; id="EditorElement\_1824076">0</mn><mi\; id="EditorElement\_1824077">"</mi><mi\; id="EditorElement\_1824078">)</mi>$

$=$COUNTIF$($E$11$:E$1010,">0")$

ear my selection

$2$ points

What is the probability that Grear will refund more than $$50$ for a tire? This can be calculated as follows: divide $[$the number of times they pay more than $$50]$ by $[$the number of trials$].$ So$,$ it is $H\frac{14}{1000}$ in our case since we did $1000$ trials. $($Round your answer to three decimal places.$)$

Type your answer.