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
Get Answers For Free
Most questions answered within 1 hours.