Go to your welcome message, from your Instructor, in which you were assigned AND THE NUMBER IS 65 Watch the videos to ensure you know how to properly install the tool pack in Excel and how to create a data set. Download the original Excel file titled “BODY DATA Download BODY DATA.” Start a new Excel file. Copy and paste all column names from the original document. Using the random number provided by your Instructor, go to that numbered row of the “BODY DATA” file. Copy and paste the number of rows of data equal to your number into your new Excel file, including all columns. Save this data set as ST3001Data_firstinitial_lastname (e.g., STData_J_Smith). Create two new columns. Label one column “BMI Smokers” and the other column “BMI Nonsmokers.” 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.
Instruction
Explain the process you used to create your data set so that another individual could recreate the same exact data set. Choose one variable that is qualitative, and then identify that variable. Explain why it is qualitative. Choose one variable that is quantitative, and then identify that variable. Explain why it is quantitative. For the two columns you previously chose, identify the level of measure for each column. Justify your reasoning. Verify that you have been able to install the data analysis tool pack in Excel. Do this by either stating you were able to install the tool pack or showing a screenshot with the data analysis tool pack. Note: Keep in mind this process is being done to ensure that you are ready for next week’s project. Falsely verifying that you have installed the data pack will only lead to issues in Week 2. Attach your data set to the Discussion post.