This blog is for a quick tip how to run simple regression in Microsoft Excel.
For adding Regression tool Pack in Microsoft Excel visit following link..
The sample data with is used for this example is based on hypothesis
“Students which have higher admission test exam marks usually end up having higher GPA”
Place you data in the Excel sheet and look for data analysis button in the Data menu.
After selecting the data analysis, it will provide you a list of options, from which you have to find the option of regression analysis
Here select the dependent variable in the input Y range with its label too, and independent variable in input X range with it label and select the option of label below. There are several options available for the use.
Excel will show simple regression results in a new sheet. According to these results the coefficient of the independent variable is positive and significant hence the marks in the entry test exam do positively affect the GPA.
There are few other statistics options available in this plugin.
Data file : data file excel regression