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

question 6

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.

---

Definitions:

Sub-

A prefix meaning below, under, or beneath, often used to form nouns, adjectives, or verbs.

Toward

In the direction of; closer to a particular point or in consideration of.

Edema

Swelling caused by excess fluid trapped in the body's tissues, often seen in the feet, ankles, and legs.

Iasis

A suffix used in medical terminology to denote a condition, disease, or infestation by a specific pathogen or disease process.