Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-29-2016, 12:45 PM   #1
In Runtime
 
alex_boothby's Avatar
 
Join Date: Apr 2005
Posts: 309
Send a message via MSN to alex_boothby
Default Excel Help

Hi Guys,

Hoping someone who is a whiz at excel can help.

So I want to find out yearly mileage increases of my car. I have ten years of mileage entries, but they are at random times a year an not one year apart each time.

Is there a way I can get excel to calculate a estimated annual mileage for each year?

I'm guessing I could just plot a graph and use a trend line and pick out the same time of year, but I'm sure there is a smarter way!

I tend to come across this problem a lot!

Here is my data if that helps

I'm hoping this makes sense....

Mileage Date
10168 04/09/2007
19906 05/03/2008
30601 01/10/2008
40405 05/10/2009
40577 08/10/2009
49782 05/07/2010
50434 27/07/2010
54499 09/06/2011
68732 31/05/2012
83197 17/12/2014
90225 11/12/2015
95623 23/02/2016
__________________

alex_boothby is offline   Reply With Quote
Old 09-29-2016, 01:06 PM   #2
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 7,893
Default Re: Excel Help

you can just subtract dates in the format that you have to get a day count.

e.g 23/02/2016-11/12/2015 = 74

or more appropriatly
23/02/2016 - 04/09/2007 = 3094 (days)
3094 days / 365 = 8.47 years

95623 - 10168 = 85455

85455 miles / 8.47 years = 10081.15 miles per year average
__________________

__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 09-29-2016, 08:09 PM   #3
Daemon Poster
 
Technician's Avatar
 
Join Date: Feb 2016
Location: US
Posts: 503
Default Re: Excel Help

Quote:
Originally Posted by root View Post
you can just subtract dates in the format that you have to get a day count.

e.g 23/02/2016-11/12/2015 = 74

or more appropriatly
23/02/2016 - 04/09/2007 = 3094 (days)
3094 days / 365 = 8.47 years

95623 - 10168 = 85455

85455 miles / 8.47 years = 10081.15 miles per year average
This method will only show an average, but not show if there is a year over year increase, ie "I drove twice as far in 2006 compared to 2005"...etc.
Technician is offline   Reply With Quote
Reply

Tags
excel, stats

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 01:43 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0