# Ideal Salary Calculations using Regression - Task

Hello Friends,

We have a task on finding some calculations using multiple regression concepts. You can use any back-end technology and show the output to us which should be useful to us to use it in our asp.net form.

We need to find the ideal Salary of a sales representative, for that we will provide you the tables and database for the input values, you need to apply the inputs in the following formula and need to show the output value.

Formula 1:

Salary = ß0 + ß1 * Age + ß2 * Experience + ß3 * firmKnowledge + ß4 * gender + ß5 * highestEducationCompleted + ß6 * jobTitle + ß7 * negotiationSkills + ß8 * presentationSkills + ß9 * productKnowledge + ß10 * salesTechnologySkills + ß11 * timeManegmentSkills

We are sharing the input values for the Formula 1 through Regressions excel (Sheet name: Formula 1) for your understanding and reference.

Then, to calculate the individual’s ideal salary for that round, use the same formula:

Formula 2:

Ideal Salary = ß0 + ß1 * AgeSalesRep + ß2 * ExperienceSalesRep + ß3 * firmKnowledgeSalesRep + ß4 * genderSalesRep + ß5 * highestEducationCompletedSalesRep + ß6 * jobTitleSalesRep + ß7 * negotiationSkillsSalesRep + ß8 * presentationSkillsSalesRep + ß9 * productKnowledgeSalesRep + ß10 * salesTechnologySkillsSalesRep + ß11 * timeManagementSkillsSalesRep

We are sharing the input values for the Formula 2 through Regressions excel (Sheet name: Formula 2) for your understanding and reference.

Upon your confirmation for taking up the above task we can provide you the tables and database for input values.

After successful completion of the above task need to submit the source code with documentation and proper KT.

It is an urgent requirement, if you can assist us immediate it would be great.

Skills: Microsoft SQL Server