Categories
Writers Solution

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?

Can someone complete this assignment?? 1

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?

Can someone complete this assignment?? 2
Can someone complete this assignment?? 3
Can someone complete this assignment?? 4
Can someone complete this assignment?? 5
Can someone complete this assignment?? 6
Can someone complete this assignment?? 7
Can someone complete this assignment?? 8
Can someone complete this assignment?? 9
Can someone complete this assignment?? 10
Can someone complete this assignment?? 11

Answer.

Athletes by gender

These pie charts show the number of athletes by gender in Sydney 2000 and Rio 2016:

Can someone complete this assignment?? 12
Can someone complete this assignment?? 13

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 

Assignment Status: Solved By Our Experts.

WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU

WE OFFER THE BEST PAPER WRITING SERVICES on How have the Olympic games athletes changed over time?

USA, AUS, CA & UK PhD Writers

By admin

Academic tutoring services from the best essay writing company

Leave a Reply

Your email address will not be published. Required fields are marked *