Explore BrainMass

Explore BrainMass

    Using EXCEL to Create Plots of Normal Distributions

    This content was COPIED from BrainMass.com - View the original, and get the already-completed 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 March 4, 2021, 6:04 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.49

    ADVERTISEMENT