fm3_chapter34

fm3_chapter34 - A 1 2 3 4 1 2 3 B 5 6 7 C D E F G USING...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
USING TRANSPOSE 1 5 2 6 1 2 3 #MACRO? 3 7 5 6 7 A B C D E F G 1 2 3 4
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1 5 2 6 1 2 3 3 7 5 6 7 TRANSPOSING WITH COPY Use Edit|Paste Special and click Transpose A B C D E F 1 2 3 4
Background image of page 2
THE FREQUENCY ARRA Date 3-Jan-77 0.50 1-Feb-77 0.48 -4.08% #MACRO? Minimum -24.71% 1-Mar-77 0.45 -6.45% Maximimum 32.48% 1-Apr-77 0.47 4.35% 2-May-77 0.46 -2.15% Bin Frequency 1-Jun-77 0.50 8.34% -25.71% 0 1-Jul-77 0.48 -4.08% -23.71% 2 1-Aug-77 0.47 -2.11% -21.71% 1 1-Sep-77 0.50 6.19% -19.71% 2 3-Oct-77 0.47 -6.19% -17.71% 6 1-Nov-77 0.48 2.11% -15.71% 3 1-Dec-77 0.50 4.08% -13.71% 5 3-Jan-78 0.47 -6.19% -11.71% 8 1-Feb-78 0.47 0.00% -9.71% 10 1-Mar-78 0.51 8.17% -7.71% 18 3-Apr-78 0.58 12.86% -5.71% 23 1-May-78 0.56 -3.51% -3.71% 26 1-Jun-78 0.53 -5.51% -1.71% 35 3-Jul-78 0.53 0.00% 0.29% 35 1-Aug-78 0.51 -3.85% 2.29% 37 1-Sep-78 0.53 3.85% 4.29% 30 2-Oct-78 0.48 -9.91% 6.29% 33 1-Nov-78 0.49 2.06% 8.29% 22 1-Dec-78 0.50 2.02% 10.29% 21 2-Jan-79 0.50 0.00% 12.29% 9 1-Feb-79 0.50 0.00% 14.29% 13 1-Mar-79 0.53 5.83% 16.29% 5 2-Apr-79 0.55 3.70% 18.29% 4 1-May-79 0.53 -3.70% 20.29% 5 1-Jun-79 0.53 0.00% 22.29% 2 2-Jul-79 0.53 0.00% 24.29% 1 1-Aug-79 0.55 3.70% 26.29% 1 4-Sep-79 0.56 1.80% 28.29% 0 1-Oct-79 0.48 -15.42% 30.29% 2 1-Nov-79 0.40 -18.23% 32.29% 0 3-Dec-79 0.42 4.88% 34.29% 1 2-Jan-80 0.45 6.90% 1-Feb-80 0.41 -9.31% 3-Mar-80 0.39 -5.00% 1-Apr-80 0.34 -13.72% 1-May-80 0.34 0.00% 2-Jun-80 0.34 0.00% 1-Jul-80 0.40 16.25% 1-Aug-80 0.39 -2.53% 2-Sep-80 0.39 0.00% 1-Oct-80 0.37 -5.26% 3-Nov-80 0.32 -14.52% 1-Dec-80 0.29 -9.84% Ford stock price Monthly return 30 35 40 26 35 35 37 30 33 Frequency Distribu of Ford Return Jan 1977 - Dec 20 A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2-Jan-81 0.29 0.00% 2-Feb-81 0.29 0.00% 2-Mar-81 0.35 18.81% 1-Apr-81 0.32 -8.96% 1-May-81 0.34 6.06% 1-Jun-81 0.35 2.90% 1-Jul-81 0.32 -8.96% 3-Aug-81 0.30 -6.45% 1-Sep-81 0.30 0.00% 1-Oct-81 0.25 -18.23% 2-Nov-81 0.25 0.00% 1-Dec-81 0.25 0.00% 4-Jan-82 11.33% 1-Feb-82 0.29 3.51% 1-Mar-82 0.32 9.84% 1-Apr-82 0.34 6.06% 3-May-82 0.35 2.90% 1-Jun-82 0.37 5.56% 1-Jul-82 0.34 -8.46% 2-Aug-82 0.42 21.13% 1-Sep-82 0.39 -7.41% 1-Oct-82 0.48 20.76% 1-Nov-82 0.50 4.08% 1-Dec-82 0.59 16.55% 3-Jan-83 0.60 1.68% 1-Feb-83 0.58 -3.39% 1-Mar-83 0.61 5.04% 4-Apr-83 0.78 24.58% 2-May-83 0.72 -8.00% 1-Jun-83 0.86 17.77% 1-Jul-83 0.92 6.74% 1-Aug-83 0.87 -5.59% 1-Sep-83 0.94 7.74% 3-Oct-83 1.02 8.17% 1-Nov-83 0.95 -7.11% 1-Dec-83 0.98 3.11% 3-Jan-84 0.95 -3.11% 1-Feb-84 0.87 -8.80% 1-Mar-84 0.85 -2.33% 2-Apr-84 0.86 1.17% 1-May-84 0.87 1.16% 1-Jun-84 0.85 -2.33% 2-Jul-84 0.94 10.06% 1-Aug-84 1.02 8.17% 4-Sep-84 1.09 6.64% 1-Oct-84 1.13 3.60% 1-Nov-84 1.09 -3.60% 3-Dec-84 1.11 1.82% 2-Jan-85 1.19 6.96% 1-Feb-85 1.09 -8.78% 1-Mar-85 1.04 -4.70% 1-Apr-85 1.01 -2.93% -25.7% - -23.7% -23.7% - -21.7% -21.7% - -19.7% -19.7% - -17.7% -17.7% - -15.7% -15.7% - -13.7% -13.7% - -11.7% -11.7% - -9.7% -9.7% - -7.7% -7.7% - -5.7% -5.7% - -3.7% -3.7% - -1.7% -1.7% - 0.3% 0.3% - 2.3% 2.3% - 4.3% 4.3% - 6.3% 6.3% - 8.3% 0 5 10 15 20 25 2 1 2 6 3 5 8 10 18 23 26 22 A B C D E F 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
Background image of page 4
1-May-85 1.08 6.70% 3-Jun-85 1.12 3.64% 1-Jul-85 1.12 0.00% 1-Aug-85 1.11 -0.90% 3-Sep-85 1.11 0.00% 1-Oct-85 1.19 6.96% 1-Nov-85 1.38 14.81% 2-Dec-85 1.48 7.00% 2-Jan-86 1.62 9.04% 3-Feb-86 1.85 13.28% 3-Mar-86 2.12 13.62% 1-Apr-86 1.97 -7.34% 1-May-86 2.10 6.39% 2-Jun-86 2.16 2.82% 1-Jul-86 2.12 -1.87% 1-Aug-86 2.36 10.72% 2-Sep-86 2.10 -11.67% 1-Oct-86 2.30 9.10% 3-Nov-86 2.34 1.72% 1-Dec-86 2.25 -3.92% 2-Jan-87 3.00 28.77% 2-Feb-87 3.08 2.63% 2-Mar-87 3.40 9.88% 1-Apr-87 3.71 8.73% 1-May-87 3.70 -0.27% 1-Jun-87 4.03 8.54% 1-Jul-87 4.17 3.41% 3-Aug-87 4.43 6.05% 1-Sep-87 4.02 -9.71% 1-Oct-87 3.14 -24.71% 2-Nov-87 2.96 -5.90% 1-Dec-87 3.14 5.90% 4-Jan-88 3.58 13.11% 1-Feb-88 3.80 5.96% 1-Mar-88 3.61 -5.13% 4-Apr-88 4.03 11.01% 2-May-88 4.11 1.97% 1-Jun-88 4.55 10.17% 1-Jul-88 4.58 0.66% 1-Aug-88 4.25 -7.48% 1-Sep-88 4.42 3.92% 3-Oct-88 4.50 1.79% 1-Nov-88 4.54 0.88% 1-Dec-88 4.41 -2.91% 3-Jan-89 4.84
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 37

fm3_chapter34 - A 1 2 3 4 1 2 3 B 5 6 7 C D E F G USING...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online