1. You will manipulate and analyze data using Excel or SPSS.
2. You will copy charts, graphs, table, from Excel or SPSS into Word document.
3. 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.

Excel File Edit View Insert Format Tools Data Window Help ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx a 100% Review QSearch in Sheet | Font Data Alignment abc Format Cells HEM & Dry E-46 Y Home Layout Tables Charts SmartArt Formulas Edit A , Fill - Calibri (Body) 11 - A- A = = = to clear B IU Erdo A E33 B11 Themes Number General - % 2 Normal Bad 0 Wrap Text Merge 2 conditional Good Check Cell Neutral Calculation Insert Delete Format Themes Aa Formatting A G H | K | | | M | N | 0 | P | Q | R | 5 | I | U | V | W | X= 2 3 Average of Usual Hours Worked Gender Total Female Male Grand Total 40.63 43.26 42.19 Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN 200092 1060 @OW T XA FOST 24 Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx 3 100% P ivotTable QSearch in Sheet Font Format Cells Themes O S A E Cone E 44" Y- Home Layout Tables Charts SmartArt Formulas Data Edit Alignment A , Fill - Calibri (Body) 11 AA abc Paste Clear B 1 U B A E 3 G6 % e fx 44.3984168865435 B Review Number Number $ % , oo Normal Wrap Text Merge - Bad Conditional Neutral Calculation Check Cell Insert Delete Format Formatting Themes Aa' A G H J K L M N O P Q R S T U V E W States Alabama Average of Usual Hours Worked Gender Female Male Grand Total Florida Georgia North Carolina 40.51 40.25 40.56 42.66 43.02 43.85 41.75 41. 87 4 2.60 41.60 43.13 42.47 South Carolina 42.5 45 43.75 Tennessee Grand Total 41.24 40.63 44.401 43.26 43.14 6 7 44.40 42.19 Average Hours Worked Alabama 140 Florida 19 43.1365 Georgia North Carolina 40.51 40 25 40.56 South Carolina Tennessee FEMALE MALE 36 37 38 39 41 42 43 + Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN L29 2A L 24 I X ) 2 L Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx 100% P ivotTable QSearch in Sheet Review Number Format Cells Themes HEM & Dry E-45 Y= a Home Layout Tables Charts SmartArt Formulas Data Edit Font Alignment A , Fill - Calibri (Body) 11 A A abc Paste Clear B 1 A E E 3 1 8 fx 10 F Normal Bad Wrap Text Merge - General % , Conditiona Neutral Calculation Check Cell Insert Delete Format Formatting Themes Aa' A7 E G H J K L M N O P Q R S T U V W = Gender Female Average of Yearly Earnings 4 Education 58 69 7 10 9 A 11.5 Male Grand Total 13797.83 19156.75 17662.08 13633.95 30983.80 24043.86 12418.04 24812.42 20385.86 15997.07 22330.73 19975.91 14831.92 22629.23 20850.89 21373.45 32473.98 27933.98 26087.89 39847.15 33887.55 31057.99 40358.47 35687.19 35992.19 57906.65 48907.35 52553.02 90498.49 76187.29 28187.72 4 4429.62 3 7796.11 Earnings by Education Level 10 Female 13 16 14 18 15 Grand Total 16 17 18 19 100000.00 90000.00 80000.00 70000.00 60000.00 50000.00 40000.00 30000.00 20000.00 10000.00 0.00 Male 8 9 10 11 11.5 12 13 14 16 18 36 37 38 39 41 42 43 Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN 400090 240 * @ WT XA HORE 24 Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx QSearch in Sheet Format Cells Themes Dry 24" Y= a 100% Charts SmartArt Formulas Data P ivotTable Font Alignment 11 -A- A = = = abc Wrap Text A E E Merge 11.5 F G Review Number General 9- % Normal Bad 4.0 .00 Conditional Formatting Neutral Calculation Check Cell Insert Delete Format Themes Aa A2 C H J K L M N O P Q R S UVVE HEM & Home Layout Tables Edit A , Fill - Calibri (Body) Paste Clear B I : % fx A 1 Row Labels -+Sum of Total Wages 11.5 1188501 1202193 2568618 2596326 3116242 7886869 48683679 50932983 59666970 62767649 12 Grand Total 240610030 ON Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN L29 2A L 24 I X ) 2 L Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx 100% P ivotTable QSearch in Sheet 24" Y a Formulas Data Alignment = = abc 333 Format Cells Themes = Review Number General % , Normal Wrap Text Merge Bad o Conditional Formatting Neutral Calculation Check Cell Insert Delete Format Themes Aa' PH . OG $n $ Home Layout Tables Charts SmartArt Edit Font A , Fill - Calibri (Body) 11 -A- A Paste Clear B I B A B1 % fx Gender B C D 1 Sum of TotalWages Gender 2 States + Female Male Grand Total 3 South Carolina 32600 5 6400 89000 4 Tennessee 6120311 15612961 21733272 5 Alabama 6653861 13154576 19808437 6 North Carolina 15711915 4283112358543038 7 Georgia 1994711943533798 63480917 Florida 24822257 5213310976955366 9 Grand Total 73288063 167321967 240610030 F G H I K L M N O P Q R S T U V W X = 19 36 37 38 39 41 42 43 Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN 20090241 @OW T XA > FOLD 24 Excel File Edit View Insert Format Tools Data Window Help ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx a 100% Review QSearch in Sheet | Font Data Alignment abc Format Cells HEM & Dry E-46 Y Home Layout Tables Charts SmartArt Formulas Edit A , Fill - Calibri (Body) 11 - A- A = = = to clear B IU Erdo A E33 B11 Themes Number General - % 2 Normal Bad 0 Wrap Text Merge 2 conditional Good Check Cell Neutral Calculation Insert Delete Format Themes Aa Formatting A G H | K | | | M | N | 0 | P | Q | R | 5 | I | U | V | W | X= 2 3 Average of Usual Hours Worked Gender Total Female Male Grand Total 40.63 43.26 42.19 Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN 200092 1060 @OW T XA FOST 24 Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx 3 100% P ivotTable QSearch in Sheet Font Format Cells Themes O S A E Cone E 44" Y- Home Layout Tables Charts SmartArt Formulas Data Edit Alignment A , Fill - Calibri (Body) 11 AA abc Paste Clear B 1 U B A E 3 G6 % e fx 44.3984168865435 B Review Number Number $ % , oo Normal Wrap Text Merge - Bad Conditional Neutral Calculation Check Cell Insert Delete Format Formatting Themes Aa' A G H J K L M N O P Q R S T U V E W States Alabama Average of Usual Hours Worked Gender Female Male Grand Total Florida Georgia North Carolina 40.51 40.25 40.56 42.66 43.02 43.85 41.75 41. 87 4 2.60 41.60 43.13 42.47 South Carolina 42.5 45 43.75 Tennessee Grand Total 41.24 40.63 44.401 43.26 43.14 6 7 44.40 42.19 Average Hours Worked Alabama 140 Florida 19 43.1365 Georgia North Carolina 40.51 40 25 40.56 South Carolina Tennessee FEMALE MALE 36 37 38 39 41 42 43 + Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN L29 2A L 24 I X ) 2 L Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx 100% P ivotTable QSearch in Sheet Review Number Format Cells Themes HEM & Dry E-45 Y= a Home Layout Tables Charts SmartArt Formulas Data Edit Font Alignment A , Fill - Calibri (Body) 11 A A abc Paste Clear B 1 A E E 3 1 8 fx 10 F Normal Bad Wrap Text Merge - General % , Conditiona Neutral Calculation Check Cell Insert Delete Format Formatting Themes Aa' A7 E G H J K L M N O P Q R S T U V W = Gender Female Average of Yearly Earnings 4 Education 58 69 7 10 9 A 11.5 Male Grand Total 13797.83 19156.75 17662.08 13633.95 30983.80 24043.86 12418.04 24812.42 20385.86 15997.07 22330.73 19975.91 14831.92 22629.23 20850.89 21373.45 32473.98 27933.98 26087.89 39847.15 33887.55 31057.99 40358.47 35687.19 35992.19 57906.65 48907.35 52553.02 90498.49 76187.29 28187.72 4 4429.62 3 7796.11 Earnings by Education Level 10 Female 13 16 14 18 15 Grand Total 16 17 18 19 100000.00 90000.00 80000.00 70000.00 60000.00 50000.00 40000.00 30000.00 20000.00 10000.00 0.00 Male 8 9 10 11 11.5 12 13 14 16 18 36 37 38 39 41 42 43 Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN 400090 240 * @ WT XA HORE 24 Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx QSearch in Sheet Format Cells Themes Dry 24" Y= a 100% Charts SmartArt Formulas Data P ivotTable Font Alignment 11 -A- A = = = abc Wrap Text A E E Merge 11.5 F G Review Number General 9- % Normal Bad 4.0 .00 Conditional Formatting Neutral Calculation Check Cell Insert Delete Format Themes Aa A2 C H J K L M N O P Q R S UVVE HEM & Home Layout Tables Edit A , Fill - Calibri (Body) Paste Clear B I : % fx A 1 Row Labels -+Sum of Total Wages 11.5 1188501 1202193 2568618 2596326 3116242 7886869 48683679 50932983 59666970 62767649 12 Grand Total 240610030 ON Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN L29 2A L 24 I X ) 2 L Excel File Edit View Insert Format Tools Data Window H elp ) 25% (4) Fri 9:49 PM Q E Wages Southern States A.xlsx 100% P ivotTable QSearch in Sheet 24" Y a Formulas Data Alignment = = abc 333 Format Cells Themes = Review Number General % , Normal Wrap Text Merge Bad o Conditional Formatting Neutral Calculation Check Cell Insert Delete Format Themes Aa' PH . OG $n $ Home Layout Tables Charts SmartArt Edit Font A , Fill - Calibri (Body) 11 -A- A Paste Clear B I B A B1 % fx Gender B C D 1 Sum of TotalWages Gender 2 States + Female Male Grand Total 3 South Carolina 32600 5 6400 89000 4 Tennessee 6120311 15612961 21733272 5 Alabama 6653861 13154576 19808437 6 North Carolina 15711915 4283112358543038 7 Georgia 1994711943533798 63480917 Florida 24822257 5213310976955366 9 Grand Total 73288063 167321967 240610030 F G H I K L M N O P Q R S T U V W X = 19 36 37 38 39 41 42 43 Answer 1 Answer 2 Answer 3 Answer 4 Answer 5 Data Questions + JAN 20090241 @OW T XA > FOLD 24