Explore BrainMass

Explore BrainMass

    Using EXCEL to Create Plots of Normal Distributions

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 December 24, 2021, 5:05 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