# Q7 Car Cruising

13. Dig the Data Line Up

## Introduction

### Steps

1. Collaborating on data collection: work with one or two partners (or as a class) to collect the information from the parking lot. Share the data collected with the entire class. You will work in smaller groups to enter the data into the spreadsheet provided in Step 2.

Print this form to collect your information from the parking lot.

2. Open the Car Data Spreadsheet .

At the bottom of our sample, notice the tabs that say color, models, and month. Be sure you’re on the correct tab when entering your data.

3. Entering the data: begin by filling in the color of the cars on the first sheet (use the information you gathered in the parking lot). Continue by filling in the information for the model and month.

4. Preparing to analyze the data:

Car Color: Click on the color tab. You will be totaling the number of cars in column B, figuring out the % of each color in column C, and then comparing your results to the survey data collected by RPG Industries (column D) by creating a bar chart of your results (from columns A, C, and D).

Open this pdf document to follow the steps.

Model: You will be comparing your sample to the best selling cars in the U.S. in 2012. You will create a pie chart showing the car models from your data.

Open this pdf document to follow the steps.

License Plate Month: You will create a chart of your choice to best represent this data.

10. Create a screenshot of each of the spreadsheet pages and graphs. Insert or paste these into a word processing document or your portfolio to submit to your teacher.

• What is the most popular color of car in the lot?
• Which is the most frequent birthday month? What are the top three models of cars in the lot?
• Which type of graph best represents each of the sets of data?
• Why did you choose or reject each type of graph?

12. Check with your teacher on how you should submit this work.

## Completing this Quest

Check off this Quest on the 21t4s roadmap

Go to Quest 8 Whiskers

Websites/Apps