Please use Excel to disintegrate the formula that needs to be solved

G H E F In Seattle, 68 of 203 adults surveyed said they had a college degree. In Minneapolis, 99 of 247 adults surveyed said they had a college degree. Based on this sample data, can we conclude that the proportion with a college degree is different between the two cities? First create a 95% confidence interval, and then perform the hypothesis test. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Seattle Minneapolis degree? 68 99 n 203 0.3350 0.4008 A. point estimate of the difference between proportions (give a positive answer) 247 p bar For the 95% confidence interval: 8. critical value for 95% confidence C. standard error D. margin of error E. lower value of confidence interval F. upper value of confidence interval For the hypothesis test: G. test statistic (Hint: you've already calculated the standard error above) H. p-value 1. Can you conclude that the proportions are different? (Answer Yes or No) G H E F In Seattle, 68 of 203 adults surveyed said they had a college degree. In Minneapolis, 99 of 247 adults surveyed said they had a college degree. Based on this sample data, can we conclude that the proportion with a college degree is different between the two cities? First create a 95% confidence interval, and then perform the hypothesis test. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Seattle Minneapolis degree? 68 99 n 203 0.3350 0.4008 A. point estimate of the difference between proportions (give a positive answer) 247 p bar For the 95% confidence interval: 8. critical value for 95% confidence C. standard error D. margin of error E. lower value of confidence interval F. upper value of confidence interval For the hypothesis test: G. test statistic (Hint: you've already calculated the standard error above) H. p-value 1. Can you conclude that the proportions are different? (Answer Yes or No)