Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Donation ID Donor ID Last Name First Name Organization Amount Donation Date Instructions: 1 211 #DIV/0! James Diabetic Association $119.00 6/6/12 Your company has been
Donation ID | Donor ID | Last Name | First Name | Organization | Amount | Donation Date | Instructions: | ||
1 | 211 | #DIV/0! | James | Diabetic Association | $119.00 | 6/6/12 | Your company has been collecting data on donors and the charities to which they | ||
2 | 234 | Daniels | Julie | Make a Wish Foundation | $35.00 | 8/11/11 | contribute money. Each donor is identified by his/her Donor ID. All Donor IDs are unique. | ||
3 | 243 | Bagley | Bob | Cancer Society | $187.00 | 7/30/11 | Each donation is identified by its Donation ID. | ||
4 | 334 | Kellee | Pete | Police Federation | $161.00 | 12/21/11 | Use the data in columns A-G to answer the 10 questions below. | ||
5 | 345 | Cross | Roberta | Leukemia Society | $59.00 | 4/1/12 | |||
6 | 365 | Lee | Sufeing | Homeless Shelters | $19.00 | 3/11/11 | Question | Answer | |
7 | 211 | Smith | James | Habitat for Humanity | $242.00 | 11/15/11 | What is the first and last name of the person who donated most often? | ||
8 | 370 | Wills | Mary | Habitat for Humanity | $161.00 | 12/11/11 | How much money was donated to Make a Wish Foundation in 2011? | ||
9 | 389 | Fisher | Scott | Cancer Society | $107.00 | 6/19/11 | Which organization received the single greatest donation amount from Roberta Cross (ID = 345)? | ||
10 | 432 | Ash | Jamie | Habitat for Humanity | $100.00 | 9/2/11 | What was the average donation for the Police Federation? | ||
11 | 245 | Cross | Roberta | Make a Wish Foundation | $59.00 | 7/4/12 | What quarter/year combination generated the greatest total donation dollar amount? | ||
12 | 456 | Butler | Amy | Cancer Society | $26.00 | 7/3/12 | How many donations were made that were greater than $100? | ||
13 | 499 | Cross | Sally | Animal Shelter | $10.00 | 5/25/11 | How many different organizations are in this list? | ||
14 | 543 | Jordan | Scott | Meals on Wheels | $35.00 | 7/29/11 | How many different donors in this list donated more than $500 over their lifetime? | ||
15 | 234 | Daniels | Julie | Amnesty International | $116.00 | 9/23/12 | Which month has the most total number of donations? | ||
16 | 558 | Los | Jim | Meals on Wheels | $35.00 | 4/21/11 | Which month has the most money been donated? | ||
17 | 654 | Ash | Carlin | Cancer Society | $44.00 | 1/27/11 | Which month did James Smith (Donor ID = 211) donate the most money? | ||
18 | 657 | Rogers | Scott | Animal Shelter | $19.00 | 3/3/11 | |||
19 | 675 | Ash | Scott | Diabetic Association | $19.00 | 11/22/10 | |||
20 | 832 | Haitz | Todd | Cancer Society | $19.00 | 6/14/10 | |||
21 | 234 | Daniels | Julie | Make a Wish Foundation | $59.00 | 5/22/10 | |||
22 | 945 | Williams | James | Vietnam Veterans | $26.00 | 1/25/11 | |||
23 | 977 | Rogers | Scott | Homeless Shelters | $35.00 | 9/16/11 | |||
24 | 987 | Haim | Gary | Diabetic Association | $19.00 | 6/20/11 | |||
25 | 211 | Smith | James | Diabetic Association | $26.00 | 2/20/11 | |||
26 | 234 | Daniels | Julie | Make a Wish Foundation | $119.00 | 8/28/11 | |||
27 | 243 | Bagley | Bob | Cancer Society | $119.00 | 12/19/11 | |||
28 | 334 | Kellee | Pete | Police Federation | $200.00 | 12/17/10 | |||
29 | 345 | Cross | Roberta | Leukemia Society | $281.00 | 4/23/12 | |||
30 | 365 | Lee | Sufeing | Homeless Shelters | $42.00 | 12/27/10 | |||
31 | 211 | Smith | James | Habitat for Humanity | $51.00 | 9/19/12 | |||
32 | 370 | Wills | Mary | Habitat for Humanity | $19.00 | 6/12/10 | |||
33 | 389 | Fisher | Scott | Cancer Society | $19.00 | 6/29/11 | |||
34 | 432 | Ash | Jamie | Habitat for Humanity | $10.00 | 12/4/11 | |||
35 | 510 | Jones | Ella | Make a Wish Foundation | $59.00 | 3/5/12 | |||
36 | 456 | Butler | Amy | Cancer Society | $62.00 | 1/12/12 | |||
37 | 499 | Cross | Sally | Animal Shelter | $170.00 | 7/3/11 | |||
38 | 543 | Jordan | Scott | Meals on Wheels | $59.00 | 9/15/11 | |||
39 | 234 | Daniels | Julie | Police Federation | $100.00 | 9/8/12 | |||
40 | 558 | Los | Jim | Meals on Wheels | $100.00 | 6/16/11 | |||
41 | 654 | Ash | Carlin | Diabetic Association | $39.00 | 9/23/10 | |||
42 | 657 | Rogers | Scott | Animal Shelter | $39.00 | 6/30/10 | |||
43 | 675 | Ash | Scott | Diabetic Association | $39.00 | 5/3/11 | |||
44 | 832 | Haitz | Todd | Cancer Society | $42.00 | 7/6/10 | |||
45 | 234 | Daniels | Julie | Make a Wish Foundation | $51.00 | 5/13/11 | |||
46 | 945 | Williams | James | Vietnam Veterans | $59.00 | 3/5/12 | |||
47 | 977 | Rogers | Scott | Homeless Shelters | $68.00 | 1/9/12 | |||
48 | 987 | Haim | Gary | Diabetic Association | $26.00 | 6/2/10 | |||
49 | 211 | Smith | James | Diabetic Association | $23.00 | 4/30/11 | |||
50 | 234 | Daniels | Julie | Make a Wish Foundation | $39.00 | 7/24/11 | |||
51 | 243 | Bagley | Bob | Cancer Society | $96.00 | 7/19/12 | |||
52 | 334 | Kellee | Pete | Police Federation | $103.00 | 5/3/11 | |||
53 | 345 | Cross | Roberta | Leukemia Society | $96.00 | 5/14/11 | |||
54 | 365 | Lee | Sufeing | Homeless Shelters | $161.00 | 5/31/11 | |||
55 | 211 | Smith | James | Habitat for Humanity | $241.00 | 3/11/12 | |||
56 | 370 | Wills | Mary | Habitat for Humanity | $200.00 | 6/30/12 | |||
57 | 389 | Fisher | Scott | Cancer Society | $119.00 | 3/20/12 | |||
58 | 432 | Ash | Jamie | Habitat for Humanity | $39.00 | 6/20/11 | |||
59 | 454 | Cross | Sally | Make a Wish Foundation | $51.00 | 5/3/12 | |||
60 | 456 | Butler | Amy | Cancer Society | $59.00 | 6/15/11 | |||
61 | 345 | Cross | Roberta | Animal Shelter | $19.00 | 7/15/10 | |||
62 | 543 | Jordan | Scott | Meals on Wheels | $10.00 | 4/17/12 | |||
63 | 234 | Daniels | Julie | Amnesty International | $26.00 | 1/7/11 | |||
64 | 558 | Los | Jim | Meals on Wheels | $75.00 | 9/5/10 | |||
65 | 654 | Ash | Carlin | Diabetic Association | $68.00 | 12/27/11 | |||
66 | 657 | Rogers | Scott | Animal Shelter | $59.00 | 11/17/11 | |||
67 | 675 | Ash | Scott | Diabetic Association | $51.00 | 10/26/11 | |||
68 | 832 | Haitz | Todd | Cancer Society | $55.00 | 9/17/12 | |||
69 | 234 | Daniels | Julie | Make a Wish Foundation | $42.00 | 8/10/10 | |||
70 | 945 | Williams | James | Vietnam Veterans | $26.00 | 6/21/12 | |||
71 | 977 | Rogers | Scott | Homeless Shelters | $241.00 | 12/28/10 | |||
72 | 987 | Haim | Gary | Diabetic Association | $161.00 | 9/12/11 | |||
73 | 211 | Smith | James | Diabetic Association | $80.00 | 7/4/10 | |||
74 | 234 | Daniels | Julie | Make a Wish Foundation | $119.00 | 2/18/12 | |||
75 | 243 | Bagley | Bob | Cancer Society | $26.00 | 4/3/12 | |||
76 | 334 | Kellee | Pete | Police Federation | $402.00 | 4/17/11 | |||
77 | 345 | Cross | Roberta | Leukemia Society | $322.00 | 6/29/11 | |||
78 | 365 | Lee | Sufeing | Homeless Shelters | $241.00 | 7/3/10 | |||
79 | 211 | Smith | James | Habitat for Humanity | $161.00 | 2/13/12 | |||
80 | 370 | Wills | Mary | Habitat for Humanity | $80.00 | 9/3/12 | |||
81 | 389 | Fisher | Scott | Cancer Society | $23.00 | 7/28/10 | |||
82 | 432 | Ash | Jamie | Habitat for Humanity | $32.00 | 10/9/11 | |||
83 | 345 | Cross | Roberta | Make a Wish Foundation | $39.00 | 6/2/10 | |||
84 | 456 | Butler | Amy | Cancer Society | $48.00 | 7/26/11 | |||
85 | 345 | Cross | Roberta | Animal Shelter | $39.00 | 6/20/12 | |||
86 | 843 | Lopez | Jorge | Meals on Wheels | $32.00 | 2/9/11 | |||
87 | 234 | Daniels | Julie | Amnesty International | $42.00 | 7/14/12 | |||
88 | 558 | Los | Jim | Meals on Wheels | $35.00 | 7/22/10 | |||
89 | 654 | Ash | Carlin | Diabetic Association | $51.00 | 5/25/12 | |||
90 | 977 | Rogers | Scott | Animal Shelter | $26.00 | 9/30/11 | |||
91 | 978 | Ash | Scott | Diabetic Association | $19.00 | 9/30/10 | |||
92 | 832 | Haitz | Todd | Cancer Society | $39.00 | 2/9/12 | |||
93 | 897 | Daniels | Julie | Make a Wish Foundation | $80.00 | 2/28/11 | |||
94 | 948 | Williams | James | Vietnam Veterans | $42.00 | 4/1/12 | |||
95 | 977 | Rogers | Scott | Homeless Shelters | $59.00 | 12/24/10 | |||
96 | 987 | Haim | Gary | Diabetic Association | $42.00 | 9/24/10 | |||
97 | 211 | Smith | James | Vietnam Veterans | $40.00 | 12/13/10 | |||
98 | 234 | Daniels | Julie | Make a Wish Foundation | $12.00 | 4/21/11 | |||
99 | 243 | Bagley | Bob | Cancer Society | $100.00 | 12/22/11 | |||
100 | 334 | Kellee | Pete | Meals on Wheels | $118.00 | 12/20/10 | |||
101 | 345 | Cross | Roberta | Leukemia Society | $56.00 | 7/8/10 | |||
102 | 365 | Lee | Sufeing | Homeless Shelters | $124.00 | 7/10/10 | |||
103 | 211 | Smith | James | Habitat for Humanity | $132.00 | 5/20/11 | |||
104 | 370 | Wills | Mary | Habitat for Humanity | $110.00 | 9/3/10 | |||
105 | 389 | Fisher | Scott | Cancer Society | $56.00 | 10/29/11 | |||
106 | 432 | Ash | Jamie | Habitat for Humanity | $109.00 | 10/14/12 | |||
107 | 454 | Cross | Sally | Make a Wish Foundation | $46.00 | 7/26/10 | |||
108 | 456 | Butler | Amy | Cancer Society | $25.00 | 12/28/11 | |||
109 | 345 | Cross | Roberta | Animal Shelter | $135.00 | 9/17/10 | |||
110 | 234 | Daniels | Julie | Amnesty International | $55.00 | 8/19/12 | |||
111 | 558 | Los | Jim | Meals on Wheels | $70.00 | 8/29/12 | |||
112 | 654 | Ash | Carlin | Diabetic Association | $25.00 | 10/15/11 | |||
113 | 977 | Rogers | Scott | Animal Shelter | $80.00 | 12/11/11 | |||
114 | 345 | Cross | Roberta | Animal Shelter | $65.00 | 3/25/11 | |||
115 | 843 | Lopez | Jorge | Meals on Wheels | $75.00 | 5/18/12 | |||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started