This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: Data are from Canavos, George & Miller, Don, Modern Business Statistics, 1995, Duxbury Press Intervals that will be used to create Freq Obs Num. # Complaints # of Beds Location Program Interval Bin Values Midpoint 1 22 380 Rural Local 499 250 2 5 356 Mixed State 999 750 3 36 412 Rural Local 1499 1250 4 475 Rural State 1999 1750 5 3 494 Rural State 2499 2250 6 13 582 Rural State 2999 2750 7 28 648 Rural State 3499 3250 8 5 650 Rural State 9 14 698 Urban State 10 64 800 Urban Local 11 8 801 Rural State 12 4 810 Mixed State 13 15 820 Rural State 14 211 989 Rural Local 15 1 1259 Rural State 16 3 1364 Rural State 17 77 1789 Urban Local 18 273 3117 Mixed Local 19 17 3292 Mixed State 20 176 3388 Mixed Local Problem 10.79 (1990 data on complaints about longterm care for facilities in VA ) 0 < X ≤ 499 500 ≤ X ≤ 999 1000 ≤ X ≤1499 1500 ≤ X ≤ 1999 2000 ≤ X ≤ 2499 2500 ≤ X ≤ 2999 3000 ≤ X ≤ 3499 quency Table and corresponding Histogram Bin Frequency Frequency Table to the left obtained from CM 10.79 tab with the Histogram 280 1 In 2007 & 2010 Histogram can be obtained from the Data tab, then Data An 1057 13 In 2003 and earlier Data Analysis menu is found on the Tools drop down me 1834 3 2611 More 3 Since no Bin values were specified, Excel used some method for selecting Bin values. which are the upper limits for the categories/ intervals used to determine the frequencies. procedure in Data Analysis nalysis, then Histogram enu Frequency Table obtained from CM 10.79 tab with the Histogram procedure in Data Analysis Midpoint Upper Limit Frequency 250 499 5 750 999 9 1250 1499 2 1750 1999 1 2250 2499 2750 2999 3250 3499 3 More Histogram below is from Insert; Column chart with C3 through C9 highlighted then the Midpoint values were selected for the horizontal axis values 499 999 14991999249929993499More 2 4 6 8 10 Upper Limit Frequency 250 750 1250 1750 2250 2750 3250 2 4 6 8 10 Class Midpoint Frequency Above not e t hat t t he m iddle of t he upper lim it for t he t he upper e nd of Using t he m idpoin t he left give s a m one above ....
View
Full Document
 Spring '08
 Andrews,R
 Standard Deviation, va lue

Click to edit the document details