Thanks in advance

- Thread starter A_Salem
- Start date
- Tags excel regression analysis

Thanks in advance

Start with the raw data x and y. Don't transform. Plot y up and x across.

If it looks straight put in a linear trendline and equation.

If it is not straight, change the y axis to a log scale. If it looks straight now, put in an

If that doesn't give a straight line, make the y axis normal again and make the x axis a log scale. If the graph looks straight, put in a

If this doesn't work, log both axes. If the graph looks straight now, put in a

Start with the raw data x and y. Don't transform. Plot y up and x across.

If it looks straight put in a linear trendline and equation.

If it is not straight, change the y axis to a log scale. If it looks straight now, put in an

If that doesn't give a straight line, make the y axis normal again and make the x axis a log scale. If the graph looks straight, put in a

If this doesn't work, log both axes. If the graph looks straight now, put in a

R is free and infinitely better than excel.

@noetsi I am actually learning R right now. It just takes me a while to google the right code lol.