The dataset that you will use (It is attached to this discussion thread) this week is a
Question:
The dataset that you will use (It is attached to this discussion thread) this week is a subset of the Electric Vehicle Population Data for Washington state. If you would like to examine the full dataset, you can find it here.
Directions:
Initial post (Due Thursday)
1) Save a copy of the dataset as an Excel file (it is currently a .csv file)
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 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
Response post (Due Saturday)
Examine either the Table or Chart (NOT BOTH only one) that the student has posted. Then answer the following:
a) What ONE thing did you learn interesting about the variable from examining the table or chart?
Basic Marketing Research
ISBN: 978-1133188544
8th edition
Authors: Tom J. Brown, Tracy A. Suter, Gilbert A. Churchill