PLEASE USE EXCEL AND SHOW FORMULA TEXT

Table 13.1 in the textbook provides a dataset that includes patient's age and whether the patient contracted a particular disease. Assume that this data was gathered on 20 actual patients.

Your director has asked you to manually classify the dataset in terms of "contracting the disease" (Disease = 1) or "not contracting the disease" (Disease = 0). A previous analysis on this dataset revealed that the Constant (Bo) = -4.372, and that the coefficient for Age (B1) = 0.06696.

Your director is interested in knowing if future patients between the ages of 60 and 70 should be classified as "contracting the disease" or "not contracting the disease." Assume 0.50 as a classification cutoff for contracting the disease. Using the "Problem 1 Template," determine P(Disease) for future patients between the ages of 60 and 70. Which future patients, based on their age, should be classified as "contracting the disease"?

In a 100 word document, describe the basic approach to your analysis, report your findings, and state your conclusions based on the results of the analysis.

PLEASE USE EXCEL AND SHOW FORMULA TEXT

1(x)= Potx lte Potax 1+ P(Disease) Disease 0 Patient ID 1 2 3 Age 25 29 30 Age 60 61 0 0 62 3 4 4 0 31 63 5 0 32 64 65 6 0 41 7 0 41 8 0 42 66 67 68 9 1 44 10 1 69 70 0 49 50 59 60 62 11 12 13 14 15 16 17 18 19 20 1 0 0 1 0 1 0 1 1 68 72 79 80 81 84 Constant Coefficient (BO): Age Coefficient (B1): -4.372 0.0670