Manufacturing and Allied
Assignment
Group |
Sector |
Group 1 |
MANUFACTURING & ALLIED |
Group 2 |
INSURANCE |
Group 3 |
COMMERCIAL AND SERVICES |
Group 4 |
CONSTRUCTION & ALLIED |
Group 5 |
AGRICULTURAL |
Group 6 |
BANKING TIER 1 |
Group 7 |
BANKING TIER 2 |
Group 8 |
ENERGY & PETROLEUM |
Group 9 |
AUTOMOBILES & ACCESSORIES |
Instructions
- Using Excel or R software refer to the Assignment data (NSE VWAP HISTORICAL PRICES 1Oct-12 to 25-Sep-15) to prepare a report on the stock prices as per the sector allocated to your group.
- For the final report - Submit your final report (strictly in pdf) and the supporting working file (Soft) in Excel or R before the Due date.
- The due date is – Monday, 30th November 2020. You are highly encouraged to consult me as you prepare the data for the analysis.
- The submission package should be properly referenced using APA style. No Plagiarism Allowed.
- The report should be based on measure of location, measure of dispersion, distribution of data and correlation analysis. Be sure to answer the following questions in your report.
- Measure of Location
- Create a scatter plot. Around what values of price do the data tend to cluster?
- What is the mean sales price?
- What is the median sales price?
- Is one measure more representative of the typical stock prices than the others?
- Measure of Dispersion
- What is the range of sales prices?
- What is the standard deviation?
- Is the standard deviation a useful statistic for describing the dispersion of data?
- Determine the coefficient of variations in each of the listed company hence determine which company had better results
- Measure of distribution
- Compute the minimum, maximum, median, and the first and the third quartiles of price.
- Create a box plot. Comment on the distribution of stock prices.
- Create a histogram. Comment on the distribution of data using skewness and kurtosis.
- Hence suggest how this distribution may inform future decisions on performance of stock prices
- Correlation analysis
- Using a scatter plot, describe the relationship between different companies in your respective sectors.
- Compute correlation coefficient and compare the results with part (a).
- Compute R squared and interpret.