MATH 221 NOTES 3 FA 09

MATH 221 NOTES 3 FA 09 - MATH 221 Week3 Student Name...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
MATH 221 Statistics for Decision - Making Lecture Notes     Week 3 Measures of Variation / Probability Student Name         Measures of Variation  After a group of data values has been gathered, we could possibly ask ourselves the  question: " To what extent is the data dispersed? "  That is, how far spread is the data?  Is the difference between the highest data value and the lowest data value a large  variation?  We could also ask: " On the average, how does each data value compare  with some mean value? "  These questions indicate the need for so - called measures of  dispersion ( variation ) that attempt to provide the answers.  Measures of dispersion  focus on comparing the given data values to each other or some central number.  Compare this focus to that of central tendency measures, which instead attempt to find: "  What number(s) best describe the entire set of data values? " The Range     The most elementary measure of dispersion is the range.  The range  is the difference  between the largest value of a given set of values and the smallest value within this  same set.  The range therefore compares the highest number to the lowest number.  Range   =   Highest Value   -   Lowest Value Example 1     A random sample of fifteen charge card accounts gave the following information about  the payment due on each card.  Find the range of these amounts.     $ 43.78 $ 162.50 $ 204.30 $ 40.32 $ 172.50 $ 32.40 $ 105.73 $ 189.23 $ 164.18 $ 40.38 $ 159.12 $ 87.46 $ 165.23 $ 48.80 $ 110.86 Solution     Here, the largest value in the given group of values is $ 204.30 and the smallest value is  $ 32.40 .  The range  therefore is equal to the difference $ 204.30   -   $ 32.40 or $ 171.90  . Finding the Range Using      MS        Excel     Using MS Excel, the range can be determined using the built - in MAX and MIN  functions.  Consider the spreadsheet shown below.   A B C 1 Employee Name  Salary   2 Bobby Benson  $ 25,750.00   © Copyright 2010 by P.E.P. 1
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
MATH 221 Statistics for Decision - Making Lecture Notes     Week 3 Measures of Variation / Probability Student Name         3 Cathy Cummings  $ 26,922.00   4 Denise Daniels  $ 83,942.00   5 Eddie Edwards  $ 45,220.00   6 Fred Fields  $ 98,125.00   7 Gina George  $ 53,125.00 8 Henry Hansen  $ 18,500.00 9 Justin James  $ 41,480.00 10   11 Salary Range   12   To determine the range of salaries in cell B11 , you would enter the following formula  into that cell.  = MAX ( B2 : B9 )  -  MIN ( B2 : B9 ) This particular formula would find the range of the salaries located within the group of  cells B2 through B9 .
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern