In your Excel click File Options. This is valuable information. To run the regression arrange your data in columns as seen below.
This is valuable information.
Click on the Office Button at the top left of the page and go to Excel Options. Slope of trendline b. Insert a scatterplot graph into a blank space or sheet in an Excel file with your data. In the excel spreadsheet click on Data Analysis present under Analysis Group under Data.