Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
Photo
- - - - -

help with data points

excel formula

  • Please log in to reply
1 reply to this topic

#1 molbio1234

molbio1234

    Enthusiast

  • Active Members
  • PipPipPipPipPip
  • 57 posts
2
Neutral

Posted 23 July 2013 - 05:02 AM

If I have a set of 3 data points, 27, 26, 35 and another set of 3 data points: 26, 26, 27, what is the excel formula that tells me that in first set of data there is a discrepency (the 35 is an outlier).

#2 DRT

DRT

    Veteran

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 161 posts
7
Neutral

Posted 24 July 2013 - 11:53 AM

You mean the delete key?Posted Image

There are a number of tests available for identifying outliers (or, more correctly, identifying when the population is non-normal). The simple ones can be easily performed in Excel with the t.test function.
But ignoring outliers is a dangerous route to go down and can easily start to look like falsifying data. Better to repeat the experiment to gather more data and tighten the parameter estimation.




Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.