Heres the linear regression formula. In other words for each unit increase in price Quantity Sold decreases with 835722 units. This will add the Data Analysis tools to the Data tab of your Excel ribbon.
You will now see a window listing the various statistical tests that Excel can perform.
On an Excel chart theres a trendline you can see which illustrates the regression line the rate of change. For linear regression Microsoft Excel provides special functions to get the slope and intercept coefficients. Enter the equation that appears on the chart in cell C1 but replace X with A1 As an example if the displayed equation is y 36246x 26259 enter 36246A126356 without quotes in cell C1. You can find the scatterplot graph on the Insert ribbon in Excel 2007 and later.