lease follow the formatting guidance listed in the template:
– Introduce the data you are working with
– Introduce the test you will be doing
– Insert the first test images scaled to fit the document
– Discuss the findings and introduce the next test
– Insert second test results scaled to fit the document
– Discuss the findings and any conclusions.
Times new roman font and double spacing should be used. Dont put labels like task 1, task 2. DO NOT just post all your images and put a paragraph at the bottom. Dont provide multiple separate uploads.
There is a rubric for this assignment and I allow you to resubmit. Please view the rubric carefully.
use first 3 documents attached
—————-
part 2
Compose the entire project: Combine Project Part 1 to Part 4 together and
1. Add an introduction paragraph
2. Add an overall conclusion paragraph
3. Discuss how we can reduce the racial equity gap, or what factors may contribute to it.
What could you do personally to help reduce the gap
Use last 4 documents for this
casestudytemplate514.docx
MalevFemaleIncome4.xlsx
Chapter11Statcrunch12.docx
MathAssignmentproject4.pdf
statcrunch.pdf
MathProjectPt2Lab1.pdf
OnesampleTconfidenceintervalMeanofvariable90_confi.pdf
Data was collected by the American Consumer Survey as a part of the Census in the year 2013. The data was discussed in this project is the income of White Women, Black Women and All Males…. (continue with your introduction of the topic- DO NOT COPY MINE). The first(later you will use next) part of this study will look at (Fill in with the test you will be doing). The results of that test can be seen here.
Input the image of the results. Please adjust it to be of appropriate size to be seen and for one graph to not take up an entire page. You can make the images smaller to fit nicely in the paper. *If you have multiple images, shrink them to all fit in a single row.
Discuss your findings: We can see from the graph/table etc… Whatever you have to discuss here from the first test you should. The more specific with the values and data the better.
The next part of this study will look at the (fill in the test). You can then explain why you may run this test, or what kind of things it will show…. The results of that test can be seen here:
Input the image of the test
Make sure it is appropriate size
If you make them individual make them small enough to fit in a line for comparison.
Discuss the findings: Again in paragraph form. Complete sentences, proper grammar, professional sounding research paper.
image1.png
,
Sheet1
State
White Women
Black Women
Men
Alabama
35212
28410
43400
Alaska
46000
56000
Arizona
40586
35513
44000
Arkansas
32000
28895
40000
California
51782
43630
50000
Colorado
43000
36527
50000
Connecticut
50747
39355
60000
Delaware
43497
37440
49900
District of Columbia
70424
48703
69000
Florida
38000
30000
40000
Georgia
39400
32000
42500
Hawaii
45659
48000
Idaho
32105
40000
Illinios
41601
36527
50000
Indiana
34694
32000
45000
Iowa
35513
28600
45000
Kansas
36000
31069
45000
Kentucky
33483
28998
42800
Louisiana
36000
25891
48000
Maine
36000
43000
Maryland
51782
46000
57000
Massachusetts
50000
39355
60000
Michigan
38000
34176
48000
Minnesota
41426
32976
50000
Mississippi
33141
25000
40000
Missouri
35000
31069
43000
Montana
32105
42000
Nebraska
35000
27500
45000
Nevada
41426
33762
42300
New Hampshire
41426
52000
New Jersey
51782
42000
60000
New Mexico
42250
42300
New York
48000
40000
50000
North Carolina
37283
30034
42000
North Dakota
34600
46200
Ohio
36527
31454
46900
Oklahoma
33141
30000
40000
Oregon
39355
35513
46000
Pennsylvania
39000
35513
50000
Rhode Island
44000
32164
52000
South Carolina
36000
26600
40000
South Dakota
31069
39000
Tennessee
35000
30439
40000
Texas
42000
34498
45000
Utah
35513
50000
Vermont
39355
45000
Virginia
44015
35212
52000
Washington
43186
36527
53000
West Virginia
30439
27395
45000
Wisconsin
37387
30439
46000
Wyoming
35513
53000
,
Statcrunch Chapter 11
This project requires you to look at income data from 51 different areas (50 states and D.C.). This data has a column for each of the following: White Women, Black Women, All Men. This is actual data comprised from the Census 2013 American Consumer Surveys. The goal is to work with real data, run statistics and draw conclusion on the difference or similarities in income based on race. There are 5 parts to this project that you will work on during 5 different weeks of the course. You will be writing conclusions, differences and similarities between the data sets after each part so in the end you have a complete report that will be submitted. In the end your findings should discuss the discrepancies in income based on race. Each week I will grade your submission and provide feedback on parts you should redo before completing the final project at the end of the semester.
Part 5
Task 1: Open the Income data set in Statcrunch.
Task 2: Construct a 95% confidence interval for the average difference in the means between White Women and Black Women’s income.
Task 3: Construct a 95% confidence interval for the average difference in the means between White Woman’s income and the Male income.
Task 4: Write your conclusion from the hypothesis test, being sure to include the hypotheses, P-value, and if we reject or do not reject the null. List the confidence interval and be sure to write an interpretation sentence.
***Step by Step directions for Statrcrunch are on the following Pages
***Please follow formatting guidance provided in the case study template
Performing a paired t test:
Make sure you have opened the Income data set. Click Stats T-Stats Paired. For sample 1 select White Women. Sample 2 will be Black Women. The hypothesis test we wish to perform will be a greater than test. Click Compute.
Make sure you highlight, copy and paste this data into your write up.
Constructing a Paired Mean Confidence Interval:
Click Stats T-Stats Paired. For sample 1 select White. Sample 2 will be Male. This time select confidence interval. There is no need to change the confidence level as we want a 95% confidence level. Click Compute. Make sure you highlight, copy and paste this data into your write up.
Now type your findings for the week. Write your conclusion from the hypothesis test, being sure to include the hypotheses, P-value, and if we reject or do not reject the null. Did it make a difference if you use alpha of .01 versus alpha of .10? List the confidence interval and be sure to write an interpretation sentence. Please review how we write out conclusions. There is/is not sufficient evidence… We are ___% confident the mean difference … Why are the values in this confidence interval negative?
Please refer to the formatting guidelines on the case study template
image1.png
image2.png
,
One sample T hypothesis test: μ : Mean of variable H0 : μ = 59842 HA : μ > 59842
Hypothesis test results: Variable Sample Mean Std. Err. DF T-Stat P-value
White 64430.885 2097.8149 51 2.1874592 0.0167
One sample T hypothesis test: μ : Mean of variable H0 : μ = 59842 HA : μ < 59842
Hypothesis test results: Variable Sample Mean Std. Err. DF T-Stat P-value
Black/African American 40358.596 1286.4605 51 -15.144968 <0.000
,
Colu mn
n Mea
n Varia nce
Std. dev.
Std. err.
Medi an
Rang e
Min Max Q1 Q3
Whit e
52 6443 0.885
2.288 4303 e8
1512 7.558
2097. 8149
6095 9.5
1109 02
2113 8
1320 40
5636 5.5
7131 8
Black / Africa n Amer ican
52 4035 8.596
8605 8996
9276. 7988
1286. 4605
3857 2.5
5060 4
1949 6
7010 0
3364 5.5
4574 4
Over all Avera ge
52 5984 2.692
1.354 2761 e8
1163 7.337
1613. 8082
5884 8
6243 8
2016 6
8260 4
5282 4
6839 2.5
The provided data presents summary statistics for three groups: White, black, and the overall.
Based on the mean values, White people have an average income of $64,430.885, which is the highest, then the overall mean of $59,842.692, and the Black group has the lowest income at $40,358.596. The same trend is observed in the median income, where White individuals have the highest median at $60,959.5, followed by the overall median of $58,848, and Black individuals with a median of $38,572.5.
The spread of data, as indicated by the range, is widest for White individuals (range: The highest range was women ($21,138-$132,040), followed by the overall range ($20,166-$82,604), and then Black individuals (range: $ 19,496-$70,100). This implies greater income inequality amongst Whites.
Looking at boxplots would probably give a better idea of the income distribution within each group. Both minimum and maximum values and the interquartile range (Q3-Q1) provide information about spread and central tendency. Outliers can also be detected.
Overall, the data points to large income conferences between Whites and Blacks. White individuals usually have higher mean and median incomes and a more comprehensive income range. Analyzing boxplots would allow a visual representation of these differences, giving a more intricate perception of the income distribution within each group.
,
Column n Mean Varianc
e Std. dev.
Std. err.
Medi an
Rang e
Mi n
Ma x
Q1 Q3
Overall Average 5 2
59842 .692
1.35427 61e8
11637. 337
1613.8 082
58848 6243 8
20 16 6
826 04
528 24
683 92.5
White 5 2
64430 .885
2.28843 03e8
15127. 558
2097.8 149
60959 .5
1109 02
21 13 8
132 040
563 65.5
713 18
Black/African American
5 2
40358 .596
860589 96
9276.7 988
1286.4 605
38572 .5
5060 4
19 49 6
701 00
336 45.5
457 44
White is the race that has a higher income (M=64430.89, SD=15127.56)
than the Black/African American. Black/African has ana average income of
40358.596 with a standard deviation of 9276.80. The overall average income
of the two races is 59842.69 with a standard deviation of 11637.34. The
histogram shows that the income of the black/African American is skewed to
the right.
X<70,000
X<75000
X<47,500
,
One sample T confidence interval: μ : Mean of variable
90% confidence interval results:
Variable Sample Mean Std. Err. DF L. Limit U. Limit
Overall Average 59842.692 1613.8082 51 57139.104 62546.281
White 64430.885 2097.8149 51 60916.447 67945.322
Black/African American
40358.596 1286.4605 51 38203.408 42513.784
One sample T confidence interval: μ : Mean of variable
98% confidence interval results:
Variable Sample Mean Std. Err. DF L. Limit U. Limit
Overall Average 59842.692 1613.8082 51 55966.781 63718.604
Black/African American
40358.596 1286.4605 51 37268.881 43448.311
White 64430.885 2097.8149 51 59392.526 69469.243
Interpretation Sentences:
1. We are 90% confident that the average income for overall individuals is
between $57,139.104 and $62,546.281.
2. We are 90% confident that the average income for Black/African American
individuals is between $60,916.447 and $67,945.322.
3. We are 90% confident that the average income for white individuals is
between $38,203.408 and $42,513.784.
4. We are 98% confident that the average income for overall individuals is
between $55,966.781 and $63,718.604.
5. We are 98% confident that the average income for Black/African American
individuals lies between $37,268.881 and $43,448.311.
6. We are 98% confident that the average income for White individuals lies
between $59,392.526 and $69,469.243.
Discussion on Confidence Levels:
As the confidence level increases, strides from 90% to 98%, variability of confidence
intervals also grows. Such an increase in the CI length demonstrates that the collected data
provide a higher level of accuracy in estimating the population parameter. This indicates
that, as such confidence levels increase, the flux of possible population means gets larger
and the area of the range exceeds other values.
Interested in getting help with this assignment?
Get a professional writing team to work on your assignment!
Order Now
Recent postsFor this final assignment, you will prepare a brief paper detailing the steps undertaken to complete a presentation that disseminates information you assemble
Please choose to answer only one of the 2 following questions. Option 1: In your opinion and based on scientific, peer-reviewed published evidence, does child
At the beginning of the previous academic year, the institution announced it would drop football at the conclusion of the season. The announcement created pub
you will review current research in Personality and provide a critical evaluation of that personality research through an annotated bibliography. An annotated
In Module 5, we considered the third in our three-part series on research design. Specifically, the focus was on the longitudinal studies, in which the resear
Need help with a similar or different Task?
We have the best writers to help you. Hire Writer Now
