The most important part of statistics is accurately and effectively communicating the results of a study. For this lab, you will be conducting a statistical analysis for data of your choosing.
Lab Procedure:
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)
All axes should be properly labeled.
See Canvas resources for examples of each type of chart.
Using Word, write a short report that introduces your data and utilizes the two best visual representations of your data.
Explain how your data is quantitative and at the ratio-level.
Discuss the descriiptive statistics that you found.
Explain your choice for which two visual representations best represent your data.
What conclusions can you draw about your data from the visual representations