Using a Spreadsheet Program Such as Excel, Plot the Following $\hat { Y }$

Essay

Using a spreadsheet program such as Excel, plot the following logistic regression function with a single X, $\hat { Y }$ _{i =}
$\frac { 1 } { 1 + e ^ { - \left( \hat\beta _ { 0 } + \hat\beta _ { 1 } X _ { i } \right) } }$ , where $\hat { \beta }$ ₀ = - 4.13 and $\hat { \beta }$ ₁ = 5.37. Enter values of X in the first column starting from 0 and then incrementing these by 0.1 until you reach 2.0. Then enter the logistic function formula in the next column. Finally produce a scatter plot, connecting the predicted values with a line.