Calculate slope with odd data points, and using IF statement?

Hi Guys,

I'm using excel slope function to calculate whether a trend is positive or negative for traffic for a website.

I saw this solution which worked however i can't seem to get it working when i have odd data points e.g. 5 month. Example:

screenshot.6712.jpg

It works well when even months, but not odd.

How do i fix this?

The other question is i want to create a if statement, so if the slope is negative or positive it will say in the projection column.

What would the IF statement look like to do this in excel e.g. if number is negative add negative to column if positive...

I have added the worksheet here: https://ufile.io/efc431

Mods the attached feature in excel forum is not working see: https://www.useloom.com/share/1b4a3f...1279edea62fcd3

Any suggestions would be very much appreciated!

Cheers.

Thanks for your response. What i'm trying to do is figure out with the traffic trend overall is up or down, i manage to calculate the slop with just 4 data points (Dec, Jan, Feb, March) but when i included (April) then the formula doesn't work.

why not just create a range of x values (1,2,3,4,5)
then slope (yvalues, xvalues)

if you inserted a row at the top of the spreadsheet for the x's
slope (b3:f3,b1:f1)

Got it, i can see what i was doing wrong. Thanks guy!

I changed months to array of numbers (1,2,3,4,...) which resulted to this:

screenshot.6719.jpg

It seems the number is quite low for that sharp increase in traffic e.g. from 25 visits to 1000 (in month 5) the slope is 0.34%.

I want to get the IF statement working now for this figure, any suggestions on how to go about this?

Cheers.