Can someone complete this assignment??
How have the Olympic games athletes changed over time? Introduction Business Context. You work for a company that specializes in analyzing data for a variety of clients in the sports industry. Some questions that you frequently encounter include determining if a new player is promising enough to invest money in their development, which teams are the most likely to win certain matches, what events will be the most attractive to advertisers, etc. Business Problem. As part of one of your projects, you have been asked to perform an exploratory data analysis of historical data to detect patterns in the provenance, physical profile, and other characteristics of the athletes who compete in the Olympic games. The conclusions of your analysis will help the rest of the team prepare a report for a new client who helps sports gear manufacturers find advertising opportunities. Analytical Context. You have scraped a dataset from the Internet, which contains data for all the Olympic games from Norway 1994 to Rio 2016. It comprises data for 46,533 individual athletes and has 13 columns for each one of them. There are 68,848 rows instead of 46,533 rows in the olympics_data worksheet because some athletes have won multiple medals: ID: A unique number assigned to each athlete Name: The athlete’s name Sex: The athlete’s sex Age: The athlete’s age at the moment of the games Height: The athlete’s height in centimeters Weight: The athlete’s weight in kilograms Team: The athlete’s team (country) Year: The year Season: The season City: The host city Sport: The sport the athlete competed in Medal: The medal that the athlete won, if any (can be Gold, Silver, Bronze, or NA) Won medal?: 1 if the athlete won a medal, 0 otherwise The dataset can be downloaded from this link. Note: Please write all your formulas in the calculations worksheet unless explicitly asked to do it in another sheet, clearly indicating the exercise they belong to. You will need to submit the Excel file along with this notebook. Height, weight, and age Exercise 1 1.1 Calculate the average height, weight, and age of athletes in Rio 2016 across all sports. Answer. 1.2 Repeat Exercise 1.1 but for Sydney 2000. Have the averages changed noticeably? Answer. Geographic representation Exercise 2 This is a chart of the number of countries that participated in the games from 1998 to 2016. What can you conclude from it? Hint: Keep in mind that Summer and Winter games are not held in the same year. In the Winter games, the number of teams is typically lower than in the Summer games. Answer. Exercise 3 These are the top 10 countries by number of athletes sent for all the games between 1998 and 2016. What patterns can you spot? Answer. Athletes by gender These pie charts show the number of athletes by gender in Sydney 2000 and Rio 2016: Exercise 4 4.1 We need to put labels on these pie charts. How many male and female athletes were there in Rio 2016 and Sydney 2000? Hint: You can use the COUNTIF() function to solve this exercise. This function works very similarly to the COUNTA() function, with the difference that it only counts those cells that meet a certain condition. Feel free to look this function up on the Internet! Answer. 4.2 Use Excel to calculate the ratio of