Excel data (copy & paste excatly like that):
Row Id Homeowner (1=Yes) Gender (1=Female) Home Value ($1000s) Income ($100s) Number Promotions Largest Gift ($) Latest Gift ($) Average Time Between Gifts (Month) Average Gift
1 1 1 1399 703 74 6 5 3 4.857142857
2 1 0 698 463 46 12 12 6 9.4
3 0 1 828 376 32 10 5 7 4.285714286
4 1 0 1471 546 94 10 8 3 7.08
Instructions Fund raising Database Your (fictional) manager, Sarah Trindle, has identified some questions she would like you to answer using the Fundraising Database. The database is a sample of the history of donors that have contributed to your non-profit company. It includes many variables about the demographics of the donors and the amount they have donated. 1. What is an interval estimate of the average donation for the population based off this sample? 2. What is an interval estimate of the proportion of donors that are home owners for the population based off this sample? 3. Is there a significant difference between the mean maximum donation between donors that own a home and those that do not own a home? Assume unequal variances. 4. We want to make a claim that the average donation is $13 for the population. Does this sample provide evidence against that claim? Conduct appropriate confidence intervals and hypothesis tests at 95% confidence (5% significance) to answer these questions and summarize your results in a formal report to your (fictional) manager, Ms. Trindle.Excel data (copy & paste excatly like that) : Gender (1=Female) Home Value ($1000s) Income ($100s) Number Promotions Largest Gift ($) Latest Gift ($) Average Time Between Gifts (Month) Average Gift Row Id Homeowner (1=Yes) POPPPOPPPPOOPPPPPPPPPPOPP 1399 703 74 6 5 4. 857142857 69 463 46 12 12 9.4 828 376 32 10 5 4.285714286 1471 546 94 10 8 7.08 547 132 20 11 7. 666666667 482 :75 10 11 857 36t 20 10 7.3 20 10. 69230769 135 497 15 505 TOo WWWGW Van W 9.576923077 388 15 10 9 438 533 21 16 1316 $75 66 12 6 428 71 73 3. 659090909 629 172 59 3.652173913 1318 458 10 1052 102 20 16.66666667 779 50 98 4. 344827586 807 393 50 10 9. 090909091 2246 540 76 34 14.55555556 78 398 60 31.7 995 407 25 13.6 936 590 3.62962963 36 392 20 8.833333333 3510 33 15 12.5 155 6.076923077 POPPOOPOPPOPPPPPPPPOPOOPPPPPP 735 1888 435 98 53 23 17. 3958 862 11.9 OPOPOGOOGOOPOPOPOPOPOPPOPPOPPOPOOOPOOPPPPOOPPOOPOP 273 15 20 41 15 15 $10 328 50 25 10.0625 326 8 780 14 354 48 15 20 13.46153846 $18 48 92 15 8. 454545455 3321 36 66 20 9. 444444444 1868 380 28 10 5.166666667 457 29 85 10 3.590909091 1604 431 26 10 8.7 842 $56 50 10 5.944444444 2085 797 50 4.722222222 5505 114 24 16 13 319 428 10 5. 10 10 29 315 2.260869565 295 $15 20 11.75 575 102 16 13 998 354 10 16 12 10. 66666667 105 15 9.727272727 314 207 25 12 4347 54 10 6 24 14. 835 364 4.344827586 1772 492 506 GNOBE 13.71428571 6. 4138
