CREATING A DATA SET

**THIS DISCUSSION IS DIVIDE IN TWO PARTS –

 

1. MAIN DISCUSSION POST BY WEDNESDAY 5/31/2023 BEFORE 8:00 PM EST
2. TWO REPLIES BY FRIDAY 06/02/2023 BEFORE 8:00 PM EST

 

CREATING A DATA SET

You will create a data set that will become the basis of your assignments for the rest of the course.

To prepare:

Review the video of how to create a Data Set. See link below

https://www.youtube.com/watch?v=zzDETZNBHuM

 

Instructions:

1. You were assigned a random number greater than 50.My number is 54
2. The original Excel file titled “BODY DATA.” See attached excel document.
3. Start a new Excel file. Copy and paste all column names from the original document.
4. Using the random number provided by your Instructor,(54),go to that numbered row of the “BODY DATA” file.
5. Copy and paste the number of rows of data equal to your number into your new Excel file, including all columns.
6. Save this data set as
7. Create two new columns. Label one column “BMI Smokers” and the other column “BMI Nonsmokers.”
8. Sort the data by smoking status. Then, copy and paste all BMI data for smokers into the appropriate column. Do the same for the BMI data for nonsmokers.

Write a discussion post withthe following:

1. Explain the process you used to create your data set so that another individual could recreate the same exact data set.
2. Choose one variable that is qualitative, and then identify that variable. Explain why it is qualitative.
3. Choose one variable that is quantitative, and then identify that variable. Explain why it is quantitative.
4. For the two columns you previously chose, identify the level of measure for each column. Justify your reasoning.