EXCEL IS ONLY TO BE USED AS A WAY TO ORGANIZE YOUR WORK AND/OR AS A CALCULATOR. BEYOND THE 'SUM' FUNCTION YOU MAY NOT USE THE FUNCTIONS WITHIN EXCEL TO COMPLETE THE ASSIGNMENT.

6. Use the following sample of 30 responses on a 7-point scale measuring people's attitudes toward the death penalty (1 = strongly oppose through 7 = strongly favor) to:

4	5	1	4
2	4	6	7
4	4	3	1
3	3	2	3
4	2	1	3
5	3	4	4
4	4	1	3
	4	3

Calculate a 95% confidence interval

Calculate a 99% confidence interval

Interpret what each of these intervals means.

Please only use excel or by hand.