Results 1 to 2 of 2

Thread: Calculate contribution weight of an average

  1. #1
    Newbie
    Joined
    Apr 2017
    From
    St Louis
    Posts
    1

    Calculate contribution weight of an average

    My data set is looking at a bunch of rental car transactions. I grouped all the rentals together by what type of vehicle was rented. I have the numbers of rentals (how many times a vehicle was rented), Number of rental days (how many calendar days the rental went out for) , and the total amount it cost for the entire rental. From that I calculate the the average amount per calendar day it cost the rent a certain vehicle ( Total Rental Amount / number of rental days). I am comparing two calendar years (2015 & 2016).

    What I need to get is the dollar amount each vehicle contributed to the total average growth year over year.



    Calculate contribution weight of an average-math-assist..jpg

    An example of what it would look like if below ( these are not correct, just to show what the outcome would look like

    Calculate contribution weight of an average-math-assist1.jpg


    Thanks for any help. Excel Sheet is attached
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    6,577
    Thanks
    1711

    Re: Calculate contribution weight of an average

    Hey Terriault.

    I'd recommend setting up a conditional expectation with a linear model.

    If you have a value of growth for each year as a function of year with a linear model [possibly generalized depending on the model parameters and constraints] then you can estimate the growth random variable as a function and plot it.

    What experience do you have with linear models and statistics?
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Calculate the average over the given interval.
    Posted in the Calculus Forum
    Replies: 4
    Last Post: Sep 9th 2013, 08:55 PM
  2. Replies: 12
    Last Post: Aug 25th 2011, 09:10 PM
  3. Calculate Weighted Average
    Posted in the Statistics Forum
    Replies: 2
    Last Post: Aug 3rd 2010, 11:44 PM
  4. Average weight of water
    Posted in the Calculus Forum
    Replies: 2
    Last Post: Aug 14th 2009, 10:35 PM

/mathhelpforum @mathhelpforum