Question: how to find the slope and y intercept in excel?
Answer: Click the cell in your spreadsheet in which you would like Excel to display the y-intercept of your line.
Type "=INTERCEPT(" without quotes in the formula bar above the spreadsheet.
Click the first cell containing the y values of the line that you need the intercept for. ... 
Type a comma in the formula field.