Exercise 1 [10 points] As the output of this exercise, you are required to submit your code and its output under a section in your markdown le. The data is created by Benedikt Claus. It's about Mario Kart World Records and contains world records for the classic racing game on the Nintendo 64. The records are saved in the records . csv le and contain the following variables: variable class description track character Track name type factor Single or three lap record shortcut factor Shortcut or non-shortcut record player character Player's name system_played character Used system (NTSC or PAL) date date World record date time_period period Time as 'hms' period time double Time in seconds record_duration double Record duration in days This Video talks about the history of Mario Kart 64 World Records in greater detail. Despite it's rst release back in 1996, it is still actively played by many and latest world records was achieved in Feb 2021 when the dataset was created in May 2021. The game consists of 16 individual tracks, and world records can be achieved for the fastest single lap or the fastest completed race (for three laps). Also, through the years, players discovered shortcuts in many of the tracks. Fortunately, shortcut and non-shortcut world records are listed separately. time Plot 1 117.5 120.0 - 122.5 - 115.0- 90.0- 92.5 95.0- 37.5 - 128 - 136 132 - 124- back to NTSC-times 2000 - 2000 - 2000 - 2000 - 2005 2005 - 2005 - 2005 - 2010- Sherbet Land Mario Raceway 2010 - Frappe Snowland 2010 - Banshee Boardwalk 2010 - data wrangling. Each plot is worth 5 marks. 2015 - 2015 - 2015 - 2015- 2020 - 2020 - 2020 - NONONO UIOUTOUTO WWWWP 2000 - 2000 - 2000 - 2000 2005 - 2005 2005 - 2005 Toad's Turnpike 2010 - Moo Moo Farm Kalimari Desert 2010 - 2010 - 2010 Bowser's Castle 2015 - 2015 - 2015 - How the three lap, with no shortcut world record develop over time little slower at 25 frames per second. All times in this dataset are PAL-times, but they can be converted Furthermore, the Nintendo 64 was released for NTSC- and PAL-systems. On PAL-systems, the game runs a For this question, you have to reproduce the following two visualisations. You may also have to perform some 2015- 2020 - 2020 2020 - date NNNN! OUIOUIO GOUTOUT 102 96 120 - 98 - 100 - 125 - 2000 - 2000 - 2000 - 2000 - 2005 . 2005 - 2005 - 2005 - Wario Stadium 2010 - 2010 - Koopa Troopa Beach Rainbow Road 2010 - 2010 - Choco Mountain 2015 - 2015 - 2015 - 2015 - 2020 2020- 2020 - 2020 - 105 185- 180 - 125 - 175 - 130- 140 - 120 - 150 - 2000 - 2000 2000 - 2000 - 2005 - 2005 - 2005 - 2005 - 2010 Yoshi Valley 2010 - Royal Raceway Luigi Raceway 2010 - D.K.'s Jungle Parkway 2010- 2015 - 2015- 2015 2015- 2020 2020 2020 - 2020 -Plot 2 How the WR for Rainbow Road develop overtime With shortcuts, it is quicker to finish a 3 lap race than completing a single lap! 300 - Race Single Lap with no shortcut a: E Single Lap with shortcut 200 - Three Lap with no shortcut Three Lap with shortcut 100 - 2000 2005 2010 2015 2020 date Hint: o All plots here are created with chunk options of fig.width=7, fig.height=5