(solution) I need the answers to the following questions based on the

(solution) I need the answers to the following questions based on the

I need the answers to the following questions based on the information given. This is for a Quantitative Methods in Business class so all work needs to be shown on an Excel Spreadsheet (including the use of formulas).

A market research study is being conducted to determine if a product modification will be well received by the public. A total of 1,000 consumers are questioned regarding this product.

The table below provides information regarding this sample.

Positive

Reaction

Neutral

Reaction

Negative

Reaction

Male

240

60

100

Female

260

220

120

a) What is the probability that a randomly selected male would find this change unfavorable (negative)?

b) What is the probability that a randomly selected person would be a female who had a positive reaction?

c) If it is known that a person had a negative reaction to the study, what is the probability that the person is male?