please use format to answer following questions
Lazarus Consulting is a large computer consulting company in New York. Pete Lazarus, the CEO and founder, is well known for his philanthropic efforts. Pete knows that most of his employees contribute to nonprofit organizations and wants to reward them for their efforts while encouraging others to contribute to charities. Pete began a program that matches 50 percent of each employee donation. The only stipulations are that the charity must be a nonprofit organization and the company will match only up to $2,000 per year per employee.
| | What was the total donation amount per organization? (Without matching funds.) |
| | What were the average donations per organization? (Without matching funds.) |
a HA 5 WES DX , FO el BE #T TO M N N 0 P 0 0 R 0 2 ARIAH AYK4 Data Version 1.xlsx NE New Tab Arial v 10 VA A A ab y LE GATA B 1 Uv CAY - % 8 99 Al . fx Submitted A D E F G H 1 K L 1 Submitted Employee ID Last Name First Name | Organization Amount Donation Sant 2 2011/12,8 211 Smith Diabetic Action $50 2011/12/19 3 2011112096 234 Daniel Make a Wiah Faurentiam S225 2011/12/29 4 2011/12/6 243 Barla Bob Cancer Society $26 2011/1216 5 2011/12/10 334 Kola Pets Police Federation S180 2011/12/14 6 2011/12,6 345 CM Roberto LAUKAMA Socialy 560 2011/12/19 7 2011/12:27 385 Lee Suleing Homeless Shelter 325 2011/12/30 2011/12/13 388 mith James abitat for Humanis $150 2011/12/23 2011/12027 370W Many Habitat for Humanity 5100 10 2011/12/29 2011/12/4 3R9 Fisher ne Sott Cancer Society S125 2011/12/10 11 2011/11:29 432 Ach Habitat for Humanity 350 2011/12 12 2011/12/2 454 Cross Roberta Make a Wish Fourdation $76 2011/1214 13 2011/12/3 456 Butler Amy Cancer Society S250 2011/12/10 14 2011/12/3 439 Cmas Roberta Animal Shelter $20 2011/12 15 2011/12/2 543F Scoli Meals on Wheels $125 2011/12/28 16 2011/12/12 546 Daniels wie Amnesty Inte matural $200 2011/12/21 17 2011/12/20 650 Les Meals on Wheels S116 2011/12/22 2011/12/5 654 Ash Carn Diabetic Association 5100 2011/1216 19 2011/12/12 857 Rover Sool Animal Shelter 395 2011/12/15 20 2011/1219 675 Ash Diabet Assoca $100 2011 92/10 21 2011/12/6 832 Haltz Todd Cancer Social $50 2011/12/14 22 2011/12/16 857 Danials Jule MAKA A WEh Foundation S130 2011/12/21 23 2011/12/13 45 WIB Vietnam Veterans 360 2011/12/13 24 2011/12/14 Stoti Homeless Shelters 300 2011072419 20 2011/12/17 997 Halm Gary Diabetic Assocation $50 2011102/22 26 2011/2/6 21 Smith comes Diabetic Actor $50 2011/2/19 27 2011/2/16 234 Daniel Make Wah Faurdation S225 220-9011 28 2011/215 Burle 249 Baules Bub Cancer Sucie 325 2011/26 29 2011/2010 334 Kolne Pete Poknaderation S180 2011/2/14 30 2011/2/6 345 Cmas Roberto Loukama oglaly SEO 2011/2/13 31 2011/2:27 385 |Sufeins Home Shala 325 2130.2011 32 2011/2/13 388 Smith Games Teatfer Human $150 2011/2/23 32 2011/2:27 370 Wis Mary Habitat for Humanity $100 2:29:2011 34 20 11:24 359 Fisher Spott Cancer Society 595 20112/10 35 2011/1199 432 Ah | tamis | TE Habitat for Humanity Himand 550 2011:2:1 36 2011/22 454 CIUS Roberta Make a Wish Fourdation 375 2011/24 37 2011 456 Butler Am Cancerning $200 2011/2/10 499 Cmss Roberta Animal Shelter $20 2012 2011/25 35 2011/12 543F Sot Massan WAAS 325 2011 1912 2011/22 548 Daniel Lue Arnesty Internatural $200 2011/2/21 41 2011/2/20 650 LOS im Meals on Wheels 318 2011/2/22 42 201125 654 Ash Carin Diabetic Association 5100 2011/26 43201199 657 RODA Animal Shalar 595 2011/2/15 44 201129 675| Ash Swoll Diabetic Association S100 2011/2/18 2011/2/6 832 Haitz Todd Cancer Society $50 2011/2/14 46 2011/2/16 857 Daniels Jule Make Wish Foundation S130 201112/21 47 2011/2/3 945 WIAM Vienam Valentin 560 2011/2/13 18 2011/2014 972 R Suoll Homeless Shalom 380 2011/2/19 49 201112117 992 Haim Gary HEZE 16 tr $50 2011/2/22 20 11/6/6 251 Smith James Diabetic Association $50 2011/6/19 944 Anna 1041 con AYK 4 Tracking Donations Answers + 1 Scott 201123 + 100% AYK4 Data Version 1.xlsx a ab y 4 WED - % DX 30 el #t F G H 1 L L M N. P 0 R T E- ARIAH NE New Tab Arial v 10 VA A A LE GATA B U de A Al fx Submitted A B D E 49 2011/2017 297 Halim Gary Diabetic Assocation 50 2011 6.6 20 Smith lames Diabetic Association 51 2011/8116 234| Daniel LA MAKA & Wish Foundation 52 2011/8/5 243 Ray Bub Society 53 2011/8/10 334 Kalec Patc Pokederation 54 2011/6/6 345 Cross Roberta Leukemia Society le 55 3ASI 011/8:27 Suling Home Shala SE 2011/8/13 388 Habitat for Humanity 57 201 18:27 30 MS Mary Habitat for Humanity 58 2011/6/4 389 Fisher Scott Cancer Society 55 2011/5199 432 Ah MA Habitat for Humanity 80 2011/02 454 Cruus Roberts Maku a With Foundation 61 2011/6/3 456 Butler Amy Cancer Socies 62 2011/6/3 499 Cross Roberta Animal Shelter A9 2011/12 543 Fishe Sot Meals on Wheels 84 2011/8/8 548 Daniel Juie Arnesty Internatural 60 201108120 650 Los um Meals on Wheels GE 2011/05 654 Ash Carin Diabetic Association 67 201116 657 ROGA Sot TAnimal Shelter 88 2011/8/9 675 Ash Scoil Diabetic Auction 09 2011/6/6 832 Haitz Todd Cancerny 70 2011/6/16 857 Daniel Jul Make Wish Foundation 71 2011/6/3 245/WIAM -am Vietnam Veterans 72 972 Rovers Scoil Home Sholars 2011/8/17 90 Haim Gary Diabetic Association 74 - 2011.99 29 mes Diabetic Association 75 2011/9:19 234 Danial MAKA A Wish Foundation 76 2011/918 248 Bayley Bals Cancer Society 77 2011/9/10 334 Kalee Pate Police Foderation 78 2011.9 341 Cross Haberta Leukema Sony 79 20110.27 38 LA Sulaing Home Shakers 802011/9/18 399 Smile IHtial for HJ. 01 201119:27 370 Wils Mary abitat for Humanity 12 2011/9/4 399 Fished Spott Cancer Society 89 2011/0:29 432 Ah la mia Hastat for Humanity Bal I 84 2011/12 484 Cross Robert Make a Wish Fourdation 05 2011/03 480 Butler Amy Cancer Society 2011/9/3 499 Emas Roberta An mal Shaber 87 2011/12 843 Fisher Scott Msan Wheels 2011/8/9 849 Daniele Annely Intematoral 08 2011131201 830 LUG Jim Meals on Wheels 90 994 Ath Carin Diabet ABANG 91 2011/09 937 Rogers Scott Animal Shelter 92 2011 9.9 97AA Small Diabetic Association 83 2011/09 832 Haiz Todd Cancer Sur 94 201 19:19 897 Daniels Jule Make a Wish Foundation 95 201103 94 Wiams James Vietnam Veterans OF 2011/2/14 977 Roger Sot Hos Shala DY 97 2011/9/17 987 Halim Gary Diabetic Association 88 AYK 4 Tracking Donations Answers + + ** 2011131 $50 $50 S225 325 $100 $60 525 $150 $100 $65 350 375 $250 SE $20 565 $200 $56 S100 595 $100 350 5130 560 380 $50 uc $80 5298 328 $100 $50 $28 S180 $100 $98 $80 378 S200 $20 $58 S200 508 S100 598 S100 380 $130 $90 380 380 2011/2/22 2011/6/13 2011/6/29 2011/88 2011/6/14 2011/6/19 2011/6/30 2011/6/23 2011/6/29 2011/6/10 2011/8/1 201116 2011 CD 2011/56 2011/6/26 2011621 2011/6/22 2011, 2011/6/15 2011/6/18 2011/6/14 2011/6/21 2011/6/13 2011/6/18 201110/22 201110110 2011/02 2011.919 2011 2011/5/19 2011/0/30 2011/8723 201118729 2011/5/10 2011/11 2011/954 2011910 2011 2011/0723 2011/8/21 2011/9/22 2011 2011/919 2011/11 2011/9/18 2011/6/14 20111121 2011/5/13 2011/12 2011/8/22 23 Smith + 100% ARI RA AYK4 Data Version 1.xlsx a 2 New Tab AR # H SM 200% LT HHH RNA EX . 103 100% BE 5183 THE th Bt! * T xfx E4 B D E F G Amount Amount 1 2 3 TOTAL DONATIONS PER ORGANIZATION 4 Organization 5 Amnesty International Total 6 Animal Shelter Total 7 Cancer Society Total 8 Diabetic Association Total 9 Habitat for Humanity Total 10 Homeless Shelters Total 11 Leukemia Society Total 12 Make a Wish Foundation Total 13 Meals on Wheels Total 14 Police Federation Total 15 Vietnam Veterans Total 16 Grand Total 17 18 19 20 21 22 23 24 AVERAGE DONATION PER ORGANIZATION Organization Amnesty International Total Animal Shelter Total Cancer Society Total Diabetic Association Total Habitat for Humanity Total Homeless Shelters Total Leukemia Society Total Make a Wish Foundation Total Meals on Wheels Total Police Federation Total Vietnam Veterans Total Grand Average AYK 4 Tracking Donations Answers + 1 CT 200%
