Statistics- Electric Vehicle Population Data for Washington state.

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?

NEED A CUSTOMIZED PAPER ON THE ABOVE DETAILS?

Submit your order now!