Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Tried to upload table it will only take photos. There are tabs each instruction. Really need help ASAP thanks Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from...

Q:

You will have to make a physics report. Your work will require to include all these following items: 2. GOALS (briefly but precisely state the goals of the experiemnt) 3. THEORY (formulas,...

Q:

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Q:

UNIVERSITY OF BRADFORD WORKSHOP 2 2016 Module PH3004D Learning Outcomes: By the end of this workshop you will be able to: 1) Use SPSS to check the normal distribution of the data assumption 2) Edit...

Q:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Q:

please help me answer question by excel 1. Each team member will pick a company to analyze. That way, teams with 5 members will be working with portfolios of 5 different stocks, and teams with 4...

Q:

Name: T.A. name/Class time: MW Lecturer: Lab 11: Multiple Regression Open the lab dataset on Blackboard Learn or previously saved in SPSS. This dataset contains the data for 96 subjects. The...

Q:

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

Q:

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

Q:

Scenario: Tom Jones, the CFO for the firm PSUWC Energy, LLC, woke up with a start at 4:00 am on 04/27/2018, due to his phone ringing. It was his senior financial analyst, vacationing in Europe,...

Q:

Compare the effectiveness of quenching in moderately agitated water and oil by graphing, on a single plot, radial hardness profiles for 65-mm (2 -in.) diameter cylindrical specimens of an 8630 steel...

Q:

Telebrands direct markets assorted products, including the Audubon Singing Bird Clock, the Magic Hanger, Ambervision Sunglasses, and the Better Pasta Pot. Its strategy is to compare its product to...

Q:

The term Caucasian is a synonym for White True or false

Q:

As with most bonds, consider a bond with a face value of $1,000. The bond's maturity is 18 years, the coupon rate is 6% paid annually, and the discount rate is 13%, What should be the estimated value...

Q:

2-8 Fulbert Timber Merchants in Brixton, UK features a large selection of building supplies, including timber, fencing and decking, mouldings, hardwood flooring, sheet materials, windows, doors,...

Q:

2-7 Use the Time/Space Collaboration and Social Tool Matrix to classify the collaboration and social technologies used by BASF..

Q:

2-6 Identify the steps that are performed in the process of selecting and checking out a book from your college library and the information that flows among these activities. Diagram the process. Are...