Answer:
We can use the following excel code: "=1-NORM.DIST(0.1314,0,1,TRUE)" or the standard normal table
We can use the following excel code: "=NORM.DIST(0.75,0,1,TRUE)" or the standard normal table.
We can use the following excel code: "=1-NORM.DIST(0.01,0,1,TRUE)" or the standard normal table
Step-by-step explanation:
Previous concepts
Normal distribution, is a "probability distribution that is symmetric about the mean, showing that data near the mean are more frequent in occurrence than data far from the mean".
The Z-score is "a numerical measurement used in statistics of a value's relationship to the mean (average) of a group of values, measured in terms of standard deviations from the mean".
Solution to the problem
We can use the following excel code: "=1-NORM.DIST(0.1314,0,1,TRUE)" or the standard normal table
We can use the following excel code: "=NORM.DIST(0.75,0,1,TRUE)" or the standard normal table.
We can use the following excel code: "=1-NORM.DIST(0.01,0,1,TRUE)" or the standard normal table