nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Methods for assessing lag variables

statman

Do any of the gurus on here have an easy way to adjust columns based on some hypothesized lag. Example situation: Trying to determine the impact of factors on sales, and some of the factors have been hypothesized to have a lag effect (e.g., 1 wk, 2 wk, 1 month, 1 qtr). So, for example, if we want to determine the effect of some variable (e.g., reviews, price, stars, etc.), but it takes "x" time (would like to easily vary this) for the variables change to take effect. I basically have to shift the data in columns to see these lag effects...anyone got a better idea? TIA!

Accepted answers

All comments

txnelson

It would be very easy to setup new columns for the different weeks, or to setup a binning column for the different weeks, and then to analyze the data. And that would be a good approach

HadleyMyers

Hi,

There is a script that allows you to create lag columns save on the community ( Create multiple lag columns ). Does that help?

statman

Thanks for your responses. I can setup new columns and shift the data manually (that's what I already do), but I was looking for a simple dialog that quickly lags a column a specified number of days/weeks/months/ etc. The script lets you start the lag after a specified number, but then goes by one row at a time.

txnelson

Can you please provide a description of you data table, or better yet, a sample of your data table. Without that, one can only guess what your data are, and what JSL is required to setup the lag columns.

statman

Yes, of course. First just a typical scenario...I am interested in the response variable of number of units sold (appliances). I have this recorded in a column. I have another column for statistics on housing starts. I hypothesize that appliance sales do not occur at the housing start, but at some time interval multiple months from housing starts, so I want to lag the actual units sold column a number of months (and be able to vary this by different time series). For the greatly reduced attached data set, there is a column of reviews, columns of "events", a column of units sold (Y) and Units sold lagged by 7 days (Yl). The units don't actually sell when the events or reviews occur, but are lagged. So the questions we are trying to answer are:

1. Do the events have a significant effect on units sold? If you correspond the units sold with the same row of the event, this assumes the sales occur simultaneously (on the same day) which may be non-sensical.

2. How much lag is there from "event" to change in units sold?

Example.jmp