Line of best fit - for logarithmic-like dataset

  • Context: Undergrad 
  • Thread starter Thread starter Phystudent91
  • Start date Start date
  • Tags Tags
    Fit Line
Click For Summary

Discussion Overview

The discussion revolves around finding a suitable line of best fit for a dataset related to air filter performance, specifically focusing on the relationship between filter height and filtration percentage. The dataset exhibits characteristics that suggest a logarithmic or exponential-like behavior, with constraints such as not exceeding 100% filtration.

Discussion Character

  • Exploratory
  • Technical explanation
  • Mathematical reasoning

Main Points Raised

  • One participant presents a dataset with four data points and describes the challenge of fitting a logarithmic curve due to the nature of the data, which does not exceed 100% filtration.
  • Another participant suggests adding an additional data point at x=1 billion, y=100% to help define the curve better.
  • A different participant proposes a model of the form y = 1 - (1 - a_1)e^{-a_2 x} for nonlinear fitting, noting that knowing f(0) = 0.21 can help determine one of the parameters.
  • Another suggestion involves transforming the model to a linear form by plotting ln(1-y) against x to facilitate fitting.

Areas of Agreement / Disagreement

Participants present multiple modeling approaches and suggestions, indicating that there is no consensus on a single method or model that fits the data adequately.

Contextual Notes

The discussion includes various assumptions about the data behavior and the potential need for additional data points, which may affect the fitting process. The limitations of the proposed models in accurately representing the dataset are acknowledged but not resolved.

Who May Find This Useful

This discussion may be useful for individuals working with similar datasets in fields such as engineering, data analysis, or any area requiring modeling of asymptotic behavior in data.

Phystudent91
Messages
6
Reaction score
0
Hi all,

Firstly, hope I'm posting in the right place!

I'm working with a company that works with air filters. Without going into specifics etc, I have 4 data points:

| x | y |
|0mm|21%|
|150mm|59.6%|
|300mm|83%|
|550mm|90%|

where x is Filter Height and y is Filtration.
(Apologies for bad formatting - I looked but couldn't find the syntax anywhere for posting in a table!)


In the title, I've called it 'logarithmic-like' and what I mean by that is that it will not go above 100% (obviously) and looking at the data points, it's got a definite exponential fall off.

21% at 0mm I know sounds weird, but it's a characteristic of the system which, through laziness and some contractual NDA stuff, I won't go in to.

I've used 3 different graph-drawing softwares (Excel, JMP 11 and graph) + WolframAlpha and have come to the conclusion that it isn't possible to alter the curve of a logarithmic plot enough to fit this data.

I've also tried flipping the data and an exponential won't fit - x^2 does, but doesn't asymptote at 100%, so isn't really accurate enough. Increasing the power just makes any graphical software peak between the 1st and second points and then rise to the rest.

TLDR;

I have this data set (above) and I'm attempting to find a line of best fit so that we can design a unit and "know" what filtration it will give. Can anyone help me with a way of finding a formula that fits or a piece of software that will?

Thanks in advance!
 
Physics news on Phys.org
One method that might work is to add one more data point: x=1 billion, y = 100%.
 
You could try modeling it with y = 1 - (1 - a_1)e^{-a_2 x} and perform a nonlinear fit to estimate the parameters. And if you know that f(0) = 0.21 then you know one of the parameters, y = 1 - 0.79e^{-a_2 x} , a_1 = 0.21.

ExpNonLinFit1407220716.png
 
  • Like
Likes   Reactions: 1 person
da_nang said:
You could try modeling it with y = 1 - (1 - a_1)e^{-a_2 x} and perform a nonlinear fit
You could make it linear:
ln(1-y) = ln(1-a1) - a2x
Plot ln(1-y) against x.
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 12 ·
Replies
12
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 1 ·
Replies
1
Views
5K
  • · Replies 14 ·
Replies
14
Views
4K
  • · Replies 4 ·
Replies
4
Views
4K
  • · Replies 9 ·
Replies
9
Views
4K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K