Skip to main content
Back

Quadratic Regression - Excel definitions

Control buttons has been changed to "navigation" mode.
1/15
  • Quadratic Regression
    A statistical method modeling data with a parabolic curve, ideal for nonlinear relationships between variables.
  • Parabola
    A U-shaped curve representing the graphical form of a quadratic equation, often seen in quadratic regression plots.
  • Scatterplot
    A chart displaying data points for two variables, used to visually assess relationships and fit regression models.
  • Polynomial Trendline
    A curve fitted to data in a chart, where the equation includes powers of the independent variable, such as order two for quadratics.
  • Order Two
    A polynomial degree indicating the highest exponent is squared, characteristic of quadratic equations.
  • Regression Equation
    A mathematical formula predicting the dependent variable based on the independent variable(s) in a fitted model.
  • Coefficient of Determination
    A value, often denoted as R^2, indicating how well the regression model explains the variation in the response variable.
  • R Squared
    A statistic ranging from 0 to 1 that measures the proportion of variance in the dependent variable explained by the model.
  • Intercept
    The constant term in a regression equation, representing the predicted value when all independent variables are zero.
  • X Squared Coefficient
    The parameter multiplying the squared independent variable in a quadratic equation, shaping the curvature of the parabola.
  • Axis Titles
    Labels added to chart axes to clarify the variables represented, enhancing interpretability of visual data displays.
  • Chart Elements
    Features such as titles, trendlines, and labels that can be added or modified in Excel charts for clarity and analysis.
  • Predicted Value
    The outcome calculated from the regression equation for a given input, often denoted as y-hat.
  • Data Table
    An organized arrangement of values for variables, serving as the source for plotting and regression analysis.
  • Rounding
    The process of adjusting numerical values to a specified number of decimal places for clarity and ease of interpretation.