B
broer konijn
Dear all,
I am preparing a spreadsheet in order to perform some analysis (i.e
OLS regressions). I use independent variables to explain one dependen
variable. I tried to construct the independent variables myself, but
cannot figure out how to build them with worksheet functions. M
difficulties for two variables are attached as simplified examples an
illustrate the issue.
I would prefer solving these issues with worksheet functions, althoug
my several attempts get stuck at certain the points in both issues:
-In the 'similarity of previous purchases' (issue 2): how do I manag
to 1) observe the most frequent occurring code, 2) remember this cod
and calculate the ratio with this code at any point in time?
-In the 'average time' (issue 2): when a F4-locked starting cell of
moving average should be unlocked, given a certain criterium an
re-lock again at a new place in the spreadsheet.
I know, the spreadsheet is perhaps more clear....Thanx in advance fo
all attempts!:
+-------------------------------------------------------------------
|Filename: Issues variables.zip
|Download: http://www.excelforum.com/attachment.php?postid=4772
+-------------------------------------------------------------------
I am preparing a spreadsheet in order to perform some analysis (i.e
OLS regressions). I use independent variables to explain one dependen
variable. I tried to construct the independent variables myself, but
cannot figure out how to build them with worksheet functions. M
difficulties for two variables are attached as simplified examples an
illustrate the issue.
I would prefer solving these issues with worksheet functions, althoug
my several attempts get stuck at certain the points in both issues:
-In the 'similarity of previous purchases' (issue 2): how do I manag
to 1) observe the most frequent occurring code, 2) remember this cod
and calculate the ratio with this code at any point in time?
-In the 'average time' (issue 2): when a F4-locked starting cell of
moving average should be unlocked, given a certain criterium an
re-lock again at a new place in the spreadsheet.
I know, the spreadsheet is perhaps more clear....Thanx in advance fo
all attempts!:
+-------------------------------------------------------------------
|Filename: Issues variables.zip
|Download: http://www.excelforum.com/attachment.php?postid=4772
+-------------------------------------------------------------------