Part 2 Data Analysis

The following should be based on the data set you created from the larger BODY DATA data set using the instructions provided.

make Graphical Displays of Data

Replace this text with your Excel output created using the following instructions:

Using the column labeled Smoker (not sorted by smoking status), create an appropriate graphical display to clearly show the breakdown of smokers and nonsmokers in your data set. Be sure to label your graph appropriately.

Copy and paste your graph from Excel here. Write a one-sentence interpretation of what the graph display. Create a histogram for the column labeled BMI (not broken down by smoking status). Use a bin width of 2. Start the bins at your minimum data point as appropriate for your data set. Be sure to label your graph appropriately. Write a one-sentence interpretation of what the graph display. Create two modified box plots for BMI, one for smokers one for nonsmokers. Be sure to label your graph appropriately. Copy and paste your graph from excel here. Write a one-sentence interpretation of what the graph display.

Descriptive statistics

Replace this text with your Excel output created using the following instructions: Use the data analysis tool pack to create two tables of descriptive statistics, one for smokers and one for nonsmokers using the columns created in step 7 in the preparation section. Copy and paste those statistics here.

Comparing data

Replace this text with your response to the following: Use these statistics to answer the following questions comparing smokers to nonsmokers. Be sure to provide values from your Excel output to support your reasoning.

Which group has an BMI that is typically higher? Be sure to write at least one sentence justifying your reasoning including values from the excel output. Which group has greater variation in their BMI? Be sure to write at least one sentence justifying your reasoning including values from the excel output. Do you suspect any outliers are present in the BMI for each group? Be sure to justify your reasoning.