Explore BrainMass

Explore BrainMass

    Finding descriptive sample statistics

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

    I have a question about a statistic problem regarding the dataset provided. It is based on a sample of 252 men, all of whom have had their body fat and weight recorded. Also a doctor's office claims that the mean body fat in men is 20%. I have the mean, media and mode but I am not sure how to find the range and standard deviation. Please help.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:48 am ad1c9bdddf


    Solution Preview

    To find out the range=Max - Min, we need to find the maximum and minimum. For instance, if we want to compute the range of the data: weights. Then we can use the functions MAX and MIN (both can be found in Excel). Here ate the steps:

    Step ...

    Solution Summary

    The solution consists of details of finding descriptive sample statistics such as mean, median, range, and standard deviation by Excel.