A political poll immediately prior to a local election revealed thefollowing result.
​ | Female Voters | Male voters | Vote Democrat | 1200 | 1150 | Vote Republican | 2100 | 950 | Total |     n1 = 3300 | n2 = 2100 |
​ ​ |
Please show Excel work:
A. Use α = .05. Test to determine whether the proportions offemale and male voters who intend to vote for the Democratcandidate differ? Report the test statistic and the p-value.
B. Provide a 99% confidence interval for the difference in theproportion of female and male voters who intend to vote for theDemocrat candidate
