Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve all, they are the same question Exercise 1-17 (Static) (L01-2) MarkLines is an online portal (www.marklines.com) that reports automotive Industry data. The table

Please solve all, they are the same question image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Exercise 1-17 (Static) (L01-2) MarkLines is an online portal (www.marklines.com) that reports automotive Industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year's sales. Manufacturer GM (Et.) Ford Toyota Tint Chrysler Honda Nissan Hyundai Subaru Kia Mercedes (includes Sprinter) BMW VW Maxda Audi Tesla (Est.) Land Rover Volvo Mitsubishi Porsche MINI Jaguar Others smart Car Sales Janov Jan-Nov. 2017 2010 2,691,493 2,654,568 2,334,290 2,265,590 2,211,533 2,205,762 1,887,430 2,038,684 1,492,112 1,449,713 1,455,238 1,345,157 621,961 612,225 504.614 615,594 546,629 542,265 332,990 310,012 271,432 276,657 309,395 322,012 262,577 274,455 199.534 200.550 40,320 106,050 66,759 61,526 71,828 89,437 55,185 109,088 51,507 53,116 42,494 40,887 36,180 27.021 18,901 17,251 2.905 1.154 a. Using computer software, compare 2017 sales to the 2018 sales for each manufacturer by computing the difference. Make a list of the manufacturers that increased sales compared to 2017, make a list of manufacturers that decreased sales. Which manufacturers are in the top five with increased sales? Which manufacturers are in the bottom five with decreased sales? (Enter values in decreasing order and negative values with a minus sign.) Top five Monufacturer Difference from 2017 to 2018 Bottom five Manufacturer Difference from 2017 to 2018 Prey 1 of 9 Next > b. Using computer software, compare 2017 sales to 2018 sales for each manufacturer by computing the percentage change in sales. Make a list of the manufacturers in order of increasing percentage changes. Which manufacturers are in the top five in percentage change? Which manufacturers are in the bottom five in percentage change? (Enter values in decreasing order and negative values with a minus sign. Round percentage answers to 1 decimal place.) Top five Manufacturer % change from 2017 % % % 39 % Bottom five Manufacturer % change from 2017 % % c.1. Using computer software, first sort the data using the 2018 year-to-date sales. Then, design a bar graph to illustrate the 2017 and 2018 year-to-date sales for the top 10 manufacturers and select the most appropriate graph below. Bar Graph Bar Graph Year-to-date Unit Sales through November, 2017 and 2018 Year-to-date Unit Sales through November, 2017 and 2018 30,00.000 30,00.000 25,00,000 25,00,000 20,00.000 2000.000 Sales 15,00.000 Through November 2017 Through November 2018 15.00,000 Through Through 10,00 000 10,00.000 5,00,000 500.000 0 ford isan Wonde Hyundai Ford Toyota GM) yote Fut Chrysler Future GM) Bar Graph A O Bar Graph Bar Graph c-2. Design a bar graph to illustrate the percentage change for the top 10 manufacturers and select the most appropriate graph below. Bar Graph * Change 2017-2018, year-to-date November, Top Ten Manufacturers Bac Graphen *Change 2017-2018, year to date November, Top Ten Manufacturers Ford GM Toyota Flat Curse Soba Hyd Ford Toyota et Chrysler Honda N ME 10.00 MOON 6.00 400N 2.ON GOON 2001 400 -6.00% ON 300N 10 DON BOON GOON 4.00 2.00 GOON 200 LOOM -600N BOON 1000N OB Graph A O Bar Graph B Bar Graph

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions