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. a). List 3 main sources to collect primary data and secondary data, respectively; b) Abbi collected the below data from Thomson Reuters Eikon of Tesco. How much is Arithmetic mean of the stock price? The median of the stock price? The monthly percentage change on 01/04/2020? 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 c). What is the best type of chart to represent the variable Tesco Stock Price? d). In her dissertation, Abbi states that primary data is qualitative data. Is it correct? If not, how would you explain to Abbi?
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.
a). List 3 main sources to collect primary data and secondary data, respectively;
b)
- Abbi collected the below data from Thomson Reuters Eikon of Tesco. How much is
- Arithmetic mean of the stock price?
- The
median of the stock price? - The monthly percentage change on 01/04/2020?
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 |
c). What is the best type of chart to represent the variable Tesco Stock Price?
d). In her dissertation, Abbi states that primary data is qualitative data. Is it correct? If not, how would you explain to Abbi?
Make calculations in excel and explain why did you choose this formula. Put explanations (answers) for each question. Thank you in advance.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images