Watch the instructional video attached here Video before you start this problem.
You may also want to download the attached step by step document attached here DeathsMedian.docx
Download the Excel sheet linked here, deaths.xlsx
Give all answers to two decimal places.
1) What is the median mortality rate for just Europe?
2) What is the median mortality rate for just Males?
Make a Pivot Table and Chart and Add Measure "Median" as shown in the video to answer the following questions.
If you are using the web version of Excel, you will have to filter your data then copy and paste special the data into the raw data sheet of the ESP4 workbook.
3) What is the median mortality rate for European Males?
4) What is the median mortality rate for Western Pacific Females?
5) What is the median mortality rate for African Males for just the year 2000? Hint: You will need to filter your chart by year.
- Question Help:
- Written Example