Purchase Solution

Statistics: histograms and bell shape curves

Not what you're looking for?

Ask Custom Question

Need instruction on how to draw the histogram for the following data to determine what the bell curve distribution looks like. In excel if possible.

Please see attached file.

I can't graph axis's to reflect the story that I am trying to determine which is to find out which distribution is more bell shaped.
Thank you,

Attachments
Purchase this Solution
Solution Summary

How to draw the histogram in EXCEL for the following data to determine what the bell curve distribution looks like.

Solution Preview

Histogram and Bell Shape
-instructions-

To make the histogram and the Shape of the data in EXCEL, we need to follow these steps:
1. Make the transpose of the ...

Solution provided by:
Chris Busu, PhD (IP)
Education
  • BSc, University of Bucharest
  • MSc, Ovidius
  • MSc, Stony Brook
  • PhD (IP), Stony Brook
Recent Feedback
  • "Thank you "
  • "Thank You Chris this draft really helped me understand correlation."
  • "Thanks for the prompt return. Going into the last meeting tonight before submission. "
  • "Thank you for your promptness and great work. This will serve as a great guideline to assist with the completion of our project."
  • "Thanks for the product. It is an excellent guideline for the group. "
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.

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Water Consuption

    From the above two histograms, we found their shapes look alike. Their shapes of the distribution are similar to bell-shape.

  • Normally Distributed Histograms

    What shape would your distribution histogram be if the variable is approximately normally distributed? The shape of the bar graphs and histograms of almost any kind of numerical data resembles a Bell-shaped pattern.

  • Why histograms and frequency polygons are used in business S

    Solution provides explanation as to why histograms and frequency polygons are used in business statistics.

  • personal characteristic

    Now, people come in all different sizes, which makes up the shape of the bell curve. However, assuming that the sample is normally distributed, all bell curves follow the same pattern.

  • Histograms, bar-graphs, and other statistical presentations of data

    399446 Histograms, bar-graphs, and other statistical presentations of data Why is it useful to know something about the shape of a set of numbers (a "dataset")?

  • American Intellectual Union: Job Satisfaction Charts

    Just reading the measure of centra tendency you get the idea that the data isn't a nice bell curve but it is hard to visual what the "shape" of the data might be (except just not a bell shape). A graph really helps with this. See below.

  • Histogram: Shape of sample; Value of estimate; S.D.

    325656 Histograms: What shape of sample; value of estimate; standard deviation A population has a mean of 79 and a standard deviation of 27. Sample means are computed for several thousand random samples of size ?

  • Histograms and Central Tendency

    269800 Histograms and Central Tendency Compute descriptive statistics for the number of brothers and sisters (variable sibs), years of education (variable educ), and hours worked last week (variable hrs1).

  • Statistics - Finding Standard Deviation

    for a Random Shape and a Bell Shape seem pretty insignificant with the biggest observed difference occurring with the +/- 1 stdev results.

View More Related Solutions