☑A FILE HOME INSERT Paste Clipboard A1 Calibri BIU- Y x 1 2 A m B - PAGE LAYOUT 11 A Font fx C Б Using return distributions - Excel FORMULAS DATA % ? REVIEW VIEW Alignment Number Conditional Format as Cell Formatting Table Styles- Styles Cells Editing 4 D E F G H J Suppose the returns below are normally distributed. Based on these values, what is the approximate probability that your return will be less than -2.1 percent in a given year? What range of returns would you expect to see 95 percent of the time? What range would you expect to see 99 percent of the time? 4 5 6 Average return 7 Standard deviation 8 Return less than 9 10 11 6.30% 8.40% -2.10% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. Probability less than -2.10% 12 13 14 15 Range 16 95 percent 17 99 percent 18 19 20 Lower return Upper return Sign In > 4

☑A FILE HOME INSERT Paste Clipboard A1 Calibri BIU- Y x 1 2 A m B - PAGE LAYOUT 11 A Font fx C Б Using return distributions - Excel FORMULAS DATA % ? REVIEW VIEW Alignment Number Conditional Format as Cell Formatting Table Styles- Styles Cells Editing 4 D E F G H J Suppose the returns below are normally distributed. Based on these values, what is the approximate probability that your return will be less than -2.1 percent in a given year? What range of returns would you expect to see 95 percent of the time? What range would you expect to see 99 percent of the time? 4 5 6 Average return 7 Standard deviation 8 Return less than 9 10 11 6.30% 8.40% -2.10% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. Probability less than -2.10% 12 13 14 15 Range 16 95 percent 17 99 percent 18 19 20 Lower return Upper return Sign In > 4

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 22P: Consider the following time series: a. Construct a time series plot. What type of pattern exists in...

See similar textbooks

Similar questions

(Click on the icon here into a spreadsheet.) T in order to copy the contents of the data table below Investment X Y Z Expected return 17% 17% 17% Standard deviation 7% 8% 9%
Given the following probability distribution of returns: Probability Return 0.1 -15.0% 0.25 0.0% 0.3 8.5% 0.25 12.0% 0.1 32.0% what is the expected return?
You are analyzing risk and return and CAPM using the historical data provided below (the same as the downloadable file DataQ16.xlsx ). YYYYMM Return(Stk) Return(Mkt) Return(T-bill) 201601 -4.98% -10.18% 0.05% 201602 -2.07% -2.90% 0.06% 201603 11.63% 8.71% 0.06% 201604 0.32% 1.40% 0.07% 201605 9.39% -1.20% 0.09% 201606 1.62% -0.10% 0.09% 201607 5.91% 5.28% 0.09% 201608 8.20% 4.96% 0.08% 201609 5.55% 1.39% 0.09% 201610 -3.38% -1.56% 0.11% 201611 -5.88% -0.63% 0.11% 201612 -2.07% -3.46% 0.12% 201701 7.75% 6.18% 0.14% 201702 1.27% 1.63% 0.14% 201703 7.63% 1.56% 0.09% 201704 9.25% 2.09% 0.09% 201705 10.20% 4.25% 0.08% 201706 4.33% 0.41% 0.09% 201707 12.25% 6.05% 0.11% 201708 4.98% 2.37% 0.11% 201709 2.19% -1.49% 0.09% 201710 4.05% 2.51% 0.09% 201711 13.78%…
v.1
Berdasarkan informasi tersebut a. Expected return Asset A b. Standard Deviation Asset A dan Asset B c. Portfolio AB Expected Return. d. Coefficient Correlation AB e. Portofolio AB Standard Deviation Please explain by Microsoft excel
Complete the table below using CAPM model Case Expected return RF RM Beta A ? % 10% 18% 0.8
To 4-digit accuracy, what is the Mean of IWM return and the Mean of EEM return?
Use the following returns for X and Y. Returns Year X Y 1. 21.8% 26.4% 2. -16.8 -3.8 3. 9.8 28.4 4. 19.8 -14.6 5. 4.8. 32.4 a. Calculate the average returns for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the variances for X and Y. (Do not round intermediate calculations and round your answers to 6 decimal places, e.g., 32.161616.) c. Calculate the standard deviations for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
calculate the following Sharpe Ratio (SP) Treynor Measure Jensen Measure M2 measure T2 measure Information Ratio (appraisal ratio) Fund Average return Standard Deviation Beta coefficient Unsystematic Risk A 0.240 0.220 0.800 0.017 B 0.200 0.170 0.900 0.450 C 0.290 0.380 1.200 0.074 D 0.260 0.290 1.100 0.026 E 0.180 0.400 0.900 0.121 F 0.320 0.460 1.100 0.153 G 0.250 0.190 0.700 0.120 Market 0.220 0.180 1.000 0.000 Risk free return 0.050 0.000
You are given the following set of data: HISTORICAL RATES OF RETURN Year NYSE Stock X 1 - 26.5% - 22.0% 2 37.2 15.0 3 23.8 10.0 4 - 7.2 4.0 5 6.6 11.8 6 9 20.5 30.6 18.9 17.6 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round intermediate calculations. Round your answer to two decimal places. Beta = b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places. NYSE Stock X Average return,π Avg % % Standard deviation, σ % % c. Assume that the situation during Years 1 to 7 is expected to prevail in the future (i.e., x = TX, Average ↑ M = TM,…
The market and Stock J have the following probability distributions: Probability rM rJ 0.3 15.00 % 19.00 % 0.4 10.00 6.00 0.3 18.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank % Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %
Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Risk-free Return Year 2007 2008 2% 1% Print Market Return 7% -30% Done XYZ Return 9% - 39% - X