1) The first assignment is ”analysing college success scenario”. You have to choose only one role to to the task.
2) The second assignment is hypothesis testing assignment. You will see the direction what to do on the screenshots.
I choose variable PCT_DIABETES_ADULTS10
I uploaded the excel file for reference. Do not use the actual mean calculated in the file for the state. Suppose that PCT_DIABETES_ADULTS10 equals to 10% and then make a claim and provide an alternative hypothesis.
All the directions how to do the task you find on the screenshots.
Let me know if you have any questions.