Question: Help me, I need to create an excel dashboard but there are too many data.. I don't know how to separate them.. please give me

Help me, I need to create an excel dashboard but there are too many data.. I don't know how to separate them.. please give me idea The data was extracted from the 1974 Motor Trend US magazine, and comprises fuel consumption and 10 aspects of automobile design and performance for 32 automobiles 1973- 1974 models

mpg	Miles/(US) gallon
cyl	Number of cylinders
disp	Displacement (cu.in.)
hp	Gross horsepower
drat	Rear axle ratio
wt	Weight (1000 lbs)
qsec	1/4 mile time
vs	V/S
am	Transmission (0 = automatic, 1 = manual)
gear	Number of forward gears
carb	Number of carburetors

Help me, I need to create an excel dashboard but

Cars Mpg Cyl Disp Hp 21 6 160 110 Drat Wt Osec Vs Am Gear Carb 3.9 2.62 16.46 0 1 4 4 4 21 6 160 110 3.9 2.875 17.02 0 1 4 4 22.8 4 1 1 4 1 Mazda RX4 Mazda RX4 Wag Datsun 710 Hornet 4 Drive Hornet Sportabout Valiant 108 93 258 110 3.85 2.32 18.61 3.08 3.215 19.44 21.4 6 1 0 3 1 18.7 8 360 175 3.15 3.44 17.02 0 0 3 2 2.76 1 0 1 18.1 14.3 3 3 Duster 360 0 0 4 Mere 240D 24.4 1 0 4 4 2 1 4 2 0 0 3.21 3.69 3.92 3.92 3.92 3.07 1 4 4 6 225 105 8 360 245 4 146.7 62 4 140.8 95 6 167.6 123 6 167.6 123 8 275.8 180 8 275.8 180 8 275.8 180 8 472 205 3.46 20.22 3.57 15.84 3.19 20 3.15 22.9 3.44 18.3 3.44 18.9 4.07 17.4 3.73 17.6 3.78 18 5.25 17.98 1 22.8 19.2 17.8 16.4 17.3 15.2 10.4 0 4 4 0 0 0 0 3 3.07 3.07 2.93 3 3 3 3 3 3 3 4 0 0 0 0 10.4 8 460 215 3 5.424 17.82 0 0 3 0 3 4 4 Mere 230 Mere 280 Mere 280C Merc 450SE Merc 450SL Merc 450SLC Cadillac Fleetwood Lincoln Continental Chrysler Imperial Fiat 128 Honda Civic Toyota Corolla Toyota Corona Dodge Challenger AMC Javelin Camaro Z28 Pontiac Firebird Fiat X1-9 Porsche 914-2 Lotus Europa Ford Pantera L Ferrari Dino Maserati Bora Volvo 142E 4 14.7 32.4 30.4 33.9 21.5 15.5 15.2 13.3 19.2 27.3 8 440 230 4 78.7 66 4 75.7 52 4 71.1 65 4 120.1 97 8 318 150 8 304 150 8 350 245 8 400 175 4 79 66 4 120.3 91 4 95.1 113 8 351 264 6 145 175 8 301 335 4 121 109 3.23 5.345 17.42 4.08 2.2 19.47 4.93 1.615 18.52 4.22 1.835 19.9 3.7 2.465 20.01 2.76 3.52 16.87 3.15 3.435 17.3 3.73 3.84 15.41 3.08 3.845 17.05 4.08 1.935 18.9 4.43 2.14 16.7 3.77 1.513 16.9 4.22 3.17 14.5 3.62 2.77 15.5 3.54 3.57 14.6 4.11 2.78 18.6 1 1 1 1 0 0 0 0 1 0 1 0 0 0 1 0 1 1 1 0 0 0 0 0 1 1 1 1 1 1 1 3 3 3 3 3 4 5 5 5 5 5 4 4 1 2 1 1 2 2 4 2 1 2 2 4 6 8 2 26 30.4 15.8 19.7 15 21.4

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 General Management Questions!

Discussion Board Week 2 1. "Estimating Demand and Its Elasticities" and Statistical Estimation of the Demand Curve During the Weekly Scenarios Herb Jones, a graduate student and part-time data...

self_reported_type service_time redirect_time arrival_time 1 1 7.535305743 0 2019-04-01 6:01 2 2 8.667680283 0 2019-04-01 6:02 3 1 0.5 0 2019-04-01 6:05 4 1 7.036390086 0 2019-04-01 6:05 5 1...

If possible don't describe steps but otherwise show the excel calculations and results. At least the first part/question!!!!! should include one Excel file with the master budget and 2 dashboard...

please see attachment for instructions,Only the following budget spreadsheets are to be included: Sales, Collections, and Production. Be sure to use Word Wrapping, Alignment, and Punctuation for...

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...

Using the link attach create a master budget. This assignment is to be submitted using an Excel XLS or XLSX workbook. Each budget schedule is to be contained on a separate spreadsheet tab. You are to...

Requirement 1 : The following articles will introduce you to the intersection of big data and the accounting profession. Even if you are working in groups, I expect EVERY STUDENT to read ALL of these...

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

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Sylvia Williams bought a microwave oven that had been reduced by 30% to $340. What was the original price of the oven? Round to the nearest dollar.

Willaby Company had net sales of $248,000 and cost of goods sold of $114,080. Calculate and interpret the gross profit ratio, assuming the gross profit ratio for the industry is an average of 53%.

Dera purchased $10,000 in Chevron Corp. stock at the beginning of the year he receives 40 dividends in the stock worth 11435 at the end of the year Door still owns the stock what is the rate of return

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...