MBAd 6222 Data Analysis & Decisions Assignmen t5 Student ID: G Marc Huston, the Director of Development at a large public university wants to understand the relationship (if any) between graduates' income and the amount of their charitable donation to the university in any given year. Based on anecdotal evidence, Huston conjectures that (1) among those who graduated at least 15 years ago, those whose income is higher will contribute more to the university, and (2) among those who graduated less than 15 years ago, no such positive relationship exists. A random sample of graduates was selected. Each row in the \"Graduates.xlsx\" file (...note that this week we are providing you with the data in Excel spreadsheet format...) corresponds to one graduate, for whom there are four data values: ID, years since graduation, income across the past 12 months (in dollars and cents), and amount contributed to the university across the past 12 months (in dollars and cents). Part I: Those who graduated less than 15 years ago: 1. Hypotheses Symbolic: In words: Ho: Ha: 2. Procedure: 3. Assumptions: 4. Assuption Tenability: 5. Results: n 1 Test Test Value d.f. Text accompanying the Results: 6. Implications: p-value Accept HA? Part II: Those who graduated at least 15 years ago: 1. Hypotheses Symbolic: In words: Ho: Ha: 2. Procedure: 3. Assumptions: 4. Assuption Tenability: 5. Results: n 1 Test Test Value d.f. Text accompanying the Results: p-value Accept HA? 6. Implications: What does this allow us to say about Huston's original conjecture? ID Years 1228900 1887865 2760723 2782022 5030494 5188538 5965161 6849900 9926371 11006357 11733944 12855453 14887114 15134133 18769859 19655301 19986908 20027836 21166005 21223648 21292853 22797828 23751356 24961736 25040132 25386850 27640155 29421622 30828130 31091854 32664438 33865039 36961647 38142701 38667118 38708021 38783230 40581349 40647573 40875444 41897508 43437378 44011805 45210758 45441450 45699080 45888268 46590953 50059559 50700984 51712175 53704115 53980800 54295289 54310560 54349203 54974151 56740370 57549278 57620787 58714394 59506574 59661903 60013605 61169452 61495879 62793873 64254316 64658748 65551507 66372932 68582398 69428943 71980938 72508181 72930795 Income Contrib 12 56933 2 37823 11 53581 49 167596 1 44876 36 113118 50 175745 6 47629 1 43805 47 162474 3 40287 38 118732 36 117821 2 39044 19 66492 29 97756 42 137721 1 36576 34 112161 29 98753 14 60292 35 110733 31 100537 43 141415 2 40083 41 139302 18 72749 47 161647 10 49418 4 44201 24 79863 44 149282 47 164932 37 115381 42 137995 40 134463 13 54436 8 47527 8 51049 34 112816 6 52690 19 66467 5 49772 19 68537 9 50153 23 81839 23 77679 25 83914 20 68369 50 178407 16 68311 17 68135 9 49375 27 92468 21 74746 2 43397 11 54961 37 120983 49 170477 11 52708 26 90586 38 119643 6 51154 12 60681 17 69100 38 118820 26 89247 1 36640 7 46199 38 123604 41 130362 44 146976 42 140999 31 103364 11 54767 13 60512 520 570 560 5900 540 3540 5720 550 570 5390 550 4140 3920 540 2890 3380 4160 530 3920 3310 570 3800 3300 4450 560 5140 3160 5770 540 510 2690 5330 5380 4190 4430 4390 550 540 590 3680 510 2850 500 2920 550 2750 2800 3420 2930 5820 2540 2320 560 3260 2750 510 510 4620 5380 590 3580 3650 540 520 2950 3690 3220 570 540 4630 4680 4570 5190 3110 550 530 73151829 73528872 73674508 73699113 75549585 76637970 79167642 79398887 81166900 83110718 83934490 85251015 87405358 88952804 91484930 91908533 93213134 94874008 96660581 97528877 98106945 98301368 98328133 99175542 23 45 23 23 11 38 12 36 13 39 39 13 24 28 45 21 21 6 2 18 40 14 49 12 79590 153876 74374 80046 59243 119553 55145 111930 61444 127481 126396 63511 79061 95216 146796 72424 78401 51222 42597 67421 128485 63132 168132 56055 2830 5580 2740 2710 530 4020 570 3960 510 4250 3810 510 2710 3700 5100 2390 3010 500 590 2170 4250 570 5990 560