Question

Calculate the standard deviation (based on daily return in %) over the time period provided below....

Calculate the standard deviation (based on daily return in %) over the time period provided below.

Stock_B Stock_C Stock_D
2014
2015
2016

the data set contains more but this is how it look like

Date Stock_A Stock_B Stock_C Stock_D Stock_E Stock_F
1/1/14 $314.87 $553.95 $253.04 $440.22 $878.62 $1,123.17
1/2/14 $314.65 $550.44 $256.24 $435.69 $878.53 $1,142.03
1/3/14 $314.76 $549.59 $257.85 $435.85 $870.37 $1,155.40
1/4/14 $314.96 $549.91 $257.64 $436.31 $859.32 $1,171.34
1/5/14 $314.88 $549.46 $254.96 $436.79 $879.11 $1,152.60
2/24/15 $288.72 $624.01 $216.06 $497.27 $839.58 $871.85
2/25/15 $288.87 $623.01 $218.83 $496.66 $822.95 $887.89
2/26/15 $289.31 $620.96 $220.40 $495.05 $824.52 $899.79
3/7/15 $288.66 $622.30 $222.48 $495.28 $841.56 $913.60
3/8/15 $289.09 $621.30 $222.28 $492.70 $853.42 $913.13
2/22/16 $304.54 $614.47 $268.87 $560.20 $754.64 $964.05
3/28/16 $304.27 $611.40 $276.83 $564.17 $645.94 $1,000.36
3/29/16 $304.88 $608.96 $276.34 $566.15 $608.49 $1,014.07
4/1/16 $305.20 $611.01 $276.79 $562.32 $611.08 $998.88
4/2/16 $305.43 $609.06 $275.09 $566.13 $620.86 $991.78
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Stock_B Stock_C Stock_D
2014 1.872124 1.999895 1.865696
2015 1.247249 2.66462 1.76855
2016 2.243 3.380101 2.561177
Add a comment
Know the answer?
Add Answer to:
Calculate the standard deviation (based on daily return in %) over the time period provided below....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • question 1,7&10 a) Given the information below: {1, 2, 3, 4, 5, 6} A = {1}...

    question 1,7&10 a) Given the information below: {1, 2, 3, 4, 5, 6} A = {1} B= {4,5) C = {3,6} LIST the elements in each of the following sets: AU ( BCC) Hint Do not use ellipsis, but list each element of the set separated by a comma in numerical order in curly braces that look like this: {}. If the set is empty, type Empty Set without curly braces. (AUB) n(AUC) = Hint Do not use ellipsis, but...

  • 1. You are the new data scientist for Fitbit. When viewing the Google Analytics account associate...

    1. You are the new data scientist for Fitbit. When viewing the Google Analytics account associated with the Fitbit website., you notice that the Average Time on Site is 82 seconds. - Describe 4 different ways you can provide context for this metric. - For the sub-activity, refer to the attachment below entitled, "Image_Module_11.jpg" (the image is also embedded within the text below). Imagine that you have created an email campaign designed to drive users to your site. The email...

  • Data for daily returns is provided below for Chinese Stocks. Calculate expected returns and standard deviation...

    Data for daily returns is provided below for Chinese Stocks. Calculate expected returns and standard deviation and recommend which counter you would invest in based on expected returns and secondly on risk. Listed Company Code_Comcd Stock Code_Stkcd Latest Stock Name_Lstknm Date_Date Daily Return_Dret C603508 603508 Thinker 2018-01-18 0,0138 C603508 603508 Thinker 2018-01-19 -0,0054 C603508 603508 Thinker 2018-01-22 0,0116 C603508 603508 Thinker 2018-01-23 0,0018 C603508 603508 Thinker 2018-01-24 0,014 C603508 603508 Thinker 2018-01-25 -0,0123 C603508 603508 Thinker 2018-01-26 -0,0081 C603508 603508...

  • Calculate the range, mean, mode, median, Standard deviation Calculate the skewness and kurtosis for the above...

    Calculate the range, mean, mode, median, Standard deviation Calculate the skewness and kurtosis for the above data and interpret the data. The following is data collected from the daily salary employees of ZZ COMPANY.. 68 19 43 11 37 30 19 67 65 34 96 23 93 73 46 39 21 12 89 52 33 21 18 57 80 56 91 62 56 48 84 23 78 96 49 36 90 42 65 15 43 36 65 59 34 71...

  • Assume you are analyzing a time series of 12 observations. Using a 3-period moving average, you...

    Assume you are analyzing a time series of 12 observations. Using a 3-period moving average, you successfully calculate the Mean Absolute Error (MAE), Mean Square Error (MSE), and Mean Absolute Percentage Error (MAPE) for each forecasted time period. You then sum the error calculations for each time period for each of the three error calculation techniques respectively. You end up with: MAE 53.5, MSE 547.25, and MAPE 44.15%. To complete your error calculation and compare the accuracy of the 3-period...

  • Based on historical data, daily demand of a product is normally distributed with a mean of...

    Based on historical data, daily demand of a product is normally distributed with a mean of 200 and standard deviation of 50. Develop a spreadsheet simulation model by simulating 300 observations of demand. After simulation freeze the simulated demand values. Use Analysis ToolPak ? Histogram create a histogram visualizing the demand distribution using bins: 100, 125, 150, 175,...,300. Use Analysis ToolPak ? Descriptive Statistics to compute the descriptive statistics metrics of the simulated values. Interpret skewness of the simulated demand....

  • Need help with C++ assignment Assignment 1 and .txt files are provided at the bottom. PART...

    Need help with C++ assignment Assignment 1 and .txt files are provided at the bottom. PART A PART B Assignment 1 #include <iostream> #include <string> #include <fstream> #include <iomanip> #include <stdio.h> #include <ctype.h> #include <string.h> #include <algorithm> using namespace std; /** This structure is to store the date and it has three integer fields **/ struct Date{    int day;    int month;    int year; }; /** This structure is to store the size of the box and it...

  • Time Period t Daily Sales 1 59 2 56 3 92 4 78 5 63 6...

    Time Period t Daily Sales 1 59 2 56 3 92 4 78 5 63 6 75 7 81 8 65 9 99 10 86 11 72 12 89 13 107 14 104 15 93 16 106 17 104 18 124 19 110 20 106 Given the Data Above for the first 20 days Daily Sales of a new restaurant, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following: Slope of Regression Equation =...

  • There is a daily demand of 10 units with standard deviation 3 unit. The lead time...

    There is a daily demand of 10 units with standard deviation 3 unit. The lead time is 14 days with the review period is 30 days. The company set policy of 98% demand satisfaction from items in stock. Beginning inventory is 150 units. How many units should be ordered?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT