Question

Please write answers clear. I will leave like if its correct.

State	POVERTY%	GUN DEATHS	H.S. GRAD's	UNEMPLOYMENT
New Jersey	6.80%	5.7	91.8	91.8
Vermont	7.60%	9.2	91 3.6	91 3.6
Minnesota	8.10%	12	91.5	4
Hawaii	8.60%	2.6	87.4	4.9
Delaware	9.20%	10.3	90.4	3.7
Utah	9.20%	12.6	90.4	3.7
Virginia	9.20%	10.2	86.6	4.5
Nebraska	9.50%	9	89.8	2.8
connecticut	9.70%	4.4	88.6	5.3
Maryland	9.70%	9.7	88.2	5.1
Idaho Alaska	9.90% 10.00%	14.1 17.6	88.4 91.4	4.2 6.6
Massachusetts	10.10%	3.1	89	4.7
Washington	10.20%	8.7	89	4.7
Wisconsin	10.20%	9.7	89.8	4.5
Nevada	10.60%	13.8	83.9	6.8
Wyoming	10.60%	16.7	87.4	4
Florida	11.10%	11.9	85.3	5.3
North Dakota	11.20%	11.8	90.1	2.9
Pennsylvania	11.20%	11.2	87.9	5.4
Lowa	11.30%	8	91.4	3.7
Colorado	11.40%	11.5	89.3	4.2
Illinois	11.50%	8.6	86.4	5.6
Missouri	11.60%	12	86.8	5.6
South Dakota	11.80%	10	89.9	3.7
Michigan	12.00%	12	87.9	5.1
New Hampshire	12.00%	6.4	91.3	3.6
Rhode Island	12.10%	6.4	84.7	5.6
Ohio	12.30%	11	87.6	4.7

Kansas	12.50%	11.4	89.7	4.6
Indiana	12.60%	13	86.6	4.6
Maine	12.60%	7.6	90.2	4.5
North Carolina	13.10%	12.1	84.3	5.9
California	13.20%	7.7	80.6	6.1
Montana	13.80%	14.4	90.8	4.1
Georgia	14.40%	12.6	83.9	5.9
New York	14.50%	4.2	84.7	5.2
Kentucky	14.80%	13.7	81.7	5.2
Tennessee	15.00%	15.4	83.1	5.7
South Carolina	15.00%	15.2	83.6	6
Arizona	15.20%	14.1	84.2	6.3
West Virginia	15.40%	14.3	82.8	7.6
Oklahoma	15.60%	16.5	85.6	4.6
Arkansas	15.90%	19.8	82.4	5.4
Texas	16.20%	10.6	79.9	4.1
Alabama	16.70%	17.6	82.1	6.2
Oregon	16.70%	11	89.1	6.1
New Mexico	17.90%	7.6	82.8	6.7
Louisiana	18.30%	19.3	82.2	6
Mississippi	20.10%	17.8	80.4	6.3

The data below lists states poverty rate, gun deaths per 100,000 people, high school graduation rate and the unemployment rate Use a 2x2 contingency table for questions 1-3. Be sure to find the test statistic and the critical values. Use the median to divide each list into 2 groups. You will need to provide the 2x2 table also. 4) Divide the data into 3 groups by gun deaths: 0-9, 9.1-12 and 12.1-20. Use ANOVA to test the claim that the average poverty rate is the same for the three groups. Provide the mean and standard deviation for each group as well as the test statistic, critical value and conclusion 5) Which factor has the biggest effect on gun deaths? Explain

Answer 1

Using Excel

=IF(C2<=9,"A",(IF(C2<=12,"B","C") ))

to group them in A,B and C

Now using Minitab

One-way ANOVA: POVERTY% versus class gun

Method

Null hypothesis         All means are equal
Alternative hypothesis At least one mean is different
Significance level      α = 0.05

Equal variances were assumed for the analysis.

Factor Information

Factor     Levels Values
class gun       3 A, B, C

Analysis of Variance

Source     DF    Adj SS    Adj MS F-Value P-Value
class gun   2 0.008322 0.004161     5.65    0.006
Error      47 0.034620 0.000737
Total      49 0.042942

Model Summary

        S    R-sq R-sq(adj) R-sq(pred)
0.0271401 19.38%     15.95%       8.84%

Means

class
gun     N     Mean    StDev        95% CI
A      14 0.11429 0.02718 (0.09969, 0.12888)
B      17 0.11294 0.02411 (0.09970, 0.12618)
C      19 0.14011 0.02955 (0.12758, 0.15263)

Pooled StDev = 0.0271401

mean and sd are provided in means table

TS = 5.65

p-value = 0.006

p-value < alpha(0.05)

hence we reject the null hypothesis

there is difference in poverty rate among different groups depending on gun rate