I have a small maths problem. I am trying to create a relationship between two sets of numbers. The non-linear value comes from a light sensor and the other set of values are LUX levels. The values are as follows :-
I have plotted these values out and they appear to give a decaying exponential curve. What I am aiming for is two cells in excel, one in which I can enter a LuX value and the other cell will display the associated ohms value.
If (x,y) appears to have a decaying exponential curve, that is if , then log y= log A+ kx, a linear relation. You can convert your list to (x, log y) and find a least squares line Y= kx+ b where Y= log y. Then
Originally Posted by Meppso