Excel Assignment data set 1.
Enter the data in Excel. Make sure you answer the questions completely and correctly.
- The National Climatic Data Center collected air pressure in a certain city in January, 2001. The following table gives measurements that some of the stations obtained.
62
|
36
|
61
|
27
|
61
|
31
|
56
|
61
|
59
|
62
|
60
|
59
|
61
|
62
|
61
|
125
|
0
|
124
|
93
|
5
|
58
|
1
|
120
|
124
|
29
|
5
|
7
|
0
|
40
|
124
|
62
|
124
|
124
|
61
|
55
|
62
|
61
|
33
|
60
|
60
|
|
|
|
|
|
|
|
|
|
|
a)
Construct a relative frequency histogram for this data using five classes: 0-25, 26-50, 51-75, 76-100, 101-125
b) Calculate the mean and the standard deviation
- Here are data on the number of people bitten by alligators in FL over a 36-year period:
Year
|
Number
Bitten
|
Year
|
Number
Bitten
|
Year
|
Number
Bitten
|
Year
|
Number
Bitten
|
1972
|
4
|
1981
|
10
|
1990
|
17
|
1999
|
16
|
1973
|
3
|
1982
|
7
|
1991
|
20
|
2000
|
23
|
1974
|
4
|
1983
|
9
|
1992
|
15
|
2001
|
25
|
1975
|
5
|
1984
|
9
|
1993
|
19
|
2002
|
17
|
1976
|
2
|
1985
|
7
|
1994
|
20
|
2003
|
12
|
1977
|
14
|
1986
|
23
|
1995
|
22
|
2004
|
13
|
1978
|
7
|
1987
|
13
|
1996
|
13
|
2005
|
15
|
1979
|
2
|
1988
|
18
|
1997
|
8
|
2006
|
18
|
1980
|
5
|
1989
|
13
|
1998
|
9
|
2007
|
18
|
a) Using Excel make a histogram (Use 5 to 10 classes) of the counts of people bitten by alligators.
b) Using Excel make a time plot of the data as well. What is the overall trend of people being bitten by alligators?
Excel Assignment # 2.
- Construct a Pie Chartanda Bar Chart for the data below.
Sneakers Sold for July 2012 at
Dick’s Sporting Goods, Winston-Salem, NC
Brand Name
|
Number Sold
|
Adidas
|
150
|
Nike
|
192
|
Reebok
|
60
|
Asics
|
108
|
Other
|
90
|
- For the data set below. (a) Decide on a class size (Use at least five classes and at most ten classes), determine the appropriate class width and then construct a frequency distribution. (b) Use EXCEL to draw a histogram based on your frequency distribution. (c) Determine if this data (sample) comes from a normally distributed population.
Data that is normally distributed is symmetric, has one peak near the center and very little data at the lower or upper extremes.Normally distributed data also follows the following 68-95-99.7 rule:
- 68% of the data lies within 1 standard deviation of the mean
- 95% of the data lies within 2 standard deviations of the mean
- 99.7% of the data lies within 3 standard deviations of the mean.
The data set below gives the administrators salary in a mid-size University in thousands (for example, 127 stands for $127,000) for 2014.
Administrators Salaries in Thousands
127
|
70
|
83
|
96
|
117
|
41
|
72
|
138
|
98
|
80
|
110
|
100
|
86
|
99
|
118
|
60
|
73
|
87
|
100
|
120
|
61
|
132
|
88
|
101
|
121
|
64
|
76
|
89
|
102
|
125
|
65
|
77
|
91
|
103
|
127
|
111
|
79
|
93
|
106
|
131
|
67
|
80
|
95
|
108
|
135
|
67
|
81
|
113
|
109
|
139
|
69
|
81
|
111
|
153
|
140
|
112
|
115
|
95
|
90
|
89
|
|
|
|
|
|
d) Using the same data as above, find the Five-number summary and draw the Box-Plot.