# Power regression for a specific function with data

1. ## Power regression for a specific function with data

I am currently working with data from a physics experiment, and I just made power regression. I get a function from it, something like
Formula:
`Please Login or Register  to view this content.`

The coefficient of determination is of course 1 because it is power regression, but what I really want is to know how well my data fits the specific function
Formula:
`Please Login or Register  to view this content.`

Is there a way of making Excel find the coefficient of determination for how well my data fits that specific model?

English is not my first language, please excuse any errors.

2. ## Re: Power regression for a specific function with data

insert a graph, build trend line and show its equation

3. ## Re: Power regression for a specific function with data

Well, I know how to build a trendline (by the way, the one you sent me is polynomial regression, and in that case the coefficient of determination will not always be 1), but is it possible to make excel give me a coefficient of determination based on my specific function and not the one from the power regression?

4. ## Re: Power regression for a specific function with data

I don't understand the question.

You have some data which you regressed to your first equation, and then say R2 is 1 "because it is a power regression". You mean the regression is a perfect fit to data? Seems unlikely.

Then you want to know R2 between the first formula and y=x^3?

5. ## Re: Power regression for a specific function with data

Maybe this:

 A B C D E F 1 x 1.00012 * x ^2.9998 x^3 2 0 0.00000 0.00000 0.999999999194346 E2: =RSQ(B2:B12, C2:C12) 3 0.1 0.00100 0.00100 4 0.2 0.00800 0.00800 5 0.3 0.02701 0.02700 6 0.4 0.06402 0.06400 7 0.5 0.12503 0.12500 8 0.6 0.21605 0.21600 9 0.7 0.34307 0.34300 10 0.8 0.51208 0.51200 11 0.9 0.72910 0.72900 12 1 1.00012 1.00000

There are currently 1 users browsing this thread. (0 members and 1 guests)