Module 10 Assignment: Randomization (50 Points) Instructions: Upload your Excel workbook by the due date on Canvas. Part 1: Assign Subjects to Groups (10 points) First, access the data for this assignment by opening the Excel file, where you will find a datasheet. Using Excel assign 13 subjects to the control group and 13 subjects to the intervention group following the steps below. See the attached video on how to do this. 1. Use =rand() in Excel in column E to create a random number for each person. 2. Copy and paste as values the numbers from =rand(). 3. Sort the values ascending. Make sure you sort all the data, not just random number. 4. Assign the first 13 subjects to the control group and the last 13 subjects to the intervention group. 5. Label this sheet Part 1. Part 2: Compare Means (10 points) Tests whether the mean glucose differs for the intervention and control groups using and independent samples t test. 1. Use the data analysis toolpak to do an independent samples t test (assume equal variances), comparing the mean blood glucose for the control and intervention groups. 2. Highlight the means and variance for each group. 3. Highlight the p-value. 4. Label the sheet with the output Part 2. Part 3: Report Results (30 points) Write 2-3 paragraphs in Essay format to address the questions below. Use a text box on the last sheet of your Excel workbook. Title the sheet Part 3. 1. Are the means for the two groups significantly different? a. How do you know? 2. Did your randomization procedure "work" to produce two equivalent groups? a. Why or why not? 3. Explain why it is important to have good randomization before introducing an intervention when conducting a randomized control trial. a. What is the role of randomization? b. How would "bad" randomization threaten your findings? c. What could you do if you have "bad" randomization?