CHALLENGE ACTIVITY 2.3.2: Excel: Linear regression. Click this link to download the spreadsheet for use in this activity. 441724.2292792.qx3zqy7 Jump to level 1 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 virginica? y = Ex: 1.234 0 x+ Ex: 1.234 What is the predicted sepal width for iris virginica for a flower with a sepal length of 4.6? Ex: 5.12 . cm 1 2 Check NextI Refresh All WE Queries Le Workbook Links IIll Stocks Lig Currencies 149 X V A B C D E F 1 Sepal length Sepal width Petal length Petal width Species 2 5.1 3.5 1.4 0.2 Iris-setosa w 4.9 3 1.4 0.2 Iris-setosa 4 4.7 3.2 1.3 0.2 Iris-setosa 4.6 3.1 1.5 0.2 Iris-setosa 5 3.6 1.4 0.2 Iris-setosa 5.4 3.9 1.7 0.4 Iris-setosa 8 4.6 3.4 1.4 0.3 Iris-setosa g 5 3.4 1.5 0.2 Iris-setosa 10 4.4 2.9 1.4 0.2 Iris-setosa 4.9 3.1 1.5 0.1 Iris-setosa 12 5.4 3.7 1.5 0.2 Iris-setosa 13 4.8 3.4 1.6 0.2 Iris-setosa 14 4.8 3 1.4 0.1 Iris-setosa 15 4.3 3 1.1 0.1 Iris-setosa 16 5.8 4 1.2 0.2 Iris-setosa 17 5.7 4.4 1.5 0.4 Iris-setosa 18 5.4 3.9 1.3 0.4 Iris-setosa 19 5.1 3.5 1.4 0.3 Iris-setosa 20 5.7 3.8 1.7 0.3 Iris-setosa 21 5.1 3.8 1.5 0.3 Iris-setosa 22 5.4 3.4 1.7 0.2 Iris-setosa 23 5.1 3.7 1.5 0.4 Iris-setosa 24 4.6 3.6 1 0.2 Iris-setosa 25 5.1 3.3 1.7 0.5 Iris-setosa 26 4.8 3.4 1.9 0.2 Iris-setosa 27 5 3 1.6 0.2 Iris-setosa 28 5 3.4 1.6 0.4 Iris-setosa 29 5.2 3.5 1.5 0.2 Iris-setosa 30 5.2 3.4 1.4 0.2 Iris-setosa 31 4.7 3.2 1.6 0.2 Iris-setosa