Question

Using Excel, construct a frequency distribution for this data. Round the class width to the appropriate pound. Add a relative frequency column to your distribution. Add a relative frequency column to your distribution. Format your rounded distribution with center alignment, borders and relative frequency rounded to three decimal places. Note the width, lower and upper.

Data:

BEAR WEIGHT

(pounds)

80

344

416

348

166

220

262

360

204

144

332

34

140

180

105

166

204

26

120

436

125

132

90

40

220

46

154

116

182

150

65

356

316

94

86

150

270

202

202

365

79

148

446

62

236

212

60

64

114

76

48

29

514

140

Answer 1

For the following given data set 80, 344, 416, 348, 166, 220, 262, 360, 204, 144, 332, 34, 140, 180, 105, 166, 204, 26, 120, 436, 125, 132, 90, 40, 220, 46, 154, 116, 182, 150, 65, 356, 316, 94, 86, 150, 270, 202, 202, 365, 79, 148, 446, 62, 236, 212, 60, 64, 114, 76, 48, 29, 514, 140 the frequency table with relativen frequency column is tabulated using excel as: 

Class Limit	Frequency	Relative frequency
0-89	14	0.259
90-179	17	0.315
180-269	11	0.204
270-359	6	0.111
360-449	5	0.093
450-539	1	0.019

Here the class limit is the interval within which inclusive of the limits certain no of values lies, where the frequency is the no of values that lie within the given class limit.

Relative frequency of the class is calculated as the class frequency/ Total frequency

Note: Feel free to ask if any query remains.