Explore BrainMass
Share

Using EXCEL to Create Plots of Normal Distributions

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

I am using Analytical Chemistry 7th edition By Skoog, West, Holler, and Crouch. please let me know if any additional info. is needed. There is a sample of the graph in the book Chapter 6 and 7.

Using Excel, construct a spreadsheet to make two plots of a Gaussian distribution: 1. relative frequency vs deviation from the mean; and 2. relative frequency vs z. Assume ( i think this is population mean) u= 5.0 and (i think this is standard deviation) alpha=0.5.

plot distribution where mean= 0.5
-be sure to have enough values so it is a smooth curve
Make two different plots with same data
Find equaiton and plug in numbers

Gaussian curve = normal error curve

dont know if you need this equation or not

z = ( x - u)/ alpha

you can pick any numbers you want for this problem

alpha means that the standard deviation is -.5 and .5 from the mean, which is 5. All I need help with is coming up with data to plot these two graphs on excel. The top of the curve needs to be at 5 when plotted on the x axis i think. .....please help!

© BrainMass Inc. brainmass.com September 21, 2018, 12:07 pm ad1c9bdddf - https://brainmass.com/statistics/normal-distribution/using-excel-create-plots-normal-distribuutions-26955

Solution Summary

This solution contains an Excel sheet that can be used to plot any normal (gaussian) distribution.

$2.19