Question: Mr. Smith has asked you to answer the below question using the Fundraising Database posted below. The database is a sample of the history of donors that have contributed to your company. It includes many variables about the demographics of the donors and the amount they have donated. We want to make a claim that the average donation is $13 for the population. Does this sample provide evidence against that claim? If necessary conduct an appropriate confidence intervals and hypothesis tests at 95% confidence (5% significance) to answer this question and summarize the results for Mr. Smith. Please add some explanations about how did you come up with the response? What analysis did you use and what was the output? If you conducted a hypothesis test, what were your hypotheses? What would be your conclusion to the question? What is your recommendation to your manager Mr. Smith? Note: please solve in Excel. Also, please provide screenshots 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 3 0 1 828 376 32 10 5 7 4.285714286 14 0 0 1318 458 25 10 10 2 8 15 0 0 1052 402 27 20 20 7 16.66666667 20 0 1 995 407 83 25 10 6 13.6 24 0 1 735 455 58 9 9 6 6.076923077 31 0 0 418 348 92 15 14 5 8.454545455 32 0 1 3321 536 66 20 20 10 9.444444444 34 0 1 457 329 85 10 10 12 3.590909091 43 0 0 675 402 24 16 16 9 13 46 0 0 620 405 52 15 11 6 9.727272727 48 0 0 4347 454 33 10 10 5 6 49 0 0 470 324 29 20 20 5 14.8 52 0 1 1000 506 28 10 5 3 6.5 55 0 1 4135 880 65 15 15 12 8.2 62 0 1 761 511 51 12 11 1 9.3 64 0 0 436 245 30 15 15 7 13.4 65 0 0 2483 668 49 50 50 4 16.33333333 70 0 0 660 329 53 14 7 0 6.857142857 75 0 0 1516 668 61 40 40 14 21.33333333 85 0 1 2124 554 28 20 10 2 8.166666667 86 0 1 1505 445 47 11 8 11 7.7 88 0 1 1631 400 24 10 10 6 7.75 91 0 1 1305 597 16 25 25 15 14 94 0 0 349 324 55 7 5 9 4.714285714 97 0 0 698 348 59 15 13 10 11.5 99 0 1 550 304 101 20 20 3 14 101 0 1 422 319 66 16 10 5 9.428571429 103 0 1 567 327 24 16 16 2 12 105 0 0 745 446 54 12 12 2 9 107 0 0 3361 760 17 25 25 5 25 108 0 0 625 489 34 10 7 14 6 114 0 0 2194 506 43 30 22 1 10.81818182 119 0 0 622 377 87 17 15 5 13.38888889 121 0 0 2827 620 40 19 19 11 12.2 125 0 1 2582 207 52 50 50 3 30 128 0 1 623 388 43 9 5 3 3.7 130 0 0 1007 366 18 25 25 5 25 137 0 1 383 336 32 16 16 14 12 138 0 1 332 403 24 11 8 6 7.25 140 0 1 761 285 79 10 5 14 5 143 0 0 674 327 36 12 12 7 8.333333333 146 0 1 497 325 66 10 6 4 5.666666667 150 0 1 1596 218 47 6 5 1 5.055555556 154 0 0 409 337 55 6 6 6 3.722222222 161 0 0 1692 440 57 12 12 5 8.666666667 163 0 0 931 477 43 10 9 8 6.411764706 165 0 1 2809 718 21 10 8 1 7.2 166 0 0 610 393 64 15 10 22 9.222222222 170 0 1 1172 534 31 15 15 6 10.42857143

Question: Mr. Smith has asked you to answer the below question using the Fundraising Database posted below. The database is a sample of the history of donors that have contributed to your company. It includes many variables about the demographics of the donors and the amount they have donated. We want to make a claim that the average donation is $13 for the population. Does this sample provide evidence against that claim? If necessary conduct an appropriate confidence intervals and hypothesis tests at 95% confidence (5% significance) to answer this question and summarize the results for Mr. Smith. Please add some explanations about how did you come up with the response? What analysis did you use and what was the output? If you conducted a hypothesis test, what were your hypotheses? What would be your conclusion to the question? What is your recommendation to your manager Mr. Smith? Note: please solve in Excel. Also, please provide screenshots 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 3 0 1 828 376 32 10 5 7 4.285714286 14 0 0 1318 458 25 10 10 2 8 15 0 0 1052 402 27 20 20 7 16.66666667 20 0 1 995 407 83 25 10 6 13.6 24 0 1 735 455 58 9 9 6 6.076923077 31 0 0 418 348 92 15 14 5 8.454545455 32 0 1 3321 536 66 20 20 10 9.444444444 34 0 1 457 329 85 10 10 12 3.590909091 43 0 0 675 402 24 16 16 9 13 46 0 0 620 405 52 15 11 6 9.727272727 48 0 0 4347 454 33 10 10 5 6 49 0 0 470 324 29 20 20 5 14.8 52 0 1 1000 506 28 10 5 3 6.5 55 0 1 4135 880 65 15 15 12 8.2 62 0 1 761 511 51 12 11 1 9.3 64 0 0 436 245 30 15 15 7 13.4 65 0 0 2483 668 49 50 50 4 16.33333333 70 0 0 660 329 53 14 7 0 6.857142857 75 0 0 1516 668 61 40 40 14 21.33333333 85 0 1 2124 554 28 20 10 2 8.166666667 86 0 1 1505 445 47 11 8 11 7.7 88 0 1 1631 400 24 10 10 6 7.75 91 0 1 1305 597 16 25 25 15 14 94 0 0 349 324 55 7 5 9 4.714285714 97 0 0 698 348 59 15 13 10 11.5 99 0 1 550 304 101 20 20 3 14 101 0 1 422 319 66 16 10 5 9.428571429 103 0 1 567 327 24 16 16 2 12 105 0 0 745 446 54 12 12 2 9 107 0 0 3361 760 17 25 25 5 25 108 0 0 625 489 34 10 7 14 6 114 0 0 2194 506 43 30 22 1 10.81818182 119 0 0 622 377 87 17 15 5 13.38888889 121 0 0 2827 620 40 19 19 11 12.2 125 0 1 2582 207 52 50 50 3 30 128 0 1 623 388 43 9 5 3 3.7 130 0 0 1007 366 18 25 25 5 25 137 0 1 383 336 32 16 16 14 12 138 0 1 332 403 24 11 8 6 7.25 140 0 1 761 285 79 10 5 14 5 143 0 0 674 327 36 12 12 7 8.333333333 146 0 1 497 325 66 10 6 4 5.666666667 150 0 1 1596 218 47 6 5 1 5.055555556 154 0 0 409 337 55 6 6 6 3.722222222 161 0 0 1692 440 57 12 12 5 8.666666667 163 0 0 931 477 43 10 9 8 6.411764706 165 0 1 2809 718 21 10 8 1 7.2 166 0 0 610 393 64 15 10 22 9.222222222 170 0 1 1172 534 31 15 15 6 10.42857143

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

Question: Mr. Smith has asked you to answer the below question using the Fundraising Database posted below. The database is a sample of the history of donors that have contributed to your company. It includes many variables about the demographics of the donors and the amount they have donated.

We want to make a claim that the average donation is $13 for the population. Does this sample provide evidence against that claim?

If necessary conduct an appropriate confidence intervals and hypothesis tests at 95% confidence (5% significance) to answer this question and summarize the results for Mr. Smith.

Please add some explanations about how did you come up with the response? What analysis did you use and what was the output? If you conducted a hypothesis test, what were your hypotheses? What would be your conclusion to the question? What is your recommendation to your manager Mr. Smith?

Note: please solve in Excel. Also, please provide screenshots

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
3	0	1	828	376	32	10	5	7	4.285714286
14	0	0	1318	458	25	10	10	2	8
15	0	0	1052	402	27	20	20	7	16.66666667
20	0	1	995	407	83	25	10	6	13.6
24	0	1	735	455	58	9	9	6	6.076923077
31	0	0	418	348	92	15	14	5	8.454545455
32	0	1	3321	536	66	20	20	10	9.444444444
34	0	1	457	329	85	10	10	12	3.590909091
43	0	0	675	402	24	16	16	9	13
46	0	0	620	405	52	15	11	6	9.727272727
48	0	0	4347	454	33	10	10	5	6
49	0	0	470	324	29	20	20	5	14.8
52	0	1	1000	506	28	10	5	3	6.5
55	0	1	4135	880	65	15	15	12	8.2
62	0	1	761	511	51	12	11	1	9.3
64	0	0	436	245	30	15	15	7	13.4
65	0	0	2483	668	49	50	50	4	16.33333333
70	0	0	660	329	53	14	7	0	6.857142857
75	0	0	1516	668	61	40	40	14	21.33333333
85	0	1	2124	554	28	20	10	2	8.166666667
86	0	1	1505	445	47	11	8	11	7.7
88	0	1	1631	400	24	10	10	6	7.75
91	0	1	1305	597	16	25	25	15	14
94	0	0	349	324	55	7	5	9	4.714285714
97	0	0	698	348	59	15	13	10	11.5
99	0	1	550	304	101	20	20	3	14
101	0	1	422	319	66	16	10	5	9.428571429
103	0	1	567	327	24	16	16	2	12
105	0	0	745	446	54	12	12	2	9
107	0	0	3361	760	17	25	25	5	25
108	0	0	625	489	34	10	7	14	6
114	0	0	2194	506	43	30	22	1	10.81818182
119	0	0	622	377	87	17	15	5	13.38888889
121	0	0	2827	620	40	19	19	11	12.2
125	0	1	2582	207	52	50	50	3	30
128	0	1	623	388	43	9	5	3	3.7
130	0	0	1007	366	18	25	25	5	25
137	0	1	383	336	32	16	16	14	12
138	0	1	332	403	24	11	8	6	7.25
140	0	1	761	285	79	10	5	14	5
143	0	0	674	327	36	12	12	7	8.333333333
146	0	1	497	325	66	10	6	4	5.666666667
150	0	1	1596	218	47	6	5	1	5.055555556
154	0	0	409	337	55	6	6	6	3.722222222
161	0	0	1692	440	57	12	12	5	8.666666667
163	0	0	931	477	43	10	9	8	6.411764706
165	0	1	2809	718	21	10	8	1	7.2
166	0	0	610	393	64	15	10	22	9.222222222
170	0	1	1172	534	31	15	15	6	10.42857143

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Point Estimation, Limit Theorems, Approximations, and Bounds$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.