Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I attached the Excel data. Please use the Excel data I attached. R75 viXfx A B C D E F G H J K L

I attached the Excel data. Please use the Excel data I attached.

image text in transcribed
R75 viXfx A B C D E F G H J K L M N O P Q Fuel consumption calculator Metric units (km, L) BBP W N Odometer Fuel Cost of the Date (total) Filled volume 100% filled? Accumulated Refill cost Consumption km Statistics General Last X refills price dd/mm/yyyy km $/L km $ km/L L/100km |miles/gallon $/km Total distance km 5690 490 2010/3/21 72000 20 1.75 Yes 35 Total fuel volume L 572 145 2010/3/25 72300 30 1.6 No 300 30 48 Total spent $ 810.1 188.5 2010/3/29 72800 30 1.55 No 800 60 46.5 Average consumption km/L 10.5 10.3 2010/4/2 72950 30 1.4 No 950 90 42 Minumum consumption km/L 8.2 8.2 2010/4/6 73200 30 1.39 No 1200 120 41.7 Maximum consumption km/L 13.0 13.0 2010/4/10 73500 30 1.39 Yes 1500 150 41.7 10.0 10.0 23.5 0.14 Average km cost $/km 0.13 0. 13 12 2010/4/14 73800 29 1.37 Yes 300 29 39.73 10.3 9.7 24.3 0.13 Minumum km cost $/km 0.10 0.11 13 2010/4/18 74100 25 1.4 No 300 25 35 Maximum km cost $/km 0. 16 0. 16 14 2010/4/22 74400 32 1.29 Yes 500 57 41.28 10.5 9.5 24.8 0.13 Total refills done 20 15 2010/4/26 74700 24 1.34 Yes 300 24 32.16 12.5 8.0 29.4 0.10 Considered period days 76 161 16 2010/4/30 75000 32 1.5 No 300 32 48 17 2010/5/4 75300 31 1.6 Yes 600 63 49.6 9.5 10.5 22.4 0.16 X= 5 18 2010/5/8 75600 25 1.6 Yes 300 25 40 120 8.3 28.2 0.13 19 2010/5/12 75900 27 1.4 Yes 300 27 37.8 11.1 9.0 26.1 0.14 Consumption x Distance 20 2010/5/16 76200 32 1.35 Yes 300 32 43.2 9.4 10.7 22.1 0.15 14.0 21 2010/5/20 76550 31 1.25 Yes 350 31 38.75 11.3 8.9 26.6 0.12 22 2010/5/24 76820 30 1.32 Yes 270 30 39.6 9.0 11.1 21.2 0.14 12.0 23 2010/5/28 77110 29 1.4 Yes 290 29 40.6 10.0 10.0 23.5 0.13 24 2010/6/1 77460 27 1.33 Yes 350 27 35.91 13.0 7.7 30.5 0.11 10. 25 2010/6/5 77690 28 1.2 Yes 230 28 33.6 8.2 12.2 19.3 0. 16 8.0 26 Consumption (km/L) 27 6.0 28 4.0 29 INSTRUCTIONS METRIC US Plan2 +

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

Anatomy Of A Fraud Investigation

Authors: Stephen Pedneault

1st Edition

470560479, 978-0470560471

More Books

Students also viewed these Economics questions