- Go to your welcome message from your SME in which you were assigned a random number greater than 50. (My # assigned is 63)
- Download the original Excel file titled BODY DATA. (attached is the exel file).
- Start a new Excel file. Copy/paste all column names from the original document.
- Using the random number provided from your SME, go to that row of the BODY DATA file. (Again my random # is 63 that was assigned)
- Copy and paste the number of rows of data equal to your number, including all columns, into your new Excel file.
- Save this data set as STData_firstinitial_lastname (e.g., STData_J_Smith).
- Create two new columns: one labeled BMI Smokers and one labeled BMI Nonsmokers.
- Sort the data by smoking status and copy paste all BMI data for smokers into the appropriate column and all BMI data for nonsmokers in the appropriate column.
The Creating a data set video will walk you through the process of making your own data set.
Data set adapted from:
Triola, M. F. (2022). Elementary statistics using Excel (7th ed.). Boston, MA: Pearson.
- Appendix B, “Data Sets,” Data Set 1: Body Data (pg. 796)
To submit
Save the data set as STData_J_Hinson.
Creating graphical display of data:
Then Your newly created data set will be used to compare the BMI of smokers to non-smokers. Create the following graphs in Excel:
1.
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.
2.
Copy
and paste your graph from Excel here. Write a one-sentence interpretation of
what the graph display.
3.
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. Write a one-sentence interpretation of what the graph display.
4.
Create
two modified box plots for BMI, one for smokers one for nonsmokers. Write a
one-sentence interpretation of what the graph display.
Descriptive statistics
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 portion.
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.