Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

(a) Use Excel to sketch a graph of the standard normal distribution with a mean of 0 and a standard deviation of 1. Generate x values in column A...

(a) Use Excel to sketch a graph of the standard normal distribution with a mean of 0 and a standard deviation of 1. Generate x values in column A ranging from -3 to 3 in increments of 0.5. Use NORM.DIST to generate the y values in column B.

(b)  Use Excel to sketch a graph of a normal distribution with a mean of 10 and a standard deviation of 1. Generate x values in Column A ranging from 7 to 13 in increments of 0.5. Use NORM.DIST to generate the y values in column B. Compare the graphs of parts (a) and (b). Do the height and spread of the graphs appear to be the same? What is different? Why would you expect this difference.

(c)  Sketch a graph of a normal distribution with a mean of 0 and a standard deviation of 2. Generate x values in Column A ranging from -6 to 6 in increments of 0.5. Use NORM.DIST to generate the y values in Column B. Compare that graph to that of part (a). Do the height and spread of the graphs appear to be the same? What is different? Why would you expect this difference? Note, to really compare the graphs, it is best to graph them using the same scales. Redo the graph of part (a) using x from -6 to 6. Then redo the graph in this part using the same x values as in part (a) and y values ranging from 0 to the high value in part

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question