Using Excel's TREND function will help you identify patterns in previous and current data, ... Also, we don't need a const value, as setting the y-intercept at 0 would yield inaccurate data.

Use the Excel interpolate function to get accurate data calculations. ... How to Find the Y-Intercept of a Line of a Graph in Excel on a Mac.