• Support PF! Buy your school textbooks, materials and every day products Here!

Finding upper and lower limits of a graph

  • Thread starter Aki
  • Start date
  • #1
Aki
82
0

Homework Statement


This is not really a homework problem, but it looks like a rather easy problem that I can't quite figure out.

So I have a graph like shown in the attachment: a quantity vs time graph with some data points. I had no problem finding the average, but now I want to find both an upper and lower limits that would enclose 80% of the data points (so like what I have drawn in the graph). My question is: how can I do that using a simple program like Excel?


Homework Equations


I tried applying Chebycheff's Inequality
http://en.wikipedia.org/wiki/Standard_deviation" [Broken]

For 80% of the data points, I found the number of standard deviations from the average would be SquareRoot 5. So (SquareRoot 5 * Standard Deviation)/2 , and then add and subtract that from the average to find the limits.

The Attempt at a Solution


Chebycheff's Inequality worked for most graphs. However, for some graphs, I would get a negative value for the lower limit and that's not what I want to see.


Thanks for the help!
 

Attachments

Last edited by a moderator:

Answers and Replies

  • #2
HallsofIvy
Science Advisor
Homework Helper
41,770
911
Chebycheff's Inequality will give difference from the mean. Since here the mean is 80 I don't think you are in any danger of getting a negative lower limit!
 
  • #3
Aki
82
0
Chebycheff's Inequality will give difference from the mean. Since here the mean is 80 I don't think you are in any danger of getting a negative lower limit!
well I just made up that graph. I can't show the data that I'm working with because it's confidential. Anyhow, there are graphs where if I apply the Chebycheff's Inequality, I get a negative value for the lower limit.
 

Related Threads for: Finding upper and lower limits of a graph

Replies
1
Views
8K
Replies
3
Views
4K
  • Last Post
Replies
4
Views
14K
  • Last Post
Replies
2
Views
5K
  • Last Post
Replies
5
Views
2K
Replies
13
Views
443
Replies
4
Views
1K
Top