In order to do so, we have to follow the following steps to create a scatter graph first then add a polynomial trendline with an order of 2. In this section, we are going to demonstrate how to create the best fit quadratic trendline from chart elements. Adding Best Fit Quadratic Trendline From Chart Elements Here we have given a dataset of Sales and we are going to make a best fit quadratic line using the dataset, where the Number of Sales is dependent and Hours of Work is a dependent variable.ġ. How to Plot Best Fit Quadratic Line in Excel: 2 Easy Ways The “a” coefficient represents the quadratic term, the “b” coefficient represents the linear term, and the “c” coefficient represents the constant term. Where “a”, “b”, and “c” are coefficients determined by Excel’s trendline analysis. The quadratic trendline equation in Excel is a mathematical formula that represents the best-fit quadratic curve for a set of data points. Related Articles Quadratic Trendline Equation
