Think of a topic or question that you’re interested in exploring further that can be studied through data.
It is recommended, but not required, that you pick a topic in your field of study.
Find a source for your data (or use one of the suggested data source sites listed below).
The data must be quantitative and ratio-level (See Chapter 1, section 2).
You will need between 30 – 60 data values.
You will need to provide a direct link to the source of the data.
Your data must be less than 2 years old.
Using Excel, perform the following statistical analyses:
Calculate Descriiptive Statistics using Data Analysis (See Chapter 3, page 102) – Mean, Median, Mode, Sample Standard Deviation, Variance, 5-number Summary,
Generate a bar chart (See Chapter 2, pages 38-39)
Generate a pie chart (See Chapter 2, page 40-43) – If possible, break your data into categories and provide counts for each category. Then use this to generate a pie chart.
Generate a histogram (See Chapter 2, pages 56-59)
Generate a line graph (See Chapter 2, pages 71-72)
Generate a box and whisker (Chapter 3, pages 143-147)
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.