Purchase Solution

Excel Spreadsheet that Plots a Bell Curve (Normal Distribution) for Inputted Values of Mean and Standard Deviation

Not what you're looking for?

Ask Custom Question

I would like to have an Excel file (that is: MyChart.xls) that will chart a Gaussian curve for me (a 'normal bell curve'). I would like the various parameters that affect the shape of the curve "separated out" (that is, put in separte cells) so I can independently change them...so I can easily see the effect on the chart. [That is: there might be a few 'intermediate steps' as the formula is 'built-up'.]

Purchase this Solution
Solution Summary

An Excel Spreadsheet that Plots a Bell Curve (Normal Distribution) for Inputted Values of Mean and Standard Deviation is provided. The solution is detailed and well presented. The response received a rating of "5/5" from the student who originally posted the question.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Using EXCEL to Create Plots of Normal Distributions

    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.

  • Normal Probability Plots

    The frequency curve for such a distribution is called a normal curve.

  • Describe the Properties of a Normal Distribution

    It is a bell shaped curve, and is described by two parameters, the mean and the standard deviation. The normal distribution is called the standard normal distribution, indicated by N(0, 1), if its mean is zero and the standard deviation is unity.

  • Frequency Distribution, Mean and Standard Deviation

    The Empirical Rule says that, in a normal distribution, 68.27% of the observations fall within one standard deviation of the mean, 95.45% fall within two, and 99.73% fall within 3. Our values are extremely close to these numbers.

  • Define the Normal Distribution and Describe its Properties

    A normal distribution is a probability distribution that plots its data in a symmetrical way with the mean as a centre of the distribution. It is a bell shaped distribution.

  • Characteristics and Importance of Normal Distribution

    Researchers know with a normal distribution that 68% of the values will be one standard deviation of the mean, 95% of the values will be two standard deviations of the mean, and 99.7% of the values will be within three standard deviations of the mean.

  • T and Z calculations represented on a bell curve

    The z distribution, in contrast, is always a perfect bell curve, and is called the standard normal distribution. Both of these values (t and z) represent standard deviations.

  • Standard Deviation & Bell-Shaped Curve

    For example, see an example of a graph at http://www.tushar-mehta.com/excel/charts/normal_distribution/, which has a mean of zero and a standard deviation of 1, i.e., (m=0, s=1).

  • Bell curve problems

    63386 Bell curve problems How do you develop a bell curve for 1,000 cases: With a given mean of 20 and a standard deviation of 2, how do you compute the -3,-2,-1 (mean), +1,+2,+3 points along the baseline of the curve (assuming the curve is normal)?

View More Related Solutions