+ Reply to Thread
Results 1 to 5 of 5

Power regression for a specific function with data

  1. #1
    Registered User
    Join Date
    03-01-2018
    Location
    Denmark
    MS-Off Ver
    16.10
    Posts
    2

    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: copy to clipboard
    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: copy to clipboard
    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. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Power regression for a specific function with data

    insert a graph, build trend line and show its equation
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-01-2018
    Location
    Denmark
    MS-Off Ver
    16.10
    Posts
    2

    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. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    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?
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power regression - standard error values
    By David2017 in forum Excel General
    Replies: 8
    Last Post: 02-26-2017, 01:52 PM
  2. Create Power slide from excel using Specific background graphics of PPLayout
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2015, 12:25 AM
  3. VBA Linear Regression function?
    By Daniel86 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-03-2015, 11:12 AM
  4. Obtain a general regression function that decribes a data set
    By schnett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2013, 11:58 AM
  5. Function to write Data to DB from specific rows and colomuns Plus specific Timestamp
    By Mudhafar.M in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 08:01 PM
  6. Problem with the Regression Function in VBA
    By Juan Atehortua in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2013, 09:23 PM
  7. How to detect a specific active power point?
    By darren1979 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2010, 05:48 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1