(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
Engineering homework help
Solution:
15% off for this assignment.
Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!
Why US?
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Money Back
If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.