Building a Frequency Distribution in Excel
Not what you're looking for?
Please help with the following statistics problems.
For the following data:
15 25 13 10 9 17 13 15 20 5
1) Calculate the mean and standard deviation
2) Decide if it's a normal distribution
3) Build a frequency distribution
Purchase this Solution
Solution Summary
This solution shows how to calculate the mean and standard deviation, and build a frequency distribution in Excel. The data sample size is n=10. Explanations are given along with calculations in Excel.
Solution Preview
Dear Student:
First input your data into an Excel spreadsheet (see the attached spreadsheet). Arranged the data in a column, each piece of data in its own cell. For calculating the standard deviation, go to an empty cell, click fx, a box opens where you can search for the function you are looking for. Type 'standard deviation' in the box, click Go and in the lower box you see alternative functions to use. Choose STDEV (this is the one you will most often use for standard deviation) and another box opens. Now, in this particular example, for number1 space, you input cell references ...
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
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.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.