1 / 52

Slides by John Loucks St . Edward’s University

Slides by John Loucks St . Edward’s University. Chapter 3, Part A Descriptive Statistics: Numerical Measures. Measures of Location. Measures of Variability. Measures of Location. Mean. If the measures are computed for data from a sample, they are called sample statistics . Median.

tova
Download Presentation

Slides by John Loucks St . Edward’s University

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Slides by John Loucks St. Edward’s University

  2. Chapter 3, Part A Descriptive Statistics: Numerical Measures • Measures of Location • Measures of Variability

  3. Measures of Location • Mean If the measures are computed for data from a sample, they are called sample statistics. • Median • Mode • Percentiles If the measures are computed for data from a population, they are called population parameters. • Quartiles A sample statistic is referred to as the point estimator of the corresponding population parameter.

  4. The sample mean is the point estimator of the population mean m. Mean • Perhaps the most important measure of location is the mean. • The mean of a data set is the average of all the data values. • The mean provides a measure of central location.

  5. Sample Mean Sum of the values of the n observations Number of observations in the sample

  6. Population Mean m Sum of the values of the N observations Number of observations in the population

  7. Sample Mean • Example: Apartment Rents Seventy efficiency apartments were randomly sampled in a small college town. The monthly rent prices for these apartments are listed below.

  8. Sample Mean • Example: Apartment Rents

  9. Median • The median of a data set is the value in the middle • when the data items are arranged in ascending order. • Whenever a data set has extreme values, the median • is the preferred measure of central location. • The median is the measure of location most often • reported for annual income and property value data. • A few extremely large incomes or property values • can inflate the mean.

  10. Median • For an odd number of observations: 26 18 27 12 14 27 19 7 observations 27 12 14 18 19 26 27 in ascending order the median is the middle value. Median = 19

  11. Median • For an even number of observations: 26 18 27 12 14 27 30 19 8 observations 27 30 12 14 18 19 26 27 in ascending order the median is the average of the middle two values. Median = (19 + 26)/2 = 22.5

  12. Median • Example: Apartment Rents Averaging the 35th and 36th data values: Median = (475 + 475)/2 = 475 Note: Data is in ascending order.

  13. Trimmed Mean • Another measure, sometimes used when extreme values are present, is the trimmed mean. • It is obtained by deleting a percentage of the smallest and largest values from a data set and then computing the mean of the remaining values. • For example, the 5% trimmed mean is obtained by removing the smallest 5% and the largest 5% of the data values and then computing the mean of the remaining values.

  14. Mode • The mode of a data set is the value that occurs with • greatest frequency. • The greatest frequency can occur at two or more • different values. • If the data have exactly two modes, the data are • bimodal. • If the data have more than two modes, the data are • multimodal. • Caution: If the data are bimodal or multimodal, Excel’s MODE function will incorrectly identify a single mode.

  15. Mode • Example: Apartment Rents 450 occurred most frequently (7 times) Mode = 450 Note: Data is in ascending order.

  16. Using Excel to Computethe Mean, Median, and Mode • Excel Formula Worksheet A B C D E Apart- Monthly 1 ment Rent ($) 2 1 525 Mean =AVERAGE(B2:B71) 3 2 440 Median =MEDIAN(B2:B71) 4 3 450 Mode =MODE.SNGL(B2:B71) 5 4 615 6 5 480 Note: Rows 7-71 are not shown.

  17. Using Excel to Computethe Mean, Median, and Mode • Excel Value Worksheet A B C D E Apart- Monthly 1 ment Rent ($) 2 1 525 Mean 490.80 3 2 440 Median 475.00 4 3 450 Mode 450.00 5 4 615 6 5 480 Note: Rows 7-71 are not shown.

  18. Percentiles • A percentile provides information about how the • data are spread over the interval from the smallest • value to the largest value. • The pth percentile of a data set is a value such that at least p percent of the items take on this value or less and at least (100 - p) percent of the items take on this value or more. • Admission test scores for colleges and universities • are frequently reported in terms of percentiles.

  19. Percentiles Arrange the data in ascending order. Compute index i, the position of the pth percentile. i = (p/100)n If i is not an integer, round up. The pth percentile is the value in the ith position. If i is an integer, the pth percentile is the average of the values in positions i and i+1.

  20. 80th Percentile • Example: Apartment Rents i = (p/100)n = (80/100)70 = 56 Averaging the 56th and 57th data values: 80th Percentile = (535 + 549)/2 = 542 Note: Data is in ascending order.

  21. 80th Percentile • Example: Apartment Rents “At least 80% of the items take on a value of 542 or less.” “At least 20% of the items take on a value of 542 or more.” 56/70 = .8 or 80% 14/70 = .2 or 20%

  22. Lp = (p/100)n + (1 – p/100) Using Excel’s Rank and Percentile Tool to Compute Percentiles and Quartiles • Using Excel’s Percentile Function The formula Excel uses to compute the location (Lp) of the pth percentile is Excel would compute the location of the 80th percentile for the apartment rent data as follows: L80 = (80/100)70 + (1 – 80/100) = 56 + .2 = 56.2 The 80th percentile would be 535 + .2(549 - 535) = 535 + 2.8 = 537.8 Excel interpolates over the interval from 0 to n.

  23. Using Excel’s Rank and Percentile Tool to Compute Percentiles and Quartiles 80th percentile • Excel Formula Worksheet A B C D Apart- Monthly th 1 ment Rent ($) 80 Percentile 2 1 525 =PERCENTILE.INC(B2:B71,.8) 3 2 440 4 3 450 It is not necessary to put the data in ascending order. 5 4 615 6 5 480 Note: Rows 7-71 are not shown.

  24. Using Excel’s Rank and Percentile Tool to Compute Percentiles and Quartiles • Excel Value Worksheet A B C D Apart- Monthly th 1 ment Rent ($) 80 Percentile 2 1 525 537.8 3 2 440 4 3 450 5 4 615 6 5 480 Note: Rows 7-71 are not shown.

  25. Quartiles • Quartiles are specific percentiles. • First Quartile = 25th Percentile • Second Quartile = 50th Percentile = Median • Third Quartile = 75th Percentile

  26. Third Quartile • Example: Apartment Rents Third quartile = 75th percentile i = (p/100)n = (75/100)70 = 52.5 = 53 Third quartile = 525 Note: Data is in ascending order.

  27. Lp = (p/100)n + (1 – p/100) Third Quartile • Using Excel’s QUARTILE.INCFunction Excel computes the locations of the 1st, 2nd, and 3rd quartiles by first converting the quartiles to percentiles and then using the following formula to compute the location (Lp) of the pth percentile: Excel would compute the location of the 3rd quartile (75th percentile) for the rent data as follows: L75 = (75/100)70 + (1 – 75/100) = 52.5 + .25 = 52.75 The 3rd quartile would be 515 + .75(525 - 515) = 515 + 7.5 = 522.5

  28. Third Quartile • Excel Formula Worksheet 3rd quartile A B C D Apart- Monthly 1 ment Rent ($) Third Quartile =QUARTILE.INC(B2:B71,3) 2 1 525 3 2 440 It is not necessary to put the data in ascending order. 4 3 450 5 4 615 6 5 480 Note: Rows 7-71 are not shown.

  29. Third Quartile • Excel Value Worksheet A B C D Apart- Monthly 1 ment Rent ($) Third Quartile 522.5 2 1 525 3 2 440 4 3 450 5 4 615 6 5 480 Note: Rows 7-71 are not shown.

  30. Using Excel’s QUARTILE.INC Function • If the value of 1 in the QUARTILE.INC function is • changed to 0, Excel computes the minimum value in • the data set. • If the value of 1 is changed to 4, Excel computes the maximum value in the data set.

  31. Excel’s Rank and Percentile Tool Step 1 Click the Data tab on the Ribbon Step 2 In the Analysis group, click Data Analysis Step 3 Choose Rank and Percentile from the list of Analysis Tools Step 4 When the Rank and Percentile dialog box appears (see details on next slide)

  32. Excel’s Rank and Percentile Tool Step 4 Complete the Rank and Percentile dialog box as follows:

  33. Excel’s Rank and Percentile Tool • Excel Value Worksheet Note: Rows 11-71 are not shown.

  34. Measures of Variability • It is often desirable to consider measures of variability • (dispersion), as well as measures of location. • For example, in choosing supplier A or supplier B we • might consider not only the average delivery time for • each, but also the variability in delivery time for each.

  35. Measures of Variability • Range • Interquartile Range • Variance • Standard Deviation • Coefficient of Variation

  36. Range • The range of a data set is the difference between the largest and smallest data values. • It is the simplest measure of variability. • It is very sensitive to the smallest and largest data values.

  37. Range • Example: Apartment Rents Range = largest value - smallest value Range = 615 - 425 = 190 Note: Data is in ascending order.

  38. Interquartile Range • The interquartile range of a data set is the difference • between the third quartile and the first quartile. • It is the range for the middle 50% of the data. • It overcomes the sensitivity to extreme data values.

  39. Interquartile Range • Example: Apartment Rents 3rd Quartile (Q3) = 525 1st Quartile (Q1) = 445 Interquartile Range = Q3 - Q1 = 525 - 445 = 80 Note: Data is in ascending order.

  40. Variance The variance is a measure of variability that utilizes all the data. It is based on the difference between the value of each observation (xi) and the mean ( for a sample, m for a population). The variance is useful in comparing the variability of two or more variables.

  41. Variance The variance is the average of the squared differences between each data value and the mean. The variance is computed as follows: for a sample for a population

  42. Standard Deviation The standard deviation of a data set is the positive square root of the variance. It is measured in the same units as the data, making it more easily interpreted than the variance.

  43. Standard Deviation The standard deviation is computed as follows: for a sample for a population

  44. Coefficient of Variation The coefficient of variation indicates how large the standard deviation is in relation to the mean. The coefficient of variation is computed as follows: for a sample for a population

  45. Sample Variance, Standard Deviation, And Coefficient of Variation • Example: Apartment Rents • Variance • Standard Deviation the standard deviation is about 11% of the mean • Coefficient of Variation

  46. Using Excel to Compute the Sample Variance, Standard Deviation, and Coefficient of Variation • Formula Worksheet A B C D E Apart- Monthly 1 ment Rent ($) 2 1 525 Mean =AVERAGE(B2:B71) 3 2 440 Median =MEDIAN(B2:B71) 4 3 450 Mode =MODE.SNGL(B2:B71) 5 4 615 Variance =VAR.S(B2:B71) 6 5 480 Std. Dev. =STDEV.S(B2:B71) 7 6 510 C.V. =E6/E2*100 Note: Rows 8-71 are not shown.

  47. Using Excel to Compute the Sample Variance, Standard Deviation, and Coefficient of Variation • Value Worksheet A B C D E Apart- Monthly 1 ment Rent ($) 2 1 525 Mean 490.80 3 2 440 Median 475.00 4 3 450 Mode 450.00 5 4 615 Variance 2996.16 6 5 480 Std. Dev. 54.74 7 6 510 C.V. 11.15 Note: Rows 8-71 are not shown.

  48. Using Excel’sDescriptive Statistics Tool Step 1 Click the Data tab on the Ribbon Step 2 In the Analysis group, click Data Analysis Step 3 Choose Descriptive Statistics from the list of Analysis Tools Step 4 When the Descriptive Statistics dialog box appears: (see details on next slide)

  49. Using Excel’sDescriptive Statistics Tool • Excel’s Descriptive Statistics Dialog Box

  50. Using Excel’sDescriptive Statistics Tool • Excel Value Worksheet (Partial) Note: Rows 9-71 are not shown.

More Related