Answer the following question on excel

1. The following contingency table shows opinions about global warming (nonissue vs. serious concern) among registered voters, broken down by political party affiliation (Liberal, Conservative, and Independent). Opinions on Global Warming Nonissue Serious Concern Total Liberal 70 430 500 Political Party Conservative 260 240 500 Independent 100 100 200 Total 430 770 1200 a) What is the probability that a randomly selected registered voter who is a Conservative believes that global warming is a serious issue? b) What is the probability that a randomly selected registered voter is a Conservative given that he or she believes global warming is a serious issue? c) What is P(Serious Concern|Liberal)? 2. Suppose that a polygraph can detect 58% of lies, but incorrectly identifies 24% of true statements as lies. A company gives everyone a polygraph test, asking "Have you ever stolen anything from your place of work?" Naturally, all the applicants answer "No," but the company has evidence to suggest that 10% of the applicants are lying. When the polygraph indicates that the applicant is lying, that person is ineligible for a job. a) Draw the probability tree for these relationships b) What is the probability that a random job applicant is a dishonest worker who is cleared by the polygraph