| OCT 1993
Letters To S&C by Technical Analysis, Inc.
LETTERS by Technical Analysis, Inc. STANDARD DEVIATION Editor, In the ""Relative volatility index"" sidebar on pages 64-65 of the June 1993 STOCKS & COMMODITIES, the Excel spreadsheet gives the formulas for the up close volatility and down close volatility in columns E and F. Please define for me STDEVP(D2:D11). I would appreciate a numerical answer. Thank you. ROBERT MAAS - Largo, FL The STDEVP(D2:D11) formula in Excel measures the standard deviation of the closing prices listed in cells D2 through D11. Standard deviation measures the variance about the mean. In our case, we are measuring the variance of the last 10 days of closing prices compared with the mean or average of the last 10 days of closing prices. To learn more about standard deviation, I suggest purchasing a used college statistics textbook from your local community college. Or try The Economist Guide to Business Numeracy, a paperback($17.95) just published by John Wiley & Sons, 605 Third Ave., New York, NY 10158-0012, 800-C ALL WILEY. The book covers everything from statistics for business applications to data analysis techniques, chart reading, investment accounting, forecasting and linear programming. —Editor
by Technical Analysis, Inc.
Technical Analysis of STOCKS & COMMODITIES
The Traders’ Magazine since 1982
has had over 1,226,237 subscribers from 174 different countries.
37,000 Page Traders’ Archive for $89.99
To continue reading, sign-up for trial access to Traders.com and the S&C Archive — 37,000 pages of trading ideas!
After verifying your email address, you will have limited access to the S&C Archive, as well as access to a Digital Edition of S&C, and access to Traders.com Advantage and Working Money for 30 days.
Not a subscriber to Technical Analysis of
STOCKS & COMMODITIES magazine?
Click
here to subscribe, or request
a trial subscription.
Log-in now to view articles from the S&C Archive.
Your Subscriber ID is located at the top of your magazine label, highlighted here in red.
Your last name can be found on the second line, highlighted here in blue.
*If you have a company name on the label, that can also be used. It will appear below your name on the label.
If you do not have a Subscriber ID on your label, you can find it on your statement or renewal form.
For help locating your Subscriber ID number, please call us at 1-800-832-4642 or send an email to Survey@Traders.com. If sending an email, please include your name and mailing address.