1) Save a copy of the dataset as an Excel file (it is currently a .csv file) (attached)
2) Use the RAND() function in Excel to generate a simple random sample of 500 records (rows)
3) Use pivot tables in Excel to create a Frequency Distribution Table for ONLY the by ONE of the following – your choice (Year, Make, or County)
4) Use pivot charts to generate a bar chart from your pivot table
5) Using APA version 7 formatting, paste your Frequency Distribution Table in your post
6) Using APA version 7 formatting, paste your chart to your post
on the last part write – a) What ONE thing did you learn interesting about the variable from examining the table or chart?