Question: Please do this in excel if possible Problem 3. In Assignment 1, you considered the polling of a population of voters. Consider a population of
Please do this in excel if possible

Problem 3. In Assignment 1, you considered the polling of a population of voters. Consider a population of 1,000 registered votes (not 1 million, for this problem) 50% are women, and there is still a 28.5% chance that a women votes Candidate A. There is still a 26.5% chance that a man will vote for Candidate A. There are multiple ways to simulate (X, Y) jointly one can use RANDO to sample using the joint probability distribution, or one can use RANDBETWEENO to sample the population data directly. Create a simulation for 300 calls, using any valid method estimate the correlation between X and Y. Report this sample correlation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
