$1\mathrm{.}6$ Use functions to calculate the

mean, sample standard deviation, and

count for the age of customers who

buy a BMX bicycle.

Use the Task $5-8$ worksheet as

your work area.

Filter the data in the Transactions

worksheet to display the

customers that purchased BMX

bicycle.

Copy and paste the customer ages

for from the filtered data starting in

cell H$3).$

What are the mean, standard

deviation, and count for age of

customers who buy a BMX

bicycle? Select your answer from

the drop down in cell B$6).$

ox $1\mathrm{.}8$ Complete the statistical test for the hypothesis that the average age of customers who buy a BMX bicycle is $47$ or less. What is the $\backslash ($ p $\backslash )$ value for the test and for a given significance level of $0\mathrm{.}05,$ would you reject the null hypothesis?

$-$ Use the Task $5-8$ worksheet as your work area.

$-$ Select your answer from the drop down in cell B$12).$