Mini Project – Data and Graphing | Complete Solution

Mini Project – Data and Graphing                Name_____________________________________________
For this worksheet you will get practice using Minitab. You will then be asked to answer some questions and/or analyze graphs and output.  You will also get practice copying and pasting from Minitab into this word document.  To earn credit you will need to complete this document, save it as a Word Document, and submit it as an attachment before the due date.  Point values for each part are given in brackets. This worksheet is based on the Student Survey Data Minitab file that is in Blackboard under Course Info and Docs.

Example:  Suppose I wanted to create a Dotplot of the distance in miles the students are from BCC.  I would go to graph, and select Dotplot.  The screenshot is shown below. (note:  To take a screenshot, click control and print screen.  You can then paste it into this Word document!)
 

Clicking Dotplot opens a new window where I can select a simple Dotplot, click ok, and then select my variable which is miles from BCC.  Shown below is what I am seeing.  I got the Miles from BCC to appear in the window by first clicking into the window and then double clicking the displayed variable of Miles to BCC that appeared in the left section.  If we then click, ok, we will get the Minitab default Dotplot.  Notice there is an option to first click labels.  This would let me specify things like title and other labels.  
 

This is the resulting graph I obtained:
 

I was able to create the graph in Minitab.  I then put my cursor in the graph and right clicked.  I saved the graph and then simply pasted it into the Word document.
If I had wanted to edit the title I should have done that in Minitab first. Once it is pasted into Word you lose the Minitab edits!  In Minitab you point to a label and right click it.  Choose edit and rename it!  Not too bad!
Complete the following, save your finished document as a Word Document and submit it on Blackboard.

1)    Create a simple histogram in Minitab for the variable, Odometer.  Rename the horizontal axis, MILES , and give the graph the title, “Odometer Readings”.  

a.    Copy the graph and paste it here, between parts a and b.  Adjust the size so that it is large enough to be clear but small enough so that parts b and c still fit on this page.  [2]

b.    What did Minitab use for the length of the class intervals?  How can you tell?   [2]

c.     Without looking at the actual odometer readings from the Minitab worksheet, how could you use the Histogram to determine in which class interval the Median falls?   In which interval does it fall?  [2]

2)    Create a Pie Chart for the variable High School.  Since there are many different schools listed it would be a good idea to have each slice labeled with the category name and the percentage.  Get Minitab to do this for you and paste the Pie Chart below.  (you will need to figure out the specific options required)     [2]

3)    Have Minitab calculate the following descriptive statistics for the variables Age and Siblings:
Mean, Median, Standard Deviation, and Coefficient of Variation. Others may be displayed too but be sure all of these are displayed.  To do it in Minitab, select Stats then Basic Stats and then Display Descriptive Stats.  Click into the variables window and then double click Age and then double click Siblings.  At the bottom, click on Statistics and you can control what gets displayed.  Be sure all the statistics mentioned above are selected.

a.    Copy the Minitab output.  You can find this in the session window, just above the worksheet with the data values.  Paste the output here:    [2]

b.    Which measure of dispersion/variability is the most appropriate to compare to determine which of these 2 variables shows the higher relative dispersion?  Which variable shows the higher relative dispersion?  [2]

4)    Have Minitab create a boxplot for the variable Height split up for males and females separately.  To do this choose a “one Y boxplot with groups”.  Select height as the graph variable and select sex in the second entry window as the variable to split up the data by.  Copy the graph below [2 pts] and use it to answer the questions that follow.

a)    What is the immediate conclusion you can draw for the heights of males versus females?  [1]

b)    Which boxplot, male heights or female heights, shows a distribution that seems to be slightly skewed-left or left-skewed?  How can this be determined by looking at the boxplot? [1]

5)    Create a fitted line plot (Stat-Regression-Fitted Line Plot) for the variables x = age of vehicle and y = odometer reading in miles.  Be careful, Minitab asks for the y variable first.  

a)    Copy and paste the fitted line plot below and be sure it is large enough to clearly view. [2]

b)    Interpret the slope of the regression line – be sure to include the actual value of the slope and indicate what it specifically means in terms of these variables and units. [2]