Frequency Distribution, Mean and Standard Deviation
Not what you're looking for?
Please see attached file for full problem description.
Use the data set collected in a) to do the following.
1. Group the data into at least 10 different classes and create a frequency distribution table for the data set, and graph the histogram of the data set; Make an educated guess about the mean, standard deviation, and make comments about whether the shape of distribution may be considered a Bell curve (Normally distributed).
2. Calculate the summary measurements, mean x and standard deviation s for the data set the "Descriptive Statistics" package in MS Excel.
3. Count the number of measurements in the intervals x ± s, x ± 2s, and x ± 3s. Express each count as a percentage of the total number of measurements. Apply Empirical Rule to discuss whether the conclusion about the shape of the data set distribution give in 1) seems correct.
4. Superimpose the Normal distribution line chart with Mean and standard deviation from 2) onto the relative Frequency bar chart of the data set. Further discuss the shaper of the data set.
The completed project report should be created in One Microsoft Excel file. The report should include
? (Sheet 1. name it Cover Sheet) A cover page with a title of your project (you select), and student names of the group.
? (Sheet 2. name it Data) A detailed discussion about objective of you analysis and the how, when, and where you collected your data. Discuss why the data you collected is representative. Provide the raw data in this sheet.
? (Sheet 3. name it Data Analysis) This sheet contains answer to question 1-4.
Give clear explanation about the class range selection, as well as the generated Table(s) and Chart(s).
Purchase this Solution
Solution Preview
a) Data collection
? Collect a sample of data with at least 50 observations.
I put the data in an Excel spreadsheet.
b) Data Analysis
Use the data set collected in a) to do the following.
1. Group the data into at least 10 different classes and create a frequency distribution table for the data set, and graph the histogram of the data set; Make an educated guess about the mean, standard deviation, and make comments about whether the shape of distribution may be considered a Bell curve (Normally distributed).
I made the frequency distribution by sorting the data, setting 13 class intervals of width 2, and counting the number of scores in each class. I used that information to make a histogram. (Note: I chose 13 intervals because the instructions said to group the data into at least 10 classes. To have at ...
Purchase this Solution
Free BrainMass Quizzes
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.
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.