Week 1 Stats 3 - 6. Click in cell A1 and drag down to A17....

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

View Full Document Right Arrow Icon
For office 2007 and vista: 1. Open excel, and click add-ins. 2. Input all values given in the problems in column A. Therefore: Cell A1 = 23 A2 = 25 A3 = 20 A4 = 10 A5 = 12 A6 = 9 A7= 18 A8 = 2 A9 = 11 A10 = 6 A11= 35 A12 = 41 A13 = 20 A14 = 11 A15 = 29 A16 = 11 A17 = 10 3. Click MegaStat, click descriptive statistics. 4. Ensure that mean, standard deviation, and range (if needed) all have checks next to them. 5. Click the box next to input range.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6. Click in cell A1 and drag down to A17. (The following will show in the range field: Sheet1!$A$1:$A$17) 7. Click ok. The outputs will appear in a separate tab from the sheet where you entered your values. Here you will see the following results: Count 17 Mean 17.24 Sample Variance 112.69 Sample Standard Deviation 10.62 Minimum 2 Maximum 41 Range 39...
View Full Document

This note was uploaded on 03/26/2012 for the course STATISTIC GM533 taught by Professor Henry during the Fall '10 term at Keller Graduate School of Management.

Ask a homework question - tutors are online