Question: a . Build a histogram with the bin values provided (bin width 75) and check whether it is approximately symmetric and bell-shaped. b . Use
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help