USA: +1(669)289-8683 
Sign in
I have statistical problems that I need help with. Pie charts, histograms, finding 95% confidence interval, and a hypothesis test with strong statistical evidence are part of the problems to solve—the instructions are in the spreadsheet. I have to submit the problem by Wednesday, October 16, at 9:00 PM (Eastern Time), so I would need the spreadsheet back by 4:00 PM (Eastern Time). Please review the spreadsheet first, and then let me know if someone can complete the problem by Wednesday. Thanks.
>Question M 7 F F 3 M 4 M 4 F 6 M 6 F 6 20 F 0 M 4 M 5 32 F 5 M 0 22 M 0 F 0 F 7 M 0 F 5 F 6 F 4 20 M 5 20 M 1 F 3 M 4 53 M 2 F 5 33 F 6 M 2 F 3 62 M 4 25 F 1 F 4 38 F 6 F 6 F 3 26 M 3 29 M 0 27 M 1 46 M 0 30 F 4 26 F 0 M 3 43 F 3 21 M 7 51 M 3 M 5 36 M 0 F 6 43 F 4 F 6 F 7 29 F 4 21 M 4 66 F 0 23 M 2 22 M 2 23 F 1 28 F 5 31 F 6 25 M 1 43 F 5 37 M 6 26 F 4 58 M 0 47 M 0 21 F 2 47 F 6 48 M 3 61 M 7 56 M 6 50 M 0 20 F 2 77 M 7 66 M 6 31 M 5 43 M 1 48 F 5 47 M 3 33 M 0 72 M 1 68 M 5 70 F 7 69 F 3 69 F 7 33 M 4 56 F 7 45 M 4 46 F 3 64 F 3 70 M 4 46 F 5 33 F 0 29 M 5 22 M 5 33 M 5 69 F 6 45 M 7 43 M 6 62 M 5 75 F 4 51 F 4 27 F 0 58 F 2 34 F 7 78 F 6 48 M 0 25 M 2 34 F 5 81 F 5 66 F 5 64 F 7 61 M 0 59 M 4 71 F 0 31 M 0 52 F 0 51 M 3 79 F 5 29 F 2 57 M 4 56 M 8 21 M 1 38 M 7 60 M 5 36 M 6 41 M 5 35 F 7 41 M 0 26 F 0 50 F 3 68 M 0 50 M 4 32 M 7 40 F 5 33 F 4 25 F 2 33 F 3 45 M 6 45 M 5 23 F 0 46 F 2 20 M 0 42 M 1 44 F 3 41 F 0 52 M 5 28 M 2 80 M 4 29 F 7 44 F 2 39 F 7 28 F 6 55 M 7 42 F 6 28 M 4 28 M 0 42 M 0 27 F 0 64 M 0 29 M 6 61 M 5 64 M 1 72 F 7 47 M 3 54 M 5 57 M 3 37 F 7 35 M 5 25 M 0 53 M 1 71 M 5 60 F 6 27 M 3 35 M 6 55 F 0 49 F 0 54 F 0 67 F 7 39 M 6 54 M 3 65 F 4 75 M 0 Question 1: What is your age?
2
1
Participant
Q1
Q2
Q
3
1
32
M
6
2
36
F
7
3
6
0
4
60
5
5
30
6
20
7
33
8
63
9
40
10
22
11
12
26
13
65
14
15
43
16
17
21
18
53
19
39
20 65 F 6
21
57
22
72
23
52
24
25
26
29
27
31
28
29 60 M 6
30
55
31 55 M 0
32 39 M 5
33 40 F 4
34
35
58
36
62
37
38
39 37 M 6
40 38 F 5
41
51
42
43
67
44
59
45
46
47
48
49
50
51
74
52 47 F 2
53 41 F 2
54
55 67 M 4
56
57 25 F 0
58 24 M 3
59 49 M 2
60 34 M 0
61
62 50 M 0
63
70
64
65 47 F 4
66
71
67 22 M 0
68
69
76
70 74 F 2
71
77
72 42 M 7
73
74 49 F 1
75
76 68 F 4
77 34 M 6
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
Question 2: Are you male of female?
Question 3: How many times per week do you get at least 30 mintues of
continuous exercise
Instructions:
(1) Construct 3 pie charts for Question 3. The first is total popualtion, the
second is males the third is females.
(2) Construct a bar chart or histogram that shows male and female exercise
habits.
(3) Create a histogram that shows the exercise habits of the population.
The data classes should be the number of times per week that a person
exercises.
(4) Does age seem to be correlated with exercise rates? If so, in what
direction does the correlation go? Use a reasonable argument or
statistical evidence to support your response.
(5) Find a 95% confidence interval for the Pittsburgh population mean number
of days that a Pittsburgher will exercise. (NOTE: The standard deviation
of your sample is 2.41 days.)
(6) It is stated that, on average, females exercise more than males. Perform
a hypothesis test on the mean rates of male and female exercise habits
using a 95% confidence level to determine if there is, indeed, strong
statistical evidence that females exercise more. (You should use the
female mean as the population mean and the male mean as the sample
mean.
