Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra 1, Volume 2

Authors: Edward B. Burger, Juli K. Dixon, Steven J. Leinwand, Timothy D. Kanold

Student Edition

0544368185, 978-0544368187

More Books

Students also viewed these Mathematics questions

Question

=+ What are their individual goals?

Answered: 1 week ago