Find the equation of the regression line of the transformed

Find the equation of the regression line of the transformed data. log y = (Round to three decimal places as needed.)

Solution

first log y is calculated.

x

y

logy

1

299

2.4757

2

476

2.6776

3

865

2.9370

4

1493

3.1741

5

2562

3.4086

6

4400

3.6435

7

7611

3.8814

Regression analysis is used by Excel program

Regression Analysis

r²

1.000

n

7

r

1.000

k

1

Std. Error

0.011

Dep. Var.

logy

ANOVA table

Source

SS

df

MS

F

p-value

Regression

1.5654

1  

1.5654

12334.50

1.12E-09

Residual

0.0006

5  

0.0001

Total

1.5661

6  

Regression output

confidence interval

variables

coefficients

std. error

   t (df=5)

p-value

95% lower

95% upper

Intercept

2.2253

0.0095

233.723

2.72E-11

2.2008

2.2498

x

0.2364

0.0021

111.061

1.12E-09

0.2310

0.2419

The regression line

Logy= 0.236x+2.225

x	y	logy
1	299	2.4757
2	476	2.6776
3	865	2.9370
4	1493	3.1741
5	2562	3.4086
6	4400	3.6435
7	7611	3.8814