Problem 1: On this sheet, create a column graph (chart) that indicates the average Baseline IPSS for participants in each of the three age groups (Age Group 1=37-49; Group 2=50-64; Group 3=65 and above). Include an appropriate title at the top of the graph and label the columns or create a legend that indicates the age groups in the chart.
Problem 2: Place your answer in the blue box to the right (don't put the formula in the box). What is the standard deviation of the IPSS change for participants in age group 3?
Problem 3: Place your answer in the blue box to the right. What is the 95% confidence interval of the mean IPSS change for participants in age group 3? State your answer in the same format as this hypothetical answer: 14 +/- 2.47 points.
For Questions 4-7: Calculate the IPSS change for all participants. Sort the dataset by race. Run the appropriate t-test to determine if the 6-month IPSS is significantly less than the baseline IPSS for participants in racial group 3.
Question 4: Was a two-sample t-test or a paired t-test used? Why?
Question 5: How many tails were used?
Question 6: What was the p-value you used for interpretation?
Question 7: What is the interpretation of your results? Was the 6-month IPSS significantly less than the baseline IPSS for participants in racial group 3? Use alpha=0.05 for the interpretation. Justify your answer.