Question
Background: The datarepresents the number of West Nile virus cases reported per week for one year. By performing all the Descriptive Statistics tests in Excel,
Background: The datarepresents the number of West Nile virus cases reported per week for one year. By performing all the Descriptive Statistics tests in Excel, Merge some cells on a new worksheet.
Using this data, answer the following questions. a. What type of data is this? b. How many records are in the data set? c. What is the minimum value? d. What is the maximum value? e. What is the standard deviation value? f. What is standard deviation value? Why is it important? g. What is the variance value? h. What is the average value? i. What is the median value? j. Look at the skewness value you calculated. Is this data skewed? If yes, then is it a positive or negative skew? List the references that you used to determine this.
Week Number | Number of West Nile Virus Cases |
1 | 6 |
2 | 1 |
3 | 169 |
4 | 1 |
5 | 15 |
6 | 42 |
7 | 6 |
8 | 157 |
9 | 68 |
10 | 6 |
11 | 315 |
12 | 23 |
13 | 6 |
14 | 963 |
15 | 25 |
16 | 4 |
17 | 4 |
18 | 30 |
19 | 2 |
20 | 1 |
21 | 2 |
22 | 3 |
23 | 3 |
24 | 461 |
25 | 47 |
26 | 254 |
27 | 121 |
28 | 157 |
29 | 95 |
30 | 3 |
31 | 83 |
32 | 1 |
33 | 3 |
34 | 29 |
35 | 1 |
36 | 21 |
37 | 2 |
38 | 17 |
39 | 1 |
40 | 174 |
41 | 43 |
42 | 28 |
43 | 90 |
44 | 19 |
45 | 69 |
46 | 21 |
47 | 2 |
48 | 17 |
49 | 1 |
50 | 174 |
51 | 43 |
52 | 28 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started