Data Generating Processor

J

JulieSmiths

New Member
Joined
Aug 18, 2014
Messages
14
Hello,
I am trying to create a data generating processor on VBA excel where I would put a formula (e.i y=1+9y+b) and I would be able to generate multiple observations with that. The problem is I have no idea where to start: like where to enter the formula and everything.
Thank you in advance for your time.
Julie Smiths
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Show an example of the reult you're trying to achieve.
 
Upvote 0
Hi,
Thanks for the reply
I would like to obtain a table like the one below
a column with t(time) and one with y (the value I want to generate)
So it would look like this
t y
1 i already have the value (e.i 3)
2 unknow
3 ....
4
5
6
...

thanks
Julie Smiths
 
Upvote 0
Not following that, Julie.

y = 1 + 9y + b

Is b the unknown? Where is t in that?
 
Upvote 0
I am sorry I was unclear. T is the time t=1 (today) and t=2 tomorrow and so on
The formula is y(t) = 1 + 9y(t-1) + b(t)
I already have y1 which is 3 and b(t) ~ N (0,1)
The processor need to be an autoregressive process with a derivation
 
Upvote 0
This is no more than a guess:

Row\Col
A​
B​
C​
1​
t​
y​
​
2​
1​
3.00​
B2: Input
3​
2​
28.31​
B3: =1 + 9*B2 + RAND()
4​
3​
256.76​
5​
4​
2312.55​
6​
5​
20814.73​
7​
6​
187333.67​
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Rename query after generating with vba
Replies
0
Views
79
peterhess2002
P
T
  • Question
Multiple filters on filtered list
Replies
1
Views
218
Cubist
Cubist
A
  • Question
Formula generated ID value result is not read as text in vba.
2
Replies
13
Views
336
aRush113
A
B
  • Question
VBA to show and change list of names depending on selection
Replies
7
Views
468
mumps
mumps
H
  • Question
Excel/VBA Soccer/Football Lineup Generator
Replies
1
Views
336
Eric W
Eric W

Forum statistics

Threads
1,214,990
Messages
6,122,625
Members
449,093
Latest member
catterz66

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top