Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions