Question: Home Insert Page Layout Formulas Data Review View Calibn In Copy - 11 Ex wrap Text General Paste Normal Bad Good Format Painter Merge &

Home Insert Page Layout Formulas Data Review View Calibn In Copy - 11 Ex wrap Text General Paste Normal Bad Good Format Painter Merge & Center - Conditional Format as Neutral Calculation Check Cell Clipboard Font Formatting ~ Table - Alignment Number K21 Styles A B D E Chevy G Ford H Hyundai Honda K M N 1 Cruze Focus Toyota VW O Elantra Civic Corolla 2 January 21,711 Jetta 21,303 21,006 19,341 20,985 19,671 February 18,274 19.385 19,992 20,872 25,000 19.785 19.105 4 March 17,934 16,557 15,713 17, 181 16,889 16,006 April 19,387 17,420 15,054 14,500 14,093 14,083 20,000 6 May 17.097 16,147 15,023 15,800 15,727 16,875 7 June 16,244 16.173 14,295 15,058 15,236 16,893 15,000 8 Total 1,10,647 1,06,985 1,01,083 1,02,752 1,02,715 Box 3 - upper 1,02,633 9 Mean 18441.1667 17830.83 16847.17 17125.33 17119.17 17105.5 10,000 Box 2 - lower 10 Median 18,104 16,989 15,384 16,491 16,308 16,884 Box 1-hidden 11 Mode #N/A #N/A #N/A #N/A #N/A #N/A 5,000 12 Range 5,467 5,156 6,711 6,372 6,892 5,588 Standard Deviation 13 1756.22222 1908.163 2630.868 2304.797 2474.754 1871.83 Chevy Ford Hyundai Honda Toyota VW Jetta 14 Cruze Focus Elantra Civic Corolla 15 Minimum 16,244 16,147 14,295 14,500 14,093 14,083 16 Q1 17,306 16,269 15,031 15,244 15,359 16,223 17 Median 18,104 16,989 15,384 16,491 16,308 16,884 18 Q3 19,109 18,894 18,922 18,801 19,061 18,552 19 Maximum 21,711 21,303 21,006 20,872 20,985 19,671 20 21 Box 1 -hidden 17,306 16,269 15,031 15,244 15,359 16,223 22 Box 2 - lower 798 720 353 1,247 949 661 23 Box 3 - upper 1,005 1,905 3,539 2,311 2,753 1,668 24 25 Whisker Top 2,602 2,409 2,084 2,071 1,924 1,119 + 26 Whisker Bottom 1,062 122 736 744 1,266 2,140
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
