Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

avg_monthly_hrs,department,filed_complaint,last_evaluation,n_projects,recently_promoted,salary,satisfaction,status,tenure 221,engineering,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Left,5.0 232,support,,,3,,low,...

1 answer below »
avg_monthly_hrs,department,filed_complaint,last_evaluation,n_projects,recently_promoted,salary,satisfaction,status,tenure
221,engineering,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Left,5.0
232,support,,,3,,low, XXXXXXXXXX,Employed,2.0
184,sales,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
206,sales,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
249,sales,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
140,sales,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,4.0
121,sales,1.0, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
150,engineering,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
215,engineering,1.0, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,7.0
269,support,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,2.0
147,sales,,,2,,medium, XXXXXXXXXX,Left,3.0
188,sales,1.0, XXXXXXXXXX,6,,low, XXXXXXXXXX,Employed,5.0
191,support,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,4.0
290,engineering,, XXXXXXXXXX,6,,medium, XXXXXXXXXX,Left,4.0
253,sales,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,6.0
258,support,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Left,5.0
151,engineering,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,3.0
252,IT,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Left,5.0
276,product,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
154,marketing,,,2,,low, XXXXXXXXXX,Left,3.0
259,product,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Employed,3.0
136,marketing,,,3,,low, XXXXXXXXXX,Employed,3.0
176,IT,,,3,,low, XXXXXXXXXX,Employed,3.0
231,support,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,3.0
125,temp,,,2,,medium,,Employed,
109,sales,1.0, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
130,procurement,1.0, XXXXXXXXXX,6,,low, XXXXXXXXXX,Employed,6.0
163,sales,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Employed,3.0
67,temp,,,1,,low,,Employed,
184,sales,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,3.0
268,engineering,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,4.0
188,finance,, XXXXXXXXXX,3,,medium,1.0,Employed,4.0
107,engineering,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Employed,3.0
156,sales,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
234,IT,1.0, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,2.0
127,sales,,,5,,low, XXXXXXXXXX,Employed,3.0
282,IT,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,3.0
133,sales,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,4.0
270,engineering,, XXXXXXXXXX,6,,low, XXXXXXXXXX,Employed,5.0
184,,,1.0,5,,low, XXXXXXXXXX,Employed,5.0
132,marketing,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
126,support,1.0, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,10.0
139,product,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,3.0
308,engineering,, XXXXXXXXXX,7,,medium, XXXXXXXXXX,Left,4.0
70,temp,,,3,,low,,Employed,
147,engineering,,,2,,low, XXXXXXXXXX,Left,3.0
274,support,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Left,6.0
278,sales,, XXXXXXXXXX,7,,low, XXXXXXXXXX,Left,4.0
156,engineering,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,2.0
185,sales,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
263,sales,, XXXXXXXXXX,6,,low, XXXXXXXXXX,Employed,6.0
260,sales,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,3.0
224,support,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,2.0
224,sales,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,10.0
135,sales,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
147,marketing,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Employed,3.0
245,engineering,, XXXXXXXXXX,7,,medium, XXXXXXXXXX,Left,4.0
203,product,1.0, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
235,finance,1.0, XXXXXXXXXX,4,,high, XXXXXXXXXX,Employed,2.0
187,IT,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,5.0
132,management,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
258,product,, XXXXXXXXXX,7,,low, XXXXXXXXXX,Left,4.0
165,engineering,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
146,sales,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
159,,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
198,engineering,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Left,2.0
159,marketing,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
275,product,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Employed,3.0
141,support,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
173,finance,,,4,,low, XXXXXXXXXX,Employed,3.0
203,sales,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,2.0
203,engineering,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,5.0
230,sales,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,4.0
168,sales,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
183,IT,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
246,support,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,3.0
209,engineering,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,3.0
224,sales,,1.0,3,,medium, XXXXXXXXXX,Employed,6.0
143,support,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
140,sales,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Employed,2.0
212,support,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,4.0
156,marketing,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,5.0
186,IT,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,2.0
162,sales,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
158,support,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
156,sales,,,3,,low, XXXXXXXXXX,Employed,2.0
283,IT,,,3,,low, XXXXXXXXXX,Employed,3.0
113,,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
214,IT,1.0,,4,,low, XXXXXXXXXX,Employed,2.0
181,product,1.0, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
140,support,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
184,engineering,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
168,sales,1.0, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
146,engineering,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Left,3.0
251,engineering,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,2.0
219,support,,1.0,5,,low, XXXXXXXXXX,Left,5.0
170,product,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Employed,3.0
187,marketing,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,5.0
207,product,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
165,support,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,3.0
241,,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
139,engineering,,,4,,low, XXXXXXXXXX,Employed,3.0
165,support,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,4.0
167,engineering,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,2.0
163,sales,, XXXXXXXXXX,4,,medium, XXXXXXXXXX,Employed,3.0
161,,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Employed,5.0
271,IT,, XXXXXXXXXX,6,,low, XXXXXXXXXX,Left,4.0
310,sales,, XXXXXXXXXX,7,,medium, XXXXXXXXXX,Left,4.0
257,support,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
278,sales,, XXXXXXXXXX,7,,low, XXXXXXXXXX,Left,4.0
229,engineering,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,6.0
186,IT,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
211,sales,, XXXXXXXXXX,4,,high, XXXXXXXXXX,Employed,7.0
248,management,,,4,,high, XXXXXXXXXX,Employed,3.0
231,management,1.0,,3,,high, XXXXXXXXXX,Employed,2.0
266,sales,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,5.0
135,engineering,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
248,support,,1.0,5,,medium, XXXXXXXXXX,Left,5.0
161,IT,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
212,product,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,2.0
103,,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,3.0
160,sales,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,2.0
268,engineering,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,3.0
116,sales,1.0, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
150,,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
146,IT,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
215,IT,, XXXXXXXXXX,6,,medium, XXXXXXXXXX,Employed,3.0
194,sales,, XXXXXXXXXX,5,,high, XXXXXXXXXX,Employed,2.0
200,product,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,4.0
213,sales,, XXXXXXXXXX,3,,high, XXXXXXXXXX,Employed,3.0
163,information_technology,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,2.0
148,sales,, XXXXXXXXXX,2,,low, XXXXXXXXXX,Left,3.0
245,product,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Employed,5.0
250,support,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Left,2.0
250,sales,1.0, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,2.0
173,engineering,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Employed,2.0
248,sales,1.0, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,3.0
158,management,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,3.0
196,support,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
265,procurement,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,8.0
159,engineering,, XXXXXXXXXX,3,,high, XXXXXXXXXX,Employed,3.0
262,sales,, XXXXXXXXXX,5,,medium, XXXXXXXXXX,Employed,3.0
175,sales,, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,3.0
278,sales,, XXXXXXXXXX,7,,low, XXXXXXXXXX,Left,4.0
248,sales,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Left,5.0
275,product,, XXXXXXXXXX,3,,low, XXXXXXXXXX,Employed,2.0
258,support,, XXXXXXXXXX,5,,low, XXXXXXXXXX,Employed,6.0
253,engineering,,1.0,5,,medium, XXXXXXXXXX,Left,5.0
165,support,, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,5.0
269,support,1.0, XXXXXXXXXX,3,,medium, XXXXXXXXXX,Employed,4.0
148,finance,, XXXXXXXXXX,2,,medium, XXXXXXXXXX,Left,3.0
156,sales,1.0, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
274,sales,1.0, XXXXXXXXXX,4,,low, XXXXXXXXXX,Employed,2.0
196,support,1.0,1
employeedata-2smncxm1.csv kchousedata-ezuao0au-effclxto.csv
Answered 2 days After Oct 22, 2021

Solution

Suraj answered on Oct 25 2021
123 Votes
Exploratory Data Analysis and Modelling

Introduction: As we are given the data set of house price with different variables and the requirement is to do the exploratory data analysis (EDA) and then fit a multiple linear regression to predict the price of a house with given values of different variables.
First, we will do some visualization to see the pattern about the data. The different plots are given as follows:
Here, first we plot the histograms for all the variables in the data set to see their distribution. The first histogram is of the dependent variable price. We can clearly see that the distribution of dependent variable is positively skewed as there is long tail towards to the right side.
The next histograms are for all the independent variables. We can see that the distribution of all the variables is positively skewed as there is long tail towards right side for all the variables.
From the next plot, we can see that there are number of outliers in the price variable. These outliers will affect the model in the fitting of the model.
From the next plot, we can see that the distribution of the number of bedrooms is symmetric as the bars are looking symmetric in both sides. Thus, we can say that the distribution of the number of bedrooms is normal distribution.
From the next plot, we can see...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File