Calculate the standard deviation of U.S. Treasurybills, long-term governmentbonds, andlarge-company stocks for
Table_8_1 - Microsoft Excel X File Home Insert Page Layout Formulas Data Review View QuickBooks X Ruler Formula Bar Split View Side by Side Normal Page Page Break Full Zoom 100% Zoom to Hide Custom New Arrange Freeze If Synchronous Scrolling Save Switch Macros Layout Preview Views Screen Gridlines V Headings Selection |Window All Panes - Unhide DD Reset Window Position Workspace Windows Workbook Views Show Zoom Window Macros J11 fix A B D E F G I K P Q RE 2 Table 8.1 Year-by-Year Returns, 1950-1999 Three-Month Long-Term Large Small U.S. Treasury Government Company Company Year Bills Bonds Stocks Stocks 5 1950 1.20% -0.96% 32.68% 48.45% 1951 1.49% -1.95% 23.47% 9.41% 1952 1.66% 1.93% 18.91% 6.36% 8 1953 1.82% 3.83% -1.74% -5.66% 9 1954 0.86% 4.88% 52.55% 65.13% 10 1955 1.57% -1.34% 31.44% 21.84% 11 1956 2.46% -5.12% 6.45% 3.82% 12 1957 3.14% 9.46% -11.14% -15.03% 13 1958 1.54% -3.71% 43.78% 70.63% 14 1959 2.95% -3.55% 12.95% 17.82% 15 1960 2.66% 13.78% 0.19% -5.16% 16 1961 2.13% 0.19% 27.63% 30.48% 17 1962 2.72% 6.81% 8.79% 16.41% 18 1963 3.12% -0.49% 22.63% 12.20% 19 1964 3.54% 4.51% 16.67% 18.75% 20 1965 3.94% -0.27% 12.50% 37.67% 21 1966 4.77% 3.70% -10.25% -8.08% 22 1967 4.24% -7.41% 24.11% 103.39% 23 1968 5.24% -1.20% 11.00% 50.61 24 1969 6.59% -6.52% -8.33% -32.27% 25 1970 6.50% 12.69% 4.10% -16.54% 26 1971 4.34% 17.47 14.17% 18.44% 27 1972 3.81% 5.55% 19. 14% -0.62% 28 1072 6 Q10% 1 Table 8.1 Year-by-Year Returns 1 4no 14 760% 40 6A% Ill Ready 80% +Table 8_ 1 - Microsoft Excel Home Insert Page Layout Formulas Data Review View QuickBooks @ ( ER 23 [V| Ruler \\\ Formula Bar ` Split View Side by side* ` Hide* [` Synchronous Scrolling* Normal\ Page Page Break| Custom Full [V] Gridlines\\ Headings ZOOM 10.096\ Zoom to* New Arrange Freeze* Unhide\ Save Switch Macros Layout\ Preview* Views Screen Selection| Window* All Panes *\ ^ Reset Window Position Workspace Windows*\ Workbook Views Show Zoom Window* Macros 1 11 D E M P H 5 LET 27 |1972 3.81% 5.55% 28 1973 6 . 91% 1.40% 19.14% - 14.75% - 0.62 % -40.54% 1974 7.93% $1.53% - 26.40% - 29. 74% 30 1975 5 . 80% 37.26% 6.9.54 % 31 1975 5 . 05 % 17 .017% 23.98% 197 7 5 . 101% 54. 81% - 7.26% 22.012% 1978 7.15% - 4 . TE % 6.50% 22.29% 34 \1979 10. 45 % 9.012% 18. 71% 35 1980 11.57% 13 . 17% 32.48% 43.99% 35. 34% 19:37 14.95 % 1982 101.71% 3.61% - $.98% 7.79% 6 .52% 22.09% 22.37% 27.44% 38 1983 8. 85% - 0 .53%/ 34.49} 39 1984 10.012% 15. 29 %/} 6.46 % - 14.012 } 40 19:35 7.83% 32.63% 32.0.0% 28.21% 41 19:35 6 . 18% 23. 95 % 13. 40% 5 .34% 3.40% 42 1987 5.50% - 2. 65 % - 13.95 %/ 43 1938 5. 44% 8.401% 16 .86 % 31.34% 21.72% 44 1989 8.32% 19. 49% 8.37% 45 1990 7.85% 7.13% 45 1991 5 .65% - 3.20% 13. 39% 30.65% - 27. 08% 50.24% 1992 3.54% 7.79% 7.71. 27.843) it 48 1993 2.97% 15. 48% 9.87% 19.94 3.91% - 7 . 18% 20.30% 49 1.29% - 3.34% 50 1995 5.58% 5.5017/ 31. 67 % 37.70%/ . 23:07 % 3:3.21% 19:36 76:50% 1997 5 .32% 15. 183 33. 17% 22.35% 19:43 5 . 11% 1.3.52` 28.5.8% 21.04% - 2.55% 19:49 4. 80% - 3. 74% 21.2 6% 50- year 5. 226% 5.936% 14.890% 17. 10.3% Standard 5 5 Deviation* 2.980% 9. 493% 16.695% 29. 0143% 5 7 A`` : Sources For annual returns are the Center For Filesearch on Security Prices 14 Standard & Fry's FAINT inHer Filecall `inT instar and Finlimning - Smith, Flannel! ! 15 1 #| Table 8 . 1 Year-by - Year Returns | 41 Ready BE\EAT 70%6 6 \ ( + )P8-11 (similar to) .Questton Help a Standard deviation, Calculate the standard deviation of U 5, Treasury bills] long-term government bonds, and large-company stocks for 1986 to 1995 from Table 81 Which had the highest variance? Which had the lowest variance? Click on the Spreadsheet Learning Aid to see Table 3,1Yearby-Year Returns, 19501999 Hint; Mal-re sure to round all intermediate calculations to at least seven (7) decimal places. The input instructions, phrases in parenthesis after each answer box, only apply for the answers you will type. What is the standard deviation of US. Treasury bills for 1986 to 1995? D96 (Round to three decimal places.) Enter your answer in the answer box and then click Check Answer. 4 - -l 4
