ExploreDataBankrupt2000

ExploreDataBankrupt2000 - delete the excess rows. Replace...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Summary Statisics for: Bkrpt2000 Count 51 Mean 24702.9608 Standard Deviation 27229.8409 Five-Number Summary Minimum 1425.00 First quartile 5590.00 Median 16742.00 Third quartile 36424.00 Maximum 160564.00 IQR 30834.00 Outliers? Upper Fence 82675.00 Yes Lower Fence -40661.00 No Range of Data 159139.00 Category Width 22735 Category Upper Limit Count of Bkrpt2000 24154 33 46889 10 69624 6 92359 1 115094 0 137829 0 160564 1 Total 51 24154 468 0 5 10 15 20 25 30 35 -100000 -50000
Background image of page 1

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

View Full DocumentRight Arrow Icon
889 69624 92359 115094 137829 160564 Count of Bkrpt2000 Category Upper Limit 0 0 50000 100000 150000 200000 1 2 Box Plot of Bkrpt2000
Background image of page 2
Bkrpt2000 31422 1425 21669 16298 160564 15610 11373 4874 2614 73991 57934 5004 7270 62332 37480 8184 11448 20842 23125 4053 31098 16742 36424 15445 17917 26283 3307 5590 14304 3934 38727 7072 61748 25789 2029 53555 19304 18077 43835 4843 11662 2148 47097 62927 14399 1601 37064 31248 8208 17965 1997 Paste your data into column A of this worksheet to create summary statistics and exploratory graphics. If your data is shorter than this column,
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: delete the excess rows. Replace the column heading for better labels. Five-Number Summary Box Plot of Bkrpt2000 Minimum 1425.00 Value Plot First quartile 5590.00 1425 0.5 Median 16742.00 1425 1 Third quartile 36424.00 1425 1.5 Maximum ### 5590 0.5 5590 1 5590 1.5 16742 0.5 16742 1 16742 1.5 36424 0.5 36424 1 36424 1.5 160564 0.5 160564 1 160564 1.5 1425 1 160564 1 5590 0.5 36424 0.5 5590 1.5 LoFence GrafVal HiFence 36424 1.5-40661 0.3 82675-40661 0.7 82675 Quartile Calculations (Book Rules) Initial first quartile rank 13 Rule 1 applies use rank: 13 value of rank: 5590 first quartile: 5590 Initial third quartile rank 39 Rule 1 applies use rank: 39 value of rank: 36424 third quartile: 36424-100000-50000 50 1 2 Box Plot o 0000 100000 150000 200000 of Data2Do...
View Full Document

Page1 / 5

ExploreDataBankrupt2000 - delete the excess rows. Replace...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online