Question

Electric Bill
99
174
205
181
150
105
156
200
130
85
160
188
93
119
175
114
151
216
133
168
144
152
209
178
126
131
147
171
112
170
98
166
153
157
133
146
190
169
142
152
111
122
186
154
117
138
194
140
132
161

In our text, "Applied Business Statistics for Business Managers using Excel," please read Chapters 2 and 3. In Chapter 2, you will be learning how to construct some basic charts using Microsoft Excel. In Chapter 3, you will start to summarize your data using descriptive statistics as well as start to graph histograms. 1. Please complete ONE practice problem at the end of Chapter Two. 2. Please complete one of the paractice problems at the end of Chapter Three. The Beverage data set and Electric data sets are attached. See below:

Electric Bill
99
174
205
181
150
105
156
200
130
85
160
188
93
119
175
114
151
216
133
168
144
152
209
178
126
131
147
171
112
170
98
166
153
157
133
146
190
169
142
152
111
122
186
154
117
138
194
140
132
161

Answer 1

the discriptive statistics is given as

mean=	150.06
median=	151.5
mode=	133
first quartile=	130.25
third quartile=	170.75
minimum=	85
maximum=	216

using struges formula for number of class =k=1+3.322log10(N)=1+3.322*log10(50)=6.644 (next whole number is 7)

range=maximum-minimum=216-85=131

class interval=131/7=18.71 ( we can take 20 for our convenience)

class interval	frequency	cumulative frequency
85-105	4	4
105-125	7	11
125-145	10	21
145-165	12	33
165-185	9	42
185-205	5	47
205-225	3	50

the histogram is made as

14 12 10 85-105 105-125 125-145 145-165 165-185 185-205 205-225 Class interval