 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Standard Deviation | Login/Join |
| Virtuoso |
We have a database with stock prices per month (first, last, max, min). We need to calculate the standard deviation and the variance to measure the risk and the volatility. I can do this in excel, but if this would be possible in Webfocus it would help a lot.
| ||||||
|
| Virtuoso |
| |||
|
| Virtuoso |
Thanks Alan I think that will do what I need. I just could not find it. I typed "standard deviation" in the find button, but no result. I wish I had the old PCFocus manual. There was a big part on this statistical issues.
| |||||||
|
| Virtuoso |
You actually brought back to mind the old ANALYSE function. Is that still available, I've not seen it since, oh, 1996 I think. Alan. WF 7.705/8.007 | |||
|
| Virtuoso |
Yes it would be great to have that functionality in WebFocus. I get several question on statistics.
| |||||||
|
| Virtuoso |
Tell me about it. I have had to do mean and median on grade point. Turns into major issue at times. I always have to look up the formulas and I used to be good in math. Have a great weekend all. Leah | |||
|
| Expert |
Just fyi if you open Excel, type STANDARD DEVIATION into the HELP menu, you get very nice formulae for different forms of STD, depending on your needs. thank you mr gates. A little careful reading, and you can replicate in WF.
| |||||
|
| Gold member |
Using the formula "s = square root of[(sum of Xsquared -((sum of X)*(sum of X)/N))/(N-1)]" for standard deviation you have all of the components in the prefix operators with the SUM verb, i.e SUM, Mean = AVE, and Square Root=ASQ. WF 7703M, XP/Win7, MRE, RC, BID, PMF, HTML, PDF, Excel 2000/7/10 | |||
|
| Virtuoso |
Haven't really tested this, but ... the old ANALYSE FILE HOLD still works in webfocus reporting server 764. I started an interactive agent and created a hold file. Did an ANALYSE FILE HOLD, entered CORRE, and it gave me some output. Don't know if it's correct, but that's not really important. There is also still an analyse manual (for mainframe focus) on the IBI doc site available, so you could just pick that up and start using ANAYLSE again.... Link to the document is: Stats manual Hope this helps ... GamP
| |||||||||
| ||||||||||
| Expert |
OMG it DOES work. Now the ? is, how to grab the output. STATHOLD doesn't appear to existThis message has been edited. Last edited by: susannah,
| |||||
|
| Platinum Member |
While we could take the ANALYSE FILE HOLD and make it GUI controlled so it would work in WebFocus, my question is, would this be enough, or would it be too little considering the plethora of statistical packages out there today? Release 7.6.9 Windows HTML | |||
|
| Expert |
Gerry, it would be enough for users who don't have a stat package or the time to fight the budget fight to get one...and just want a not-too-mission-critical way to build a tiny multivariate model and crank out a forecast that beats linear extrapolation. That would be fine. ( i seem to recall we talked about this at a summit in the last millenium) We all know that ANALYSE won't work on BY field breaks...only on one dataextract at a time...so ok we'll deal with it..but as soon as you give it to us...i'll betcha an NFR will come thru for a more flexible version... Give us an inch... That would be my 2 cents.
| |||||
|
| Virtuoso |
I do agree wth Susannah, but meanwhile I will try to use it as is. First print the manual.... Thanks G
| |||||||
|
| Virtuoso |
I agree wholly with Sussanah. It was useful in the past and would be useful in the present for the simpler models that otherwise require us to actually do some long forgotten math. Alan. WF 7.705/8.007 | |||
|
| Expert |
As long as we have your Attn, Gerry.... ill put in a plug for TRIG FUNCTIONS..the majors sin cos tan and their arcs. Please! and glenda reminds that i forgot secant, and the other co's..cosec and cotan.This message has been edited. Last edited by: susannah,
| |||||
|
| Guru |
I'm with Susannah. I spent several long days and lots of time picking others brains in order to develope a distance calculator to use in WebFOCUS. It would have been so much easier with the the trig functions Susannah has requested. Glenda In FOCUS Since 1990 Production 8.2 Windows | |||
|
| Guru |
Susannah, I wouldn't know where to start when it comes to articles. I had a point to prove to a Cobol programmer and I did just that. As for money, these are on the house. Glenda In FOCUS Since 1990 Production 8.2 Windows | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |