help!! hard linear regression + reordering of equation

tara_xoxo_xoxo

New member
Joined
Apr 17, 2011
Messages
1
Hi really hope someone can help i need to fit a linear regression model to this trans formed data (it has been transformed by log(original+1)
I then need the equation of the model - i Have worked this out to be log y = 0.0272 + 0.9761(logx+1) - i think this is wrong!!!!

The question is then asking me to take exponentials of both sides of the fitted equation (remember that e^(a+b log(x+1)) = c(x+1)^b, where c=e^) and re express the model directly for the second column in terms of the first.
Giving a very sibple equation relating column 2 to column 1

column1 column2
4.56726 4.36374
3.98843 3.40883
6.28148 6.00166
9.74718 6.60259
5.73483 5.26347
5.08116 5.40087
2.3979 2.26384
5.46141 5.16656
6.09783 6.27341
1.25276 4.8803
3.95124 3.70721
0 0
2.31254 2.23431
0 0
4.94876 4.79612
0 0
2.56495 2.55955
0 0
0 0
3.55535 3.43849
0 0
0 0
0 0
6.04761 6.2779
2.0464 2.33214
2.08691 1.90806
3.86514 3.8601
5.07867 5.18122
2.70805 2.68717
1.64481 1.77326
1.4327 2.02815
2.27932 2.04511
1.65441 1.66393
3.07269 3.06805
3.07269 3.06805
1.8718 1.91692
2.02815 1.805

i am so amazing lost!! and its due in less than 24 hours!! someone help please!!
 
It would be a whole lot easier with the original data.

What's wrong with Point #4?
 
Top