2.3.2: Excel: Linear regression.

The famous iris dataset (the first sheet of the spreadsheet linked above) was first published in 1936 by Ronald Fisher. The dataset contains 50 samples from 3 iris species: setosa, virginia, and versicolor. Four features are measured, all in cm: sepal length, sepal width, petal length, and petal width.

What is the equation for the least square regression line where the independent or predictor variable is sepal length and the dependent or response variable is sepal width for iris versicolor?

What is the predicted sepal width for iris versicolor for a flower with a sepal length of 5.19?