I am using Analytical Chemistry7th 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 datato 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!

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