Select a topic for which you can gather 50-80 data points for one quantitative variable. Data should be recent (within the past couple of years). (DO NOT USE THE SAMPLE DATA for your lab.) Sample topics:
- Inflation rate, interest rate, personal savings, price-to-rent ratio, etc.
(Trading Economics is a great website for business-oriented data), - Workplace injuries, productivity, unemployment, etc. (US Bureau of Labor Statistics, Data Tools, is a great website for business-oriented data.)
- State Immigration Data Sheets (Office of Homeland Security),
- Poverty by state (Americanprogress.org),
- Gasoline prices by state (AAA),
- MLB, NBA, NFL, ESPN, and similar websites provide player data.
2. Place data in an Excel spreadsheet. Include one dataset for one variable for this project.
- Clearly label your data.
- Font and font size should be consistent throughout your table.
- Select “All Borders” for your data. (Home, Font, Borders Box, All Borders).
- Rename the sheet that contains your data “Data.”
- Provide a citation for your data source on your Datasheet in cell D2.
(Website, Year, Title, Weblink). - Create Descriptive Statistics using Excel.