This question already has an answer here:
- Help Writing An Equation [closed] 2 answers
I've posted about this project before as math is not at all my strong subject anymore. I have a couple sets of data and I need to make some equations for them. I've used Excel to get trend lines, but the equations that I'm getting aren't close enough to be accurate and useful.
Firstly, I need an equation that can give me the appropriate Resistance (R) value based off of the Voltage value being read by an ADC.
Excel's closest trend line for V compared to R is saying: V = 121.98(R)^-0.814. This yields value that are 40 off in the higher end. That's the most important end, around 5V, as I can't go above about 5.1V. I need that to be relatively close.
Next, my ADC values range from 0 to 1024. My top value of 1024 is 230°F, and I'm setting the bottom value of 0 to be 75°F. So I need an equation that will correspond the voltage value read by my ADC (V) to the range of 0 to 1024 (Let's make that variable ADC)
You guys were really helpful before. Thank you so much in advance for your help now. It means a lot
Here is my set of data: http://i.stack.imgur.com/eycjy.png