Calculation of descriptive statistics in Excel.
Not what you're looking for?
Using the Excel program, enter the data below onto a worksheet. Then touch the Paste Function button on the toolbar. You'll get a menu. On the left side of the menu, select "Statistical." This will make the right side show all the statistical tests you can do with EXCEL. Pick "average" and it will calculate the mean, pick "standard deviation", and it'll do that. You get the idea. Calculate the mean, the variance, and the standard deviation of each of the following sets of numbers:
(a) 4, 0, 1, 4, 3, 6
(b) 5, 3, 1, 3, 4, 2
Which of the sets is more spread out? Draw a histogram of set (a) and one of set (b) to see how the set with the larger variance is more spread out.
Now, suppose that we add 2 to each of the numbers in set (a) above.
That gives us the set that follows: 6, 2, 3, 6, 5, 8
(c) Find the mean and the standard deviation of this set of numbers.
(d) Compare your answers with those for set (a) above. How did adding 2 to each number change the mean? How did it change the standard deviation?
(e) Can you guess, without doing the arithmetic, what will happen to the mean and standard deviation of set (a) from above if we add 10 to each number in that set?
(f) Do the histograms resemble a normal distribution? Explain why or why not.
Purchase this Solution
Solution Summary
The solution gives the step by step procedure for the computation of mean, median, standard deviation and histogram.
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.
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.
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.