Factor-Hair-Revised.CSV Advanced Statistics

Please refer to the Project video for complete context about the “Advance Statistics” problem.

The objective of the project is to use the dataset ‘

Factor-Hair-Revised.csv

‘ to build an optimum regression model to predict satisfaction. You are expected to

Perform exploratory data analysis on the dataset. Showcase some charts, graphs. Check for outliers and missing values (8 marks)
Is there evidence of multicollinearity ? Showcase your analysis(6 marks)
Perform simple linear regression for the dependent variable with every independent variable (6 marks)
Perform PCA/Factor analysis by extracting 4 factors. Interpret the output and name the Factors (20 marks)
Perform Multiple linear regression with customer satisfaction as dependent variables and the four factors as independent variables. Comment on the Model output and validity. Your remarks should make it meaningful for everybody
(20 marks)

Please note the following:

You have to submit 2 files :
Business Report: In this you need to submit all the answers to all the questions in a sequential manner. Your answer should include detailed explanations & inferences to all the questions. Your report should not be filled with codes. You will be evaluated based on the business report. It should include the detailed explanation of approach used, insights, inferences, all outputs of codes like graphs, tables etc.
R code file : This is a must and will be used for reference while evaluating
You must give the sources of data presented. Do not refer to blogs; Wikipedia etc.
Any assignment found copied/ plagiarized with other group(s) will not be graded and marked as zero.
Please ensure timely submission as post deadline assignment will not be accepted.

Thanks

Program Office

Scoring guide (Rubric) – Project 2 Rubric (1)

CriteriaPoints1.1 EDA – Basic data summary, Univariate, Bivariate analysis, graphs -4

1.2 EDA – Check for Outliers and missing values and check the summary of the dataset -4

2. Check for Multicollinearity – Plot the graph based on Multicollinearity -6

3. Simple Linear Regression (with every variable) -6

4.1 Perform PCA/FA and Interpret the Eigen Values (apply Kaiser Normalization Rule) -10

4.2 Output Interpretation Tell why only 4 factors are being asked in the questions and tell whether it is correct in choosing 4 factors. Name the factors with correct explanations. -10

5.1 Create a data frame with a minimum of 5 columns, 4 of which are different factors and the 5th column is Customer Satisfaction – 3

5.2 Perform Multiple Linear Regression with Customer Satisfaction as the Dependent Variable and the four factors as Independent Variables -4

5.3 MLR summary interpretation and significance (R, R2, Adjusted R2,Degrees of Freedom, f-statistic, coefficients along with p-values) -8

5.4 Output Interpretation -5

2 8.2

4.9

3.4

5.6

5.4 4.5

7 3.7

4.7 4.5

5 9 3.4

6 4.5 6.8

4.5

3.1

4 4.3 3.7

5.1

3.3 4.7

3.7 5

5.4 8.9 4.8 2.1 2 5.7

8 6.2 3.3 3.9 4.8 4.6 3.6 5.1 6.9 5.4 4.3 3.7

9 5.8 3.6 5.1

3.7 5.9 5.8

5.9

4.6 7

6.4 4.5 5.1 6.1 4.7 5.7 5.7

5.4 4.1 4.4 5.5

4.6 4.8 2.7 6.8 4.6 6.8 5.8

4 7.4

6.1 4.9 6.3 3.9 4.4 3.9 6.4 8.2 5.8 3 3.2 6

5.6 4.6 6.9 5 6.9

6.5 5.1 4.4 8.4

9.2 3.9 5.7 5.5

8.4 4.8 7.1 6.7 4.5

7.6

6.3 4.5 4.7 6.9 4.5 6.8 5.9 8.8 6 4.8 5.2 8

8.7 3.2 4 6.8 3.2

3.8 4.9 6.1 4.3 4.5 6.6

5.7 4 6.7 6 3.3 5.5 5.1 6.2 6.7 4.2 4.5 6.4

5.9 4.1 5.5 7.2 3.5 6.4 5.5 8.4 6.2 5.7 4.8 7.4

5.6 3.4 5.1 6.4 3.7 5.7 5.6

5.4 5 4.5 6.8

9.1 4.5 3.6 6.4 5.3 5.3 7.1 8.4 5.8 4.5 4.4 7.6

5.2 3.8 7.1 5.2 3.9 4.3 5 8.4 7.1 3.3 3.3 5.4

5.7 6.8 5.9 5.4

7.8 4.5 6.4 4.3 4.3

3.6 7.4 5.1 3.5

4.7 3.7 6.7 4.8 4 7

9.3 2.4 2.6 7.2 2.2 7.2 4.5 6.2 6.4 6.7 4.5 8.6

6 4.1 5.3 4.7 3.5 5.3 5.3 8 6.5 4.7 4 4.8

6.4 3.6 6.6 6.1 4 3.9 5.3 7.1 6.1 5.6 3.9 6.6

8.5 3 7.2 5.8 4.1 7.6 3.7 4.8 6.9 5.3 4.4 6.3

7 3.3 5.4 5.5 2.6 4.8 4.2 9 6.5 4.3 3.7 5.4

8.5 3 5.7 6 2.3 7.6 3.7 4.8 5.8 5.7 4.4 6.3

7.6 3.6 3 4 5.1 4.2 4.6

4.9 4.7 3.5 5.4

6.9 3.4 8.5 4.3 4.5 6.4 4.7 5.2 7.7 3.7 3.3 6.1

7.2 4.5 2.3 5.1 3.8 6.6 6.8 3 3 6.4

6.7 3.7 6.5 5.3 5.3 5.1 4.9 9.2 5.7 3.5 3.4 5.4

8 3.3 6.1 5.7 5.5 4.6 4.7 8.7 5.9 4.7 4.2 7.3

6.7 4 5.2 3.9 3 5.4 6.8 8.4 6.2 2.5 3.5 6.3

8.7 3.2 6.1 4.3 3.5 6.1

5.6 6.1 3.1 2.5 5.4

9 3.4 5.9 4.6 3.9 6 4.5 6.8 6.4 3.9 3.5 7.1

9.6 4.1 6.2 7.3 2.9 7.7 5.5 7.7 6.1 5.2 4.9 8.7

8.2 3.6 3.9 6.2 5.8 4.9 5 9 5.2 4.7 4.5 7.6

6.1 4.9 3 4.8 5.1 3.9 6.4 8.2 5.1 4.5 3.2 6

8.3 3.4 3.3 5.5 3.1 4.6 5.2 9.1 4.1 4.6 3.9 7

3.8 4.7 5.4 3.8 6.5 4.9 8.5 4.9 4.1 4.1 7.6

9.3 5.1 4.6 6.8 5.8 6.6 6.3 7.4 5.1 4.6 4.3 8.9

5.1 5.1 6.6 6.9 4.4 5.4 7.8 5.9 7.2 4.9 4.5 7.6

8 2.5 4.7 7.1 3.6 7.7 3 5.2 5.1 4.3 4.7 5.5

5.9 4.1 5.7 5.9 5.8 6.4 5.5 8.4 6.4 5.2 4.8 7.4

10 4.3 7.1 6.3 2.9 5.4 4.5 3.8 6.7 5 3.5 7.1

5.7 3.8 6.8

5.7 5.7 6 8.2 6.6 6.5 5.2 7.6

9.9 3.7 3.7 6.1 4.2 7 6.7 6.8 5.9 4.5 3.9 8.7

7.9 3.9 4.3 5.8 4.4 6.9 5.8 4.7 5.2 4.1 4.3 8.6

6.7 3.6 5.9 4.2 3.4 4.7 4.8 7.2 5.7 4 2.8 5.4

8.2 2.7 3.7 7.4 2.7 7.9 3.1 5.3 5.3 4.5 4.9 5.7

9.4 2.5 4.8 6.1 3.2 7.3 4.6 6.3 6.3 4.7 4.6 8.7

6.9 3.4 5.7 4.4 3.3 6.4 4.7 5.2 6.4 3.2 3.3 6.1

8 3.3 3.8 5.8 3.2 4.6 4.7 8.7 5.3 4.9 4.2 7.3

9.3 3.8 7.3 5.7 3.7 6.4 5.5 7.4 6.6 4.1 3.4 7.7

7.4 5.1 4.8 7.7 4.5 7.2 6.9 9.6 6.4 5.7 5.5 9

7.6 3.6 5.2 5.8 5.6 6.6 5.4 4.4 6.7 4.6 4 8.2

10 4.3 5.3 3.7 4.2 5.4 4.5 3.8 6.7 3.7 3.5 7.1

9.9 2.8 7.2 6.9 2.6 5.8 3.5 5.4 6.2 5.6 4 7.9

8.7 3.2 8.4 6.1 2.8 7.8 3.8 4.9 7.2 5.4 4.5 6.6

8.4 3.8 6.7 5 4.5 4.7 5.9 6.7 5.1 2.7 3.6 8

8.8 3.9 3.8 5.1 4.3 4.7 4.8 5.8 5 4.4 2.9 6.3

7.7 2.2 6.3 4.5 2.4 4.7 3.4 6.2 6 3.3 2.6 6

6.6 3.6 5.8 4.1 4.9 4.7 4.8 7.2 6.5 3.5 2.8 5.4

5.7 3.8 3.5 6.7 5.4 5.7 6 8.2 5.4 4.7 5.2 7.6

5.7 4 7.9 6.4 2.7 5.5 5.1 6.2 7.5 5 4.5 6.4

5.5 3.7 4.7 5.4 4.3 5.3 4.9 6 5.6 4.5 4.3 6.1

7.5 3.5 3.8 3.5 2.9 4.1 4.5 7.6 5.1 4 3.4 5.2

6.4 3.6 2.7 5.3 3.9 3.9 5.3 7.1 5.2 4.7 3.9 6.6

9.1 4.5 6.1 5.9 6.3 5.3 7.1 8.4 7.1 5.4 4.4 7.6

6.7 3.2 3 3.7 4.8 6.3 4.5 5 5.2 2.9 3.1 5.8

6.5 4.3 2.7 6.6 6.5 6.3 6 8.7 4.7 4.6 4.6 7.9

9.9 3.7 7.5 4.7 5.6 7 6.7 6.8 7.2 4.1 3.9 8.6

8.5 3.9 5.3 5.5 5 4.9 6 6.8 5.7 4.4 3.7 8.2

9.9 3 6.8 5 5.4 5.9 4.8 4.9 7.3 3.1 3.8 7.1

7.6 3.6 7.6 4.6 4.7 4.6 5 7.4 8.1 4.5 3.9 6.4

9.4 3.8 7 6.2 4.7 6.5 4.9 8.5 7.3 4.3 4.1 7.6

9.3 3.5 6.3 7.6 5.5 7.5 5.9 4.6 6.6 5.2 4.6 8.9

7.1 3.4 4.9 4.1 4 5 5.9 7.8 6.1 2.6 2.7 5.7

9.9 3 7.4 4.8 4 5.9 4.8 4.9 5.9 3.2 3.8 7.1

8.7 3.2 6.4 4.9 2.4 6.8 4.6 6.8 6.3 4.3 4 7.4

8.6 2.9 5.8 3.9 2.9 5.6 4 6.3 6.1 2.7 3 6.6

6.4 3.2 6.7 3.6 2.2 2.9 5 8.4 7.3 2

7.7 2.6 6.7 6.6

7.2 4.3 5.9 6.5 4.7 4.3 8.2

7.5 3.5 4.1 4.5 3.5 4.1 4.5 7.6 4.9 3.4 3.4 5.2

5 3.6

3 3.5 4.2 4.9 8.2 4.3 2.4 3.1 5.2

7.7 2.6 8 6.7 3.5 7.2 4.3 5.9 6.9 5.1 4.3 8.2

9.1 3.6 5.5 5.4 4.2 6.2 4.6 8.3 6.5 4.6 3.9 7.3

5.5 5.5 7.7 7 5.6 5.7 8.2 6.3 7.4 5.5 4.9 8.2

9.1 3.7 7 4.1 4.4 6.3 5.4 7.3 7.5 4.4 3.3 7.4

7.1 4.2 4.1 2.6 2.1 3.3 4.5 9.9 5.5 2 2.4 4.8

9.2 3.9 4.6 5.3 4.2 8.4 4.8 7.1 6.2 4.4 4.2 7.6

9.3 3.5 5.4 7.8 4.6 7.5 5.9 4.6 6.4 4.8 4.6 8.9

9.3 3.8 4 4.6 4.7 6.4 5.5 7.4 5.3 3.6 3.4 7.7

8.6 4.8 5.6 5.3 2.3 6 5.7 6.7 5.8 4.9 3.6 7.3

7.4 3.4 2.6 5 4.1 4.4 4.8 7.2 4.5 4.2 3.7 6.3

8.7 3.2 3.3 3.2 3.1 6.1 2.9 5.6 5 3.1 2.5 5.4

7.8 4.9 5.8 5.3 5.2 5.3 7.1 7.9 6 4.3 3.9 6.4

7.9 3 4.4 5.1 5.9 4.2 4.8

5.7 3.4 3.5 6.4

ID	ProdQual	Ecom	TechSup	CompRes	Advertising	ProdLine	SalesFImage	ComPricing	WartyClaim	OrdBilling	DelSpeed	Satisfaction
1									8														5							3				9		2							5.9			4					4.9					6		6.8	4.	7		3.7	8.2
									2.7															5.1								7.2						3.4	7.9					3.1				5.3				5.5					3.9				5.7
			9.2													5.6															5.4						7.4							5.8						4.5				6.2	8.9
																						6.4					3.3														4.7	8.8					4.3						4.8
																			5.2														4.6		2.2					6.1					3.5				7.1
												6.5			2.8											4.1	8.5										3.6
												6.9							2.6	2.1		2.3
																	6.3
																		6.7			9.3							4.4
		10												8.4
11												8.7									3.2								3.8
12
13	9.5															6.6									7.6
14						2.4													4.2
15
16							7.8
17
18
19						9.1
20
21
22			9.6			8.3							9.9
23						8.6										7.3
24
25
26
27
28
29
30												7.7
31
32		8.1						2.5
33
34
35
36										2.9
37
38
39
40
41
42			9.4
43
44
45
46
47
48								7.5
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84	1.6
85	1.9
86
87	1.3
88
89
90
91
92
93
94
95
96
97
98
99
100	9.7

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order