Skip to content

Arif-Rehman/ExcelR-Assignment---Multi-Linear-Regression-Assignment---5

Repository files navigation

ExcelR-Assignment---Multi-Linear-Regression-Assignment---5

Multiple linear regression : Multiple linear regression is used to estimate the relationship between two or more independent variables and one dependent variable. You can use multiple linear regression when you want to know:

  1. How strong the relationship is between two or more independent variables and one dependent variable (e.g. how rainfall, temperature, and amount of fertilizer added affect crop growth).

  2. The value of the dependent variable at a certain value of the independent variables (e.g. the expected yield of a crop at certain levels of rainfall, temperature, and fertilizer addition).

This assignment will study following Questions:

Statement No 1 :

Prepare a prediction model for profit of 50 startups data.

Do transformations for getting better predictions of profit and make a table containing R^2 value for each prepared model.

Statement No 2 :

Consider only the below columns and prepare a prediction model for predicting Price.

Corolla [ "Price", "Age_08_04", "KM", "HP", "cc", "Doors", "Gears", "Quarterly_Tax", "Weight" ]