AutoSave OFF AH ? C ... spreadsheets_linear_regression E zyBooks ? Home Insert Draw Page Layout > Tell me Share Comments Feedback? A v Conditional Formatting Format as Table Cells Editing An: Clipboard Font Alignment Number Cell Styles v D CHALLENGE ACTIVITY 2.3.2: Excel: Linear regression. B61 X V fx 2.7 A B C D E F G H I Click this link to download the spreadsheet for use in this activity. 41 5.1 3.4 1.5 0.2 Iris-setosa 42 5 3.5 1.3 0.3 Iris-setosa 270604.2007652.qx3zay7 43 4.5 2.3 1.3 0.3 Iris-setosa 4 4 3.2 1.3 0.2 Iris-setosa Jump to level 1 5 3.5 1.6 0.6 Iris-setosa 5.1 38 19 0.4 Iris-setosa 4.8 3 1.4 0.3 Iris-setosa 5.1 3.8 1.6 0.2 Iris-setosa 4.6 3.2 1.4 0.2 Iris-setosa 5.3 3.7 1.5 0.2 Iris-setosa 3.3 1.4 0.2 Iris-setosa 3.2 4.7 1.4 Iris-versicolor The famous iris dataset (the first sheet of the spreadsheet linked above) was first published in 6.4 3.2 4.5 1.5 Iris-versicolor Fisher. The dataset contains 50 samples from 3 iris species: setosa, virginia, and versicolor. Fo 6.9 3.1 4.9 1.5 Iris-versicolor 5.5 2.3 4 1.3 Iris-versicolor measured, all in cm: sepal length, sepal width, petal length, and petal width. 56 6.5 2.8 4.6 1.5 Iris-versicolor 5.7 2.8 4.5 1.3 Iris-versicolor What is the equation for the least square regression line where the independent or predictor va 58 6 . 3 3.3 4.7 1.6 Iris-versicolor and the dependent or response variable is petal width for iris setosa? 59 4.9 2.4 3.3 1 Iris-versicolor 60 6.6 2.9 4.6 1.3 Iris-versicolor 5.2 2.7 3.9 1.4 Iris-versicolor 1 Iris-versicolor y Ex: 1.234 Ext EX: 1.234 62 5 2 3.5 63 5.9 3 4.2 1.5 Iris-versicolor 6 2.2 4 What is the predicted petal width for iris setosa for a flower with a petal length of 2.27? 64 1 Iris-versicolor 6.1 2.9 4.7 1.4 Iris-versicolor 5.6 2.9 3.6 1.3 Iris-versicolor Ex: 5.12 @ cm 6.7 3.1 4.4 1.4 Iris-versicolor 5.6 3 4.5 1.5 Iris-versicolor 5.8 2.7 4.1 1 Iris-versicolor 6.2 2.2 4.5 1.5 Iris-versicolor 5.6 2.5 3.9 1.1 Iris-versicolor 5.9 3.2 4.8 1.8 Iris-versicolor 6.1 2.8 4 1.3 Iris-versicolor 6.3 2.5 4.9 1.5 Iris-versicolor 1 75 6 .1 2.8 4.7 1.2 Iris-versicolor 76 6.4 29 4.3 1.3 Iris-versicolor 77 6.6 3 4.4 1.4 Iris-versicolor Check Next 78 6 .8 2.8 4.8 1.4 Iris-versicolor 79 6.7 3 5 1.7 Iris-versicolor 80 6 2.9 4.5 1.5 Iris-versicolor 81 2.6 35 1 Iris-versicolor Feedback? Iris Systolic blood pressure + Cricket chirps vs temperature + 100% Ready