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

Please do this in excel if possible Problem 3. In Assignment 1,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!