Power Fit - Trendline
 

Is it possible to link the Power Fit result back to the spreadsheet for
further data analysis?

My chart accurately displays all values however, I need to use these values
for further data analysis.

Thank you.

Answer: Power Fit - Trendline
 

Yes, it is possible to link the Power Fit result back to the spreadsheet for further data analysis. Here are the steps to do so:

1. Right-click on the chart and select "Select Data" from the drop-down menu.
2. In the "Select Data Source" dialog box, click on the "Hidden and Empty Cells" button.
3. In the "Hidden and Empty Cell Settings" dialog box, select the "Connect data points with line" option and click OK.
4. Close the "Select Data Source" dialog box.
5. Click on the chart to select it.
6. Click on the "Design" tab in the Excel ribbon.
7. Click on the "Select Data" button in the "Data" group.
8. In the "Select Data Source" dialog box, click on the "Edit" button under "Horizontal (Category) Axis Labels".
9. In the "Axis Labels" dialog box, select the range of cells that contains the x-axis values for the chart and click OK.
10. Close the "Axis Labels" dialog box.
11. In the "Select Data Source" dialog box, click on the "Edit" button under "Legend Entries (Series)".
12. In the "Edit Series" dialog box, select the range of cells that contains the y-axis values for the chart and click OK.
13. Close the "Edit Series" dialog box.
14. Close the "Select Data Source" dialog box.

Now, the chart is linked to the spreadsheet and any changes made to the data in the spreadsheet will be reflected in the chart. You can use these values for further data analysis by referencing them in other cells or formulas in the spreadsheet.

Power Fit - Trendline
 

Suppose you have a plot of y=2x^3 with the x-values in A1:A12 and y-values
in B1:B12
Select two cells and enter =LINEST(LN(A1:A12),LN(B1:B12)) and use
CTRL+SHIFT+ENTER to complete it
You will get 3 and 0.693147
Suppose the 0.69 value is in E1 then =EXP(E1) gives you the 2
Now you know the parameters of the power curve
This is shown on my website
http://www.people.stfx/bliengme/Exce...Polynomial.htm but it seems the
university server is dead (again!) today
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"gsamoil" wrote in message
...
Is it possible to link the Power Fit result back to the spreadsheet for
further data analysis?

My chart accurately displays all values however, I need to use these
values
for further data analysis.

Thank you.

Power Fit - Trendline
 

The power law fit gives Y = k X^n. You can transform this into a simple
linear regression model:

log Y = log K + n log X

Put the log of X and Y into two more columns, and use LINEST or simply SLOPE
and INTERCEPT to determine log K and n.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"gsamoil" wrote in message
...
Is it possible to link the Power Fit result back to the spreadsheet for
further data analysis?

My chart accurately displays all values however, I need to use these
values
for further data analysis.

Thank you.