Task 5 Based on your sample in assignment 1 answer the following questions by using Excel. (You should take screenshot of the used functions in Excel and then copy and paste your final answers). a. b. Summarize the users Continents by grouped frequency distribution table. Calculate relative frequency and percent frequency Represent the data by Bar diagram. (8 Marks) (8 Marks) (4 Marks) C. usage_minutes oty Lisamouth gender clicked ad Continent Female no South America Male yes Oceania Male no Unknown South Laurton Tumeri Male no Europe Anica Campbelistad West Ericaport Joshuamouth New Wilmouth North Derekville Female yes Female no Male yes Europe Europe Europe Africa Unknown Europe Unknown Asia Oceania Africa Africa Asia North America Unknown Unknown Europe Asia South Cynthashire Male yes South Alexeisborough Female yes Jordanshire yes Chrismouth Female yes Joneston Male yes Rogerburgh Female yes North Samantha Female yes Joneston Male no Mezaton Female yes West Josep Male no Andersonchester Female yes West GuyDury Female no Lake Beckyburgh Male yes Meyerchester Female no Brownview Female no Broceburgh Female no Port Eja Sandravie Male no Lake Dustin Female yes Pruittmouth Female ne Garciamouth Female yes South Corey Male no Johnstad Female ne Pamelamouth Male no East John Male no Mackenziemouth female no Port Jason yes Sanchezland Female Unknown Unknown North America Unknown Unknown Asia Oceania Unknown Oceania Unknown Africa Asia Europe Unknown Port Juan Female no Unknown Shanstad Female no North America JULICY UIT Johnstad Female no Oceania Pamelamouth Male no Unknown Male no Africa Asia East John Mackenziemouth Port Jason Sanchezland Port Juan Female no Male yes Female no Female no Female no Shawstad Europe Unknown Unknown North America Europe North America Europe Europe Male no Male yes Lopezmouth East Georgeside East Jessefort Meaganfort Rochabury Female yes Female no Female yes Asia North Katie Male yes Oceania Asia Africa Lake Michael Female no Lake Brian Female no East Christopherbury Female no Kimberlyhaven Female no Africa Unknown Hintonport Male yes South America Europe Brittanyborough Female yes