conditional probability with random variables

I would like to have the response to this question in excel format so that I can see the formulas used.
The last question ask the probability that an applicant who is rejected by the polygraph is actually trustworthy. I do not quite understand this question please help/explain.

See attached file for full problem.

Don't use plagiarized sources. Get Your Custom Essay on
conditional probability with random variables
From $8/Page
Order Essay

Lie detectors are controversial instruments barred from use as evidence in many courts. Nonetheless, many employers use lie detector screening as part of their hiring process in the hope that they can avoid hiring people who might be dishonest. There has been some research, but no agreement, about the reliability of polygraph tests. Based on this research, suppose that a polygraph can detect 61% of lies, but incorrectly identifies 17% of true statements as lies. A company believes that 94% of its job applicants are trustworthy. The 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 polygraph identifies some of those answers as lies making the person ineligible for a job.

0.17 Polygraph says “Lie”
0.94 Trustworthy
0.83 Polygraph says “Doesn’t Lie”

0.61 Polygraph says “Lie”
0.06 Dishonest
0.39 Polygraph says “Doesn’t Lie”

c. What’s a probability that a job applicant who is rejected by the polygraph was actually trustworthy?

Solution Preview
Probability (rejected & trustworthy) = 0.94*0.17
Probability (rejected & dishonest) = …

Solution Summary
This solution provides calculations for estimations of conditional probability.

To continue with the answer check on

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 20% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Top Writers 4Me
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 10k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Healthcare Writing & Communications
Thank you so much for all of your hard work! Appreciate it all!
Customer 452483, November 14th, 2021
Very clear, and complete information presented. I, thank you for all of your hard work, appreciate it!
Customer 452483, August 9th, 2021
Customer 452483, July 5th, 2021
English 101
Amazing thank you!
Customer 452615, August 1st, 2022
Thank you for all of your help and hard work, truly appreciate you guys always being there with my hectic schedule. Thank you again!
Customer 452483, September 20th, 2021
Perfect! Thank you guys for all of your great help! :)
Customer 452483, August 23rd, 2021
Thank you so much for all of your hard work & help! It’s perfect! Appreciate it!!
Customer 452483, September 11th, 2021
Thank you so much for all of your hard work, appreciate every bit of it!
Customer 452483, September 6th, 2021
PERFECT! Thanks a million, you're all awesome!!!!
Customer 452483, July 7th, 2021
Good job!! Thank you!!!
Customer 452487, September 9th, 2021
Thank you so much!
Customer 452483, July 26th, 2021
Thank you for your help
Customer 452555, February 16th, 2022
Customer reviews in total
Current satisfaction rate
2 pages
Average paper length
Customers referred by a friend
20% OFF your first order
Use a coupon TOP20 and enjoy expert help with any task at the most affordable price.
Claim my 20% OFF Order in Chat
Open chat
Chat with us Live Here
Get in Touch with Our Live Chat Agents via WhatsApp on +1(346) 416-0954. Get Unlimited Access to Answers on Any Queries With Your Paper.