The tutor explains the difference between power and exponential curves.

According to Excel, a power equation has the form

y=ax^b

whereas an exponential equation has the form

y=ae^kx

Example:

I tried both options on the following data:

Excel gave me the following regression equations:

Power: y=2.5804x^1.514

Exponential: y=0.902e^0.7707x

To my observation, Excel will not offer a power equation if x=0 is in the data. It will not offer an exponential if (0,0) is in the data.

I’ll be telling how to get an equation for a given data set in future posts:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.