use this Data bellow and answer the questions States College Degree Rate (%) Poverty Rate (%) Column1
Question:
use this Data bellow and answer the questions
States | College Degree Rate (%) | Poverty Rate (%) | Column1 |
District of Columbia | 59.8% | 16.8 | |
Massachusetts | 44.5% | 10.4 | |
Colorado | 41.6% | 9.7 | |
Maryland | 40.9% | 10.3 | |
New Jersey | 40.7% | 10.2 | |
Connecticut | 40% | 10.1 | |
Vermont | 39.7% | 10.2 | |
Virginia | 39.5% | 10.6 | |
New Hampshire | 37.6% | 7.4 | |
New York | 37.5% | 14 | |
Minnesota | 36.8% | 9.3 | |
Washington | 36.7% | 9.9 | |
Illinois | 35.5% | 12.1 | |
Rhode Island | 35% | 12.1 | |
California | 34.7% | 12.3 | |
Utah | 34.7% | 8.7 | |
Oregon | 34.4% | 12.2 | |
Kansas | 33.9% | 11.6 | |
Hawaii | 33.6% | 10.9 | |
Montana | 33.1% | 12 | |
Delaware | 32.7% | 11.5 | |
Maine | 32.5% | 11.2 | |
Nebraska | 32.5% | 10.5 | |
Pennsylvania | 32.3% | 12.2 | |
Georgia | 32.2% | 14.2 | |
North Carolina | 32% | 13.5 | |
Wisconsin | 30.8% | 10.8 | |
North Dakota | 30.7% | 10.9 | |
Texas | 30.7% | 14.2 | |
Florida | 30.5% | 13.2 | |
Arizona | 30.3% | 12.9 | |
Alaska | 30% | 10.8 | |
Michigan | 30% | 13 | |
Missouri | 29.9% | 12.8 | |
Iowa | 29.3% | 11 | |
South Dakota | 29.3% | 11.8 | |
South Carolina | 29% | 14.5 | |
Determine the data point that has the minimum and maximum values in your dependent variables column.
With Minimum Value:
With Maximum Value:
c. Separate the data for your dependent variable into two groups - Group one is for values above the median and Group two is for values below the median.
Group One : | Groupe 2 |
N | N |
M | M |
SS | SS |
5. Analysis. Describe the dependent variable in a short paragraph (at least three sentences) based on your analysis of the data. (include graph)
Part 4: Hypothesis Test
1. Hypothesis TestTest the claim that there is a significant difference for your independent (x) variable between the two groups of the dependent ( y) variable.
a. State the null and alternative hypothesis.
b. Find the pooled variance for the two groups.
c. Compute the standard error of the difference between the means of the two groups.
d. Hypothesis Test Based on the t-Test using a \alpha =0.01 significance level.
e. make a statement stating whether there is significant difference between the two groups as related to the independent and the dependent variables
f. Write 2 or more paragraphs stating your conclusions, observations, analysis, and evaluation