Purchase Solution

Using EXCEL to Create Plots of Normal Distributions

Not what you're looking for?

Ask Custom Question

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!

Purchase this Solution
Solution Summary

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

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • TESTS OF THE EQUALITY OF TWO NORMAL DISTRIBUTIONS

    b) Use the following to calculate the value of the test statistic. c) Construct two box plots on the same graph. (The material is from TESTS OF THE EQUALITY OF TWO NORMAL DISTRIBUTION.

  • Normal Distribution, Mean Difference, and Boxplot

    Using the above rule, we know that both and follow normal distributions, with means and ; and variance and . In order to build the confidence interval, we need to know the variance and distribution of the random variable.

  • Normal Probability Plots

    This response discusses the use of normal probability plots to determine the distribution of data.

  • Descriptive, Graphical and T-Test Using SPSS

    Copy only the Normal p-p Plots into your assignment Word document (you do not need to copy the beginning output nor the Detrended Normal p-p Plots). 4.

  • Comparing Four Dietary Regemens:

    .*** I used SPSS to do these problems, using the data you provided in the Excel file: Kruskal-Wallis test: This is a one-way analysis of variance by ranks, so it is non-parametric. It does not assume a normal population.

  • Plot standard normal distribution formula in excel

    This solution plots the standard normal distribution formula in excel.

  • Forecast and Accuracy Measures

    Then create scatter plots or line plots of each time series. From the plots, determine what the components of each time series are.

  • 4 basic assumption of multiple regression analysis

    that the relationship between an independent variable and the dependent variable is linear You can create scatter plots, have excel create a linear trend line, and see how close the R squared value is to 1.

  • Minitab Problem

    466942 Statistical Concepts Plotting the Binomial Probabilities using MINITAB 1.) Create plots for the three binomial distributions above.

View More Related Solutions