***EXCEL FILE PROVIDED THROUGH LINK IN THE INSTRUCTIONS AT THE BEGINNING OF THE TEST***

***"DATA 2" CAN BE FOUND AS THE SECOND"WORKSHEET" IN THE EXCEL FILE PROVIDED***

As the quality control manager at a plant that produces cereal, you would like to ensure that the average amount of cereal being put in each box is 455g. A random sample is contained below (this sample is also contained in theDATA 2tab of the downloaded Excel file).At a 5% significance level, can you conclude that the average fill level is different than 455g?

Cereal Box Fill Levels451.48453.62452.03455.14457.1455.61458.61458.96452.53452.54455.43452.32455.12457.6455.6457.44458.39457.57456.79457.06456.23457.05453.04458.26455.75453.37456.89458.99457.79457.68456.13457.85458.65458.98457.98457.46455.09457.72458.69456.22455.58451.83453.19458.58455.72456.69457.85453.13458.83457.25452.78454.92453.69451.17455.72455.38458.16457.24453.28451454.92457.65452.88456.1452.62

a) Properly state the hypotheses:(1 mark)

b) Calculate the p-value (SHOW ALL WORK):(3 marks)

IN ORDER TO SHOW YOUR WORK FOR PART B...CREATE A TABLE THAT MIMICS THE EXCEL FUNCTION YOU ARE USING...YOUR ANSWER SHOULD INCLUDE THE FOLLOWING:

1) FUNCTION NAME:

2) FIELD 1 ENTRY:

3) FIELD 2 ENTRY:

4) FIELD 3 ENTRY:

5) FIELD 4 ENTRY:

6) YOUR FINAL ANSWER:

IF THERE ARE NOT 4 "ARGUMENTS" FOR THE EXCEL FUNCTION, INCLUDE ONLY THE NUMBER OF FIELDS THAT ARE APPLICABLE.

YOUR FIELD ENTRIES MUST BE NUMERICAL VALUES...NOT CELL REFERENCES

c) Conclusion:(Must be mathematically justified)(1 mark)