a. Build a histogram with the bin values provided (bin width 75) and check whether it is approximately symmetric and bell-shaped.

b. Use Descriptive Statistics function from Data Analysis. i. State the mean, median and mode. ii. What is the degree of skewness?

c. Construct 90%, 95%, and 99% confidence intervals for the average number of new cases in South West Ontario. Interpret each confidence interval. *Show the output of confidence interval (the margin of error by Excel), and then calculate LCL (lower confidence level) and UCL(upper confidence level) by labeling "LCL" and "UCL" for the answers clearly. (Round to whole number)

d. Which interval is narrower? Why?

Number of New Cases over Time in Ontario

Public Reporting Period South West BIN:

Mar 8 - Mar 14 1 75

Mar 15 - Mar 21 30 150

Mar 22 - Mar 28 119 225

Mar 29 - Apr 4 285 300

Apr 5 - Apr 11 300 375

Apr 12 - Apr 18 304

Apr 19 - Apr 25 249

Apr 26 - May 2 188

May 3 -May 9 128

May 10 -May 16 180

May 17 -May 23 168

May 24 -May 30 148

May 31 -June 6 91

June 7 - June 13 210

June 14 - June 20 158

June 17 June 23 178

Total 2737