+ Reply to Thread
Results 1 to 4 of 4

Determing Average Intensity, not as simple as using avg

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Determing Average Intensity, not as simple as using avg

    For a weight lifting calculator I have a column where the reps performed are entered and a column for the intensity. Since each set may have a different number of reps performed determining the average intensity isn't as easy as using avg and the selected range. What formula will take the number of reps into consideration when determining average intensity?

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Determing Average Intensity, not as simple as using avg

    Hi -

    I'm no fitness expert, but it sounds like you might want to use a weighted average. For example, say you did 10 curls at an intensity of 50 lb. Then you did 8 curls at 55 lb, 6 curls at 60 lb, and finished with 4 curls at 65 lb.

    You could express the weighted average intensity as the sum of the number of curls times the intensity all divided by the sum of the total number of curls.

    For our example, it would be (10*50 + 8*55 + 6*60 + 4*65)/(10+8+6+4)

    That equals 1560/28 = 55.7 lb. In other words the average intensity of the workout is about 56 lb. If weight is not your measure of intensity, you could substitute time (e.g., number of reps in 20 seconds).

    Not sure if that's what you're looking for, but i hope it helps.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Registered User
    Join Date
    04-14-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Determing Average Intensity, not as simple as using avg

    Use a weighted average. (RepsA/TotalReps)*IntensityA + (RepsB/TotalReps)*IntensityB + (RepsC/TotalReps)*IntensityC ...

    where TotalReps = RepsA + RepsB + Reps C ...

  4. #4
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Determing Average Intensity, not as simple as using avg

    I di some thinking and came up with a different route to this, thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1