Results 1 to 4 of 4

Math Help - Explaining a trend in the data.

  1. #1
    Newbie
    Joined
    Mar 2011
    Posts
    3

    Question Explaining a trend in the data.

    Yr 1HoursDollarsRateYr 2HoursDollarsRateDeltasHrs growth$ GrowthRate Difa.214.2$6,135 $28.64 a.258.3$7,292 $28.23 a.20.6%18.9%-1.4%b.152.3$6,494 $42.63 b.155.3$6,685 $43.06 b.1.9%3.0%1.0%total366.5$12,629 $34.45 total413.6$13,977 $33.80 total12.8%10.7%-1.9%

    Here is the situation, I have total hours and dollars for group a and b in yr 1 and 2. I calculated a rate for each group (dollars/hours), then a weighted rate for each year with the two groups combined. I am analyzing several aspects of these numbers in the 3 (delta) section. The delta section is nothing more than the growth from year 1 to year 2. The calculation is (yr2-yr1)/yr1 gives me the escalation (or de-escalation as the case may be). My question is this: How the heck is there a -1.4% movement in group a and 1.0% movement in group b and a combination of the two of -1.9%?

    I am baffled and distraught.. would appreciate any help on this.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Mar 2011
    Posts
    3
    sorry, my table is ruined when copy and pasted...here it is as a picture:

    [/IMG]
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Senior Member
    Joined
    Nov 2010
    From
    Clarksville, ARk
    Posts
    398
    Quote Originally Posted by cantfigurethisout View Post
    Yr 1HoursDollarsRateYr 2HoursDollarsRateDeltasHrs growth$ GrowthRate Difa.214.2$6,135 $28.64 a.258.3$7,292 $28.23 a.20.6%18.9%-1.4%b.152.3$6,494 $42.63 b.155.3$6,685 $43.06 b.1.9%3.0%1.0%total366.5$12,629 $34.45 total413.6$13,977 $33.80 total12.8%10.7%-1.9%

    Here is the situation, I have total hours and dollars for group a and b in yr 1 and 2. I calculated a rate for each group (dollars/hours), then a weighted rate for each year with the two groups combined. I am analyzing several aspects of these numbers in the 3 (delta) section. The delta section is nothing more than the growth from year 1 to year 2. The calculation is (yr2-yr1)/yr1 gives me the escalation (or de-escalation as the case may be). My question is this: How the heck is there a -1.4% movement in group a and 1.0% movement in group b and a combination of the two of -1.9%?

    I am baffled and distraught.. would appreciate any help on this.
    What numbers did you put together to get the "Rate Difference"?
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Newbie
    Joined
    Mar 2011
    Posts
    3
    rate dif is the difference in rate from yr 1 to yr 2. I believe the calc is (yr2-yr1)/yr1
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. How can I tell if my trend is real?
    Posted in the Advanced Statistics Forum
    Replies: 8
    Last Post: June 24th 2011, 02:32 PM
  2. Replies: 4
    Last Post: August 13th 2010, 10:22 AM
  3. Curve trend
    Posted in the Advanced Statistics Forum
    Replies: 4
    Last Post: August 8th 2009, 01:38 AM
  4. Replies: 1
    Last Post: December 11th 2008, 08:57 PM
  5. Need a term for a trend
    Posted in the Math Topics Forum
    Replies: 4
    Last Post: January 15th 2007, 12:04 AM

Search Tags


/mathhelpforum @mathhelpforum