What is the excel formula to use to compute the answers ? Between =Rand or =IF A

Question

What is the excel formula to use to compute the answers ?

Between =Rand or =IF

A political campaign supporting a particular candidate conducted an exit poll of 125 voters to estimate the proportion of voters who cast a ballot in favor of its candidate. In Column B, create a dummy variable for the voters' responses, where 1 indicates a vote for the candidate and 0 indicates a vote against the candidate You must use a spreadsheet function to create the dummy variable. Your answer will be graded as incorrect if you manually enter the dummy variable data HOME INSERT DATA fx 1 Voter Response Dummy Variable 2 For 3 Against 4 Against 5 For 6 For 7 Against 8 Against 9 Against 10 Against 1 For 12 Against 13 Against 4 Against 15 For 16 Against 17 Against 18 For 19 Against 20 Against 21 For 22 For 23 24 Against 25 For nst RESET SAVE SUBMIT Attempts left: 1 Question 19 of 20

Explanation / Answer

the formula that should be used if "=If(A2=For, 1 , 0)" which means if the response in the second column is For, the output must be 1 else the output is 0.

"=Rand" is a function to get random numbers.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.