ࡱ > . \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ a \ p Antun Balaz B a = = h \:#8 X@ " 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 6 ]A r i a l 1 ]A r i a l 1 ]A r i a l 1 ; ]A r i a l 1 ]A r i a l 1 c ]A r i a l 1 c ]A r i a l "$"#,##0_);\("$"#,##0\)! "$"#,##0_);[Red]\("$"#,##0\)" "$"#,##0.00_);\("$"#,##0.00\)' " "$"#,##0.00_);[Red]\("$"#,##0.00\)7 * 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_). ) ) _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)? , : _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6 + 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) + ) , * ` Sheet1 0 hpq HA High and Low " Rate of Return j% Distribution " b Z 3 A @ @ $ " Date Open High Low Close Volume Adj. Close*- Columns A to G contain the data obtained from2 Column I contains rate of return for purchasing of0 K1 contains standard deviation. The cells M1 and) N1 contain the same numbers, but averaged over the last 1000 days.* Yahoo! Finance for Hewlett Packard Company (Ticker: HPQ).7 one stock (at the lowest price that day) and selling it2 next day (at the highest price) - see the formula. Rate of return. The graph in the Sheet High and Low represents/ time dependence of high and low prices for HPQ.* time dependence of rate of return for HPQ. Bins Frequency5 The cell J1 contains mean interest rate, and the cell0 The graph in the Sheet Rate of Return represents( The Sheet Distribution contains graph of( distribution of rates of return for HPQ.h (do not forget to use "Paste Special" instead of the usual Paste) into the column A. Then we will define^ boundaries of bins (column B), and after that, using the function FREQUENCY, we will count howh many times the rate of return was element of some specific bin. For example, cell C2 contains the numberr The choice of the range of bins, as well as the choice of size of every bin is made according to the graph of timel dependence of rate of return: we will choose the range of bins so that most of the values are in that range,m To plot a distribution of rates of return for HPQ Company, we will copy the column containing rates of returnc equal to the number of events "rate of return is element of the interval [-0.1, -0.099)" and so on.p and the size of one bin we can choose, for example, so that the total numer of bins is 30 or so (up to 100-500). * q v c c a 8 7) h- PE ] of j o t x } ' 7 G Ϝ W ߥ g w / ? O _ o ' 7 $ G) - W2 6 g; ? wD H M R V [ _ /d h ?m q Ov z _ o ' 7 G Ͼ W g w / ? O _ o " ' + 0 4 '9 = 7B F GK O WT X g] a wf j o t x } / ? Ǔ O ל _ o ' 7 G W g w / ? $ O) - _2 6 o; ? D I M R V '[ _ 7d h Gm q Wv z g w / ? ǵ O _ o ' 7 G W g w " ' + 0 4 /9 = ?B F OK O _T X o] a f k o t x '} 7 G ϓ W ߜ g w / ? O _ o ' 7 G $ W) - g2 6 w; ? D I M R V /[ _ ?d h Om q _v z o ' 7 G ϵ W ߾ g w / ? O _ o " ' m* d MbP?_ * + % " ? ? U } m 7) @ $@ !' e % 6) @ % e A D 6) I :oe? 3 D D D A D D A ( lӹs