How to Create the Average Function to Calculate Average Projected Revenue in Excel. If you track your daily earnings using an Excel spreadsheet, ... How to Graph Linear Equations in Excel 2007.

Linear returns are simpler to calculate and involve subtracting the beginning stock price (S1) from the ending price (S2), then dividing by S1. Linear Return Percentage = [(S2 - S1)/S1] x 100%.

Here's how to run both simple and multiple linear regression in Google Sheets using the built-in LINEST function. No add-ons or coding required.