Question: how to create equation in excel from data?
Answer: Insert a scatterplot graph into a blank space or sheet in an Excel file with your data. ... 
Select the x-axis (horizontal) and y-axis data and click OK. ... 
Right-click on any of the dots and select “Add Trendline” from the menu.