Question

Mutant genes: In a study to determine whether the frequency of a certain mutant gene increases with age, the number of mutant genes per micro gram of DNA was counted for each of 15 men. The results are presented in the following table Age Number of Mutants 100 46 45 53 54 68 53 57 65 47 61 70 72 82 83 52 35 68 71 49 264 29 148 195 83 449 202 a. Compute the least-squares regression line for predicting number of mutants from age. Round the slope and y-intercept values to four decimal places Regression line equation: y -

Answer 1

Answer

Copy paste the data into excel sheet

Enter age data in column A from A1 to A15 and number of mutants in column B from B1 to B15

Use excel function SLOPE and INTERCEPT to find the slope and intercept of the required regression equation

select age values as known x’s and number of mutant as known y’s

=SLOPE(B1:B15,A1:A15)

= 6.1866

and

=INTERCEPT(B1:B15,A1:A15)

= -245.3320

So, equation is given as

y = -245.3320 + 6.1866(x)