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
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:
The solution consists of details of finding descriptive sample statistics such as mean, median, range, and standard deviation by Excel.