I need these questions answered using the Sample Superstore data from Tableau software.Make a new worksheet to answer every multiple choice question.Only answer the question once. If you see it again in the questions i sent, just ignore it.
Which region saw the biggest decline in year-over-year growth in profitability from 2018 to 2019?
Select one:a.Centralb.Eastc.Westd.South
Question2
CompleteMark 0.00 out of 1.00Flag question
Question text
On average, which shipping mode has the longest number of days to ship from the order date?
Select one:a.Standard Classb.First Classc.Second Classd.Same Day
Question3
CompleteMark 0.00 out of 1.00Flag question
Question text
Which state had the largest product volume per order?
Select one:a.New Hampshireb.Californiac.Vermontd.New York
Question4
Not answeredMarked out of 1.00Flag question
Question text
How many customers who ordered in 2019 also ordered in 2018?
Select one:a.489b.558c.632d.135
Question5
CompleteMark 0.00 out of 1.00Flag question
Question text
Determine which segment has the most customers. How many customers are there in this segment?Select one:a.3,020b.5,191c.409d.236
Question6
CompleteMark 1.00 out of 1.00Flag question
Question text
Which state was the most profitable in 2019?
Select one:a.Washingtonb.Californiac.Texasd.New York
Question7
CompleteMark 0.00 out of 1.00Flag question
Question text
The top 5 customers belong to which segment(s)?
Select one or more:a.Home Officeb.Consumerc.Corporate
Question8
Not answeredMarked out of 1.00Flag question
Question text
What percentage of the year's orders occurred in Q4 of 2019?
Select one:a.38.20%b.42.12%c.37.00%d.36.81%
Question9
Not answeredMarked out of 1.00Flag question
Question text
Which sub-categories are unprofitable across all regions? (Select all that apply)
Select one or more:a.Fastenersb.Tablesc.Storaged.Bookcasese.Copiersf.Furnishingsg.Bindersh.Appliancesi.Machinesj.Suppliesk.Chairsl.Phonesm.Paper
Question10
Not answeredMarked out of 1.00Flag question
Question text
Which products were driving losses overall? (Select the top 3)
Select one or more:a.
Eureka Disposable Bags for Sainitaire Vibra Groomer Upright Vacuumb.
Euro Pro Shark Stick Mini Vacuumc.
Cubify CubeX 3D Printer Double Head Printd.
Bush Westfield Collection Bookcases, Dark Cherry Finishe.
Canon imageCLASS 2200 Advanced Copierf.
Chromecraft Bull-Nose Wood Oval Conference Tables & Basesg.
Lexmark MX611dhe Monochrome Laser Printerh.
Cubify CubeX 3D Printer Triple Head Print
How many orders were unprofitable in the Central region throughout all years? (Profit =
Select one:a.418b.1,039c.1,175d.318
Question2
CompleteMark 1.00 out of 1.00Flag question
Question text
Determine which state is the least profitable overall. For the products that are unprofitable, what is the median discount given in this state? (Profit =
Select one:a.80%b.50%c.20%d.60%
Question3
CompleteMark 1.00 out of 1.00Flag question
Question text
What percentage of the year's orders occurred in Q4 of 2019?
Select one:a.36.81%b.38.20%c.37.00%d.42.12%
Question4
CompleteMark 0.00 out of 1.00Flag question
Question text
Which product(s) in the Central region have consistently had a negative profit ratio over the years?
Select one or more:a.Machinesb.Bindersc.Furnishingsd.Bookcasese.Appliancesf.Tables
Question5
Not answeredMarked out of 1.00Flag question
Question text
Which products were driving losses overall? (Select the top 3)
Select one or more:a.
Eureka Disposable Bags for Sainitaire Vibra Groomer Upright Vacuumb.
Lexmark MX611dhe Monochrome Laser Printerc.
Canon imageCLASS 2200 Advanced Copierd.
Cubify CubeX 3D Printer Double Head Printe.
Cubify CubeX 3D Printer Triple Head Printf.
Euro Pro Shark Stick Mini Vacuumg.
Bush Westfield Collection Bookcases, Dark Cherry Finishh.
Chromecraft Bull-Nose Wood Oval Conference Tables & Bases
Question6
CompleteMark 0.50 out of 1.00Flag question
Question text
The top 5 customers belong to which segment(s)?
Select one or more:a.Consumerb.Corporatec.Home Office
Question7
CompleteMark 0.00 out of 1.00Flag question
Question text
Determine which segment has the most customers. How many customers are there in this segment?Select one:a.409b.5,191c.236d.3,020
Question8
CompleteMark 1.00 out of 1.00Flag question
Question text
On average, which shipping mode has the longest number of days to ship from the order date?
Select one:a.Second Classb.First Classc.Same Dayd.Standard Class
Question9
CompleteMark 0.00 out of 1.00Flag question
Question text
For the region that saw the biggest decline in year-over-year growth in profitability from 2018 to 2019, what was the amount of decline?
Select one:a.62%b.82%c.50%d.65%
Question10
CompleteMark 0.00 out of 1.00Flag question
Question text
Which state had the largest product volume per order?
Select one:a.Californiab.New Hampshirec.New Yorkd.Vermont
Determine which state is the least profitable overall. For the products that are unprofitable, what is the median discount given in this state? (Profit =
Select one:a.20%b.50%c.80%d.60%
Question2
CompleteMark 0.00 out of 1.00Flag question
Question text
Determine which segment has the most customers. How many customers are there in this segment?Select one:a.3,020b.5,191c.409d.236
Question3
CompleteMark 0.50 out of 1.00Flag question
Question text
Which product(s) in the Central region have consistently had a negative profit ratio over the years?
Select one or more:a.Tablesb.Appliancesc.Machinesd.Binderse.Furnishingsf.Bookcases
Question4
CompleteMark 0.00 out of 1.00Flag question
Question text
For the region that saw the biggest decline in year-over-year growth in profitability from 2018 to 2019, what was the amount of decline?
Select one:a.65%b.82%c.50%d.62%
Question5
CompleteMark 1.00 out of 1.00Flag question
Question text
How many customers who ordered in 2019 also ordered in 2018?
Select one:a.135b.632c.558d.489
Question6
CompleteMark 0.57 out of 1.00Flag question
Question text
Which sub-categories are unprofitable across all regions? (Select all that apply)
Select one or more:a.Tablesb.Bindersc.Chairsd.Suppliese.Paperf.Copiersg.Furnishingsh.Storagei.Bookcasesj.Phonesk.Machinesl.Appliancesm.Fasteners
Question7
CompleteMark 0.00 out of 1.00Flag question
Question text
Which region saw the biggest decline in year-over-year growth in profitability from 2018 to 2019?
Select one:a.Westb.Southc.Centrald.East
Question8
CompleteMark 0.00 out of 1.00Flag question
Question text
How many orders were unprofitable in the Central region throughout all years? (Profit =
Select one:a.1,175b.418c.1,039d.318
Question9
CompleteMark 1.00 out of 1.00Flag question
Question text
Which state was the most profitable in 2019?
Select one:a.Washingtonb.Californiac.Texasd.New York
Question10
CompleteMark 1.00 out of 1.00Flag question
Question text
The top 5 customers belong to which segment(s)?
Select one or more:a.Home Officeb.Consumerc.Corporate