| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trend Line constants as Excel Cell Values
Hi Ken,
Supposing your x-range is in A2:A10, and y-range in B2:B10, select a 3-column x 1-row area and enter the following formula and confirm with CTRL-SHIFT-ENTER. =LINEST(B2:B10,A2:A10^{0,1,2},0,) Regards, B. R. Ramachandran "Ken" wrote: I want to put the constants of a 2 degree polynomial trend line into Excel Cells. Are there formula's to do this? Equation is Y = Ax(2) + Bx + C. I want the value of A,B and C in seperate cells. Can anyone suggest how this can be done? Thanks -- Ken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
| How do I Auto-Filter with multiple values in a cell in Excel? | Excel Discussion (Misc queries) | |||
| how do i get excel to automatically compute cell values | Excel Discussion (Misc queries) | |||
| How di get excel to automatically change cell values | Excel Discussion (Misc queries) | |||
| Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
Threaded Mode
