+ Reply to Thread
Results 1 to 2 of 2

Distribute variables evenly

  1. #1
    Registered User
    Join Date
    08-18-2014
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    1

    Question Distribute variables evenly

    Hi I have a row of data that I would like to distribute evenly

    Views 62 70 71 72 81 84 85 86 89 92 94 95 97 105 107 124 125 132 143 158 169 180 211 228 229 239 241 257 283 293 308 332 333 338 344 357 363 373 395 405 412 416 421 422 440 490 491 514 525 535 649 714 719 804 833 1106 1254 4480

    Sum of downloads 3 3 2 0 0 0 6 7 0 8 6 0 0 5 5 7 0 7 7 5 0 10 0 0 4 0 2 2 0 5 5 0 2 4 3 18 4 1 4 4 6 0 9 5 4 4 11 8 10 9 3 5 6 5 36 0 1

    Where I have views, I would like to distribute this evenly from the range of 0-5000 so that I can create a graph showing a correlation between the sum of downloads and the views. Is there a formula I can use to achieve this?

    Any help would be greatly appreciated, thanks
    Jovan

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Distribute variables evenly

    I'm not really sure what you mean by spreading out the data. I made some graphs that looks alright here. The cumulative makes most sense to me.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Distribute Tasks Evenly
    By karthikcoep in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2015, 05:48 AM
  2. Distribute Data Evenly
    By sohlican in forum Excel General
    Replies: 13
    Last Post: 09-19-2014, 07:37 PM
  3. Evenly distribute numbers
    By captain118 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2013, 01:27 AM
  4. Using macro to distribute task evenly
    By rename in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 09:50 PM
  5. Replies: 1
    Last Post: 05-21-2011, 09:07 AM

Tags for this Thread

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