CHALLENGE ACTIVITY 2.3.2: Excel: Linear regression. Click this link to download the spreadsheet for use in this activity. Jump to level 1 2 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 petal length and the dependent or response variable is petal width for iris versicolor? y = Ex: 1.234 + Ex: 1.234 What is the predicted petal width for iris versicolor for a flower with a petal length of 6.82? Ex: 5.12 cm0.3 Iris-set osa 1.8 Iris-virginica 2. 4.5 1.3 7.2 5. 1.6 Iris-versicolor 1.8 Iris-virginica 5.4 w 4.5 1.5 Iris-versicolor 4.4 1.3 0.2 Iris-setosa 45 1.6 0.6 Iris-setosa un 4.9 1.8 Iris-virginica 3.4 1.6 Iris-versicolor as w co in is w 0.4 Iris-set osa 5.6 2.1 Iris-virginica 6.7 3.1 4.7 1.5 Iris-versicolor 5.1 1.9 4 8 1.4 0.3 Iris-setosa 5.8 1.6 Iris-virginica 6.3 4.4 1.3 Iris-versicolor 1.9 Iris-virginica 5.6 41 1.3 Iris-versicolor 5.1 1.6 0.2 Iris-set osa 6.1 w 1.3 Iris-versicolor 4.6 3.2 1.4 0.2 Iris-setosa 6.4 2 Iris-virginica 5.5 2.5 1.2 Iris-versicolor 5.3 3.7 1.5 0.2 Iris-set osa 5.6 2.2 Iris-virginica 5.5 2.6 4.4 1.4 Iris-versicolor 3.3 1.4 0.2 Iris-setosa 5.1 1.5 Iris-virginica 6.1 3 46 1.4 Iris-versicolor 5.6 1.4 Iris-virginica 5.8 2.6 4 1.2 Iris-versicolor 3.2 4.7 1 Iris-versicolor 6.4 3.2 4.5 1.5 Iris-versicolor 6.1 2.3 Iris-virginica 5 2.3 3.3 4.2 1.3 Iris-versicolor 6.9 3.1 4.9 1.5 Iris-versicolor 5.6 2.4 Iris-virginica 5.6 2.7 4 1.3 Iris-versicolor 6.4 5.5 1.8 Iris-virginica 5.7 3 4.2 1.2 Iris-versicolor 5.5 2.3 6.5 2.8 4.6 1.5 Iris-versicolor 4.8 1.8 Iris-virginica 5.7 2.9 4.2 1.3 Iris-versicolor 4.5 1.3 Iris-versicolor 5.4 2.1 Iris-virginica 6.2 2.9 43 1.3 Iris-versicolor 5.7 2.8 6.3 3.3 4.7 1.6 Iris-versicolor 5.6 2.4 Iris-virginica 5.1 2.5 3 1.1 Iris-versicolor 4.1 1.3 Iris-versicolor 4.9 2.4 3.3 1 Iris-versicolor 5.1 2.3 Iris-virginica 5.7 2.8 1.3 Iris-versicolor 5.1 1.9 Iris-virginica 6.3 3.3 6 2.5 Iris-virginica 6.6 2.9 4.6 2.7 3.9 1.4 Iris-versicolor 5.9 2.3 Iris-virginica 5.1 1.9 Iris-virginica 5.2 5.8 2 .7 3.5 1 Iris-versicolor UnT 5.7 2.5 Iris-virginica 7.1 3 5.9 2.1 Iris-virginica W N 6.3 5.6 1.8 Iris-virginica 5.9 4.2 1.5 Iris-versicolor 5.2 2.3 Iris-virginica 2.9 4 1 Iris-versicolor wi 5.8 2.2 Iris-virginica 2.2 un 1.9 Iris-virginica 6.5 3 6.6 2.1 Iris-virginica 6.1 2.9 47 1.4 Iris-versicolor 5.2 2 Iris-virginica 7.6 2.9 3.6 1.3 Iris-versicolor 5.4 2.3 Iris-virginica 4.9 2.5 4.5 1.7 Iris-virginica 5.6 3.1 4.4 1.4 Iris-versicolor 5.9 5.1 1.8 Iris-virginica 7.3 2.9 6.3 1.8 Iris-virginica 6.7 6.7 2.5 5.8 1.8 Iris-virginica 5.6 3 4.5 1.5 Iris-versicolor 7.2 3.6 6.1 2.5 Iris-virginica 5.8 2.7 4.1 1 Iris-versicolor 1.5 Iris-versicolor 6.5 3.2 5.1 2 Iris-virginica 6.2 2.2 4.5 6.4 2.7 5.3 1.9 Iris-virginica 5.6 2.5 3.9 1.1 Iris-versicolor 5.5 2.1 Iris-virginica 5.9 3.2 4 8 1.8 Iris-versicolor 6.8 5 2 Iris-virginica 6.1 2.8 4 1.3 Iris-versicolor 5.7 2.5 6.3 2.5 4.9 1.5 Iris-versicolor 5.8 2.8 5.1 2.4 Iris-virginica 6.4 3.2 5.3 2.3 Iris-virginica 6.1 2.8 4.7 1.2 Iris-versicolor 3 5.5 1.8 Iris-virginica 6.4 2.9 4.3 1.3 Iris-versicolor 6.7 2.2 Iris-virginica 6.6 W 4.4 1.4 Iris-versicolor 3.8 2.3 Iris-virginica 6.8 2.8 4.8 1.4 Iris-versicolor 2.6 6.9 1.5 Iris-virginica 67 5 1.7 Iris-versicolor on 2.2 5 4.5 1.5 Iris-versicolor 3.2 5.7 2.3 Iris-virginica 6 2.9 2.8 4.9 2 Iris-virginica 5.7 2.6 3.5 1 Iris-versicolor 5.5 3.8 1.1 Iris-versicolor 2.8 6.7 2 Iris-virginica 2.4 2.7 4.9 1.8 Iris-virginica 5.5 2.4 3.7 1 Iris-versicolor 39 6.7 3.3 5.7 2.1 Iris-virginica 27 1.2 Iris-versicolorSepal length Sepal width Petal length Petal width Species 5.1 3.5 1.4 D.2 Iris-setosa 4.9 3 1.4 0.2 Iris-set osa 4.7 3.2 1.3 0.2 Iris-set osa 4.6 3.1 1.5 0.2 Iris-set osa 5 3.6 1.4 0.2 Iris-set osa 5.4 3.9 1.7 D.4 Iris-setosa 4.6 3.4 1.4 0.3 Iris-set osa 5 3.4 1.5 0.2 Iris-set osa 4 4 2.9 1.4 0.2 Iris-set osa 4.9 3.1 1.5 O.1 Iris-set osa 5.4 3.7 1.5 0.2 Iris-setosa 4.8 3.4 1.6 0.2 Iris-set osa 4.8 3 1.4 O.1 Iris-set osa 4.3 3 1.1 O.1 Iris-set osa 5.8 4 1.2 0.2 Iris-set osa 5.7 4 4 1.5 0.4 Iris-set osa 5.4 3.9 1.3 0.4 Iris-set053 5.1 3.5 1.4 0.3 Iris-set osa 5.7 3.8 1.7 0.3 Iris-setosa 5.1 3.8 1.5 0.3 Iris-setosa 5.4 3.4 1.7 0.2 Iris-set osa 5.1 3.7 1.5 D.4 Iris-set osa 4.6 3.6 1 0.2 Iris-setosa 5.1 3.3 1.7 0.5 Iris-setosa 4.8 3.4 1.9 0.2 Iris-set osa 5 3 1.6 0.2 Iris-set osa 5 3.4 1.6 0.4 Iris-set osa 5.2 3.5 1.5 0.2 Iris-set osa 5.2 3.4 1.4 0.2 Iris-set osa 47 3.2 1.6 0.2 Iris-setosa 4.8 3.1 1.6 0.2 Iris-set osa 5.4 3.4 1.5 0.4 Iris-set osa 5.2 4,1 1.5 O.1 Iris-setosa 5.5 4.2 1.4 0.2 Iris-set osa 4.9 3.1 1.5 O.1 Iris-set osa 5 3.2 1.2 0.2 Iris-setosa 5.5 3.5 1.3 0.2 Iris-set osa 4.9 3.1 1.5 O.1 Iris-set osa 4 4 3 1.3 D.2 Iris-set osa 5.1 3.4 1.5 0.2 Iris-set osa 5 3.5 1.3 0.3 Iris-set osa