Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  General  Ways to extract a metric?
Previous Previous
 
Next Next
New Post 6/17/2020 11:33 AM
Unresolved
User is offline eci
1 posts
No Ranking


Ways to extract a metric? 

Hi,

I have a business dataset, which has a few columns:

 DeviceModel, DeviceSN, Bin, DurationInMin

The DurationInMin tells how long the device stay in each Bin. The range of Bin is from 1 to 20.  Normally most devices stay in the lower bin for a long time. We want to know the difference of the duration in each bin by each device model. 

What's the best way to find a metric to find the distribution of the data?  My first attempt is to calculate percentage of time each device spend in each bin, then sum it up by bin. The cons for this method is if  we have devices always stay in one bin for long time, it will blow up our data. I need help with finding other ways help with this problem.

 

Thanks,

 Eci

 

 

 

 

 

 

 

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  General  Ways to extract a metric?

Community Blog - Latest Posts

Is Agile a reason to avoid documentation? I bet this question shows up again and again while working with product requirements. On one side, we have got long specifications, complicated diagrams, mystical technical design, too many prototypes and pretty obvious for engineers user guides (do we really need so much?). On the other side, can we actual...
The cloud-native application development has helped enterprises all around the globe reduce time-to-market, enhance performance, and develop agility and flexibility. Several enterprises are achieving these results by migrating their systems or traditional monolithic applications to the cloud. But to gain from the real benefits of cloud technology, ...
So you’ve found the perfect time and place to study and you’re ready to finally get some work done. You’ve pulled out your laptop, your textbook, and your notes, and four different highlighters. After five minutes of reading your textbook, you start zoning out and thinking about puppies. Then, you go on Tumblr and look at cut...

 



Upcoming Live Webinars




 

Copyright 2006-2021 by Modern Analyst Media LLC