\n I have this assignment due by Monday at 4pm, can someone help?\n <\/p>\n<\/div>\n
I have this assignment due by Monday at 4pm, can someone help?
\n How have the Olympic games athletes changed over time? Introduction Business Context.\u00a0You 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.\u00a0As part of one of your projects, you have been asked to perform an exploratory data analysis of historical data to\u00a0detect 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.\u00a0You 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\u00a0olympics_data\u00a0worksheet 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\u00a0this link. Note:\u00a0Please write all your formulas in the\u00a0calculations\u00a0worksheet 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:\u00a0Keep 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:\u00a0You can use the\u00a0COUNTIF()\u00a0function to solve this exercise. This function works very similarly to the\u00a0COUNTA()\u00a0function, 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\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"
I have this assignment due by Monday at 4pm, can someone help? I have this assignment due by Monday at 4pm, can someone help? How have the Olympic games athletes changed over time? Introduction Business Context.\u00a0You work for a company that specializes in analyzing data for a variety of clients in the sports industry. Some […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/285966"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=285966"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/285966\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=285966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=285966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=285966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}