Question

1a The following 12 data values are entered into column A in a spreadsheet: 14 17 19 22 23 26 31 35 42 50 57 72 The following values are then entered into column C to use as histogram bin values: 25 50 75 By entering the appropriate cell references, the Excel histogram tool is applied to the 12 data values using these bin values. What frequency value will the histogram tool produce for the bin value of 50?

1b. The following 10 data values are entered into column A in a spreadsheet: 35 39 45 48 50 55 80 110 115 135 The following values are then entered into column C to use as histogram bin values: 50 100 150 By entering the appropriate cell references, the Excel histogram tool is applied to the 10 data values using these bin values. What frequency value will the histogram tool produce for the bin value of 100?

Answer 1

1a)

The histogram is given below

Bin	Frequency
25	5
50	5
75	2

The frequency value for the bin value of 50 is 5

Histogram 6 5 4 Frequency 2 1 0 More 75 25 Bin 50 un Frequency

1b)

Bin	Frequency
50	5
100	2
150	3

The frequency value for the bin value of 100 is 2

Histogram 6 5 Frequency 2 1 0 More 150 100 50 Bin Frequency un t