I have this assignment due by Monday at 4pm, can someone help?

Our papers are 100% unique and written following academic standards and provided requirements. Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Rely on us and be on schedule! With our help, you'll never have to worry about deadlines again. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

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. 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 

Writerbay.net

We offer the best essay writing services to students who value great quality at a fair price. Let us exceed your expectations if you need help with this or a different assignment. Get your paper completed by a writing expert today. Nice to meet you! Want 15% OFF your first order? Use Promo Code: FIRST15. Place your order in a few easy steps. It will take you less than 5 minutes. Click one of the buttons below.


Order a Similar Paper Order a Different Paper