Results 1 to 6 of 6

Math Help - Formula for data set that increases daily

  1. #1
    Newbie
    Joined
    Jul 2012
    From
    CA
    Posts
    3

    Formula for data set that increases daily

    I know this is an easy one. Just shows you need math after all!

    I need to figure out the formula to use in order to project out how much space will be needed for a data project.
    Baseline of 22,000 files
    This increases by 100 each day
    Size is 80,000 per file

    How would I formulate that so I can figure out where it would be in 20 days, 50 days, 120 days, etc.? I'm ultimately going to put this into Excel.

    Thanks for the help!
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor

    Joined
    Apr 2005
    Posts
    15,707
    Thanks
    1470

    Re: Formula for data set that increases daily

    After d days, the number of files would be 22000+ 100d. The size would be 80000(22000+ 100d).
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Jul 2012
    From
    CA
    Posts
    3

    Re: Formula for data set that increases daily

    I had that....but I need to add that 100 per day to the calculation. Sort of like compound interest.

    Day 1 = 22000
    Day 2 = 22000 + 100 = 22100
    Day 3 = 22100 + 100 = 22200
    Day 4 = 22200 + 100 = 22300

    I can do it the hard way in Excel.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,102
    Thanks
    68

    Re: Formula for data set that increases daily

    Quote Originally Posted by mvalpreda View Post
    I had that....but I need to add that 100 per day to the calculation. Sort of like compound interest.
    Day 1 = 22000
    Day 2 = 22000 + 100 = 22100
    Day 3 = 22100 + 100 = 22200
    Day 4 = 22200 + 100 = 22300
    I can do it the hard way in Excel.
    Halls gave you the proper formula. Do you not see how it works?
    Your example is d=3: 3 days later; 22000 + 100d = 22000 + 100(3) = 22000 + 300 = 22300.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Jul 2012
    From
    CA
    Posts
    3

    Re: Formula for data set that increases daily

    Yes, I just realized I'm an idiot. I was over-thinking it and for some reason was thinking it was percentage and not an absolute number.

    I had it figured out on my own before. Derp.
    Follow Math Help Forum on Facebook and Google+

  6. #6
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,102
    Thanks
    68

    Re: Formula for data set that increases daily

    STOP IT! We've all done something like that before !
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 2
    Last Post: March 11th 2011, 02:32 AM
  2. Entropy increases as number of bins increases
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: February 24th 2011, 12:14 PM
  3. Working out a formula from a set of data
    Posted in the Algebra Forum
    Replies: 1
    Last Post: June 9th 2010, 03:18 AM
  4. Formula needed, all data available
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: November 26th 2009, 08:10 AM
  5. Finding a formula for this data
    Posted in the Algebra Forum
    Replies: 2
    Last Post: October 17th 2009, 07:58 AM

Search Tags


/mathhelpforum @mathhelpforum