Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

I don't understand the math of this --?

I have a list of 32 videos about various subjects on youtube --

(http://www.youtube.com/Nulfinator)

I have the date each video was uploaded

So I can calculate the number of days each video has been available for viewing.

I have the number of times each video is viewed.

I can therefore calculate the average times per day a video is viewed.

(I have done this in a spreadsheet.)

For instance I some videos that are watched twice a day on average (I give them a value of 2.00) -- I have other videos that are watch once every 3 days ( I give them a value of 0.333)

When I add all the average times per day the videos are viewed I get a pretty high number -- close to 30. I would say that this should represent an average day of video viewing. The sum of averages of all videos on all days.

Here is where things fall apart I very seldom get above 20 views in a day, I rarely get anywhere near 30 views per day (a better than average day) -- this seems like a huge discrepancy -- what is going on with not getting an average from a list of averages? A better than average day is almost unheard of!!

I have all this data in spreadsheet form if you'd like to see it just send me an E-mail.

Can you explain if there is some other variable I have to consider to get a accurate representation of an average day??

Thanks for your help!!

Cordially

Bill

4 Answers

Relevance
  • 1 decade ago
    Favourite answer

    I believe the solution to your quandary lies in the fact that most of the videos have been available for only a portion of the time under consideration. You are calculating the daily views for most of the videos for (different) restricted periods.

    ALGEBRA MODE ON:

    Pretend that you knew the exact number of views for each video for each day:

    Let V(k,n) = the number of views for the k-th video on the n-th day.

    Let K = the total number of videos and let N = the total number of days.

    So we can write an expression for the views on the n-th day:

    D(n) = V(1,n) + V(2,n) + ... + V(K,n)

    And the average daily views is:

    [D(1) + D(2) + ... + D(N)] / N = [ Sum all V(k,n) ] /N = Sum of all [V(k,n) / N]

    What you actually have is the Total views for each video:

    T(k) = V(k,1) + V(k,2) + ... + V(k,N)

    along with a Number of days for which V(k,n) might be non-zero: N(k) ≤ N

    You are calculating the video Average:

    A(k) = T(k) / N(k) = [V(k,1) + V(k,2) + ... + V(k,N)] / N(k)

    Then you sum these averages:

    Sum A(k) = Sum of all [V(k,n) / N(k)], with most N(k) smaller than N, hence 1/N(k) > 1/N and this sum is larger than the previous.

    As long as the different videos are available for different periods of time [N(k)<N], the sum of the average daily views for each video:

    Sum of all [V(k,n) / N(k)] > Sum of all [V(k,n) / N]

    will be greater than the average daily views for all the videos.

    ALGEBRA MODE OFF

    A non-algebraic explanation might be this: Each video is making its contribution in a different time period. They are contributing their views at different times, so you should not expect the sum of those views (from different times) to reflect the actual total for any particular time. It only provides an upper bound.

  • Anonymous
    1 decade ago

    For a given video you count the number of individual days and then the number of times each day it was viewed.

    So, say for one particular video you have:

    Day 1 (the day you placed them on youtube for viewing: 2/1 (viewed twice on this day)

    Day 2 ---- viewed 4 times: 4/2....average of 2

    Day 3 ---- viewed 9 times: 9/3....average of 3

    Day 4 ---- viewed 17 times: 17/4.....average of 4.25, but you can't view it 0.25 times so you round DOWN to the whole number of complete times it was viewed.

    And you calculate your averages this way for each video. You can easily set Excel to do this for you. Look in the Help under rounding, or truncation. You want to make sure you do NOT round the number because it could round UP, and you don't want that. You just want the whole number, and I can't recall the command that does that off hand.

    Does this help??

  • 1 decade ago

    I'm no expert on the subject, but i think your method of calculation is wrong. I'm not sure whether its the values you gave the videos based on the number of views, or whether it went wrong when you used the average of an average.

  • ?
    Lv 4
    4 years ago

    there is one in each of those reasons: a million. the instructor might no longer be available, eg, a weekend or holiday. 2. the instructor might have already defined and the pupil did no longer comprehend them - a various attitude could be triumphant. 3. Hate to sprint any idealistic objectives, yet no longer all instructors are supportive of scholars. some only call you an fool for no longer information.

Still have questions? Get answers by asking now.