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

Context:  Intro Change Request Definition Reasons for CRs Adaptive, predictive and mixed projects Flow of processing change requests Change Management Workflow Tools and Techniques 1. Intro  The World will never stop changing, as well as human needs and desires. The business environment evolves continually. An or...
For many people, a career in business systems analysis can be an ideal opportunity to use their skills in technology and business. Business systems analysts bring together the best of both worlds – technical know-how and business acumen – to help organizations become more efficient and effective. Here are some of the key benefits of pur...
There is no doubt in my mind that curiosity nurtures the mind when it comes to T shaped skills.  T shaped professional are specialist in something(the vertical line) and also have a wide range of skills and knowledge in a broad range of subjects(the horizontal line) and are are highly sought after in the workplace.  I’ve recently...

 






 

Copyright 2006-2023 by Modern Analyst Media LLC