Scene 1

LINEAR 
REGRESSION   
AI PRACTICAL BY NAVYA AND ASTHA

Scene 2

USING LINEAR REGRESSION
CALCULATION OF EXPECTED 
SALARY ACCORDING TO 
EXPERIENCE

Scene 3

Manya Goyal
File
Home
I nsert
Page Layout
Calibri
BIU
Formulas Data Review
-11
Font
View
Help
Salary_Data graph
C) Tell me what you want to do
X Cut
li Copy
•y Format Painter
Clipboard
O POSSIBLE DATA Loss
W24
B
1 YearsExpe Salary
Wrap Text
Merge & Center v
General
_ 00
Number
- Excel
.00
Conditional Format as Cell
Formatting v Table v Styles
styles
AutoSum
Fill
Insert Delete Format
Clear
z
Sort &
Editing
Find &
Select v
Alignment
Add-ins
Add-ins
Some features might he lost it vow save. this workbook in comma-delimited (rsv) format. To preserve these save it in an format. Don't show again
c
O
S
w
2
4
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Ready
1.1
1.3
1.5
2
2.2
2.9
3
3.2
3.2
3.7
3.9
4
4
4.1
4.5
4.9
5.1
5.3
5.9
6
6.8
7.1
7.9
8.2
8.7
9
39343
46205
37731
43525
39891
56642
60150
54445
64445
57189
63218
55794
56957
57081
67938
66029
83088
81363
93940
91738
98273
101302
113812
109431
105582
Salary_Data graph
(9Accessibiliw: unavailable

Scene 4

LINEAR REGRESSION OF DATA
y = 2992.1x + 29626
0
20000
40000
60000
80000
100000
120000
140000
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
SALARY
YearsExperience
Salary
Linear (Salary)

Scene 5

LIST OF VALUES WE GET..
• M (SLOPE)=2992.1
• C (Y INTERCEPT)=29626
• Y=DEPENDENT VALUE
• X=INDEPENDENT VALUE

Scene 6

NOW PREDICTION OF SALARY USING 
LINEAR REGRESSION
• Expected Salary of a person with 10 year of experience
• =10* 2992.1+ 29626=59547
• Expected salary of a person with 5 year experience
• =5*2992.1+29626=44586.5

Scene 7

AI PROJECT 22

Scene 0

Linear  Regression    Ai Practical By Navya And Astha

avatar

Using Linear Regression Calculation Of Expected  Salary According To  Experience

Linear Regression Of Data Y = 2992.1x + 29626

SALARY YearsExperience Salary Linear (Salary)

Now Prediction Of Salary Using  Linear Regression

Expected Salary of a person with 10 year of experience

Expected salary of a person with 5 year experience

AI PROJECT 22

Scene 1 (0s)

Scene 2 (16s)

Scene 3 (28s)

Scene 4 (44s)

Scene 5 (49s)

Scene 6 (59s)

Scene 7 (1m 22s)