Question

Question 4: Using the compensation data, categorize the data into 13 categories,
beginning with $400,000 < x < $800,000, $800,000 < x < $1,200,000, etc. (6 pts.)
	CEO Total Comp	Frequency
	400,000
	800,000
	1,200,000
	1,600,000
	2,000,000
	2,400,000
	2,800,000
	3,200,000
	3,600,000
	4,000,000
	4,400,000
	4,800,000
	5,200,000

I cannot provide the DATA because it dont let me post the question otherwise you can use any data just show me the way to do it

Answer 1

make a new column for bins

bins
400000
800000
1200000
1600000
2000000
2400000
2800000
3200000
3600000
4000000
4400000
4800000
5200000

suppose data in in column A

go to data -. data analysis -> histogram

This will create

bins	Frequency
400000	5
800000	12
1200000	9
1600000	5
2000000	8
2400000	6
2800000	7
3200000	7
3600000	11
4000000	2
4400000	8
4800000	10
5200000	10
More	0

Note that I have 100 data points

hence the sum of frequency is 100