[Answered]: As a DNP leader at your institution, you have been…

As a DNP leader at your institution, you have been asked to make decisions about prescription protocols related to patients with diabetes. You have also been tasked with helping the pharmacy staff decide whether to stock Metformin. You need to determine how many patients among the 50 (aged 45-65) have diabetes. For those with diabetes, determine whether Metformin decreases their fasting blood sugar (FBS). To continue your decision making, you are going to examine the data in more detail. Using the Testing Significance Data File (XLSX) , complete the following: Create a frequency distribution for ethnicity and another one for education. Identify which data are suitable for analysis using chi-square, t and F tests. Calculate the average glucose 1 for males and females separately. Compute the average of glucose 1 and 2 for each participant. Using a t-test, compare FBS 1 and FBS 2 for all participants. Run a correlation between weight and BMI.