1
/
of
1
store-traders-com
V.14:9 (375-378): SIDEBAR: Standard Error Bands - Technical Analysis, Inc.
V.14:9 (375-378): SIDEBAR: Standard Error Bands - Technical Analysis, Inc.
Regular price
$2.95 USD
Regular price
Sale price
$2.95 USD
Quantity
Couldn't load pickup availability
Sidebar: Standard error bands by Thom Hartle
Microsofts Excel comes with statistical formulas that can be used to create the standard error bands and the related indicators (sidebar Figure 1). The following example uses Microsoft stock price series; column A is the date. Column B is a numerical series for representing the X-axis for calculating the statistical indicators. We are not using the date column for the X-axis because the weekends will be counted in the calculation of the statistical indicators. The difference between Friday and Monday is three periods to Excel, not one, and therefore, the statistical indicators will use column B. In cell B2, enter the number 1, then in cell B3, enter the following formula and copy down: =B2+1
Microsofts Excel comes with statistical formulas that can be used to create the standard error bands and the related indicators (sidebar Figure 1). The following example uses Microsoft stock price series; column A is the date. Column B is a numerical series for representing the X-axis for calculating the statistical indicators. We are not using the date column for the X-axis because the weekends will be counted in the calculation of the statistical indicators. The difference between Friday and Monday is three periods to Excel, not one, and therefore, the statistical indicators will use column B. In cell B2, enter the number 1, then in cell B3, enter the following formula and copy down: =B2+1
Share
