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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

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

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