Explore BrainMass
Share

Descriptive Statistics

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

1. Calculate the (A) mean, (b) median (c) mode and (d) Range and (e) Standard Deviation for the data below. You may use full functions of Excel. Hint. Copy and paste the data into an Excel spread sheet. Copy, then click one cell in Excel, and paste. Excel will fill the proper cells below the one you selected.

Mean______; Median________; Mode; ___Range_____ Standard Deviation______

15
12
10
15
18
23
22
15
16
17

2. Show me the calculated mean, median, mode, range and Standard Deviation of the sample data below.

Mean______; Median________, Mode______, Range ___Std Dev.___________

3.6
3.7
3.8
3.9
3.9
3.9
3.9
3.9
3.9
4.2
4.3
4.6
5
5.3
5.6
5.7
5.8
6
6
6
6
6
6

© BrainMass Inc. brainmass.com March 21, 2019, 8:55 pm ad1c9bdddf
https://brainmass.com/statistics/quantative-analysis-of-data/mean-median-mode-range-standard-deviation-sample-data-353952

Solution Preview

Please see the attachments.

RES 341-R5 week 4
Find problems below.
1. Calculate the (A) mean, (b) median (c) mode and (d) Range and (e) Standard Deviation for the data below. You may use full functions of Excel. Hint. Copy and paste the data into an Excel spread sheet. Copy, then click one cell in Excel, and paste. Excel will fill the proper cells below the ...

Solution Summary

The solution provides step by step method for the calculation of descriptive statistics. Formula for the calculation and Interpretations of the results are also included.

$2.19