Data Analysis Question


by bloynoys
Tags: analysis, data
bloynoys
bloynoys is offline
#1
Feb4-13, 02:42 PM
P: 24
Hey guys, I have a question of how to go about answering a question. I am trying to decide what coding/database language to learn next (most likely SQL with some access thrown in), but have an overall question.

I am looking for an application or way to crunch daily statistical updates, then calculate distributions from that, then go back and compare numbers to distribution. So ideally, there are 1000 people, they do things on a daily basis in many different variables, these get tabulated and updated daily, I would like a program or write one that takes these creates a distribution for each column variable from data and then goes back and compares each individual statistic to overall distribution and color coats it (or another defining way of showing that) depending on where they are in the distribution. Like white is people in the top 5% of that variable, yellow shows the next 15% etc etc. Is there a way to do this easier than epically long formulas in excel and more automated to read in daily stat updates?

Thanks!
Phys.Org News Partner Science news on Phys.org
Cougars' diverse diet helped them survive the Pleistocene mass extinction
Cyber risks can cause disruption on scale of 2008 crisis, study says
Mantis shrimp stronger than airplanes
mfb
mfb is offline
#2
Feb4-13, 02:51 PM
Mentor
P: 10,846
All common statistics tools should be able to do that.
If you have data as list (name,value), marking the top 5%/20%/... is easy with excel as well, and you don't need those tools. You could probably import data with a macro.


Register to reply

Related Discussions
Data Analysis Question Introductory Physics Homework 0
Data Analysis Introductory Physics Homework 0
Data analysis question... Introductory Physics Homework 3
data analysis Atomic, Solid State, Comp. Physics 2
Analysis of xrd data Introductory Physics Homework 0