30 POINTS BRAINLIES PLEASE WORKOUT QUESTIONS a b & c
PHOTO OF GRAPH ATTACHED BELOW

a) Calculate the median number of medals for each medal type, stating the formula you would use for determining the median for the gold medals.

b) Calculate the mean number of medals for each of the 3 medal types, stating the formula you would use for determining the mean for the bronze medals.

c) Calculate the standard deviation of the total medals awarded to each country
(column F) using the formula below.
Show all the steps ( show your work ).

USE the STDEV. P function to cross-check your final answer.

Step-by-step explanation:

Implement best practices in data table formatting

Identify and address common formatting mistakes

Understand approaches for handling dates in spreadsheets

Utilise basic quality control features and data manipulation practices

Effectively export data from spreadsheet programs

Spreadsheets are good for data entry. Therefore we have a lot of data in spreadsheets. Much of your time as a researcher will be spent in this ‘data wrangling’ stage. It’s not the most fun, but it’s necessary. We’ll teach you how to think about data organization and some practices for more effective data wrangling.

23

step-by-step explanation: