• Create a new column called Average Donation that uses a formula to find how much money each project backer paid on average. (I need the formula. The picture blow  it’s the solution sheet but I need the formula. )
• Create two new columns, one called Parent Category and another called Sub-Category, that use formulas to split the Category and Sub-Category columns into the two new, separate columns. (I also need formula and how to do the rest)
•  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A id 1 Odom Inc O Baldwin, Riley and Jackson 2 Melton, Robinson and Fritz 4 Larson-Little 3 Mcdonald, Gonzalez and Ross 5 Harris Group 7 Carter-Guzman 6 Ortiz, Coleman and Mitchell 8 Nunez-Richards 10 Green Ltd B name 9 Rangel, Holt and Jones. 12 Kim Ltd 11 Perez, Johnson and Gardner 13 Walker, Taylor and Coleman 14 Rodriguez, Rose and Stewart 16 Hines Inc 15 Wright, Hunt and Rowe 17 Cochran-Nguyen 18 Johnson-Gould 19 Perez-Hess 20 Reeves, Thompson and Richardson C blurb Pre-emptive tertiary standardization Managed bottom-line architecture Function-based leadingedge pricing structure core Vision-oriented fresh- thinking conglomeration Proactive foreground Open-source optimizing database Operative upward- trending algorithm Centralized cohesive challenge Exclusive attitude- oriented intranet Open-source fresh- thinking model Monitored empowering installation Grass-roots zero administration system engine Assimilated hybrid intranet Multi-tiered directional open architecture Cloned directional synergy Extended eco-centric pricing structure Cross-platform systemic adapter Seamless 4th generation methodology Exclusive needs-based adapter Down-sized cohesive archive Proactive composite alliance D goal 100 1400 108400 4200 7600 7600 5200 4500 110100 6200 5200 6300 6300 4200 28200 81200 1700 84600 9100 62500 131800 E pledged 0 14560 142523 2477 5265 13195 1090 14741 21946 3208 13838 3030 5629 10295 18829 38414 11041 134845 6089 30331 147936 F Percent Funded O failed outcome 1040 successful 131 successful 59 failed 69 failed 174 successful 21 failed 20 live 328 successful 52 failed G 266 successful 48 failed 89 failed 245 successful 67 failed 47 failed 649 successful 159 successful 67 canceled 49 failed 112 successful H backers_co Average Donat 0 158 1425 24 53 174 18 227 708 44 220 27 55 98 200 452 100 1249 135 674 1396 0 CA 92.15 US 100.02 AU 103.21 US 99.34 US 75.83 DK 60.56 GB 64.94 DK 31 DK 72.91 US 62.9 US 112.22 US 102.35 US 105.05 US 94.15 US 84.99 US 110.41 US 107.96 US 45.1 US 45 US 105.97 US country CAD USD AUD USD USD DKK GBP DKK DKK USD USD USD USD USD USD USD USD USD USD USD USD K currency L launched at 1448690400 1408424400 1384668000 1505278800 1565499600 1568955600 1439442000 1547964000 1548309600 1346130000 1347080400 1379566800 1281762000 1285045200 1571720400 1465621200 M deadline 1281330000 1281502800 1331013600 1450159200 1575957600 1408597200 1384840800 1294812000 1536382800 1505365200 1439614800 1383804000 1285909200 1285563600 1572411600 1466658000 1333342800 1390370400 1392271200 1576303200 1294898400 1537074000 1551679200 1553490000 1406523600 1406523600 N Date Created Conversion 11/28/15 8/19/14 11/17/13 8/11/19 1/20/19 8/28/12 9/13/17 8/13/15 /9/10 9/19/13 8/14/10 9/21/10 10/22/19 6/11/16 3/6/12 12/10/19 1/22/14 1/12/11 9/8/18 3/4/19 7/28/14 O Date Ended Conversion 12/15/15 8/21/14 11/19/13 9/20/19 1/24/19 9/8/12 9/14/17 8/15/15 8/11/10 11/7/13 10/1/10 9/27/10 10/30/19 6/23/16 4/2/12 12/14/19 2/13/14 1/13/11 9/16/18 3/25/19 7/28/14 P staff_pick FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE Q spotlight FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE category & sub-category food/food trucks. music/rock technology/web music/rock theater/plays theater/plays film & video/documentary theater/plays theater/plays music/electric music film & video/drama theater/plays R film & video/drama music/indie rock. music/indie rock technology/wearables publishing/nonfiction film & video/animation theater/plays theater/plays film & video/drama food music technology music theater theater Parent Category film & video theater theater music film & video theater film & video music music technology publishing film & video theater theater S film & video food trucks rock web rock plays plays documentary plays plays T Sub-Category electric music drama plays drama indie rock. indie rock wearables nonfiction animation plays plays drama