This assignment focuses on Creating Frequency Distribution. There is also an analysis of Car Color column. You should have many more colors and the frequencies should be based on what you count (for each color) from the main spreadsheet

Creating Frequency Distribution-Car Color column

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.

 Creating Frequency Distribution-Car Color column

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.  

Detailed Instructions

 |

Do you need Assignment help from intel-writers.us?

intel-writers.us is one of the best essay help websites on the internet

Kindly click the link below to order quality essays from qualified assignment help experts
We offer well written, referenced and plagiarism free papers .

Click here to request for this assignment help