60.1K

Verified Solution

Link Copied!

Module 7 - Submittable Assignment Attached Files: module_7 ASSIGN.xlsx (26.461 KB) Attached is an Excel spreadsheet, listing data for the Acme Widget company, specifically their salary ranges broken down by sex (male/female). Use that data to investigate the claim that women in that company make less money, on average, than men. Mention some general facts about your data set, such as where you got it from, whether it's a sample or the entire population, and what the sample size is. Next, you should describe the variables you are interested in, and list some of their statistics, such as how many men and women are in your data, total sample size, type of variable, etc. You should then formulate your hypothesis and supply data to support it. For example, you could compute mean, mode, and/or median for your data, if apropriate. Depending on whether they are similar or different for the male and female portion of your data, different hypothesis would be supported. But note that comparing two means alone does not prove any conclusive relationship between them. - the neenrister n-value to support your conclusions, as described in section A small number of employees from the Acme Widget company were chosen at random. The following data was collected from them: Combined Data Female Employees Male Employees Sex Salary alary Lew Code 510X-20X1 $10X-2021 $10-20% $10X-20% $10X-2021 $10X-2021 $10X-20x1 $10X-2021 $10K-2021 $10x20x1 $10% 20% 1 510X-2011 $10X-20x1 $10X-20K 11 510X-20% $10K-2021 S10X200 $10%-20% 1 110%-20% $10X-2011 510X-2011 $10X-20X1 $10K-2011 S10X-2021 520%-20% 510X-2020 $10K-2021 $10X-20x3 $10X-2021 510X-2003 $10X-2021 510X-2020 $20K-30x2 $20K-30K 2 $20K-30X 2 $20K-30X2 $20K-30X2 $20K-30K 2 320X-30X2 $20X-302 3:20-102 $20K-30% 2 $20K-30X2 $20X-30X 2 $20K-30% 2 $20X-1022 Eemala Eemale female female female female female Eemale female Eemale female Eemala Eemale Eemala temale female Eemale female Eemale Eemale Eemale female female female female temale female Female female Eemale female female female female Eemale female Eemale female Eemale female temala female Eemale female female Eemale Salary Salary Level Code 510X-20% 1 SCOX-20K 1 1510X-20 3 SLOX-20K 1 $10X-20K 1 S10X-20K 2 $10X-20K 1 S10%-20 13 $10X-20K 1 E10X-20K $10K-20K 1 510X-20K 1 $10X-20K 1 $10-20K 1 $10x20x 1 $10K-20K 1 $10%-20% 1 SLOK-20K 3 FLOX=20K 1 $10X-20K 11 SOX-20% 1 $10X-20K 3 $10%-20% 1 SLOX-20K 1 $10K-20K 3 510X-20K 1 $10X-20K 1 SIOX-20K 3 $10X-20K 3 ELOX-20% 11 $10X-20K 1 510X-20K 8 $20K-30K 2 $20K-30K 2 $20K-30K 2 520X-JOK 2 $20X-30% 2 $20K-30K 12 320X30X 2 $20K-30K 2 520%-10% 2 $20X-30K 2 5206-30K 2 520%20K 2 $20K-30K 2 $20% -30K 2 Salary Salary Level Code 5:10-20% $20K-JOK 12 520KBOX 12 $20K-30% 2 $20K-30K 2 $20K-30% 2 520K-30K 2 520X-30% 2 $20K-30% 2 520-30 2 $20K-30% 2 $200K 2 $20K-30K 2 $20K-JOK 2 $20K-30% 2 $20K-30K 2 $20K-JOK 2 $20K-30% 2 5200 2 $20X-30K 2 520-101 2 $20K-30% 2 520K-30K 2 $20K JUK 2 $20K-30% 2 520KBOX 2 $20K-30K 2 $20K-30% 2 $20K-30% 2 520-30% 12 $20K-30K 2 $20-30% 2 $20K-BOX 2 520K-30K 2 $20K-30% 2 $20K-30K 2 $20X-30 12 $20K-30K 2 5206-30 2 $20K-30X 2 520K-10% 2 $20K-30% 2 $20K-JOK 2 $20K-30% 2 $20K-30K 2 $20K-30K 2 + female female female fenale female female female female female female female female female female 2 2 2 2 2 2 2 2 2 3 2 3 3 3 renale female female female fenale 3 2 3 2 3 Lennale 3 3 3 3 3 a 3 520X-1022 $20K-30K2 $2002 $20K-3072 $20X30X2 $20K-30X 2 $20K-30X2 F20X-1022 $20K-3072 $30K-40X2 $30K-40x3 $30X-403 20-40 $30K-4023 $30K-40x3 $30K-4073 $30X-403 $30X-40X2 $30K-40K 20x40x2 $30K-4023 $30X-40% 520K-4013 $30K-40% 3 520x40xa $30K-40X3 $30K-4013 $20K-40X2 $30K-403 510K-40 $30K-40X3 20-403 $30K-4013 $30K-40% 3 $30K-40X3 $30K-40X3 203-4023 $30X-40% 3 $40K-504 $40K-50x14 $40X-50X4 540X50X14 $40K-SOK 4 SOK-60% $50K-60 SSX-60 $50-60x5 SSDK-60% SOX60X $10-2011 $2002 $200K 2 $20K-30X 2 520-002 $20K-30K 2 $20x1082 $200K $20X-BOK 20%-30 $20K-30K $20%. JOK 5207-JOK $20K-30K 520%-30% $20K-3UK $30% -40% SJOK-40K $30-40K 510-LOX $30K-40K 20-40% $30%-40K 530% -40% 520-40K $30-40% $302.40X $30K-40K 530% -40% $20-40K $30X-40% 520x-LOX $30K-40K $30%-40K $30-40K $30K-40K 510-40K $30X-40% $20%-40K $30-40K $30% -40% 5307-40% $30K-40K 20-40% 530K-40K $40%-50% 540-SOK $40K-SOK 5402-50% $40K-SOK 590%-60 550K-60% 550-60X 550X-SOK SSDX-60% 550-60% 3 3 3 female renale female renale fenale female fenale female female female female female female fenale female female female female fenale female female female female female female female female female fernale male male nale male male male male 54 SEK $40K-SEK 4 1403585 6 540X50K 4 S40X-SUK 540%-50 4 $40K-SEK & 15:40X-SOK $40K-SEK 6 540X-SDK $40K-SEK $40K-SOK 54150K $40K-SOK 4 5401-50 6 540X-SOK S40K-SOK 5401 SEK 6 $40X-SUK 4 540E-SOK 6 $40K-SOK $40X-SOK 4 540X-SEK 6 SUDX-SEK 4 5401-SEX $4DK-SEK 4 ESOK-60 5 5SX-6 5 SSDX-60K S 5501-DK 5 SSX-6K s SSD-60 5 550-60K Is SSDX-SOK Is ESOK-SOK SS0K-60K S ESOX-60K 5 SSDX-6X Is SSX-6LK Is 550-60K 13 SSX-60% 5 5SOSOK S SSX-60K S SSX-6 S S50-60K 5 ESOKOK S 560 s >>60 6 150X >5503 SEOX 16 >FGOK >$60% 16 >60 G >60K 6 >$60% 16 3 3 3 3 3 3 3 3 3 4 4 4 4 4 5 5 5 5 Module 7 - Submittable Assignment Attached Files: module_7 ASSIGN.xlsx (26.461 KB) Attached is an Excel spreadsheet, listing data for the Acme Widget company, specifically their salary ranges broken down by sex (male/female). Use that data to investigate the claim that women in that company make less money, on average, than men. Mention some general facts about your data set, such as where you got it from, whether it's a sample or the entire population, and what the sample size is. Next, you should describe the variables you are interested in, and list some of their statistics, such as how many men and women are in your data, total sample size, type of variable, etc. You should then formulate your hypothesis and supply data to support it. For example, you could compute mean, mode, and/or median for your data, if apropriate. Depending on whether they are similar or different for the male and female portion of your data, different hypothesis would be supported. But note that comparing two means alone does not prove any conclusive relationship between them. - the neenrister n-value to support your conclusions, as described in section A small number of employees from the Acme Widget company were chosen at random. The following data was collected from them: Combined Data Female Employees Male Employees Sex Salary alary Lew Code 510X-20X1 $10X-2021 $10-20% $10X-20% $10X-2021 $10X-2021 $10X-20x1 $10X-2021 $10K-2021 $10x20x1 $10% 20% 1 510X-2011 $10X-20x1 $10X-20K 11 510X-20% $10K-2021 S10X200 $10%-20% 1 110%-20% $10X-2011 510X-2011 $10X-20X1 $10K-2011 S10X-2021 520%-20% 510X-2020 $10K-2021 $10X-20x3 $10X-2021 510X-2003 $10X-2021 510X-2020 $20K-30x2 $20K-30K 2 $20K-30X 2 $20K-30X2 $20K-30X2 $20K-30K 2 320X-30X2 $20X-302 3:20-102 $20K-30% 2 $20K-30X2 $20X-30X 2 $20K-30% 2 $20X-1022 Eemala Eemale female female female female female Eemale female Eemale female Eemala Eemale Eemala temale female Eemale female Eemale Eemale Eemale female female female female temale female Female female Eemale female female female female Eemale female Eemale female Eemale female temala female Eemale female female Eemale Salary Salary Level Code 510X-20% 1 SCOX-20K 1 1510X-20 3 SLOX-20K 1 $10X-20K 1 S10X-20K 2 $10X-20K 1 S10%-20 13 $10X-20K 1 E10X-20K $10K-20K 1 510X-20K 1 $10X-20K 1 $10-20K 1 $10x20x 1 $10K-20K 1 $10%-20% 1 SLOK-20K 3 FLOX=20K 1 $10X-20K 11 SOX-20% 1 $10X-20K 3 $10%-20% 1 SLOX-20K 1 $10K-20K 3 510X-20K 1 $10X-20K 1 SIOX-20K 3 $10X-20K 3 ELOX-20% 11 $10X-20K 1 510X-20K 8 $20K-30K 2 $20K-30K 2 $20K-30K 2 520X-JOK 2 $20X-30% 2 $20K-30K 12 320X30X 2 $20K-30K 2 520%-10% 2 $20X-30K 2 5206-30K 2 520%20K 2 $20K-30K 2 $20% -30K 2 Salary Salary Level Code 5:10-20% $20K-JOK 12 520KBOX 12 $20K-30% 2 $20K-30K 2 $20K-30% 2 520K-30K 2 520X-30% 2 $20K-30% 2 520-30 2 $20K-30% 2 $200K 2 $20K-30K 2 $20K-JOK 2 $20K-30% 2 $20K-30K 2 $20K-JOK 2 $20K-30% 2 5200 2 $20X-30K 2 520-101 2 $20K-30% 2 520K-30K 2 $20K JUK 2 $20K-30% 2 520KBOX 2 $20K-30K 2 $20K-30% 2 $20K-30% 2 520-30% 12 $20K-30K 2 $20-30% 2 $20K-BOX 2 520K-30K 2 $20K-30% 2 $20K-30K 2 $20X-30 12 $20K-30K 2 5206-30 2 $20K-30X 2 520K-10% 2 $20K-30% 2 $20K-JOK 2 $20K-30% 2 $20K-30K 2 $20K-30K 2 + female female female fenale female female female female female female female female female female 2 2 2 2 2 2 2 2 2 3 2 3 3 3 renale female female female fenale 3 2 3 2 3 Lennale 3 3 3 3 3 a 3 520X-1022 $20K-30K2 $2002 $20K-3072 $20X30X2 $20K-30X 2 $20K-30X2 F20X-1022 $20K-3072 $30K-40X2 $30K-40x3 $30X-403 20-40 $30K-4023 $30K-40x3 $30K-4073 $30X-403 $30X-40X2 $30K-40K 20x40x2 $30K-4023 $30X-40% 520K-4013 $30K-40% 3 520x40xa $30K-40X3 $30K-4013 $20K-40X2 $30K-403 510K-40 $30K-40X3 20-403 $30K-4013 $30K-40% 3 $30K-40X3 $30K-40X3 203-4023 $30X-40% 3 $40K-504 $40K-50x14 $40X-50X4 540X50X14 $40K-SOK 4 SOK-60% $50K-60 SSX-60 $50-60x5 SSDK-60% SOX60X $10-2011 $2002 $200K 2 $20K-30X 2 520-002 $20K-30K 2 $20x1082 $200K $20X-BOK 20%-30 $20K-30K $20%. JOK 5207-JOK $20K-30K 520%-30% $20K-3UK $30% -40% SJOK-40K $30-40K 510-LOX $30K-40K 20-40% $30%-40K 530% -40% 520-40K $30-40% $302.40X $30K-40K 530% -40% $20-40K $30X-40% 520x-LOX $30K-40K $30%-40K $30-40K $30K-40K 510-40K $30X-40% $20%-40K $30-40K $30% -40% 5307-40% $30K-40K 20-40% 530K-40K $40%-50% 540-SOK $40K-SOK 5402-50% $40K-SOK 590%-60 550K-60% 550-60X 550X-SOK SSDX-60% 550-60% 3 3 3 female renale female renale fenale female fenale female female female female female female fenale female female female female fenale female female female female female female female female female fernale male male nale male male male male 54 SEK $40K-SEK 4 1403585 6 540X50K 4 S40X-SUK 540%-50 4 $40K-SEK & 15:40X-SOK $40K-SEK 6 540X-SDK $40K-SEK $40K-SOK 54150K $40K-SOK 4 5401-50 6 540X-SOK S40K-SOK 5401 SEK 6 $40X-SUK 4 540E-SOK 6 $40K-SOK $40X-SOK 4 540X-SEK 6 SUDX-SEK 4 5401-SEX $4DK-SEK 4 ESOK-60 5 5SX-6 5 SSDX-60K S 5501-DK 5 SSX-6K s SSD-60 5 550-60K Is SSDX-SOK Is ESOK-SOK SS0K-60K S ESOX-60K 5 SSDX-6X Is SSX-6LK Is 550-60K 13 SSX-60% 5 5SOSOK S SSX-60K S SSX-6 S S50-60K 5 ESOKOK S 560 s >>60 6 150X >5503 SEOX 16 >FGOK >$60% 16 >60 G >60K 6 >$60% 16 3 3 3 3 3 3 3 3 3 4 4 4 4 4 5 5 5 5

Answer & Explanation Solved by verified expert

See Answer