1. Develop and interpret a 95%confidence intervalfor the Alberta Total Cattle At January 1 On Beef Operations. Generate the output using MegaStat and then include a full interpretation following the output.

Alberta

Total cattle

At January 1

On beef operations

5403.1

5627

5638.8

5134.8

5491.9

5745.5

5724.7

5512

5358.2

5183.9

4956.6

4674.8

4796.7

4881.3

4896.2

4723.8

1. Various interest groups are claiming that cattle operations are increasing in size all the time. However, other industry groups say the number of cattle in Alberta on all cattle operations has in fact decreased from the long-term annual average of 5,600 (in thousands).

Using a 5% significance level, test the hypothesis that the average number "on all cattle operations" over the last 15 years isless than5,600 (in thousands). Includeall 5 stepsand a full interpretation. Use MegaStat to generate the test statistic for Step 4 of the 5 step hypothesis procedure.

Alberta

Total cattle

At January 1

On all cattle operations

5590

5829

5825

5310

5675

5930

5900

5680

5530

5345

5120

4855

4975

5060

5075

4900

Calculating statistics

All stats are to be calculated using MegaStat in Microsoft Excel. "Answers" should all be on one "output" tab in Excel. Please ensure the answers, especially your interpretations, are clearly noted/highlighted.