## Linear Regression exemples

marion33678522

Total Posts

170

Likes

165

5

marion33678522

Total Posts

170

Likes

165

5
marion33678522

11-09-2017

I've been tryng to configure a new metric using linear regression without any success( triyng to calculate the slope of the visits cumulative over time, but the linear regression slope function does'nt return something right - maybe I'm not putting the right thing on the X argument - I used visits, but I believe it should be time)

Could someone please share any exemples of linear regressions ?

Kind regards !

#### Accepted Solutions (1)

ivan-andres

Employee

Total Posts

5

Like

1

4

ivan-andres

Employee

Total Posts

5

Like

1

4
ivan-andres
Employee

20-03-2018

Unfortunately, it's not really meant to work with time as the independent variable.  It's for comparing two metrics, and time isn't a metric.  That said, I think you can get what you want by using the cumulative function.  It will only work if the dimension of your report is time, because it's not really time based, but rather "row number" based.

The idea is that we set a 1 on every row in the results, and then use cumulative to turn that into 1, 2, 3, ...  Then that is used as the independent variable, and use visits (or any other metric, including cumulative visits) as the dependent variable.  I have included a screen shot of the formula that I used as well as the exact same calculations in Excel.  That way, you can see if it's going to work for your use case.

BrandonKern-6Rh

Employee

Total Posts

25

Likes

4

3

BrandonKern-6Rh

Employee

Total Posts

25

Likes

4

3
BrandonKern-6Rh
Employee

24-03-2018

Not sure if you have Data Workbench in your organization or not but this is a standard fea in it. DWB is for more advanced analysis such as using regression in the way you are asking about.

If you want some some more information on this feel free to reach out and I can answer any questions you have.

marion33678522

Total Posts

170

Likes

165

5

marion33678522

Total Posts

170

Likes

165

5
marion33678522

16-10-2017

I haven't got any input on this subject !

If someone could give any exemple it would be helpful !

Thanks again,

Cheers !