Results 1 to 20 of 60

Thread: How to analyze big data with Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    VBAX Contributor
    Joined
    Jul 2018
    Posts
    174
    Location
    Hi Paul,

    thank you for your reply! I have read all of your posts again and you are spot on!

    I donīt want to double count and I donīt want to use the A way.

    I have condensed my metrics down to two metrics.

    Metric A is the score of city vs city. Metric B is the score of city vs state. I am planning to weight my metrics 50% and 50%. So city01 vs city02 in metric A could be 55 and metric B could be 77. Metric A is a combination of other metrics and a score of 55 means that there are 55 comparisons where metric A is above the City 2 value and 77 is also a combination of metrics where metric B is above or equal to the state mean.

    Ex. City01 has a value of size that is greater then City02 and also greater then the state mean. The state mean is calculated from all cities in that state.

    So what I am trying to do now is to get my output (in the attachment above) to be as in your example.

    But I am not sure how?
    Last edited by waimea; 04-19-2019 at 01:21 PM.

Posting Permissions

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