Solve the following:
Q: In a study of women and heart disease, the following sample results were obtained: Among 10,239 women with a low level of physical activity (less than 200 kcal/wk), there were 101 cases of heart disease. Among 9877 women with physical activity measured between 200 and 600 kcal/wk, there were 56 cases of heart disease (based on data from "Physical Activity and Coronary Heart Dis¬ease in Women" by Lee, Rexrode, et al., Journal of the American Medical Association, Vol. 285, No. 11). Use a 0.05 significance level to test the claim that the rate of heart disease is higher for women with he lower levels of physical activity. What does the conclusion suggest?
What test statistic is used for this type of problem? Can someone help me solve this using minitab or MS excel?