Question: How do I solve this with Excel Functions/Formulas? I have calculated the answers already, but I would like to know how to solve these using
How do I solve this with Excel Functions/Formulas?
I have calculated the answers already, but I would like to know how to solve these using Excel.

A G H M A survey found that 29% of consumers from a Country A are more likely to buy stock in a company based in Country A, or shop at its stores, if it is making an effort to publicly talk about how it is becoming more sustainable. Suppose y select a sample of 200 respondents from Country A. Complete parts (a) through (d) below. a. What is the probability that in the sample, fewer than 29% are more likely to buy stock in a company based in Country A, or shop at its stores, if it is making an effort to publicly talk about how it is becoming more sustainable? The probability is 50.00 %. (Round to two decimal places as needed.) b. What is the probability that in the sample, between 25% and 33% are more likely to buy stock in a company based in Country A, or shop at its stores, if it is making an effort to publicly talk about how it is becoming more sustainable The probability is 78.75 %. (Round to two decimal places as needed.) c. What is the probability that in the sample, more than 25% are more likely to buy stock in a company based in Country A, or shop at its stores, if it is making an effort to publicly talk about how it is becoming more sustainable? The probability is 89.37 %. (Round to two decimal places as needed.) Z= P - T P - IT Op IT (1- It) n
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
