regression technique, excel, dataset

  

1. Based on the Group Cohesiveness Model (GC), answer the following questions after performing and interpreting the regression technique on the excel dataset attached. 

2.  After getting the regression outcomes, it is essential to analyze the regression model to answer the questions below. The instructor will prepare a short video explaining the content of this exercise.

4.1. How do the factors affect the organization’s GC level, and how does GC affect each consequence?

4.2. How do the factors affect the GC level shown by group range, and how does GC affect each consequence in each group range as explained in the recording? Explain. Are the factors affecting GC the same across the group ranges? How much does each important/relevant factor contribute to the GC in each group? Craft technical conclusions and an action plan to improve the GC, if any.