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:

Vicariously Liable

Legal responsibility of one party for the actions of another party, typically in an employer-employee relationship.

Formal Steps

Formal steps are specific procedures required by law or regulation to complete a legal action or process.

Incorporate

To incorporate is to legally form a corporation by filing required documents with a governmental entity, granting the company distinct legal status from its owners.

Unlimited Liability

The liability of the sole proprietor or the partners for all debts incurred by the business to the extent of their personal resources.