1. Math
  2. Advanced Math
  3. there is more data given but this is just a...

Question: there is more data given but this is just a...

Question details

There is more data given but this is just a smaller version i was wondering if someone could show me step by step how to do this on spreadsheet please?

2. A fuel log is given belovw a. Determine the average fuel consumption for the year b. Determine the day with the highest fuel consumptions c. Determine how many days had above average fuel consumption date fuel used (gallons) 1/1/2015 1/2/2015 1/3/2015 1/4/2015 1/5/2015 1/6/2015 1/7/2015 1/8/2015 1/9/2015 1073 1578 1025 1382 1511 1853 1296 1248 1785 1/10/2015 1565 1/11/2015 1985 1/12/2015 1617 1/13/2015 1214 1/14/2015 1397 1/15/2015 1437 1/16/2015 1910 1/17/2015 1056 1/18/2015 1527 1/19/2015 1255 1/20/2015 1085 1/21/2015 1854 1/22/2015 1597 1/23/2015 1681 1/24/2015 1370 1/25/2015 1842 1/26/2015 1451 1/27/2015 1923 1/28/2015 1935 1/29/2015 1346

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution