Purchase Solution

Building a Frequency Distribution in Excel

Not what you're looking for?

Ask Custom Question

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.