Steps to Perform Regression Analysis

Steps to perform regression analysis:
The regression analysis is performed to determine relationship between two or more
independent variables and one dependent variable. The steps are as follows:
1. At first based on the selected research questions, we selected three independent
variables for this study as: Deviation of policies in healthcare, big data analytics and
Performance of big data application. The dependent variable is: big data.
2. Based on three of the independent variables, we had prepared survey questions. The
questions were set up on a 5-point Likert scale in which the respondents provide their
opinion.
3. The questions are then distributed to the employees and selected sample size is 50.
4. After collecting the data from the respondents, a data sheet is prepared. We had
replaced strongly agree with 1, agree with 2, neutral with 3, disagree with 4 and
strongly disagree with 5.
5. After than we performed the regression analysis. From this test we were able to find if
null or alternative hypothesis was correct one.
6. We found the median of each independent variables and it is shown into the data
analysis sheet with input the formula for the median.
7. At first we clicked on data analysis command button on data tab. When excel displayed
the data analysis dialog box, we selected the regression analysis from the analysis tool
list and clicked OK. The following screenshot shows the dialog box.

8. We then identified X and Y values. We used input Y range text box to identify the
worksheet range holding the dependent variable. Then put input X range box to identify
the worksheet range reference holding the independent variables. We entered
$O$2:$Q$52into input X Range and $R$2:$R$52 into input Y range.