If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fitting a curve similar to capacitor charging current.
Hi all, Newbie to this forum, but need some excel help. I have collected a bunch of data from an object as it heats up. The curve is very similar to a capacitor charging current curve. In my case, manually trying to approximate this curve, I come up with a formula of y= (rise)*(1-exp(-time))+ambient. Is there a way in excel to fit a curve like this or do I need an aftermarket solution? I need something that will use the data points and perform calculations to determine the curve. Thanks, Sean -- mcgradys |
#2
|
|||
|
|||
Fitting a curve similar to capacitor charging current.
Sean,
You can add a trendline to see what type of fit works best. When the chart is selected, used Chart / Add Trendline... then choose from logarithmic, exponential, polynominal, power series, etc. When you have selected a type of curve (depending on the quality of the fit), double click on the new trend line and then on the Options tab of the dialog that opens, select "Display equation on chart" and "Display R-squared value on Chart" HTH, Bernie MS Excel MVP "mcgradys" wrote in message ... Hi all, Newbie to this forum, but need some excel help. I have collected a bunch of data from an object as it heats up. The curve is very similar to a capacitor charging current curve. In my case, manually trying to approximate this curve, I come up with a formula of y= (rise)*(1-exp(-time))+ambient. Is there a way in excel to fit a curve like this or do I need an aftermarket solution? I need something that will use the data points and perform calculations to determine the curve. Thanks, Sean -- mcgradys |
#3
|
|||
|
|||
Fitting a curve similar to capacitor charging current.
You have several answers in the microsoft.public.excel.misc (General
Questions) newsgroup to your separate post of this same question. Separately posting the same question in multiple newsgroups is generally frowned upon. Jerry "mcgradys" wrote: Hi all, Newbie to this forum, but need some excel help. I have collected a bunch of data from an object as it heats up. The curve is very similar to a capacitor charging current curve. In my case, manually trying to approximate this curve, I come up with a formula of y= (rise)*(1-exp(-time))+ambient. Is there a way in excel to fit a curve like this or do I need an aftermarket solution? I need something that will use the data points and perform calculations to determine the curve. Thanks, Sean -- mcgradys |
#4
|
|||
|
|||
Fitting a curve similar to capacitor charging current.
Sorry, I looked and saw different websites, and thought they were similar but different forums. Won't happen again. Sean -- mcgradys ------------------------------------------------------------------------ mcgradys's Profile: http://www.excelforum.com/member.php...o&userid=28806 View this thread: http://www.excelforum.com/showthread...hreadid=485045 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
curve fitting a charging capacitor type curve | mcgradys | General Discussion | 4 | November 15th, 2005 12:46 PM |
best curve fitting | ladee_bird | Charts and Charting | 1 | September 20th, 2005 07:25 AM |
Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Query Only Creent Record? | Hulk | Running & Setting Up Queries | 10 | January 25th, 2005 06:39 PM |