Question 1

Create a Frequency Distribution Table using the data from the Car Color column of the main spreadsheet.

Here's an example of what your table should look like:
A	B	
Car Color	Freq	
blue	2	
red	5	
green	3	

 	 	

You should have many more colors and the frequencies should be based on what you count (for each color) from the main spreadsheet that I provided.

Once completed, highlight all of the cells of your completed frequency table, by clicking and dragging your pointer through all of the cells.

Click on Insert, and then Recommended Charts.

Click to select the Pie Chart.

Click on the pie slices, right click Add Data Labels, and select Add Data Callouts. Add an appropriate title.

Question 2

According to the pie chart that you just created, what is the most common color of car for students who participated in this survey?  Explain how you arrived at your answer. 

Question 3 

Create a histogram for the variable Height:

Use the strategies in the text to create a frequency distribution table of the heights using the categories (or classes) of 60-64, 65-69, 70-74, and 75-79.  (Tip:  It may be helpful to sort the data based on the Height variable first.)  Don't forget that you should have a column for "classes" and a column for "frequencies."
  
Fill in the frequencies of each class.

After the frequency table is complete, select the frequency table, and click on Insert, then Recommended Charts and choose the column chart shown and click OK.  

Right-click on one of the bars and select Format Data Series.  In the pop-up box, change the Gap Width to 0.  

Add an appropriate title and axis label. 

Question 4 

1 What is the shape of the histogram that you created in the previous part? 

2. What does this shape suggest the mean in relation to the median and mode of this distribution?
  
3. What are two other conclusions that you can draw by reading this histogram?  (Write your conclusions within the context of the data being presented
Question 5 

Calculate descriptive statistics for the variable Height by Gender:
Create the following table in a Word Doc:
 	Mean	Standard Deviation	
Females	 	 	
Males	 	 	
This table will be used to record your results from the following steps below.
•	Now go into the given spreadsheet for the course, and select on Insert and then Pivot Table.
•	Select in the top box and select all the data (including labels) from Height through Gender. Also, select on the new worksheet and then OK.
•	On the right of the new sheet, select on Height and Gender, making sure that Gender is in the Rows box and Height is in the Values box. Drag and drop if you need to.
•	Select on the down arrow next to Height in the Values box and select Value Field Settings. In the pop-up box, select Average, then OK.
•	Type in those averages into the table that you created in Word.
•	Then, select on the down arrow next to Height in the Values box again and select Value Field Settings. In the pop-up box, select on StdDev this time, then select OK.
•	Type the standard deviations into your table in Word.

Question 6 

Compare the mean for the heights of males to the mean for the heights of females. Comparing these values, explain what can be concluded based on the numbers. In other words, what do these numbers tell you about the heights for males as compared to females?

 Compare the standard deviation for the heights of males to the standard deviation for the heights of females in the class. Comparing these values, explain what can be concluded based on the numbers.
(Please write your answers in complete sentences.)