Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How to create Box-Plots in Excel using this data, as If I click on Box-Whiskers, it is only providing me with whiskers. I am able
How to create Box-Plots in Excel using this data, as If I click on Box-Whiskers, it is only providing me with whiskers. I am able to get the box plot across the six models(horizontally), but when I try to go down(vertically) across monthly for each car, it is only giving me whiskers.
Month | Chevy Cruze | Ford Focus | Hyundai Elantra | Honda Civic | Toyota Corolla | VW Jetta |
January | 22711 | 21303 | 21006 | 19341 | 20985 | 20671 |
February | 19274 | 19385 | 19992 | 20872 | 19785 | 20105 |
March | 18934 | 16557 | 15713 | 17181 | 16889 | 17006 |
April | 20387 | 17420 | 15054 | 14500 | 14093 | 15083 |
May | 18097 | 16147 | 15023 | 15800 | 15727 | 17875 |
June | 17244 | 16173 | 14295 | 15058 | 15236 | 17893 |
Mean | 19441.16667 | 17830.83333 | 16847.16667 | 17125.33333 | 17119.16667 | 18105.5 |
Median | 19104 | 16988.5 | 15383.5 | 16490.5 | 16308 | 17884 |
Mode | - | - | - | - | - | - |
Range | 5467 | 5156 | 6711 | 6372 | 6892 | 5588 |
Standard Deviation | 1923.845047 | 2090.287867 | 2881.971229 | 2524.778776 | 2710.957057 | 2050.486942 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started