Background: I am working with pump curves in a hydraulic model. The model is written on excel. In the model pump curves are defined using tested flows vs. dynamic head (ft). The problem I am having is an iterative solution to fit an equation to the data points. Once the first equation is fit to the data points I skew them slightly to induce the R^2 value to 1. Each time I move a data point the best fit equation changes respectively with the order of the equation. The higher the order, the more accurate, hence the more the equation changes each time a data point is moved.(adsbygoogle = window.adsbygoogle || []).push({});

All in all I need to find how excel models the best fit line and comes up with the equation they use so I can experiment with a macro to do the iterative process. Can anyone help?

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# How does excel calculate the best fit line?

Loading...

Similar Threads - does excel calculate | Date |
---|---|

I What does normalizing a straight line mean? | Monday at 12:07 PM |

I Why does this concavity function not work for this polar fun | Jan 26, 2018 |

I How does the Vector Laplacian come about? | Oct 29, 2017 |

B Why does this derivation fail? | May 28, 2017 |

I Area under curve using Excel question | Apr 13, 2017 |

**Physics Forums - The Fusion of Science and Community**