Please show all work so it is easy to understand and use Excel.

1. Samples of Republicans, Democrats and Independents were asked to rate on a scale from 1 to 7 their opinion of prayer in public schools, with 1 being the most opposed to school prayer and 7 being the most in favor of school prayer. Given the scores below, test the null hypothesis of no difference between Republicans, Democrats and Independents on their views of prayer in public schools. If the null hypothesis of equal population means is rejected, use Turkey's HSD to identify the pairs of groups that differ significantly. Make sure to interpret your results.

Republicans	Democrats	Independent
5	1	4
7	2	4
4	1	5
3	4	2
6	3	2
5	1	1
7	4	2
3	5	5
6	1	1
5	2	3

2. A nutrition researcher wished to compare several diet programs. He randomly assigns volunteers who are approximately 50 pounds overweight to one of four groups and determines how many pounds each has lot over a one month period of time. Using these data, test to see if there are significant differences among the groups using a .05 level of significance. If the null hypothesis of equal population means is rejected, use Turkey's HSD to identify the pairs of groups that differ significantly. Make sure to interpret your results.

Low Calorie	Low Carb	Low Fat	Low Dairy
5	5	5	2
4	8	5	1
9	7	4	0
7	5	3	2
8	7	4	6
2	7	8	2
3	9	2	1
2	8	1	2
5	5	5	2
4	8	5	1