A study was undertaken to compare the use of 'out of school hours care' centres before and after school. A random sample of 50 out of school hours care centres across Sydney was selected. Download and open thechildcare.xlsxfile in Excel. This file contains the number of children booked in, both before and after school, at each centre on a randomly selected mid-week school day.

Use Excel to carry out a suitable test to address the following research question:Among out of school hours care centres in Sydney, does the average number of children attending before school care differ from the average number of children attending after school care?

(A) Histogram of after (B) Histogram of before (C) Histogram of differences (after-before) 12 8 10 2 Frequency Frequency Frequency 6 30 35 Number attending care after Number attending care before Difference in number attending care Use your Excel output, and any appropriate plots provided to answer the following questions. For each question, either choose the most correct option, or type in the answer to the number of decimal places specified. 1. (1 mark) The most appropriate test for these data is A paired t-test 2. (1 mark) Referring to the histograms provided, to check the assumption(s) for this test we would use Differences between after school numbers and before school numbers (Graph C) * 3. (2 marks) The absolute value of the test statistic is equal to (type your answer with 3 dp) 0.309 X 4. (1 mark) The degrees of freedom is equal to (type your answer as an integer) 49 5. (1 mark) The p-value is larger than 0.05 true * 6. (2 marks) The test indicates that among out of school hours centres: the average number of children enrolled before school is significantly higher than the average number enrolled after school. * x