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
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 setosa?
What is the predicted sepal width for iris setosa for a flower with a sepal length of 7.38?
The Problem and the data chart:
Excel File Edit View Insert Format Tools Data Window Help M 51% Sun 1:15 PM :83 Q DE AutoSave OFF spreadsheets_linear_regression Update Apple ID Settings Home Insert Draw Page Layou Formulas Data Review View Tell me Some account services will not be View available until you sign in again Insert v M Calibri (Body) 12 AA = ab General Ex Delete v Sensitivity Paste BIUV Ov Av E $ ~ % 9 Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v Filter Select Data A1 X V fx Sepallength B E F G H K M N 0 Q R U Sepal length Sepal width Petal length Petal width Species 5.1 3.5 1.4 0.2 Iris-setosa WN 4.9 3 1.4 0.2 Iris-setosa 4.7 3.2 1.3 0.2 Iris-setosa 4.6 3.1 1.5 0.2 Iris-setosa 3.6 1.4 0.2 Iris-setosa 5.4 3.9 1.7 0.4 Iris-setosa 4.6 3.4 1.4 0.3 Iris-setosa 3.4 1.5 0.2 Iris-setosa ot 4.4 2.9 1.4 0.2 Iris-setosa O AM 4.9 3.1 1.5 0.1 Iris-setosa 5.4 3.7 1.5 0.2 Iris-setosa 4.8 3.4 1.6 0.2 Iris-setosa 4. 1.4 0.1 Iris-setosa 4.3 w U 1.1 .1 Iris-setosa 5.8 4 1.2 0.2 Iris-setosa ot 4.4 1.5 0.4 Iris-setosa 18 PM 3.9 1.3 0.4 Iris-setosa 3.5 1.4 0.3 Iris-setosa 3.8 1.7 0.3 Iris-setosa 3.8 1.5 0.3 Iris-setosa 3.4 1.7 0.2 Iris-setosa E- 3.7 1.5 0.4 Iris-setosa webp 3.6 0.2 Iris-setosa 3.3 1.7 0.5 Iris-setosa B't 3.4 1.9 0.2 Iris-setosa w 1.6 0.2 Iris-setosa 3.4 1.6 0.4 Iris-setosa n Shot 5.2 3.5 1.5 0.2 Iris-setosa ...7.54 P 5.2 3.4 1.4 0.2 Iris-setosa 4.7 3.2 1.6 0.2 Iris-setosa 4.8 3.1 1.6 0.2 Iris-setosa 5.4 3.4 1.5 0.4 Iris-setosa 5.2 4.1 1.5 0.1 Iris-setosa 5.5 4.2 1.4 0.2 Iris-setosa 4.9 3.1 1.5 0.1 Iris-setosa 9a69 3.2 12 0.2 Iris-setosa c.jpg Iris Cricket chirps vs temperature Systolic blood pressure + + 100% Ready MAY 16 4 ... XExcel File Edit View Insert Format Tools Data Window Help M 51% Sun 1:15 PM :83 Q DE AutoSave OFF spreadsheets_linear_regression Update Apple ID Settings Home Insert Draw Page Layou Formulas Data Review View Tell me Some account services will not be View available until you sign in again Calibri (Body) v 12 AA = ab General Insert v M Ex Delete v Paste BIUV Ov Av E $ ~ % 9 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data A1 X fx Sepal length B E F G H K M N O P Q R T U 4.9 3.1 1.5 0.1 Iris-setosa n UT 3.2 1.2 0.2 Iris-setosa 5.5 3.5 1.3 0.2 Iris-setosa 4.9 3.1 1.5 0.1 Iris-setosa 4.4 1.3 0.2 Iris-setosa 5.1 3.4 1.5 0.2 Iris-setosa 3.5 1.3 0.3 Iris-setosa 1.5 2.3 1.3 0.3 Iris-setosa 3.2 1.3 0.2 Iris-setosa 3.5 1. 0.6 Iris-setosa ot 3.8 1.9 0.4 Iris-setosa 0 AM w 1.4 0.3 Iris-setosa 3.8 1.6 0.2 Iris-setosa 3.2 1.4 0.2 Iris-setosa 3.7 1.5 0.2 Iris-setosa 3.3 1.4 0.2 Iris-setosa ot 3.2 4.7 1.4 Iris-versicolor 8 PM 3.2 4.5 1.5 Iris-versicolor 3.1 4.9 1.5 Iris-versicolor 2.3 4 1.3 Iris-versicolor 2. 4.6 1.5 Iris-versicolor 2. 4.5 1.3 Iris-versicolor E- 4.7 1.6 Iris-versicolor webp 2.4 3.3 1 Iris-versicolor 2.9 4.6 1.3 Iris-versicolor 2.7 3.9 1.4 Iris-versicolor i u N o io 3.5 1 Iris-versicolor 3 42 1.5 Iris-versicolor en Shot 2.2 4 1 Iris-versicolor ...7.54 P 6.1 2.9 4.7 1.4 Iris-versicolor 5 .6 2.9 3.6 1.3 Iris-versicolo 5.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 5.2 2.2 4.5 1.5 Iris-versicolor 5.6 2.5 3.9 1.1 Iris-versicolo 9a69 c.jpg Iris Cricket chirps vs temperature Systolic blood pressure + Ready - + 100% MAY 16 4 ... XExcel File Edit View Insert Format Tools Data Window Help M 51% Sun 1:15 PM :83 Q DE AutoSave OFF spreadsheets_linear_regression Update Apple ID Settings Home Insert Draw Page Layou Formulas Data Review View Tell me Some account services will not be View available until you sign in again Calibri (Body) 12 M AA = ab General Insert v Ex Delete v Paste BIUV DV Av E $ ~ % 9 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data A1 X fx Sepal length A B E F G H K M N P Q R T U 71 5.6 2.5 3.9 1.1 Iris-versicolor 72 5.9 3.2 4.8 1.8 Iris-versicolor 73 6.1 2.8 4 1.3 Iris-versicolor 74 6.3 2.5 4.9 1.5 Iris-versicolor 6.1 2.8 4.7 1.2 Iris-versicolor 6.4 2.9 4.3 1.3 Iris-versicolor 6.6 3 4.4 1.4 Iris-versicolor 6.8 2.8 4.8 1.4 Iris-versicolor 5.7 5 1.7 Iris-versicolor ot 2.9 4.5 1.5 Iris-versicolor 0 AM 5.7 2. 3.5 1 Iris-versicolor 2.4 3 .8 1.1 Iris-versicolor in in 2.4 3.7 1 Iris-versicolor 2.7 3.9 1.2 Iris-versicolor 2.7 5.1 1.6 Iris-versicolor 5.4 3 4.5 1.5 Iris-versicolor not 3.4 4.5 1.6 Iris-versicolor 08 PM 5.7 3.1 4.7 1.5 Iris-versicolor 6.3 2.3 4.4 1.3 Iris-versicolor 5.6 3 4.1 1.3 Iris-versicolor 5.5 2.5 4 1.3 Iris-versicolor 26 4.4 1.2 Iris-versicolor 6.1 3 4.6 1.4 Iris-versicolor webp 5.8 2.6 4 1.2 Iris-versicolor 2.3 3.3 1 Iris-versicolor 5.6 2.7 4.2 1.3 Iris-versicolor 4.2 1.2 Iris-versicolor 5.7 2.9 4.2 1.3 Iris-versicolor n Shot 6.2 2.9 4.3 1.3 Iris-versicolor ...7.54 P 100 5.1 2.5 3 1.1 Iris-versicolor 101 5.7 2.8 4.1 1.3 Iris-versicolor 102 6.3 3.3 6 2.5 Iris-virginica 103 5.8 2.7 5.1 1.9 Iris-virginica 104 7.1 3 5.9 2.1 Iris-virginica 105 6.3 2 .9 5.6 1.8 Iris-virginica 106 6.5 5.8 2.2 Iris-virginica Iris Cricket chirps vs temperature Systolic blood pressure + Ready - MAY 16 4 ... XM 50% Sun 1:15 PM :28 Q DE Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF spreadsheets_linear_regression Update Apple ID Settings View Home Insert Draw Page Layou Formulas Data Review View Tell me Some account services will not be available until you sign in again Insert v M Calibri (Body) 12 AA = ab General Ex Delete v DV Av E $ ~ % 9 Conditional Format Cell Sort & Find & Analyze Sensitivity Paste BIUV Formatting as Table Styles Format v Filter Select Data A1 X fx Sepal length K M N O P Q R U B F G H 125 6.5 2.1 4.5 1.8 Iris-virginica 126 5.7 3.3 5.7 2.1 Iris-virginica 127 7.2 3.2 6 1.8 Iris-virginica 128 6.2 2.8 4.8 1.8 Iris-virginica 129 6.1 3 4.9 1.8 Iris-virginica 130 6.4 28 5.6 2.1 Iris-virginica 131 7.2 5.8 1.6 Iris-virginica 132 7.4 2.8 6.1 1.9 Iris-virginica 133 7.9 3.8 6.4 2 Iris-virginica ot 134 6.4 2 .8 5.6 2.2 Iris-virginica O AM 135 6.3 2.8 5.1 1.5 Iris-virginica 136 6.1 2.6 5.6 1.4 Iris-virginica 137 7.7 3 6.1 2.3 Iris-virginica 138 6.3 3.4 5.6 2.4 Iris-virginica 139 6.4 3.1 5.5 1.8 Iris-virginica 140 6 3 4.8 1.8 Iris-virginica lot 141 6.9 3.1 5.4 2.1 Iris-virginica 8 PM 142 6.7 3.1 5.6 2.4 Iris-virginica 143 6.9 3.1 5.1 2.3 Iris-virginica 144 5.8 2.7 5.1 1.9 Iris-virginica 145 6.8 3.2 5.9 2.3 Iris-virginica 146 6.7 3.3 5.7 2.5 Iris-virginica E- 147 6.7 3 5.2 2.3 Iris-virginica webp 148 6.3 2.5 1.9 Iris-virginica 149 6.5 5.2 2 Iris-virginica 150 6.2 3.4 5.4 2.3 Iris-virginica 151 5.9 3 5.1 1.8 Iris-virginica 152 en Shot 153 ...7.54 P 154 155 156 157 158 159 160 9a69 161 c.jpg Iris Cricket chirps vs temperature Systolic blood pressure + - + 100% Ready MAY 4 ... X 16(5) Fred & Rosemary West And X Course Hero x BAnnouncements - MAT-240-J5 X zy Section 2.3 - MAT 240: Applied X + a learn.zybooks.com/zybook/SNHUMAT240Master1/chapter/2/section/3 Update Apple ID Settings Some account services will not be View available until you sign in again. =zyBooks My library > MAT 240: Applied Statistics home > 2.3: Least squares method zyBooks catalog Help/FAQ CITIoly DaCHITTIan CHALLENGE ACTIVITY 2.3.2: Excel: Linear regression. Click this link to download the spreadsheet for use in this activity. Jump to level 1 The famous iris dataset (the first sheet of the spreadsheet linked above) was first published in Fisher. The dataset contains 50 samples from 3 iris species: setosa, virginia, and versicolor. Fo 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 va length and the dependent or response variable is sepal width for iris setosa? y = Ex: 1.234 ac + Ex: 1.234 What is the predicted sepal width for iris setosa for a flower with a sepal length of 7.38? Ex: 5.12 cm 1 2 Check Next Feedback
