Your task is to change the field according to the direction below. Then analyze and write a 2-page memo reporting on your findings. The memo should be based on the group you assigned to from the "All...

• 
  
  
  Write a memo explaining where the overall data
  
  
  




• 
  
  
  Discuss in detail how the data looks
  
  
  




• 
  
  
  Make recommendations on what to do
  
  
  




• 
  
  
  Place the chart in the memo
  
  
  




• 
  
  
  Review PivotTable rubric for details. NB:YOU DONT NEED TO DO ANYTHING ON THE EXCEL OR DATA , I HAVE DONE ALL THE STEPS AND ALL , YOUR TASK Is TO WRITE THE MEMO BASED ON THE DATA IN "All Teams Pivot Table Tab"..........
  
  
  
  
  
  Please submit as a Word Doc .docx file. NOT a PDF..and no reference. please its a MEMO
  
  
  
  
  
  

Documentation New Perspectives Excel 2019 | Module 7: SAM Project 1b Brevard County Swim Clubs SUMMARIZING YOUR DATA WITH PIVOTTABLES Author:Fatimat Dauda Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. All Employees Eligibility Employee IDNameAgeYears of ExperiencePay RateCert. YearCPR TrainedLifeguardInstructorCamp CounselorSwim TeamTeam CoachCPR CourseLevel A213Tiffany Adams22416.002018YesYesYesYesYesNoTrained2Employee IDV188 B534Hassan Bachim19115.752022NoNoNoNoNoNoNo1Employee NameJavier Vazquez B681Megan Beckman19115.752022YesNoNoNoYesNoTrained1 C826Catherine Coleman22416.002017YesNoYesYesYesNoTrained2 F724Carrie Faulkner24616.502015YesYesNoYesYesYesTrained2 G629Paul Gomez24616.502018YesYesNoYesYesYesTrained2Total EmployeesAverage Years of Experience G875Bryant Grossburg18015.502022NoNoNoNoNoNoNo1Lifeguards125.6 J608Marilyn Jesberger21316.002019NoNoNoYesYesNoYes1All Employees303.5 L869Jonathan Lampert25516.502019YesYesYesYesYesYesTrained2 M893Gina Milota21316.002020YesNoNoYesYesNoTrained1 N252Jeff Newman21316.002020NoNoNoYesYesNoYes1 O943Crystal Olneck23516.502018YesNoNoYesYesYesTrained2Years of Experience01258 P408Yolanda Padilla18015.502022NoNoNoNoNoNoNo1Pay Rate$15.50$15.75$16.00$16.50$17.50 P492Michael Pienkowski25716.502017YesYesYesYesYesYesTrained2 P833Keith Pienkowski24616.502018YesYesNoYesYesYesTrained2 Q567James Quinlan24416.002020YesNoYesYesYesYesTrained2 Q752Ryan Quinlan20216.002020YesNoYesNoYesNoTrained1 S639Andrea Shelby26817.502017YesYesNoYesYesYesTrained2 T598Anna Tran19216.002021NoNoYesNoNoNoNo1 U88Tracy Uphoff23516.502017YesYesNoYesYesYesTrained2 V188Javier Vazquez18015.502022NoNoNoNoNoNoNo1 V420Jose Vazquez22416.002018YesNoNoYesYesNoTrained2 V735Alexa Vanderson18015.502022NoNoNoNoNoNoNo1 W209Dale Wong28416.002018YesYesNoYesYesYesTrained2 W757Julie Weiss24616.502017YesYesYesYesYesYesTrained2 W909Mary Winslow24616.502018YesYesYesYesYesYesTrained2 W990Brandon Waddell21316.002019YesNoYesYesYesNoTrained1 Y753Aaron Yee20216.002019YesNoNoNoYesNoTrained1 Y888Kay Yamashita19115.752021YesNoYesNoYesNoTrained1 Y960Richard Young22416.002018YesYesNoYesYesNoTrained2 Melbourne Swim Teams Wins Team NameLocationLevelLeague202020212022Total Melbourne VipersMelbourne6Adult68923 Southern SurgeMelbourne5Adult571022 Florida Wave RunnersMelbourne3Youth77721 Swift SwordfishMelbourne2Adult37818 Summer BarracudasMelbourne1Summer46616 Coastal TarponsMelbourne6Youth56516 Melbourne SharksMelbourne3Summer25613 Slippery SealsMelbourne4Youth24612 Mighty BluefishMelbourne1Youth3249 Melbourne WahoosMelbourne2Youth4217 Most wins, 2020-2022:Melbourne Vipers Total Youth wins:65 Melbourne PivotTable LeagueTeam NameSum of 2020Sum of 2021Sum of 2022 Adult142227 Melbourne Vipers689 Southern Surge5710 Swift Swordfish378 Summer61112 Melbourne Sharks256 Summer Barracudas466 Youth212123 Coastal Tarpons565 Florida Wave Runners777 Melbourne Wahoos421 Mighty Bluefish324 Slippery Seals246 Grand Total415462 All Teams Wins Team NameLocationLevelLeague202020212022Total Cocoa Beach CyclonesCocoa Beach1Youth55717 Beach BreezeCocoa Beach1Summer66517 Mighty BluefishMelbourne1Youth3249 Brevard BarracudasMelbourne1Summer46616 Palm Bay ParrotsPalm Bay1Youth2349 Bay SkimmersPalm Bay1Youth54615 Titusville MinnowsTitusville1Youth3227 Titus OttersTitusville1Youth1247 Cocoa West PiratesCocoa Beach2Youth54413 Cocoa CardinalsCocoa Beach2Summer2215 Melbourne WahoosMelbourne2Youth4217 Swift SwordfishMelbourne2Adult37818 Bay KrakensPalm Bay2Youth63312 Palm Bay PenguinsPalm Bay2Youth65516 Seaside SplashersTitusville2Youth2237 Titusville Sea TurtlesTitusville2Youth52512 Ace AquaducksCocoa Beach3Youth65617 Cocoa FrogsCocoa Beach3Summer64515 Melbourne SharksMelbourne3Summer25613 Florida Wave RunnersMelbourne3Youth77721 Florida ThunderboltsPalm Bay3Youth2147 Florida WavesTitusville3Summer34411 Coastal TideTitusville3Youth42612 Brevard Blue WaveCocoa Beach4Youth107825 Slippery SealsMelbourne4Youth24612 Coastal HawksPalm Bay4Youth55414 Palm Bay RaysPalm Bay4Summer67821 Super SwimmersTitusville4Summer56718 Sea DogsCocoa Beach5Youth86620 Southern SurgeMelbourne5Adult571022 Seaside Sea SerpentsPalm Bay5Youth88420 Brevard MantaraysPalm Bay5Summer25310 Titusville TritonsTitusville5Youth55818 Cocoa RiptideCocoa Beach6Youth3429 Cocoa Beach SharksCocoa Beach6Adult78823 Melbourne VipersMelbourne6Adult681024 Coastal TarponsMelbourne6Youth56516 Palm Bay SurfPalm Bay6Youth54716 Bay BreakersPalm Bay6Adult43512 Swamp GatorsTitusville6Youth781025 All Teams PivotTable League(All) Row Labels2020 Wins2021 Wins2022 Wins Cocoa Beach Ace Aquaducks656 Beach Breeze665 Brevard Blue Wave1078 Cocoa Beach Cyclones557 Cocoa Beach Sharks788 Cocoa Cardinals221 Cocoa Frogs645 Cocoa Riptide342 Cocoa West Pirates544 Sea Dogs866 Melbourne Brevard Barracudas466 Coastal Tarpons565 Florida Wave Runners777 Melbourne Sharks256 Melbourne Vipers6810 Melbourne Wahoos421 Mighty Bluefish324 Slippery Seals246 Southern Surge5710 Swift Swordfish378 Palm Bay Bay Breakers435 Bay Krakens633 Bay Skimmers546 Brevard Mantarays253 Coastal Hawks554 Florida Thunderbolts214 Palm Bay Parrots234 Palm Bay Penguins655 Palm Bay Rays678 Palm Bay Surf547 Seaside Sea Serpents884 Titusville Coastal Tide426 Florida Waves344 Seaside Splashers223 Super Swimmers567 Swamp Gators7810 Titus Otters124 Titusville Minnows322 Titusville Sea Turtles525 Titusville Tritons558 Grand Total185186217 Swim Levels PivotTable Row Labels2020 Wins2021 Wins2022 Wins Level 4 Summer111315 Youth171618 Level 5 Adult5710 Summer253 Youth211918 Level 6 Adult171923 Youth202224 Grand Total93101111 Wins by Level 2020 WinsSummerYouthAdultSummerYouthAdultYouthLevel 4Level 5Level 61117522117202021 WinsSummerYouthAdultSummerYouthAdultYouthLevel 4Level 5Level 61316751919222022 WinsSummerYouthAdultSummerYouthAdultYouthLevel 4Level 5Level 61518103182324 Question Your task is to change the field according to the direction below. Then analyze and write a 2-page memo reporting on your findings. The memo should be based on the group you assigned to from the "All Teams PivotTable" tab.NB: I have already done everything in the excel,changed the field according to the direction , all you do is go to the “ All Teams PivotTable” tab and use that data to write the memo” Steps: 1) Change the filters (Adult, Youth, or summer) based on your assigned group. 2) Change the level (1 - 6) based on your assigned group. 3) Generate a new PivotTable and write your memo based on the data. ● Write a memo explaining where the overall data ● Discuss in detail how the data looks ● Make recommendations on what to do ● Place the chart in the memo ● Review PivotTable rubric for details. NB:YOU DONT NEED TO DO ANYTHING ON THE EXCEL OR DATA , I HAVE DONE ALL THE STEPS AND ALL , YOUR TASK Is TO WRITE THE MEMO BASED ON THE DATA IN "All Teams Pivot Table Tab".......... Please submit as a Word Doc .docx file. NOT a PDF..and no reference. please its a MEMO Read all this very carefully , you are using the excel file to answer this question. And the data you need in the excel file “ All Teams PivotTable”