Abbi is a final year student in OxfordUniversity doing her dissertation. After discussing with her supervisor, her research objective is to estimate the relationship between returns of stocks and level of risk of stocks (i.e. standard deviation of stock returns). Abbi is using primary data and secondary data for her research. Date Tesco Stock Price 01/05/2019 220.0 01/06/2019 224.1 01/07/2019 220.7 01/08/2019 216.6 01/09/2019 238.2 01/10/2019 232.5 01/11/2019 229.4 01/12/2019 255.2 01/01/2020 246.9 01/02/2020 228.5 01/03/2020 228.8 01/04/2020 218.8 03/04/2020 223.9 In her dissertation, Abbi states that primary data is qualitative data. Is it correct? If not, how would you explain to Abbi? The monthly percentage change on 01/04/2020?( explain how you calculate in excel, which formula you use). thank you in advance
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
Abbi is a final year student in OxfordUniversity doing her dissertation. After discussing with her supervisor, her research objective is to estimate the relationship between returns of stocks and level of risk of stocks (i.e. standard deviation of stock returns). Abbi is using primary data and secondary data for her research.
|
Date |
Tesco Stock Price |
|
01/05/2019 |
220.0 |
|
01/06/2019 |
224.1 |
|
01/07/2019 |
220.7 |
|
01/08/2019 |
216.6 |
|
01/09/2019 |
238.2 |
|
01/10/2019 |
232.5 |
|
01/11/2019 |
229.4 |
|
01/12/2019 |
255.2 |
|
01/01/2020 |
246.9 |
|
01/02/2020 |
228.5 |
|
01/03/2020 |
228.8 |
|
01/04/2020 |
218.8 |
|
03/04/2020 |
223.9 |
- In her dissertation, Abbi states that primary data is qualitative data. Is it correct? If not, how would you explain to Abbi?
- The monthly percentage change on 01/04/2020?( explain how you calculate in excel, which formula you use). thank you in advance
Step by step
Solved in 2 steps
