Denton benchmarking method (xlpbm) ?
Locked
Denton benchmarking method (xlpbm) ?
 
|
Hello.
I want to ask you about denton method. In Ms. Excel, there is a formula (xlpbm) to do a denton method. Is in SPSS provide syntax or package to access denton method? Thank you for your concern. Best regards, Fatma |
Re: Denton benchmarking method (xlpbm) ?
Administrator
|
I'm replying mainly because Fatma's post to Nabble has apparently not yet
been circulated to the mailing list. While I'm at it, though, here are a couple links that may be helpful to others who have never heard of the Denton method. https://www.imf.org/external/pubs/ft/wp/2012/wp12169.pdf https://www.imf.org/external/pubs/ft/qna/pdf/Benchmarking-Reconciliation_C6_Draft.pdf https://cran.r-project.org/web/packages/tempdisagg/tempdisagg.pdf fatmayuliana wrote > Hello. > I want to ask you about denton method. > > In Ms. Excel, there is a formula (xlpbm) to do a denton method. > > Is in SPSS provide syntax or package to access denton method? > > Thank you for your concern. > > Best regards, > > > Fatma ----- -- Bruce Weaver [hidden email] http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
|
|
The STATS DISAGG extension command available via the Utilities or Extensions menu depending on the Statistics version disaggregates a time series into higher frequencies using one of several methods. From the syntax help: CONVERSIONTYPE (optional) specifies the relationship of the disaggregated values to the original. SUM and AVERAGE specify that the sum or average of the entire disaggregated series equals the corresponding statistic for the low frequency series. FIRST and LAST specify that the first or last value of the disaggregated series equals the corresponding value of the low frequency series. CONVERSIONMETHOD (optional) specifies the conversion algorithm. The Chow-Lin, Litterman, and Fernandez methods (with variations) use generalized least squares of the low frequency variable on the aggregated values of the high frequency series and then distribute the differences in the result across the quarterly values. The estimated relationship between the low frequency series (actual and aggregated) is assumed to hold also for the high frequency series. The GLS estimators include estimation of an autoregression parameter, rho. The OLS method does ordinary least squares (with no autocorrelation parameter). These methods all require at least one high frequency indicator. The remaining methods (Denton type) can be used with or without an indicator variable and minimize the sum of squared deviations of the low and high frequency series using two additional parameters. Only one indicator variable is allowed. STATS DISAGG requires the R Essentials. On Sun, Sep 17, 2017 at 7:02 PM, Bruce Weaver <[hidden email]> wrote: I'm replying mainly because Fatma's post to Nabble has apparently not yet |
Re: Denton benchmarking method (xlpbm) ?
|
|
"STATS DISAGG requires the R Essentials"
What does it mean? Does it mean that i should have R? And install R? And operate it on R? Or i must install R but operate in on SPSS? |
Re: Denton benchmarking method (xlpbm) ?
|
Administrator
|
R may be installed already--when I installed v25 recently, it was an option
in the installation dialog. Jon can probably tell you how to check quickly. If the R Essentials have not been installed, here are some instructions: https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2.0/com.ibm.swg.ba.cognos.op_capmod_ig.7.2.0.doc/t_essentials_for_r_statistics.html HTH. fatmayuliana wrote > "STATS DISAGG requires the R Essentials" > > What does it mean? > > Does it mean that i should have R? And install R? And operate it on R? > > Or i must install R but operate in on SPSS? ----- -- Bruce Weaver [hidden email] http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
|
|
Here are details on setting up for procedures implemented in R as STATS DISAGG is. Since this is an extension command, it works just like regular Statistics built-in commands, but it needs the correct version of R and the R Essentials to be installed first, after which you can add any of 50 or so R-based extension commands via the Extensions > Extension Hub menu (v24 and later) or the Utilities menu in V22-23. Bruce, Was installing R itself really an option when you installed Statistics 25? It's an option for Python, but I didn't think R was treated that way. There is now an extension command for installing the R Essentials, though. On Mon, Sep 18, 2017 at 12:28 PM, Bruce Weaver <[hidden email]> wrote: R may be installed already--when I installed v25 recently, it was an option |
Re: Denton benchmarking method (xlpbm) ?
|
Administrator
|
Hi Jon. I can't remember for certain, but I thought it was there.
HOWEVER, when I now click on Extensions > Extension Hub, and try to install any extension command that uses R, the "Get extension" check-box is inactive, and I cannot install anything. I suppose that means I do *not* have the R Essentials installed. I must be thinking of the option to install Python automatically. (I do have R installed, by the way, but probably not the version required to match my SPSS.) You wrote: "There is now an extension command for installing the R Essentials, though." What's it called? STATS_R33_CONFIGURATION? Bruce Jon Peck wrote > Bruce, > Was installing R itself really an option when you installed Statistics 25? > It's an option for Python, but I didn't think R was treated that way. > There is now an extension command for installing the R Essentials, though. > > On Mon, Sep 18, 2017 at 12:28 PM, Bruce Weaver < > bruce.weaver@ > > > wrote: > >> R may be installed already--when I installed v25 recently, it was an >> option >> in the installation dialog. Jon can probably tell you how to check >> quickly. >> >> If the R Essentials have not been installed, here are some instructions: >> >> https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2. >> 0/com.ibm.swg.ba.cognos.op_capmod_ig.7.2.0.doc/t_ >> essentials_for_r_statistics.html >> >> HTH. >> >> >> >> fatmayuliana wrote >> > "STATS DISAGG requires the R Essentials" >> > >> > What does it mean? >> > >> > Does it mean that i should have R? And install R? And operate it on R? >> > >> > Or i must install R but operate in on SPSS? >> >> >> >> >> >> ----- >> -- >> Bruce Weaver >> > bweaver@ >> http://sites.google.com/a/lakeheadu.ca/bweaver/ >> >> "When all else fails, RTFM." >> >> NOTE: My Hotmail account is not monitored regularly. >> To send me an e-mail, please use the address shown above. >> >> -- >> Sent from: http://spssx-discussion.1045642.n5.nabble.com/ >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> > LISTSERV@.UGA > (not to SPSSX-L), with no body text except the >> command. To leave the list, send the command >> SIGNOFF SPSSX-L >> For a list of commands to manage subscriptions, send the command >> INFO REFCARD >> > > > > -- > Jon K Peck > jkpeck@ > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD ----- -- Bruce Weaver [hidden email] http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
Re: Denton benchmarking method (xlpbm) ?
|
Administrator
|
Okay, I answered my own question. After I installed R 3.3.3 (the version
required for SPSS 25), I was able to execute STATS_R33_CONFIGURATION: STATS R33 CONFIGURATION R_HOME="C:\Program Files\R\R-3.3.3\". And after that, I was able to install some R-dependent extension commands. In case others are looking, old R-versions (for Windows) can be found here: https://cran.r-project.org/bin/windows/base/old/ Bruce Weaver wrote > Hi Jon. I can't remember for certain, but I thought it was there. > > HOWEVER, when I now click on Extensions > Extension Hub, and try to > install > any extension command that uses R, the "Get extension" check-box is > inactive, and I cannot install anything. I suppose that means I do *not* > have the R Essentials installed. I must be thinking of the option to > install Python automatically. (I do have R installed, by the way, but > probably not the version required to match my SPSS.) > > You wrote: "There is now an extension command for installing the R > Essentials, though." > > What's it called? STATS_R33_CONFIGURATION? > > Bruce > > > > > Jon Peck wrote >> Bruce, >> Was installing R itself really an option when you installed Statistics >> 25? >> It's an option for Python, but I didn't think R was treated that way. >> There is now an extension command for installing the R Essentials, >> though. >> >> On Mon, Sep 18, 2017 at 12:28 PM, Bruce Weaver < > >> bruce.weaver@ > >> > >> wrote: >> >>> R may be installed already--when I installed v25 recently, it was an >>> option >>> in the installation dialog. Jon can probably tell you how to check >>> quickly. >>> >>> If the R Essentials have not been installed, here are some instructions: >>> >>> https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2. >>> 0/com.ibm.swg.ba.cognos.op_capmod_ig.7.2.0.doc/t_ >>> essentials_for_r_statistics.html >>> >>> HTH. >>> >>> >>> >>> fatmayuliana wrote >>> > "STATS DISAGG requires the R Essentials" >>> > >>> > What does it mean? >>> > >>> > Does it mean that i should have R? And install R? And operate it on R? >>> > >>> > Or i must install R but operate in on SPSS? >>> >>> >>> >>> >>> >>> ----- >>> -- >>> Bruce Weaver >>> > >> bweaver@ > >>> http://sites.google.com/a/lakeheadu.ca/bweaver/ >>> >>> "When all else fails, RTFM." >>> >>> NOTE: My Hotmail account is not monitored regularly. >>> To send me an e-mail, please use the address shown above. >>> >>> -- >>> Sent from: http://spssx-discussion.1045642.n5.nabble.com/ >>> >>> ===================== >>> To manage your subscription to SPSSX-L, send a message to >>> > >> LISTSERV@.UGA > >> (not to SPSSX-L), with no body text except the >>> command. To leave the list, send the command >>> SIGNOFF SPSSX-L >>> For a list of commands to manage subscriptions, send the command >>> INFO REFCARD >>> >> >> >> >> -- >> Jon K Peck > >> jkpeck@ > >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to > >> LISTSERV@.UGA > >> (not to SPSSX-L), with no body text except the >> command. To leave the list, send the command >> SIGNOFF SPSSX-L >> For a list of commands to manage subscriptions, send the command >> INFO REFCARD > > > > > > ----- > -- > Bruce Weaver > bweaver@ > http://sites.google.com/a/lakeheadu.ca/bweaver/ > > "When all else fails, RTFM." > > NOTE: My Hotmail account is not monitored regularly. > To send me an e-mail, please use the address shown above. > > -- > Sent from: http://spssx-discussion.1045642.n5.nabble.com/ > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD ----- -- Bruce Weaver [hidden email] http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
Re: Denton benchmarking method (xlpbm) ?
|
|
Wow. Thank you Mr. Jon and Mr. Bruce.
But, i think firstly i have to learn R and how it works on SPSS. So that i can doing STATS_DISAGG clearly. I'll read that instructions and what packages should i have first. Best Regards, Fatma |
Re: Denton benchmarking method (xlpbm) ?
Administrator
|
You really don't need to learn R to use the extensions.
It basically operates behind the scenes. fatmayuliana wrote > Wow. Thank you Mr. Jon and Mr. Bruce. > > But, i think firstly i have to learn R and how it works on SPSS. So that i > can doing STATS_DISAGG clearly. > I'll read that instructions and what packages should i have first. > > Best Regards, > > > Fatma ----- Please reply to the list and not to my personal email. Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
Re: Denton benchmarking method (xlpbm) ?
|
|
Really?
Okay, i'll try it through the instructions. Thank you for your help Mr. David. |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |