Question

# The table below shows (lifetime) peptic ulcer rates (per 100 population), U, for various family incomes,...

The table below shows (lifetime) peptic ulcer rates (per 100 population), U, for various family incomes, x, as reported by the 1989 National Health Interview Survey. Income 4000 6000 8000 12000 16000 20000 30000 45000 60000 Ulcer rate 13.6 13.3 13.5 12.8 12.2 12.3 10.9 9.6 7.8

(a) Find the equation of the regression line. Ulcer rate, U(x)=

(b) Estimate the peptic ulcer rate for an income level of x0= 29000 according to the linear model in part (a). Ulcer rate, U(x0)=

Let y = Ulcer rate

and x = income level

Let's use excel:

Step 1) First enter the given data set in excel columns.

Step 2) Then click on Data >>> Data Analysis >>>Regression >>>>OK

Step 3) Input Y Range: Select the data of column "B"

Input X Range: Select the data of column "A"

Click on Lable

then Click on Ouput Range

Look the following Image Then Click on OK, we get following result. a ) From the above output the regression equation is as follows: b) plug x = 29000 in the above regression line, so we get 