You will manipulate and analyze data using Excel or SPSS. You will copy charts, graphs, tables, from Excel or SPSS into a Word document. Write a report on your findings in
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →
Questions available in the data file.
Problem Guide:
- You will manipulate and analyze data using Excel or SPSS.
- You will copy charts, graphs, tables, from Excel or SPSS into a Word document.
- Write a report on your findings in the Word document referencing the charts, graphs, and tables from Excel or SPSS.
The original questions must be typed out as headings, with follow up answers + charts, graphs, and tables in paragraph format, and a summary or conclusion at the end of the paper. Problems have no references limit and must be in APA format.
Hrs by Gender
| Gender | Average of Usual Hours Worked |
| Female | 40.6346153846 |
| Male | 43.2575677111 |
| Grand Total | 42.1863022306 |
Hrs by Gndr State
| Average of Usual Hours Worked | Column Labels | ||||||
| Gender | Alabama | Florida | Georgia | North Carolina | South Carolina | Tennessee | Grand Total |
| Female | 41.6046511628 | 40.5057603687 | 40.250764526 | 40.5608465608 | 42.5 | 41.235059761 | 40.6346153846 |
| Male | 43.1294117647 | 42.6602348993 | 43.015037594 | 43.8492407809 | 45 | 44.3984168865 | 43.2575677111 |
| Grand Total | 42.4715719064 | 41.7524271845 | 41.8744479495 | 42.5970449966 | 43.75 | 43.1380952381 | 42.1863022306 |
Data
| Usual Hours Worked | Education (yrs) | Yearly Earnings | Race | Gender | Usual Weekly Earnings | State | Month in Sample | A_RACE | Gender | TotalWages |
| 40 | 13 | 44000 | White | Male | 858 | Georgia | 8 | 1 | 1 | 44000 |
| 35 | 12 | 12000 | White | Female | . | Georgia | 3 | 1 | 2 | 12000 |
| 70 | 11 | 54000 | White | Male | . | Georgia | 3 | 1 | 1 | 54000 |
| 40 | 16 | 48200 | White | Male | . | Georgia | 7 | 1 | 1 | 48200 |
| 38 | 12 | 24000 | White | Male | . | Georgia | 2 | 1 | 1 | 24000 |
| 60 | 18 | 62000 | White | Female | . | Georgia | 5 | 1 | 2 | 62000 |
| 40 | 13 | 17000 | White | Female | . | Georgia | 5 | 1 | 2 | 17000 |
| 50 | 8 | 25000 | Black | Male | . | Georgia | 5 | 2 | 1 | 25000 |
| 40 | 11 | 10000 | Black | Male | . | Georgia | 5 | 2 | 1 | 10000 |
| 50 | 16 | 65000 | White | Male | . | Georgia | 7 | 1 | 1 | 65000 |
| 45 | 12 | 30000 | White | Male | . | Georgia | 2 | 1 | 1 | 30000 |
| 50 | 16 | 306731 | White | Male | . | Georgia | 1 | 1 | 1 | 306731 |
| 50 | 11 | 37000 | White | Male | 643 | Georgia | 4 | 1 | 1 | 37000 |
| 40 | 12 | 34000 | White | Male | 600 | Georgia | 4 | 1 | 1 | 34000 |
| 40 | 13 | 25000 | White | Male | 520 | Georgia | 4 | 1 | 1 | 25000 |
| 40 | 12 | 42000 | White | Male | 680 | Georgia | 8 | 1 | 1 | 42000 |
| 40 | 16 | 68000 | White | Male | . | Georgia | 6 | 1 | 1 | 68000 |
| 50 | 13 | 70000 | White | Male | . | Georgia | 6 | 1 | 1 | 70000 |
| 40 | 12 | 25000 | White | Female | . | Georgia | 7 | 1 | 2 | 25000 |
| 35 | 13 | 15400 | White | Female | . | Georgia | 7 | 1 | 2 | 15400 |
| 40 | 13 | 56426 | White | Male | . | Georgia | 7 | 1 | 1 | 56426 |
| 40 | 12 | 21087 | White | Male | . | Georgia | 7 | 1 | 1 | 21087 |
| 40 | 13 | 50000 | White | Male | . | Georgia | 7 | 1 | 1 | 50000 |
| 49 | 12 | 11500 | Black | Female | 173 | Georgia | 4 | 2 | 2 | 11500 |
| 60 | 12 | 40000 | White | Male | . | Georgia | 5 | 1 | 1 | 40000 |
| 60 | 18 | 70000 | White | Female | . | Georgia | 1 | 1 | 2 | 70000 |
| 45 | 18 | 62000 | White | Male | . | Georgia | 1 | 1 | 1 | 62000 |
| 40 | 12 | 30000 | White | Male | . | Georgia | 1 | 1 | 1 | 30000 |
| 40 | 16 | 20000 | Black | Female | . | Georgia | 6 | 2 | 2 | 20000 |
| 72 | 12 | 17360 | White | Female | 224 | Georgia | 8 | 1 | 2 | 17360 |
| 50 | 12 | 32000 | White | Male | . | Georgia | 7 | 1 | 1 | 32000 |
| 60 | 16 | 60000 | White | Male | . | Georgia | 2 | 1 | 1 | 60000 |
| 40 | 11 | 9500 | White | Female | . | Georgia | 6 | 1 | 2 | 9500 |
| 40 | 11 | 9000 | White | Male | . | Georgia | 6 | 1 | 1 | 9000 |
| 40 | 12 | 0 | White | Male | . | Georgia | 6 | 1 | 1 | 0 |
| 60 | 11.5 | 38000 | White | Male | . | Georgia | 1 | 1 | 1 | 38000 |
| 52 | 11 | 45000 | White | Female | . | Georgia | 1 | 1 | 2 | 45000 |
| 45 | 12 | 16000 | White | Male | . | Georgia | 1 | 1 | 1 | 16000 |
| 40 | 12 | 30000 | White | Male | . | Georgia | 2 | 1 | 1 | 30000 |
| 40 | 18 | 29530 | White | Female | . | Georgia | 2 | 1 | 2 | 29530 |
| 38 | 12 | 8274 | White | Male | . | Georgia | 2 | 1 | 1 | 8274 |
| 40 | 12 | 11200 | White | Female | . | Georgia | 1 | 1 | 2 | 11200 |
| 45 | 12 | 21000 | White | Male | . | Georgia | 1 | 1 | 1 | 21000 |
| 45 | 12 | 24500 | White | Male | . | Georgia | 7 | 1 | 1 | 24500 |
| 40 | 16 | 30000 | White | Female | . | Georgia | 3 | 1 | 2 | 30000 |
| 40 | 12 | 30000 | White | Female | 522 | Georgia | 4 | 1 | 2 | 30000 |
| 40 | 16 | 36400 | White | Male | 765 | Georgia | 4 | 1 | 1 | 36400 |
| 50 | 16 | 29000 | White | Female | 635 | Georgia | 4 | 1 | 2 | 29000 |
| 45 | 13 | 18000 | White | Female | . | Georgia | 1 | 1 | 2 | 18000 |
| 40 | 12 | 65000 | White | Male | . | Georgia | 1 | 1 | 1 | 65000 |
| 40 | 12 | 15000 | White | Female | . | Georgia | 1 | 1 | 2 | 15000 |
| 40 | 12 | 30000 | White | Male | . | Georgia | 1 | 1 | 1 | 30000 |
| 40 | 13 | 72000 | White | Male | . | Georgia | 6 | 1 | 1 | 72000 |
| 40 | 12 | 42000 | White | Female | . | Georgia | 6 | 1 | 2 | 42000 |
| 40 | 16 | 144499 | White | Male | . | Georgia | 7 | 1 | 1 | 144499 |
| 40 | 13 | 30000 | White | Male | 480 | Georgia | 8 | 1 | 1 | 30000 |
| 40 | 12 | 35000 | White | Male | 1280 | Georgia | 8 | 1 | 1 | 35000 |
| 35 | 10 | 35000 | White | Male | . | Georgia | 8 | 1 | 1 | 35000 |
| 40 | 12 | 11000 | White | Male | . | Georgia | 1 | 1 | 1 | 11000 |
| 35 | 11 | 8000 | White | Female | . | Georgia | 1 | 1 | 2 | 8000 |
| 40 | 16 | 25000 | White | Male | 625 | Georgia | 8 | 1 | 1 | 25000 |
| 40 | 16 | 12340 | White | Female | 237 | Georgia | 8 | 1 | 2 | 12340 |
| 48 | 12 | 29
Get a plagiarism-free answer to this questionSend us your instructions and we’ll match you with the best writer in your subject.
Your pal for every paper is one click awayJoin 12,000+ students getting original, on-time papers with free Turnitin reports. All Rights Reserved Terms and Conditions |