Question

How can you perform simple linear regression analysis using Excel?

Answer 1

Linear regression in Excel can be performed in two different ways:

1. Open the excel sheet and type the dependent and independent values. You can name dependent values as X and independent values as Y. After all the values are entered in the sheet, go to formulas; then select insert function. Upon opening insert function a tab is opened. Type slope in search for the function tab. You will get a list of results. Select slope from the list of functions. Select Y values and x values from the data earlier entered and press ok. You will get the output as the slope. Similarly, follow the same procedure and type intercept. Select the intercept from the list of results. Select x and y values and press ok. The output is given as intercept.

2. Open the excel sheet and type the dependent and independent values. You can name dependent values as X and independent values as Y. Select any empty cell in the excel sheet. Insert the function as =slope, a drop down appears. Select slope from the list. Then a new tab opens; select x and y values from the data entered. Press ok and slope is returned as output. Similarly, select another empty cell. Insert =intercept. Select intercept from the drop down list. A new tab opens. Select x and y values and press ok. The output is returned as intercept.