![linear regression excel 2020 linear regression excel 2020](https://slideplayer.com/slide/17545710/103/images/3/Step+1+Open+the+Excel+workbook+titled+Chapter+15+-+Excel+Extension.xlsx+..jpg)
In this linear regression, the total amount of money you’d have to pay would be the dependent variable, which means it would be the output of our model.
![linear regression excel 2020 linear regression excel 2020](https://www.lifewire.com/thmb/7yOWwQN4Q7mJ5vCzpcFY1dfTbDE=/1399x853/filters:no_upscale():max_bytes(150000):strip_icc()/007B-how-to-run-regression-in-excel-4690640-7d87f20a5d0d4030a6be95ba3b9e84a3.jpg)
You can use a linear regression model here to determine the cost of gas you’ll have to get. Before going on a trip this long, it’s best to prepare a budget and figure out how much you need to spend on a particular section. Suppose you want to go on a long drive (from Delhi to Lonawala). Our Top Linear Regression Project Ideas Idea #1: Budget a Long Drive
![linear regression excel 2020 linear regression excel 2020](https://miro.medium.com/max/1248/1*2TBcBpQ9Kg_e9Id3nq5rww.png)
Now that we’ve discussed the basic concepts of linear regression, we can move onto our linear regression project ideas. When we find the best values for 1 and 2, we find the best line for your linear regression as well. 1 is the intercept, and 2 is the coefficient of x. To get the best line, it finds the most suitable values for 1 and 2. The linear regression model finds the best line, which predicts the value of y according to the provided value of x. The hypothesis function for linear regression is the following: The output here is the dependent value, and the input is the independent value. Linear regression predicts the dependent value (y) according to the independent variable (x). Regression models depend on the relationship between the independent and dependent variables as well as the number of variables they use. It models a prediction value according to independent variables and helps in finding the relationship between those variables and the forecast. Linear Regression is a supervised learning algorithm in machine learning.