Think of a topic or question that you’re interested in exploring further that ca

No Comments

Photo of author

By admin

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)

Leave a Comment