mba 522 calculating mean and std dev with Excel

mba 522 calculating mean and std dev with Excel - 4.09...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Speaker Rating X - Xbar Infinity Kappa 6.1 4.00 0.0070 0.0000 Column C shows difference b/w each data value and the mean. Allison One 4.12 0.1270 0.0161 click on any of the cells in column C to see the formula. Cambridge Ensemble II 3.82 -0.1730 0.0299 Dynaudio Contour 1.3 4.00 0.0070 0.0000 Hsu Rsch. HRSW12V 4.56 0.5670 0.3215 Column D squares the entry in column C Legacy Audio Focus 4.32 0.3270 0.1069 Mission 73li 4.33 0.3370 0.1136 The process of calculating the standard deviation is demonstrated PSB 400i 4.50 0.5070 0.2570 in cells to the left and below. You can click on the cells above Snell Acoustics D IV 4.64 0.6470 0.4186 to see the formulas to understand the process. Thiel CS1.5 4.20 0.2070 0.0428 ACI Sapphire III 4.67 0.6770 0.4583 Bose 501 Series 2.14 -1.8530 3.4336 DCM KX-212
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4.09 0.0970 0.0094 Eosone RSF1000 4.17 0.1770 0.0313 note: cell D22 has summation of column D in it. Joseph Audio RM7si 4.88 0.8870 0.7868 Martin Logan Aerius 4.26 0.2670 0.0713 Omni Audio SA 12.3 2.32-1.6730 2.7989 Polk Audio RT12 4.50 0.5070 0.2570 Sunfire True Subwoofer 4.17 0.1770 0.0313 Yamaha NS-A636 2.17-1.8230 3.3233 sample variance is sum of Column D divided by n-1 12.5080 sample variance: 0.6583 calculations with formulas sample std. dev: 0.8114 Mean= 3.99 sample standard dev is square root of variance standard deviation: 0.81 I computed the following using Excel functions: AVERAGE and STDEV. Mean 3.9930 standard deviation: 0.8114 X - Xbar column is squared...
View Full Document

This note was uploaded on 11/13/2011 for the course MBA 522 taught by Professor Nabavi during the Spring '08 term at Bellevue.

Ask a homework question - tutors are online