- 1 (260.66 KiB) Viewed 36 times
be for either the men or the women.
Create a frequency distribution for the quantitative data
related to either the men or the women in your sample. (Excel)
Create a histogram (this is a graphic) from the frequency
distribution you created. (Excel)
A B С D E F 1 Final Project Excel Template 2 The following data summarizes the income in USD of equally qualified men and women in the same position 3 3 4 Position Men's Income Women's Income 5 1 37159 32440 6 2 30921 21590 7 3 53813 39383 8 4 75619 72636 9 9 5 18227 4719 10 6 35694 33633 7 7 51154 42800 12 8 233368 226154 13 9 187476 176247 14 10 40034 37105 15 11 81587 73233 16 12 115870 106812 17 13 48334 43505 18 14 19420 18173 15 23163 14647 11 19 20 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 20 21 22 23 24 25 26 27 28 29 30 31 32 33 36 37 38 39 43939 17685 27231 71008 31029 73830 27231 189808 19854 34718 31842 54734 115979 72581 29022 53487 61082 48062 48388 34609 32928 15026 48225 58586 22620 50666 45567 65747 16979 17847 63469 67970 30757 77680 41553 39979 6835 21807 62329 25224 69056 28859 188127 18227 15352 26364 44645 106812 55982 10307 49527 51968 46869 43072 25930 26364 18064 37105 50666 21211 35640 50178 60593 5262 13941 57339 56362 24357 68080 32548 34 35 36 37 40 41 42 43 44 45 38 39 40 41 42 43 46 47 48 44 49 50 51 45 46 47 48 49 50 52 53 54 55 56
Null hypothesis Ho: Md = 0 (The test is a paired sample test since the samples are paired by position) There is no difference in income of equally qualified men and women in the same position. Alternative hypothesis Hai Hd 70 There is a difference in income of equally qualified men and women in the same position.