SLIDES . BY

1. SLIDES.BY . . . . . . . . . . . John Loucks St. Edward’s University

2. Chapter 3, Part B Descriptive Statistics: Numerical Measures • Measures of Distribution Shape, Relative Location, and Detecting Outliers • Five-Number Summaries and Box Plots • Measures of Association Between Two Variables • Data Dashboards: Adding Numerical Measures to Improve Effectiveness

3. Measures of Distribution Shape,Relative Location, and Detecting Outliers • Distribution Shape • z-Scores • Chebyshev’s Theorem • Empirical Rule • Detecting Outliers

4. Distribution Shape: Skewness • An important measure of the shape of a distribution is called skewness. • The formula for the skewness of sample data is • Skewness can be easily computed using statistical software.

5. .35 .30 .25 .20 .15 .10 .05 0 Distribution Shape: Skewness • Symmetric (not skewed) • Skewness is zero. • Mean and median are equal. Skewness = 0 Relative Frequency

6. .35 .30 .25 .20 .15 .10 .05 0 Distribution Shape: Skewness • Moderately Skewed Left • Skewness is negative. • Mean will usually be less than the median. Skewness = - .31 Relative Frequency

7. .35 .30 .25 .20 Relative Frequency .15 .10 .05 0 Distribution Shape: Skewness • Moderately Skewed Right • Skewness is positive. • Mean will usually be more than the median. Skewness = .31

8. .35 .30 .25 .20 .15 .10 .05 0 Distribution Shape: Skewness • Highly Skewed Right • Skewness is positive (often above 1.0). • Mean will usually be more than the median. Skewness = 1.25 Relative Frequency

9. Distribution Shape: Skewness • Example: Apartment Rents Seventy efficiency apartments were randomly sampled in a college town. The monthly rent prices for the apartments are listed below in ascending order. 525 530 530 535 535 535 535 535 540 540 540 540 540 545 545 545 545 545 550 550 550 550 550 550 550 560 560 560 565 565 565 570 570 572 575 575 575 580 580 580 580 585 590 590 590 600 600 600 600 610 610 615 625 625 625 635 649 650 670 670 675 675 680 690 700 700 700 700 715 715

10. .35 .30 .25 .20 .15 .10 .05 0 Distribution Shape: Skewness • Example: Apartment Rents Skewness = .92 Relative Frequency

11. z-Scores The z-score is often called the standardized value. It denotes the number of standard deviations a data value xi is from the mean. Excel’s STANDARDIZE function can be used to compute the z-score.

12. z-Scores • An observation’s z-score is a measure of the relative location of the observation in a data set. • A data value less than the sample mean will have a • z-score less than zero. • A data value greater than the sample mean will have • a z-score greater than zero. • A data value equal to the sample mean will have a • z-score of zero.

13. z-Scores • Example: Apartment Rents • z-Score of Smallest Value (525) Standardized Values for Apartment Rents

14. Chebyshev’s Theorem At least (1 - 1/z2) of the items in any data set will be within z standard deviations of the mean, where z is any value greater than 1. Chebyshev’s theorem requires z > 1, but z need not be an integer.

15. Chebyshev’s Theorem At least of the data values must be within of the mean. 75% z = 2 standard deviations At least of the data values must be within of the mean. 89% z = 3 standard deviations At least of the data values must be within of the mean. 94% z = 4 standard deviations

16. Let z = 1.5 with = 590.80 and s = 54.74 - z(s) = 590.80 - 1.5(54.74) = 509 + z(s) = 590.80 + 1.5(54.74) = 673 Chebyshev’s Theorem • Example: Apartment Rents At least (1 - 1/(1.5)2) = 1 - 0.44 = 0.56 or 56% of the rent values must be between and (Actually, 86% of the rent values are between 509 and 673.)

17. Empirical Rule When the data are believed to approximate a bell-shaped distribution … The empirical rule can be used to determine the percentage of data values that must be within a specified number of standard deviations of the mean. The empirical rule is based on the normal distribution, which is covered in Chapter 6.

18. Empirical Rule For data having a bell-shaped distribution: of the values of a normal random variable are within of its mean. 68.26% +/- 1 standard deviation of the values of a normal random variable are within of its mean. 95.44% +/- 2 standard deviations of the values of a normal random variable are within of its mean. 99.72% +/- 3 standard deviations

19. 99.72% 95.44% 68.26% Empirical Rule x m m + 3s m – 3s m – 1s m + 1s m – 2s m + 2s

20. Detecting Outliers • An outlier is an unusually small or unusually large • value in a data set. • A data value with a z-score less than -3 or greater • than +3 might be considered an outlier. • It might be: • an incorrectly recorded data value • a data value that was incorrectly included in the • data set • a correctly recorded data value that belongs in • the data set

21. Detecting Outliers • Example: Apartment Rents • The most extreme z-scores are -1.20 and 2.27 • Using |z| > 3 as the criterion for an outlier, there • are no outliers in this data set. Standardized Values for Apartment Rents

22. Five-Number Summariesand Box Plots Summary statistics and easy-to-draw graphs can be used to quickly summarize large quantities of data. Two tools that accomplish this are five-number summariesand box plots.

23. Five-Number Summary 1 Smallest Value 2 First Quartile 3 Median 4 Third Quartile 5 Largest Value

24. Five-Number Summary • Example: Apartment Rents Lowest Value = 525 First Quartile = 545 Median = 575 Largest Value = 715 Third Quartile = 625 525 530 530 535 535 535 535 535 540 540 540 540 540 545 545 545 545 545 550 550 550 550 550 550 550 560 560 560 565 565 565 570 570 572 575 575 575 580 580 580 580 585 590 590 590 600 600 600 600 610 610 615 625 625 625 635 649 650 670 670 675 675 680 690 700 700 700 700 715 715

25. Box Plot A box plot is a graphical summary of data that is based on a five-number summary. A key to the development of a box plot is the computation of the median and the quartiles Q1 and Q3. Box plots provide another way to identify outliers.

26. 725 550 500 600 625 650 675 700 525 575 Box Plot • Example: Apartment Rents • A box is drawn with its ends located at the first and third quartiles. • A vertical line is drawn in the box at the location of • the median (second quartile). Q1 = 545 Q3 = 625 Q2 = 575

27. continued Box Plot • Limits are located (not drawn) using the interquartile range (IQR). • Data outside these limits are considered outliers. • The locations of each outlier is shown with the symbol* .

28. Box Plot • Example: Apartment Rents • The lower limit is located 1.5(IQR) below Q1. Lower Limit: Q1 - 1.5(IQR) = 545 - 1.5(80) = 425 • The upper limit is located 1.5(IQR) above Q3. Upper Limit: Q3 + 1.5(IQR) = 625 + 1.5(80) = 745 • There are no outliers (values less than 425 or • greater than 745) in the apartment rent data.

29. 725 550 500 600 625 650 675 700 525 575 Box Plot • Example: Apartment Rents • Whiskers (dashed lines) are drawn from the ends of the box to the smallest and largest data values inside the limits. Smallest value inside limits = 525 Largest value inside limits = 715

30. Measures of Association Between Two Variables Thus far we have examined numerical methods used to summarize the data for one variable at a time. Often a manager or decision maker is interested in the relationship between two variables. Two descriptive measures of the relationship between two variables are covariance and correlation coefficient.

31. Covariance The covariance is a measure of the linear association between two variables. Positive values indicate a positive relationship. Negative values indicate a negative relationship.

32. Covariance The covariance is computed as follows: for samples for populations

33. Correlation Coefficient Correlation is a measure of linear association and not necessarily causation. Just because two variables are highly correlated, it does not mean that one variable is the cause of the other.

34. Correlation Coefficient The correlation coefficient is computed as follows: for samples for populations

35. Correlation Coefficient The coefficient can take on values between -1 and +1. Values near -1 indicate a strong negative linear relationship. Values near +1 indicate a strong positive linear relationship. The closer the correlation is to zero, the weaker the relationship.

36. Covariance and Correlation Coefficient • Example: Golfing Study A golfer is interested in investigating the relationship, if any, between driving distance and 18-hole score. Average Driving Distance (yds.) Average 18-Hole Score 69 71 70 70 71 69 277.6 259.5 269.1 267.0 255.6 272.9

37. Covariance and Correlation Coefficient • Example: Golfing Study x y 69 71 70 70 71 69 -1.0 1.0 0 0 1.0 -1.0 277.6 259.5 269.1 267.0 255.6 272.9 10.65 -7.45 2.15 0.05 -11.35 5.95 -10.65 -7.45 0 0 -11.35 -5.95 Average Total 267.0 70.0 -35.40 Std. Dev. 8.2192 .8944

38. Covariance and Correlation Coefficient • Example: Golfing Study • Sample Covariance • Sample Correlation Coefficient

39. Data Dashboards: Adding Numerical Measures to Improve Effectiveness • Data dashboards are not limited to graphical displays. • The addition of numerical measures, such as the mean • and standard deviation of KPIs, to a data dashboard • is often critical. • Dashboards are often interactive. • Drilling down refers to functionality in interactive • dashboards that allows the user to access information • and analyses at increasingly detailed level.

40. Data Dashboards: Adding Numerical Measures to Improve Effectiveness

41. End of Chapter 3, Part B