Your task is to change the field according to the direction below. Then analyze and write a 2-page...

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.

Steps:

1) Change the filters (Adult, Youth, or summer) based on your assigned group.

2) Change the level XXXXXXXXXXbased 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

npex197bfatimatdauda2-memo-ndqni4pq.xlsx question-rkbbwkfr-ocwskev2.pdf

Khushboo · Accepted Answer

Memo
From: Fatimat Dauda
To:
Subject: Memo for detailed analysis of wins for year 2020, 2021 and 2022
The selected group is Youth and level is 3 based on assigned group. The selected data can be understood well from below chart:
In the data, there are locations at which matches are happening. The matches are playing at 6 levels and there are 3 types of leagues. In the year 2020, the total matches happened 185, in year 2021, the total matches happened 186 and in the year 2022, the total matches happened 217. In our group, Youth 3 group the total matches are 105, 93, 108 in year 2020, 2021 and 2022 respectively. The win charts of the entity can be well understood from above chart. 
The win ratio of Youth group is highest at Cocoa Beach and wins ratio is lowest at Melbourne. The total number of wins at Titusville was 23 in year 2020 which has been reached to 21 and 32 respectively in year 2021 and 2022. In year 2020, Brevard Blue Wave is having highest number of wins i.e. 10 whereas Seaside Sea Serpents and Swamp Gators are having highest wins of 8 matches in year 2021 at Palm bay and Titusville. Further,

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...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment