Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem analyzing my data
I am having a problem analyzing some data and I think my problem may have to
do with not knowing enough about excel. I have one spreadsheet where i set up a plot of Resistance to Voltage. Now in another spreadsheet I have a completely different set of measurements for Voltage and I want to find the corresponding Resistance, using the plot from the first spreadsheet. How do i do this? I am pulling my hair out over here! I would go through my data points and do it by hand but I have over 900 data points. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem analyzing my data
Hello Amanda,
Without seeing your data I'd say you could either use a combination INDEX/MATCH type function or (if data structure is correct) a VLOOKUP or LOOKUP type formula. I'd recommend reading up on each of the formulas, the Help files are decent on them. Post back if you need any help with them. -- Regards, Zack Barresse, aka firefytr To email, remove NOSPAM "Amanda" wrote in message ... I am having a problem analyzing some data and I think my problem may have to do with not knowing enough about excel. I have one spreadsheet where i set up a plot of Resistance to Voltage. Now in another spreadsheet I have a completely different set of measurements for Voltage and I want to find the corresponding Resistance, using the plot from the first spreadsheet. How do i do this? I am pulling my hair out over here! I would go through my data points and do it by hand but I have over 900 data points. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem analyzing my data
Hello:
I do not know anything about volts and resistence other than what I have just read he (and I am not sure I understand all of it) http://www.allaboutcircuits.com/vol_1/chpt_2/1.html According to this site if you hold amps constant the relationship between resistance (measure in ohms) and voltage is linear. Therefore just plot the data on an xy scatter and then right click the series and choose trendline, linear and on options select display equation and r^2. You can then use this equation to estimate the Ohms for your other data. If amps are constant you should get a perfect fit (r^2=1), if they are not you will not get a perfect fit. The more your amps vary the poorer will be fit. But in any case the relationship between ohms and volts is still linear and variation is cause by the third factor(amps). Pieter Vandenberg Amanda wrote: : I am having a problem analyzing some data and I think my problem may have to : do with not knowing enough about excel. I have one spreadsheet where i set : up a plot of Resistance to Voltage. Now in another spreadsheet I have a : completely different set of measurements for Voltage and I want to find the : corresponding Resistance, using the plot from the first spreadsheet. How do : i do this? I am pulling my hair out over here! I would go through my data : points and do it by hand but I have over 900 data points. Any help would be : appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Case Sensitivity problem with data validation | Excel Worksheet Functions | |||
Problem with Import Data path | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Help with data not getting plotted | Excel Discussion (Misc queries) |