Using Excel to make Graphs
Open the data set “Freshman 15” from our course on D2L. It is a posted Excel file in our course content under the Data Sets section. The data set contains the weight and
body mass index for 67 freshman during the months of September and April, along with whether they are a male or female. Please create the following 3 graphs on Excel and answer the corresponding questions and submit your document in the Assignments folder on D2L. Thus, you should be submitting an excel file, be sure it includes the 3 graphs and the answers to the questions below. 1.
Construct a histogram for the WT April on Excel using 10 classes (10 bars). What is the shape of the histogram?
2.
Construct a scatterplot of the WT April and the BMI April. Does there appear to be a relationship
between these two variables?
3.
Construct a Box and Whisker Plot of the WT April. Are there any outliers?
Important Excel Instructions Gone Over in Earlier Classes:
Histograms can be generated using
Excel
. Open the raw data set up and highlight the data. Go to the insert option, and chose the graph with all the blue bars. This will generate a histogram. To change the number of classes and use a specific class width, right click on the x axis and select the Format Axis option. This pulls up a menu on the right side of your screen for you to fill in the Bins Width with a specific class width or the number of bins with the desired number of classes. Excel automatically starts the first class with the minimum data value in the data set.
The following other graphs
can be made on Excel by going to the Insert option and then selecting the appropriate graph from the menu. Scatter Plot = Scatter Chart In Excel We can construct boxplots in Excel
by going to the Insert option, clicking the “See All Charts” button, then clicking on the All Charts tab, and choosing the Box and Whisker plot option.
