- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Using standard deviation in excel to check for errors
Posted on 4/15/18 at 1:01 pm
Posted on 4/15/18 at 1:01 pm
Is this a realistic way to check for errors in excel? The formula is pretty simple and once you build a large enough dataset, I think it could be a start. What do the tech people think?
5
Posted on 4/15/18 at 1:17 pm to athenslife101
Errors in what? What kind of error?
Posted on 4/15/18 at 1:41 pm to athenslife101
It’s a realistic way to illuminate outliers.
Posted on 4/15/18 at 2:08 pm to Brisketeer
That’s what I’m thinking. At the very least, it can point you to the right direction of what’s wrong.
Posted on 4/15/18 at 7:47 pm to Brisketeer
i would think CV would do a better job, but thats not what he is asking...
and the answer is no, google cv and sd calculator, Westgard.
and the answer is no, google cv and sd calculator, Westgard.
Posted on 4/16/18 at 6:54 am to athenslife101
Do you mean the Z score for a given observation? Standard deviation by itself will just tell you how much variation there is for a sample or the entire population.
At any rate, nothing will confirm there is an error. In fact, you can get yourself in a subtle bit of trouble by only taking a close look at observations with a high Z score and ignoring the rest. Just because something fits in with the rest of the population doesn't mean it is correct.
At any rate, nothing will confirm there is an error. In fact, you can get yourself in a subtle bit of trouble by only taking a close look at observations with a high Z score and ignoring the rest. Just because something fits in with the rest of the population doesn't mean it is correct.
Posted on 4/18/18 at 6:30 am to LSUtigerME
Type 1 or Type 2?
Posted on 4/18/18 at 7:33 am to athenslife101
All standard deviation can tell you is if some data points are well inside or well outside the mean.
You can set up a conditonal to highlight of certain st devs are above a certain value.
You can set up a conditonal to highlight of certain st devs are above a certain value.
Posted on 4/18/18 at 2:47 pm to athenslife101
This is less of a tech question and more of a business analytics question. You are going to need to give much more detail or what you are trying to do for us to be helpful...context is really important and a number of posters have laid out potential uses cases for standard devotions, zscores, conditional formatting, but there is no way for us to tell you what is the appropriate approach.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News