Home Uncategorized regression technique, excel, dataset

Uncategorized

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.

>Survey

Corp.

employees

ly disagree

1 2 3 4 5 6 7

Totally disagree Totally agree
1 2 3 4 5 6 7 8 9

Totally disagree Totally agree
1 2 3 4 5 6 7 8 9 10

1 2 3 4 5 6 7 8 9 10

Group Cohesiveness. Determinants and Consequences Survey

Population = 13

Objective:

To measure the level of group cohesiveness perceived by the employees

To identify the relevant causes of the group cohesiveness

To analyze the impact of group cohesiveness on its consequences

Group Size: __________

1. The group I belong to is diverse in knowledge, experience, expertise, and it is managed effectively by my boss.

Total

Totally agree

2. My boss promoltes team members performance by showing individual performance measures, and public recognition

3. My boss makes me feel that I am a valued member of the organization

4. My boos makes me see that I can achieve noticeable and visible successes as employees

5. My participation within the group concerning discussion, setting goals, decision making is high

6. I perceive a high level of conformity to norms within the group I belong to

7. The group I belong to make a strong emphasis on group goal accomplishment

8. Indique how satisfied you are with the cohesiveness shown in the group you belong to.

Low

High

Dataset

Success

5 8 6 7 7 8 5 7 7

SUMMARY OUTPUT

3 7 6 7 7 6 6 7 7
6 8 6 7 7 8 5 7 7

Statistics

9 7 6 7 8 7 7 7 7

0521

Multiple R

800

8 8 6 7 7 8 5 7 7

3025

R Square

23556

5 7 6 7 8 7 6 7 7

Adjusted R Square

5 7 6 8 7 8 5 7 8

Standard Error

5 7 7 7 8 9 7 7 7

Observations 248

5 7 6 8 7 8 4 8 8

5 7 7 7 8 7 5 8 7

ANOVA

4 7 6 8 7 8 6 9 8

df SS MS F Significance F

4 6 7 7 8 9 7 9 7 Regression 4

1041759

Regression 2

16904

58452

4 8 6 8 7 8 5 9 8

Residual

4 6 7 7 7 7 8 8 7 Total

.060483871

Total 247

4 8 6 8 7 8 5 9 8

3 7 7 7 7 9 6 8 7 Success

Standard Error

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

3 8 6 8 7 8 5 9 8

4.0961356659 7.4665724211 Intercept

8.8856806984 10.9776597188

6 6 7 7 7 7 7 8 7 GroupSize

-0.0343561243 0.0519903828 Cohess

93176

-0.3238588623 -0.122558832

6 8 6 8 7 8 5 9 8 EffMgDiv

-0.2975587405 -0.0516999266 Success

-0.216750114 0.0558881407

5 7 7 7 7 9 6 8 7 IdenHealComp

-0.1901487421 0.0303393633

9 8 7 8 7 6 5 9 8 Success

0.3304816003 0.6528693743 SUMMARY OUTPUT

5 7 7 7 8 9 4 8 7
8 8 7 8 7 8 5 9 8 Regression Statistics Participation
4 7 6 7 8 9 6 8 7 SUMMARY OUTPUT Multiple R

4 8 6 8 7 8 5 9 8

R Square

3 6 6 7 8 9 4 8 7 Regression Statistics Adjusted R Square

5 8 7 7 7 5 5 9 7 Multiple R

Standard Error

4 7 6 7 8 8 6 8 7 R Square

Observations 248

5 8 7 7 7 7 5 9 7 Adjusted R Square

5 6 8 7 8 8 5 8 7 Standard Error

ANOVA

4 8 6 7 7 9 5 7 7 Observations 248 df SS MS F Significance F
4 7 8 7 8 5 5 8 7 Regression 1

2.0161558871

6 8 7 8 7 8 4 9 8 ANOVA Residual 246

6 6 8 8 8 7 4 8 8 df SS MS F Significance F Total 247 69.8709677419
2 8 6 8 7 5 4 8 8 Regression 1

3.9753852627

5 7 8 8 8 8 4 8 8 Residual 246

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

3 8 7 8 7 7 6 9 8 Total 247

Intercept

7.9945882226 9.9727777448

4 7 8 8 7 4 6 8 8 Success

24841825

0.0073381653

-0.3154303815 -0.0495379835

4 8 7 8 7 5 6 7 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
4 7 8 7 7 6 6 8 7 Intercept

5.7741904196 10.0606859555

3 8 7 8 7 9 7 7 8 Cohess

0.1835498233

-0.4686139209 0.0902237674

3 7 8 7 7 6 7 8 7
3 8 6 8 7 6 7 7 8 SUMMARY OUTPUT
6 6 6 7 7 9 7 8 7
6 8 6 8 7 8 8 7 8 Regression Statistics Conformity
5 7 6 7 7 9 8 8 7 Multiple R

6 8 6 8 7 8 8 9 8 R Square

5 7 7 7 7 9 5 9 7 Adjusted R Square

6 8 6 8 7 8 4 9 8 Standard Error

8 6 7 7 7 5 5 9 7 Observations 248
8 8 6 8 7 8 8 9 8
8 7 7 8 7 7 4 8 8 ANOVA
2 8 6 8 7 8 5 9 8 df SS MS F Significance F
4 6 7 8 8 9 8 8 8 Regression 1

1.4351695531

7 8 6 8 7 8 7 9 8 Residual 246

8 7 8 8 8 7 8 8 8 Total 247

8 8 8 8 7 8 7 7 8
5 7 8 8 8 9 8 8 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
5 8 6 8 8 8 7 7 8 Intercept

5.0301269272 8.482634936

4 6 8 8 8 7 8 8 8 Cohess

0.3207687689

-0.1113778641 0.3387314567

4 8 6 8 8 5 7 7 8
6 7 8 8 8 8 8 8 8 SUMMARY OUTPUT
6 8 7 8 8 7 7 7 8
2 6 8 8 8 8 8 8 8 Regression Statistics

2 8 7 7 8 9 7 7 7 Multiple R 0.084725119
3 7 8 8 8 8 8 8 8 R Square 0.0071783458
3 8 7 7 8 8 7 7 7 Adjusted R Square 0.0031424854
5 6 8 8 8 8 8 8 8 Standard Error 1.4950147973
5 8 7 7 8 8 5 7 7 Observations 248
4 7 8 8 7 8 8 8 8
3 8 7 7 8 8 5 7 7 ANOVA
5 8 8 8 7 8 6 8 8 df SS MS F Significance F
6 7 7 7 8 7 9 7 7 Regression 1 3.9753852627 3.9753852627 1.7786407615 0.1835498233
8 7 8 8 7 8 8 7 8 Residual 246 549.8270340921 2.2350692443
4 7 8 7 8 9 5 7 7 Total 247 553.8024193548
8 7 6 7 7 5 8 7 7
4 7 7 7 8 6 7 7 7 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
9 7 6 7 7 9 4 7 7 Intercept 7.9174381876 1.088134046 7.2761607051 0 5.7741904196 10.0606859555 5.7741904196 10.0606859555
6 7 7 7 8 8 5 7 7 Cohess -0.1891950768 0.1418618799 -1.333656913 0.1835498233 -0.4686139209 0.0902237674 -0.4686139209 0.0902237674
5 8 6 7 7 7 8 7 7
4 7 7 7 8 8 9 7 7
7 8 6 7 9 7 5 7 7
6 7 7 7 8 8 8 7 7
3 8 7 7 7 7 4 7 7
5 7 7 7 8 8 5 7 7
8 8 7 7 9 7 8 7 7
4 7 7 7 8 8 7 7 7
4 8 7 8 7 7 8 7 8
5 7 7 8 8 8 9 7 8
8 8 7 8 7 9 8 8 8
9 6 7 7 8 5 9 7 7
6 8 7 8 8 6 8 8 8
5 8 7 7 8 8 5 7 7
8 8 7 8 8 7 8 8 8

5 8 7 7 8 8 5 7 7

4 8 7 8 8 4 8 8 8
5 6 6 7 8 5 5 7 7
6 6 6 8 8 8 6 8 8
3 8 6 7 8 7 5 7 7
8 7 7 8 8 8 8 7 8
5 8 6 7 7 8 4 7 7
4 7 7 8 7 8 5 7 8
7 8 6 7 8 5 8 7 7
5 7 7 8 7 5 7 7 8
6 8 6 7 8 5 8 7 7
5 7 7 7 7 8 5 8 7
9 8 6 7 8 8 8 8 7
5 7 7 7 7 8 7 8 7
8 8 7 7 8 7 8 8 7
6 7 7 7 7 7 5 8 7
5 8 7 7 8 7 8 8 7
4 7 7 7 7 7 7 8 7
2 8 7 7 8 7 8 8 7
5 8 7 7 7 9 5 8 7
4 8 7 7 8 9 7 7 7
7 8 7 8 8 9 9 8 8
8 8 7 7 8 9 5 7 7
5 8 7 8 8 9 7 8 8
2 8 6 7 8 9 8 7 7
3 8 6 8 8 1 5 8 8
3 8 6 7 8 10 4 7 7
3 7 6 7 8 8 8 7 7
3 8 6 8 8 8 5 7 8
3 7 6 7 7 8 8 7 7
5 8 6 8 8 5 4 7 8
5 7 8 7 7 8 8 7 7
6 8 6 8 8 9 5 8 8
4 7 8 7 7 8 8 8 7
5 8 8 8 8 9 8 8 8
4 6 8 7 7 8 8 8 7
5 8 6 7 8 7 8 8 7
6 6 6 7 7 8 8 8 7
9 8 6 7 8 9 5 8 7
8 7 6 7 7 8 5 8 7
5 8 6 7 8 7 5 8 7
7 7 6 7 8 8 6 8 7
4 8 6 7 8 9 5 8 7
5 7 6 8 8 7 6 8 8
8 8 6 7 8 9 5 8 7
5 6 8 7 8 8 6 8 7
9 8 8 7 8 9 5 7 7
6 7 8 7 8 8 6 8 7
8 8 7 7 8 8 5 7 7
5 7 8 7 8 8 8 8 7

5 8 7 7 8 8 5 7 7
5 7 8 7 8 8 8 8 7

5 8 7 7 8 6 7 7 7
5 8 8 7 8 8 8 8 7
5 8 7 8 7 9 5 7 8
4 7 8 8 8 8 8 8 8

3 8 6 8 8 8 5 7 8
3 7 6 7 7 8 8 7 7
5 8 6 8 8 5 4 7 8
5 7 8 7 7 8 8 7 7
6 8 6 8 8 9 5 8 8
4 7 8 7 7 8 8 8 7
5 8 8 8 8 9 8 8 8
4 6 8 7 7 8 8 8 7
5 8 6 7 8 7 8 8 7
6 6 6 7 7 8 8 8 7
9 8 6 7 8 9 5 8 7
8 7 6 7 7 8 5 8 7
5 8 6 7 8 7 5 8 7
7 7 6 7 8 8 6 8 7
4 8 6 7 8 9 5 8 7
5 7 6 8 8 7 6 8 8
8 8 6 7 8 9 5 8 7
5 6 8 7 8 8 6 8 7
9 8 8 7 8 9 5 7 7
6 7 8 7 8 8 6 8 7
8 8 7 7 8 8 5 7 7
5 7 8 7 8 8 8 8 7

8 7 7 8 7 7 4 8 8
2 8 6 8 7 8 5 9 8
4 6 7 8 8 9 8 8 8
7 8 6 8 7 8 7 9 8
8 7 8 8 8 7 8 8 8

8 8 8 8 7 8 7 7 8

5 7 8 8 8 9 8 8 8
5 8 6 8 8 8 7 7 8
4 6 8 8 8 7 8 8 8

4 8 6 8 8 5 7 7 8

6 7 8 8 8 8 8 8 8

6 8 7 8 8 7 7 7 8

2 6 8 8 8 8 8 8 8
2 8 7 7 8 9 7 7 7
3 7 8 8 8 8 8 8 8
3 8 7 7 8 8 7 7 7
5 6 8 8 8 8 8 8 8

5 8 7 7 8 8 5 7 7
4 7 8 8 7 8 8 8 8

3 8 7 7 8 8 5 7 7
5 8 8 8 7 8 6 8 8
6 7 7 7 8 7 9 7 7
8 7 8 8 7 8 8 7 8
4 7 8 7 8 9 5 7 7

8 7 6 7 7 5 8 7 7

4 7 7 7 8 6 7 7 7
9 7 6 7 7 9 4 7 7
6 7 7 7 8 8 5 7 7

5 8 6 7 7 7 8 7 7
4 7 7 7 8 8 9 7 7
7 8 6 7 9 7 5 7 7
6 7 7 7 8 8 8 7 7
3 8 7 7 7 7 4 7 7
5 7 7 7 8 8 5 7 7
8 8 7 7 9 7 8 7 7
4 7 7 7 8 8 7 7 7

6 8 6 8 7 8 4 9 8
8 6 7 7 7 5 5 9 7

8 8 6 8 7 8 8 9 8
8 7 7 8 7 7 4 8 8
2 8 6 8 7 8 5 9 8
4 6 7 8 8 9 8 8 8
7 8 6 8 7 8 7 9 8
8 7 8 8 8 7 8 8 8
8 8 8 8 7 8 7 7 8
5 7 8 8 8 9 8 8 8
5 8 6 8 8 8 7 7 8
4 6 8 8 8 7 8 8 8
4 8 6 8 8 5 7 7 8
6 7 8 8 8 8 8 8 8
6 8 7 8 8 7 7 7 8
2 6 8 8 8 8 8 8 8
2 8 7 7 8 9 7 7 7
3 7 8 8 8 8 8 8 8
3 8 7 7 8 8 7 7 7
5 6 8 8 8 8 8 8 8
5 8 7 7 8 8 5 7 7
4 7 8 8 7 8 8 8 8
3 8 7 7 8 8 5 7 7
5 8 8 8 7 8 6 8 8
6 7 7 7 8 7 9 7 7
8 7 8 8 7 8 8 7 8
4 7 8 7 8 9 5 7 7
8 7 6 7 7 5 8 7 7
4 7 7 7 8 6 7 7 7
9 7 6 7 7 9 4 7 7
6 7 7 7 8 8 5 7 7
5 8 6 7 7 7 8 7 7
4 7 7 7 8 8 9 7 7
7 8 6 7 9 7 5 7 7
6 7 7 7 8 8 8 7 7
3 8 7 7 7 7 4 7 7
5 7 7 7 8 8 5 7 7
8 8 7 7 9 7 8 7 7
4 7 7 7 8 8 7 7 7
4 8 7 8 7 7 8 7 8

							GroupSize									EffMgDiv						IdenHealComp														Success	ParWithGroup	ConfGroupNorms			EmpGGoalAcc					Cohess
																			SUMMARY OUTPUT
																					Regression														Regression Statistics
																			Multiple R		0.37	41	0.31						46	85
																			R Square	0.1	42				88	0.09						90
																			Adjusted R Square	0.1285761757	0.0916686463
			GS										Participation																											Standard Error	0.6259591881	0.506	89	246
																			Observations						248
-0.24
			Diversity																				ANOVA
			GC									Conformity																				df							SS								MS		F		Significance F
15.8470319137	3.9617579784	10.	11	0.0000001379	6.918	87	3.						45	43	13.4635990735	0.000002834
			Identity																				Residual	243	95.2134519573	0.3918249052	245	62.9520960515	0.2569473308
					247							111		69.8709677419
0.49
						Accomplishment																				Coefficients											t Stat								P-value			Lower 95%		Upper 95%		Lower 95.0%	Upper 95.0%
																			Intercept	5.7813540435	0.8555387772	6.7575593271	0.0000000001		4.0961356659		7.4665724211	9.9316702086	0.5310416503	18.702243417	4.3222466534583E-49		8.8856806984	10.9776597188
0.0088171293	0.0219178672	0.402280			44	0.6878312767		-0.0343561243		0.0519903828	-0.2232088471	0.05	109	-4.3681375369	0.0000185092		-0.3238588623	-0.122558832
-0.1746293335	0.0624078611	-2.7981944954	0.0055509376		-0.2975587405		-0.0516999266	-0.0804309866	0.0692082795	-1.1621584474	0.2463019538		-0.216750114		0.0558881407
-0.0799046894	0.0559678575	-1.4276889081	0.1546652654		-0.1901487421		0.0303393633
0.4916754873	0.0818336797	6.0082289949	0.0000000068		0.3304816003		0.6528693743
0.1698688219
Participa tion	0.0288554167
0.0249076745
	0.084725119	0.5251976471
	0.0071783458
	0.0031424854
	1.4950147973
	2.0161558871	7.309346746		0.0073381653
67.8548118548	0.2758325685
			3.9753852627		1.7786407615				0.1835498233
	549.8270340921		2.2350692443
	553.8024193548	8.9836829837	0.5021667118	17.8898417044	2.05461082253639E-46		7.9945882226		9.9727777448
	-0.18	0.067497229	-2.7035803569		-0.3154303815		-0.0495379835
	7.9174381876		1.088134046		7.2761607051				5.7741904196				10.0606859555
	-0.1891950768		0.1418618799		-1.333656913				-0.4686139209				0.0902237674
0.0633044568
0.0040074542
-0.0000412959
1.2041422924
	1.4351695531	0.9898003249		0.3207687689
356.6898304469	1.4499586604
358.125
6.7563809316	0.8764249203	7.7090242131		5.0301269272		8.482634936
0.1136767963	0.1142610023	0.9948870915		-0.1113778641		0.3387314567
A c c omplishment

2,3,4

GroupSize EffMgDiv IdenHealComp Success ParWithGroup ConfGroupNorms EmpGGoalAcc Cohess Success

3 7 6 7 7 6 6 7 7 SUMMARY OUTPUT
4 7 6 8 7 8 6 9 8 SUMMARY OUTPUT
4 6 7 7 8 9 7 9 7 Regression Statistics Participation
4 8 6 8 7 8 5 9 8 Multiple R

Regression Statistics

4 6 7 7 7 7 8 8 7 GS Participation R Square

Multiple R

4 8 6 8 7 8 5 9 8 Adjusted R Square

R Square

3 7 7 7 7 9 6 8 7

Standard Error

Adjusted R Square

3 8 6 8 7 8 5 9 8 Diversity Observations 90 Standard Error

4 7 6 7 8 9 6 8 7 GC Conformity Observations 90
4 8 6 8 7 8 5 9 8 ANOVA
3 6 6 7 8 9 4 8 7 Identity df SS MS F Significance F ANOVA
4 7 6 7 8 8 6 8 7 Regression 4

671675

df SS MS F Significance F

4 8 6 7 7 9 5 7 7

Residual 85

05210399

Regression 2

4 7 8 7 8 5 5 8 7 Success Accomplishment Total 89

Residual 87

2 8 6 8 7 5 4 8 8 Total 89

3 8 7 8 7 7 6 9 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
4 7 8 8 7 4 6 8 8 Intercept

3.1559428635 9.7061007729 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

4 8 7 8 7 5 6 7 8 GroupSize

-0.2491789062 0.1191207997 Intercept

8.0679750753 11.2114982939

4 7 8 7 7 6 6 8 7 EffMgDiv

-0.5058594291 -0.0826330598 Cohess

-0.3786223839 -0.054651105

3 8 7 8 7 9 7 7 8 IdenHealComp

-0.3125258191 0.0763930227 Success

-0.2726276726 0.1682590311

3 7 8 7 7 6 7 8 7 Success

0.3352144834 0.8419445203

3 8 6 8 7 6 7 7 8 SUMMARY OUTPUT
2 8 6 8 7 8 5 9 8 SUMMARY OUTPUT
4 6 7 8 8 9 8 8 8 Regression Statistics Participation
4 6 8 8 8 7 8 8 8 Regression Statistics Participation Multiple R

4 8 6 8 8 5 7 7 8 Multiple R

R Square

2 6 8 8 8 8 8 8 8 R Square

Adjusted R Square

2 8 7 7 8 9 7 7 7 Adjusted R Square

Standard Error

3 7 8 8 8 8 8 8 8 Standard Error

Observations 90

3 8 7 7 8 8 7 7 7 Observations 90
4 7 8 8 7 8 8 8 8 ANOVA
3 8 7 7 8 8 5 7 7 ANOVA df SS MS F Significance F
4 7 8 7 8 9 5 7 7 df SS MS F Significance F Regression 1

0.72

4 7 7 7 8 6 7 7 7 Regression 1

4.2666666667

Residual 88

4 7 7 7 8 8 9 7 7 Residual 88

Total 89 21.6

3 8 7 7 7 7 4 7 7 Total 89 41.1555555556
4 7 7 7 8 8 7 7 7 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
4 8 7 8 7 7 8 7 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept

7.4078933633 10.4721066367

4 8 7 8 8 4 8 8 8 Intercept 11

8.891591347 13.108408653 Success -0.18

0.0850065263

-0.3853484295 0.0253484295

3 8 6 7 8 7 5 7 7 ParWithGroup

0.0019698695

-0.7212920637 -0.1675968252

4 7 7 8 7 8 5 7 8

4 7 7 7 7 7 7 8 7 SUMMARY OUTPUT

2 8 7 7 8 7 8 8 7

4 8 7 7 8 9 7 7 7 Regression Statistics Conformity
2 8 6 7 8 9 8 7 7 Multiple R

3 8 6 8 8 1 5 8 8 R Square

3 8 6 7 8 10 4 7 7 Adjusted R Square

3 7 6 7 8 8 8 7 7 Standard Error

3 8 6 8 8 8 5 7 8 Observations 90

3 7 6 7 7 8 8 7 7

4 7 8 7 7 8 8 8 7 ANOVA
4 6 8 7 7 8 8 8 7 df SS MS F Significance F
4 8 6 7 8 9 5 8 7 Regression 1

0.0389848812

4 7 8 8 8 8 8 8 8 Residual 88

3 8 6 8 8 8 5 7 8 Total 89

3 7 6 7 7 8 8 7 7

4 7 8 7 7 8 8 8 7 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
4 6 8 7 7 8 8 8 7 Intercept

16321995

3.9225146687 10.7416321995

4 8 6 7 8 9 5 8 7 Cohess

0.8911296392

-0.4147906 0.4763456756

2 8 6 8 7 8 5 9 8

4 6 7 8 8 9 8 8 8 SUMMARY OUTPUT

4 6 8 8 8 7 8 8 8

4 8 6 8 8 5 7 7 8 Regression Statistics Accomplishment
2 6 8 8 8 8 8 8 8 Multiple R

2 8 7 7 8 9 7 7 7 R Square

3 7 8 8 8 8 8 8 8 Adjusted R Square

3 8 7 7 8 8 7 7 7 Standard Error

4 7 8 8 7 8 8 8 8 Observations 90

3 8 7 7 8 8 5 7 7

4 7 8 7 8 9 5 7 7 ANOVA
4 7 7 7 8 6 7 7 7 df SS MS F Significance F
4 7 7 7 8 8 9 7 7 Regression 1

0.761987041

3 8 7 7 7 7 4 7 7 Residual 88

4 7 7 7 8 8 7 7 7 Total 89

2 8 6 8 7 8 5 9 8

4 6 7 8 8 9 8 8 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
4 6 8 8 8 7 8 8 8 Intercept

4.2768531956 10.9974448605

4 8 6 8 8 5 7 7 8 Cohess

0.5396275502

-0.5751994711 0.3030612421

2 6 8 8 8 8 8 8 8
2 8 7 7 8 9 7 7 7
3 7 8 8 8 8 8 8 8
3 8 7 7 8 8 7 7 7
4 7 8 8 7 8 8 8 8
3 8 7 7 8 8 5 7 7
4 7 8 7 8 9 5 7 7
4 7 7 7 8 6 7 7 7
4 7 7 7 8 8 9 7 7
3 8 7 7 7 7 4 7 7
4 7 7 7 8 8 7 7 7
4 8 7 8 7 7 8 7 8

0.5053744749
0.2554033599	0.32549464
0.220363518	0.1059467606
-0.44	0.6004340429	0.0853938126
0.4711388742
10.5						112	2.6278167919	7.2889415633	0.0000427104
0.58	30.6442883881		0.36	2.2884500299	1.144225015	5.1548206361	0.0076613813
	41.1555555556	19.3115499701	0.2219718387
	21.6
6.4310218182	1.6472020407	3.9042094772	0.0001888206		3.1559428635		9.7061007729
-0.0650290532	0.0926182293	-0.7021193747	0.4845229419		-0.2491789062		0.1191207997	9.6397366846	0.7907803685	12.1901567981	1.61312118931301E-20		8.0679750753	11.2114982939
-0.2942462445	0.106430921	-2.7646687789	0.0069865408		-0.5058594291		-0.0826330598	-0.2166367445	0.0814977684	-2.6581923488	0.0093484632		-0.3786223839	-0.05465	110
-0.1180663982	0.0978034299	-1.2071805491	0.2307112327		-0.3125258191		0.0763930227	-0.0521843208	0.1109088515	-0.4705153831	0.6391643268		-0.2726276726	0.1682590311
0.5885795019	0.1274300196	4.6188449442	0.0000135987		0.3352144834		0.8419445203
0.1825741858
0.3219809098	0.0333333333
0.1036717063	0.0223484848
0.0934861575	0.4871064845
0.6474503218
	0.72	3.0344827586		0.0850065263
	4.2666666667	10.178313253		0.0019698695	20.88	0.2372727273
36.8888888889	0.4191919192
8.94	0.7709527753	11.5960410104	2.05180598640355E-19		7.4078933633		10.4721066367
1.0609467146	10.3680984623	6.33137260689656E-17		8.891591347		13.108408653	0.1033308895	-1.7419766814		-0.3853484295		0.0253484295
-0.4444444444	0.1393091285	-3.190346886		-0.7212920637		-0.1675968252
0.0146316443
0.000214085
-0.0111471186
1.4383584991
	0.0389848812	0.0188435154		0.8911296392
182.0610151188	2.0688751718
182.1
7.3320734341	1.715682662	4.2735603714	0.0000485785		3.9225146687		1	0.74
0.0307775378	0.2242089318	0.1372716847		-0.4147906		0.4763456756
0.0655016608
0.0042904676
-0.0070244135
1.4175764087
	0.761987041	0.3791880405		0.5396275502
176.838012959	2.0095228745
177.6
7.6371490281	1.6908936597	4.5166347299	0.0000194226		4.2768531956		10.9974448605
-0.1360691145	0.2209694541	-0.615782462		-0.5751994711		0.3030612421

5,6,7

GroupSize EffMgDiv IdenHealComp Success ParWithGroup ConfGroupNorms EmpGGoalAcc Cohess Success

5 8 6 7 7 8 5 7 7 SUMMARY OUTPUT SUMMARY OUTPUT
6 8 6 7 7 8 5 7 7 Conformity
5 7 6 7 8 7 6 7 7 Regression Statistics Regression Statistics
5 7 6 8 7 8 5 7 8 Multiple R

Multiple R

5 7 7 7 8 9 7 7 7 GS Participation R Square

R Square

5 7 6 8 7 8 4 8 8 Adjusted R Square

Adjusted R Square

5 7 7 7 8 7 5 8 7 Standard Error

Standard Error

6 6 7 7 7 7 7 8 7 Diversity Observations 112 Observations 112
6 8 6 8 7 8 5 9 8 GC 0.36 Conformity
5 7 7 7 7 9 6 8 7 ANOVA ANOVA
5 7 7 7 8 9 4 8 7 Identity df SS MS F Significance F df SS MS F Significance F
5 8 7 7 7 5 5 9 7 Regression 4

Regression 2

5 8 7 7 7 7 5 9 7 0.37 Residual

Residual 109

5 6 8 7 8 8 5 8 7 Success Accomplishment Total 111

Total 111

6 8 7 8 7 8 4 9 8
6 6 8 8 8 7 4 8 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
5 7 8 8 8 8 4 8 8 Intercept

1.3600991467 6.8689623259 Intercept

1.2456487293 7.2544356459

6 6 6 7 7 9 7 8 7 GroupSize

-0.0421996656 0.3329793789 Cohess

0.0558821656 0.6256549979

6 8 6 8 7 8 8 7 8 EffMgDiv

-0.2624228852 0.1065461284 Success

-0.2606511511 0.4878199783

5 7 6 7 7 9 8 8 7 IdenHealComp

-0.0841824563 0.2522978318

6 8 6 8 7 8 8 9 8 Success

0.1293325604 0.614230312 SUMMARY OUTPUT

5 7 7 7 7 9 5 9 7
6 8 6 8 7 8 4 9 8 SUMMARY OUTPUT Regression Statistics
7 8 6 8 7 8 7 9 8 Multiple R

5 7 8 8 8 9 8 8 8 Regression Statistics Participation R Square

5 8 6 8 8 8 7 7 8 Multiple R

Adjusted R Square

6 7 8 8 8 8 8 8 8 R Square

Standard Error

6 8 7 8 8 7 7 7 8 Adjusted R Square

Observations 112

5 6 8 8 8 8 8 8 8 Standard Error

5 8 7 7 8 8 5 7 7 Observations 112 ANOVA
5 8 8 8 7 8 6 8 8 df SS MS F Significance F
6 7 7 7 8 7 9 7 7 ANOVA Regression 1

1.584427348

6 7 7 7 8 8 5 7 7 df SS MS F Significance F Residual 110

5 8 6 7 7 7 8 7 7 Regression 1

0.9895631664

Total 111 103.2767857143

7 8 6 7 9 7 5 7 7 Residual 110

6 7 7 7 8 8 8 7 7 Total 111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

5 7 7 7 8 8 5 7 7 Intercept

3.1955542308 8.6318502488

5 7 7 8 8 8 9 7 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Success

0.1932127769

-0.1242151999 0.6077461617

6 8 7 8 8 6 8 8 8 Intercept

4.1632657617 10.8892251717

5 8 7 7 8 8 5 7 7 Cohess

0.5108257108

-0.5823785395 0.2914833305

5 8 7 7 8 8 5 7 7

5 6 6 7 8 5 5 7 7 SUMMARY OUTPUT

6 6 6 8 8 8 6 8 8

5 8 6 7 7 8 4 7 7 Regression Statistics Conformity
7 8 6 7 8 5 8 7 7 Multiple R

5 7 7 8 7 5 7 7 8 R Square

6 8 6 7 8 5 8 7 7 Adjusted R Square

5 7 7 7 7 8 5 8 7 Standard Error

5 7 7 7 7 8 7 8 7 Observations 112

6 7 7 7 7 7 5 8 7

5 8 7 7 8 7 8 8 7 ANOVA
5 8 7 7 7 9 5 8 7 df SS MS F Significance F
7 8 7 8 8 9 9 8 8 Regression 1

6.2498721812

5 8 7 8 8 9 7 8 8 Residual 110

5 8 6 8 8 5 4 7 8 Total 111 103.2767857143

5 7 8 7 7 8 8 7 7

6 8 6 8 8 9 5 8 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
5 8 8 8 8 9 8 8 8 Intercept

2.8073034348 6.9964759124

5 8 6 7 8 7 8 8 7 Cohess

0.008935436

0.0933912733 0.6376642717

6 6 6 7 7 8 8 8 7
5 8 6 7 8 7 5 8 7

7 7 6 7 8 8 6 8 7 SUMMARY OUTPUT

5 7 6 8 8 7 6 8 8

5 6 8 7 8 8 6 8 7 Regression Statistics Accomplishment
6 7 8 7 8 8 6 8 7 Multiple R 0.0627757959
5 7 8 7 8 8 8 8 7 R Square 0.0039408005
5 8 7 7 8 8 5 7 7 Adjusted R Square -0.0051142831
5 7 8 7 8 8 8 8 7 Standard Error 1.5079111973
5 8 7 7 8 6 7 7 7 Observations 112

5 8 8 7 8 8 8 8 7

5 8 7 8 7 9 5 7 8 ANOVA
5 8 6 8 8 5 4 7 8 df SS MS F Significance F
5 7 8 7 7 8 8 7 7 Regression 1 0.9895631664 0.9895631664 0.435203109 0.5108257108
6 8 6 8 8 9 5 8 8 Residual 110 250.1175796908 2.273796179
5 8 8 8 8 9 8 8 8 Total 111 251.1071428571

5 8 6 7 8 7 8 8 7

6 6 6 7 7 8 8 8 7 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
5 8 6 7 8 7 5 8 7 Intercept 7.5262454667 1.6969616611 4.435129938 0.0000219086 4.1632657617 10.8892251717 4.1632657617 10.8892251717
7 7 6 7 8 8 6 8 7 Cohess -0.1454476045 0.2204756229 -0.6596992565 0.5108257108 -0.5823785395 0.2914833305 -0.5823785395 0.2914833305

5 7 6 8 8 7 6 8 8
5 6 8 7 8 8 6 8 7
6 7 8 7 8 8 6 8 7
5 7 8 7 8 8 8 8 7
7 8 6 8 7 8 7 9 8
5 7 8 8 8 9 8 8 8
5 8 6 8 8 8 7 7 8
6 7 8 8 8 8 8 8 8
6 8 7 8 8 7 7 7 8
5 6 8 8 8 8 8 8 8
5 8 7 7 8 8 5 7 7
5 8 8 8 7 8 6 8 8
6 7 7 7 8 7 9 7 7
6 7 7 7 8 8 5 7 7
5 8 6 7 7 7 8 7 7
7 8 6 7 9 7 5 7 7
6 7 7 7 8 8 8 7 7
5 7 7 7 8 8 5 7 7
6 8 6 8 7 8 4 9 8
7 8 6 8 7 8 7 9 8
5 7 8 8 8 9 8 8 8
5 8 6 8 8 8 7 7 8
6 7 8 8 8 8 8 8 8
6 8 7 8 8 7 7 7 8
5 6 8 8 8 8 8 8 8
5 8 7 7 8 8 5 7 7
5 8 8 8 7 8 6 8 8
6 7 7 7 8 7 9 7 7
6 7 7 7 8 8 5 7 7
5 8 6 7 7 7 8 7 7
7 8 6 7 9 7 5 7 7
6 7 7 7 8 8 8 7 7
5 7 7 7 8 8 5 7 7

0.340136321	0.2522386659
0.1156927169	0.0636243446
0.0826345007	0.0464431399
0.6217630366	0.9419181479
5.4117334257	1.3529333564	3.4996660497	0.0099993929	6.5709177999	3.2854588999	3.7031364054	0.0277991308
107	41.3650522886	0.3865892737	96.7058679144	0.8872097974
46.7767857143			103.2767857143
4.1145307363	1.389454548	2.9612560859	0.0037746185		1.3600991467		6.8689623259	4.2500421876	1.5158641471	2.8037091555	0.0059819527	1.2456487293	7.2544356459
0.1453898567	0.0946282768	1.5364314095	0.1273844671		-0.0421996656		0.3329793789	0.3407685817	0.1437391973	2.3707422055	0.0195086653	0.0558821656	0.6256549979
-0.0779383784	0.0930619726	-0.8374890003	0.4041845		-0.2624228852		0.1065461284	0.1135844136	0.1888202338	0.601547892	0.5487242141	-0.2606511511	0.4878199783
0.0840576877	0.0848676127	0.9904566072	0.3241855064		-0.0841824563		0.2522978318
0.3717814362	0.1223017099	3.0398711234	0.0029756601		0.1293325604		0.614230312
0.1238610646
0.0153415633
	0.0627757959	0.006390123
	0.0039408005	0.9614967421
	-0.0051142831
	1.5079111973
	1.584427348	1.7138653394		0.1932127769
101.6923583663	0.9244759851
			0.9895631664		0.435203109				0.5108257108
	250.1175796908		2.273796179
	251.1071428571
5.9137022398	1.3715791842	4.311601042	0.0000354737		3.1955542308		8.6318502488
0.2417654809	0.1846740803	1.3091467982		-0.1242151999		0.6077461617
	7.5262454667		1.6969616611		4.435129938		0.0000219086				4.1632657617		10.8892251717
	-0.1454476045		0.2204756229		-0.6596992565				-0.5823785395			0.2914833305
0.2459994926
0.0605157503
0.0519749844
0.9391820113
	6.2498721812	7.0855179753		0.008935436
97.0269135331	0.8820628503
4.9018896736	1.0569295252	4.6378585861	0.0000097577		2.8073034348		6.9964759124
0.3655277725	0.1373202476	2.6618636282		0.0933912733		0.6376642717

8,9

GroupSize EffMgDiv IdenHealComp Success ParWithGroup ConfGroupNorms EmpGGoalAcc Cohess
9 7 6 7 8 7 7 7 SUMMARY OUTPUT
8 8 6 7 7 8 5 7 SUMMARY OUTPUT
9 8 7 8 7 6 5 9 GS Participation Regression Statistics
8 8 7 8 7 8 5 9 Multiple R

Regression Statistics Participation

8 6 7 7 7 5 5 9 R Square

Multiple R

8 8 6 8 7 8 8 9 Diversity Adjusted R Square

R Square

8 7 7 8 7 7 4 8 GC Conformity Standard Error

Adjusted R Square

8 7 8 8 8 7 8 8 Observations 46 Standard Error

8 8 8 8 7 8 7 7 Identity Observations 46
8 7 8 8 7 8 8 7 ANOVA
8 7 6 7 7 5 8 7 0.74 df SS MS F Significance F ANOVA
9 7 6 7 7 9 4 7 Success Accomplishment Regression 4

df SS MS F Significance F

8 8 7 7 9 7 8 7 Residual 41

Regression 1

0.9252305665

8 8 7 8 7 9 8 8 Total 45

Residual 44

9 6 7 7 8 5 9 7 Total 45

8 8 7 8 8 7 8 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
8 7 7 8 8 8 8 7 Intercept

-0.2866206583 12.5552887799 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

9 8 6 7 8 8 8 8 GroupSize

-0.5642744357 0.4212887019 Intercept

7.0777835189 11.0207013296

8 8 7 7 8 7 8 8 EffMgDiv

-0.383003563 0.2524060406 Cohess

0.1239895407

-0.4587539724 0.0572388209

8 8 7 7 8 9 5 7 IdenHealComp

-0.730604772 -0.1243955194

9 8 6 7 8 9 5 8 Success

0.2454953773 1.2348797013

8 7 6 7 7 8 5 8
8 8 6 7 8 9 5 8 SUMMARY OUTPUT
9 8 8 7 8 9 5 7 SUMMARY OUTPUT
8 8 7 7 8 8 5 7 Regression Statistics
9 8 6 7 8 9 5 8 Multiple R

Regression Statistics

8 7 6 7 7 8 5 8 R Square

Multiple R

Conformity

8 8 6 7 8 9 5 8 Adjusted R Square

R Square

9 8 8 7 8 9 5 7 Standard Error

Adjusted R Square

8 8 7 7 8 8 5 7 Observations 46 Standard Error

8 7 7 8 7 7 4 8 Observations 46
8 7 8 8 8 7 8 8 ANOVA
8 8 8 8 7 8 7 7 df SS MS F Significance F ANOVA
8 7 8 8 7 8 8 7 Regression 3

df SS MS F Significance F

8 7 6 7 7 5 8 7 Residual 42

Regression 1

1.6838768116

9 7 6 7 7 9 4 7 Total 45 22.9565217391 Residual 44

8 8 7 7 9 7 8 7 Total 45

8 6 7 7 7 5 5 9 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
8 8 6 8 7 8 8 9 Intercept

1.675739827 9.0796659579 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

8 7 7 8 7 7 4 8 EffMgDiv

-0.3795671883 0.2484242509 Intercept

5.5578840692 13.6504492641

8 7 8 8 8 7 8 8 IdenHealComp

-0.7246853326 -0.1261992504 Cohess

0.3082678547

-0.8003530343 0.2586863677

8 8 8 8 7 8 7 7 Success

0.2935832769 1.2287419126

8 7 8 8 7 8 8 7
8 7 6 7 7 5 8 7 SUMMARY OUTPUT
9 7 6 7 7 9 4 7
8 8 7 7 9 7 8 7 Regression Statistics
Multiple R

SUMMARY OUTPUT

R Square

Adjusted R Square

Regression Statistics Accomplishment

Standard Error

Multiple R

Observations 46 R Square

Adjusted R Square

ANOVA Standard Error

df SS MS F Significance F Observations 46
Regression 2

Residual 43

ANOVA

Total 45 22.9565217391 df SS MS F Significance F
Regression 1

3.0355731225

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Residual 44

Intercept

2.0140842629 7.7897814542 Total 45

IdenHealComp

-0.7196362554 -0.1275661861

Success

0.2952073458 1.2201537936 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

Intercept

3.8352994496 14.4374278231

Cohess

0.2965468081

-1.0573639656 0.3300912383

0.4811065668
0.2314635286	0.2300784153
0.1564843606	0.0529360772
0.655984165	0.0314118971
0.6133557158
5.3135975255	1.3283993814	3.0870378389	0.0260262797
17.6429242137	0.4303152247		0.9252305665	2.4593771764		0.1239895407
		22.9565217391	16.553030303	0.3762052342
17.4782608696
6.1343340608	3.1794129523	1.9293920459	0.0606225644		-0.2866206583		12.5552887799
-0.0714928669	0.2440067204	-0.2929954831	0.7710034542		-0.5642744357		0.4212887019	9.0492424242	0.9782130716	9.2507886954		7.0777835189		11.0207013296
-0.0652987612	0.1573153536	-0.4150819338	0.6802460846		-0.383003563		0.2524060406	-0.2007575758	0.1280145617	-1.5682401527		-0.4587539724		0.0572388209
-0.4275001457	0.1500859011	-2.8483697843	0.0068403028		-0.730604772		-0.1243955194
0.7401875393	0.2449527735	3.0217561065	0.0043167063		0.2454953773		1.2348797013
0.4794312845
0.2298543565	0.1535558573
0.1748439534	0.0235794013
0.6488059583	0.0013880241
1.2588700441
5.2766565327	1.7588855109	4.1783797894	0.011218733
17.6798652064	0.4209491716		1.6838768116	1.0625479014		0.3082678547
69.7291666667	1.5847537879
71.4130434783
5.3777028924	1.8343970218	2.9315915957	0.0054371798		1.675739827		9.0796659579
-0.0655714687	0.155591183	-0.4214343474	0.6755870659		-0.3795671883		0.2484242509	9.6041666667	2.0077144481	4.7836317937	0.0000196344		5.5578840692		13.6504492641
-0.4254422915	0.1482809347	-2.8691638103	0.0064154741		-0.7246853326		-0.1261992504	-0.2708333333	0.2627410045	-1.0307996417		-0.8003530343		0.2586863677
0.7611625948	0.2316949394	3.2851930074	0.0020615724		0.2935832769		1.2287419126
0.4760227032
0.226597614
0.19062541
0.6425716626	0.1572777517
0.0247362912
0.0025712069
1.6492547779
5.2018930514	2.6009465257	6.2992418807	0.0039876627
17.7546286877	0.4128983416
	3.0355731225	1.116002576		0.2965468081
119.6818181818	2.7200413223
4.9019328586	1.4319729093	3.4232022316	0.0013701433		2.0140842629		7.7897814542	122.7173913043
-0.4236012208	0.1467923736	-2.8857168152	0.0060837099		-0.7196362554		-0.1275661861
0.7576805697	0.2293226622	3.3039934324	0.0019270633		0.2952073458		1.2201537936
9.1363636364	2.6303212645	3.4734782248	0.0011655382		3.8352994496		14.4374278231
-0.3636363636	0.3442188962	-1.0564102309		-1.0573639656		0.3300912383

Turn in your highest-quality paper
Get a qualified writer to help you with

“ regression technique, excel, dataset ”

Get high-quality paper

NEW! AI matching with writer

Hire a Writer

Client Reviews

4.9

Sitejabber

4.6

Trustpilot

4.8

Our Guarantees

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Money Back

If you're confident that a writer didn't follow your order details, ask for a refund.

New to Your Trusted Assignment Help Service? Sign up & Save

Calculate the price of your order

Type of paper needed:

Pages:

You will get a personal manager and a discount.

Academic level:

We'll send you the first draft for approval by at

Total price:

$0.00

Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.

Power up Your Study Success with Experts We’ve Got Your Back.

Order Now Order Now