Purchase Solution

Collect data and analyze mean, mode, median, standard deviation

Not what you're looking for?

Ask Custom Question

Your specific assignment for this week is to select a type of quantitative data to collect from your own life. Please divide the day into two parts: AM and PM and get the data on one of these items for each part.

Describe the data you are going to collect. Collect data starting today so you can have at least 20 observations (two for each day), preferably more. Provide a description of the item you collected, and a table with the data that you have collected.

Calculate and report the mean, median, and mode of the data (at lease 20 observations, preferably more). Now calculate the standard deviation of the data. For this calculation compute the difference between each one of the observations and the mean, (this number may be positive or negative), then multiply each of these differences by itself, then add all of these products, and finally divide the sum total by the number of observations. You'll get the "VARIANCE". Now take the square root of this number and you get what is called the "STANDARD DEVIATION" that measures the dispersion of the data from their mean.

Refer first to the measures of central tendency - the mean, the median and the mode. Are these numbers higher or lower that you would have expected? Which of these measures of central tendency do you think most accurately describes the lifestyle variable you are looking at?

Write a response answering the above questions using the measures of central tendency and standard deviation.

The equations must be worked out (so the steps are obvious) and then input in Excel.

Purchase this Solution

Solution Summary

This provides data set (number of birds at feeders at certain times of the day) and analyzes them for classic measures of central tendency. The data is "linked" to the statistical computations so the data can be changed and the measures "update" immediately, permitting students to play with the data and see the graphs and measures change. The data set provides show a non-normal pattern, permitting students to observe how this works. Suggestions are made to make the data more normally distributed. Students can adapt the Excel template to any data set.

Solution Preview

I created a spreadsheet and put data in for bird watching in my backyard. You can change the yellow cells and the data will update to whatever you want to measure.

You now need to interpret. Here is what you might mention:

The median and mode are both smaller than the average. You see from the data that there were ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
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.

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.