[Virtual Presenter] LINEAR REGRESSION AI PRACTICAL BY NAVYA AND ASTHA.
[Virtual Presenter] USING LINEAR REGRESSION CALCULATION OF EXPECTED SALARY ACCORDING TO EXPERIENCE.
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.
[Virtual Presenter] 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).
[Virtual Presenter] LIST OF VALUES WE GET.. M (SLOPE)=2992.1 C (Y INTERCEPT)=29626 Y=DEPENDENT VALUE X=INDEPENDENT VALUE.
[Virtual Presenter] 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.
[Virtual Presenter] THANK YOU…. THANK YOU….