Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Use Excel to find the similarity between functions.

  1. Sep 15, 2015 #1
    I am writing a paper and I came up with a function that uses a hypothetical relationship to predict the value of one variable at different points in time, I graphed it, and then graphed the actual readings from an experiment. How can quantitatively describe how close the two trends are? In other words, how can I quantitatively describe the amount of support the hypothetical relationship get from the experiment? See image for more ideas, predictive function gives values in blue, actual readings are orange. Screenshot 2015-09-15 21.39.28.png
  2. jcsd
  3. Sep 16, 2015 #2


    User Avatar

    Staff: Mentor

    You could perform a χ2 test. You can also calculate the R2 for your model, since you already have the value for the linear regression.

    If you don't know what any of that means, you can start with https://en.wikipedia.org/wiki/Goodness_of_fit
  4. Sep 16, 2015 #3


    User Avatar
    Science Advisor
    Gold Member
    2017 Award

    You can get the confidence intervals for the slope and intercept of the regression line. For a given confidence level, your theoretical parameters will be in or out of the confidence interval. Just eyeballing the data, the regression line, and your theoretical line, I think there is something missing from your theory. I think it is likely to be statistically rejected.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook