- #1
sara_87
- 763
- 0
Homework Statement
I have a formula:
x=(y/s)^r
I am given data: 6 values for x and the corresponding 6 values for y.
I am to find the values of s and r.
I could take logarithms and make this formula linear then use linear regression (as in statistics) and do the method of least squares.
But i was told that using excel is much simpler (where i don't need to put this in terms of logarithms)
But how do i use excel for such a problem?
Homework Equations
The Attempt at a Solution
I typed in the values of x in the first excel column, and the values of y in the second. but then i got stuck. i have no idea how to and where to type in the formula.
Thank you