Explore BrainMass

Explore BrainMass

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

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 12:39 am ad1c9bdddf


    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 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.