Retrieving the Opening Prices of MQG and PPT Shares
Visit the Australian Stock Exchange website, www.asx.com.au and from “Prices and research” dropdown menu, select “Company information”. Type in the ASX code “MQG” (Macquarie Group Limited), and find out details about the company. Also, type in the ASX code “PPT” (Perpetual Limited), and find out the details about that company. Both these companies belong to financial sector. Information available in the ASX website will be inadequate for your purpose, you will need to search the internet for more information. Your task will be to get the opening prices of MQG and PPT shares for every quarter from January 2008 to December 2017 (unadjusted prices). If you are retrieving the monthly prices, read the values in the beginning of every Quarter (January, April, July, October) for every year from 2008 to 2017 (Total 40 observations). To provide you with some guidance as to what the unadjusted prices look like, two charts accompany this question obtained from ANZ Share Investing, Australia. After you have researched share prices and financial sector, answer the following questions:
List all the quarterly opening price values in two tables, one for MQG and the other for PPT. Then construct a stemandleaf display with one stem value in the middle, and MQG leaves on the right side and PPT leaves on the left side. (Must use EXCEL or similar for the plot.)
Construct a relative frequency histogram for MQG and a frequency polygon for PPT on the same graph with equal class widths, the first class being “$0 to less than $10”. Use two different colours for MQG and PPT. Graph must be done in EXCEL or similar software.
Draw a bar chart of market capitals (or total assets) in 2017 (in million Australian dollars) of 6 companies listed in ASX that trade in financials with over AUD500 million in market capital. Graphing must be done in EXCEL or with similar software.
If one wishes to invest in MQG or PPT, what is the market recommendation (for example, from Morningstar, Fatprophets, InvestSmart, etc.)? If you cannot find the information, what would be your recommendation based on your research of these two companies (trend, P/E ratio, dividend yield and Beta)?
Top five telecommunication companies listed in the Australian Stock Exchange in terms of market capital are Telstra Corporation Limited (TLS), Spark New Zealand Limited (SPK), TPG Telecom Limited (TPM), Chorus Limited (CNU) and Vocus Group Limited (VOC). The accompanying table provides the average priceearnings ratio (P/E) for these companies for different years. From the data answer the questions below for these companies. (Work only with the data provided. Missing values indicate data not available for those companies during those years.)
Average priceearnings ratio 

Year 
TLS 
SPK 
TPM 
CNU 
VOC 
200708 
15.3 
11.9 
39.6 

200809 
11.5 
10.3 
8.6 
27.1 

200910 
10.4 
11.8 
21.5 
3 

201011 
11 
10.6 
15.8 
10.6 

201112 
10.3 
16.5 
13.6 
13.6 
13.3 
201213 
14.1 
12.4 
14.8 
6.7 
16.2 
201314 
13.4 
13.3 
23.4 
6.7 
20.8 
201415 
17.1 
15.5 
27.2 
8.3 
24.8 
201516 
16 
15.3 
27.8 
17.3 
23.7 
201617 
14.6 
15.7 
15.2 
18 
34.3 
Constructing StemandLeaf Displays and Frequency Histograms
Compute the mean, median, first quartile, and third quartile of average priceearnings ratio for each company using the exact position, (n+1)f, where n is the number of observations and f the relevant fraction for the quartile.
Compute the standard deviation, mean absolute deviation and range for each company.
Draw a box and whisker plot for the average priceearnings ratio of each company and put them side by side on one graph with the same scale so that the P/Es can be compared. (This graph must be done in EXCEL or similar software and cannot be handdrawn.)
Write a paragraph on priceearnings ratio values related to it being indicative of a share being a good investment or a poor investment.
The Table below is taken from the Australian Bureau of Statistics (ABS) website http://www.abs.gov.au/AUSSTATS/[email protected]/DetailsPage/3303.02013?OpenDocument. It provides data on underlying causes of death of Australian population.
Table: Number and causes of deaths in Australia in 2013 (published in 2015).
Based on the table above, what is the probability that an Australian selected at random will die from neoplasms? 1 mark
Based on the table above, what is the probability that an Australian selected at random will die from a disease of the circulatory system and is a female? 1 mark
Based on the table, which disease has the highest proportion of male deaths compared to female deaths, and also, which disease has the highest proportion of female deaths compared to male deaths? 1 mark
Visit the ABS website (Data Cube 1) and determine the probability of an Australian selected at random of dying from diabetes mellitus.
 The following data collected from the Australian Bureau of Meteorology Website (http://www.bom.gov.au/climate/data/?ref=ftr) gives the daily rainfall data (includes all forms of precipitation such as rain, drizzle, hail and snow) for the year 2017 in Melbourne, Victoria. The zero values indicate no rainfall and the leftmost column gives the date. Assuming that the weekly rainfall event (number of days in a week with rainfall) follows a Poisson distribution (There are 52 weeks in a year and a week is assumed to start from Monday. The first week starts from 2 January 2017 – you are expected to visit the website and get the daily values which are not given in the table below. Part of the 52^{nd} week may run into 2018.):
(i) What is the probability that on any given week in a year there would be no rainfall?
(ii) What is the probability that there will be 2 or more days of rainfall in a week?
(b) Assuming that the weekly total amount of rainfall (in mm) from the data provided in part (a) has a normal distribution, compute the mean and standard deviation of weekly totals.
(i) What is the probability that in a given week there will be between 5mm and 15mm of rainfall?
(ii) What is the amount of rainfall if only 10% of the weeks have that amount of rainfall or higher?Download glass data from the UCI machine learning data repository (https://archive.ics.uci.edu/ml/machinelearningdatabases/glass/). The dataset is about glass identification based on its properties. The column headings in sequence from first to last are observation number, refractive index, sodium (content in weight percent), magnesium, aluminium, silicon, potassium, calcium, barium, iron and type of glass (last column). From the data provided, answer the questions below.
a) Test for normality of all the variables separately using normal probability plot, except the first and last column variables.
(b) Construct a 90% confidence interval for each of the variables in part (a) which can be considered as normally distributed separating the data between float glass and nonfloat glass. In the last column, the numbers 1 and 3 represent float glass, all other numbers indicate nonfloat glass. In other words, there will be two confidence interval constructions for each normally distributed variable – one for the float glass observations and the other for the nonfloat glass observations. After all the confidence intervals have been constructed, identify the variable(s) which are significantly different in composition between float and nonfloat type of glasses (i.e., identify the variables where the confidence intervals do not overlap).
Retrieving the Opening Prices of MQG and PPT Shares
 Quarterly opening price
Stem and leaf plot
 Relative frequency histogram and frequency polygon
 Bar chart for total market capitalisation of six companies as on January 1, 2017 is indicated below.
 The price vs fair value graph has been obtained for both the companies which would provide an hint as to which stock is currently undervalued based on which a recommendation may be given.
Based on the above, it is apparent that PPT stock price is currently lower than the fair value which MQG is currently trading at little above the fair price. Hence, the PPT stock must be purchased.
Source: https://www.morningstar.com
 Mean, median, first quartile and third quartile of average price earnings ratio is shown below:
 Typically for stocks which have high potential of future earnings, the P/E ratio is high. On the other hand, businesses with lower growth potential or stagnant earnings are likely to trade at lower P/E. The P/E ratio tends to impact the price of the stock as for the same earnings per share, two companies can have different prices owing to the future growth, associated risk and robustness of the business model.
 Probability that a randomly selected Australian person will die from neoplasms.
Total number of persons =147,678
Number of person who will die from neoplasms = 44,674
Therefore, there is a 0.1523 probability that a randomly selected Australian female person will die from disease of circulatory system.
 Proportions have been calculated as shown below:
Therefore, there is a 0.1523 probability that a randomly selected Australian female person will die from disease of circulatory system.
 Proportions have been calculated as shown below:
Highest proportion of male deaths compared to female deaths = Neoplasms
Highest proportion of female deaths compared to male deaths = Mental and behavioural system
 Probability that a randomly selected Australian person is dying from diabetes mellitus.
Therefore, there is a 0.029 probability that a randomly selected Australian person is dying from diabetes mellitus.
 Poisson distribution
1^{st} week has started = 2^{nd} January 2017
 Probability that on a given week in a year there would be zero rainfall.
Total number of days on which rain was experienced in a year = 134
Therefore, the mean number of days on which rain was experienced per week = 134/52 = 2.5769
No rainfall:
 Probability that in a given week, there would be rainfall amount between 5 and 15mm.
Rainfall amount between 5 and 15mm
1.2815 = (X 10.096)/
 Normal probability plots for the variables
Comment: The above plot can be approximated as a linear shape and hence thus the given variable can be approximated as normal distribution.
Comment: The above plot can be approximated as a linear shape and hence thus the given variable can be approximated as normal distribution.
Comment: The above plot deviates significantly from a linear trend and hence the given variable cannot be approximated as a normal distribution.
Comment: The above plot can be approximated as a linear shape and hence thus the given variable can be approximated as normal distribution.
Comment: The above plot can be approximated as a linear shape and hence thus the given variable can be approximated as normal distribution.
Comment: The above plot deviates significantly from a linear trend and hence the given variable cannot be approximated as a normal distribution.
Comment: The above plot deviates significantly from a linear trend and hence the given variable cannot be approximated as a normal distribution.
Comment: The above plot deviates significantly from a linear trend and hence the given variable cannot be approximated as a normal distribution.
Comment: The above plot deviates significantly from a linear trend and hence the given variable cannot be approximated as a normal distribution.
 90% confidence interval for variables for both float and nonfloat glasses.
For float glass
For nonfloat glass
The variable(s) which are significantly different in composition between float and nonfloat type of glasses are as follows.
 Aluminium
 Barium
 Magnesium
For the above mentioned variables, there is no overlapping of the confidence intervals predicted for float type and nonfloat type glasses.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2020). Analysis Of Australian Stock Exchange And Causes Of Death In Australia. Retrieved from https://myassignmenthelp.com/freesamples/stat20029statisticsformanagerialdecisions/chartofmarketcapitalsformqgandpptshares.html.
"Analysis Of Australian Stock Exchange And Causes Of Death In Australia." My Assignment Help, 2020, https://myassignmenthelp.com/freesamples/stat20029statisticsformanagerialdecisions/chartofmarketcapitalsformqgandpptshares.html.
My Assignment Help (2020) Analysis Of Australian Stock Exchange And Causes Of Death In Australia [Online]. Available from: https://myassignmenthelp.com/freesamples/stat20029statisticsformanagerialdecisions/chartofmarketcapitalsformqgandpptshares.html
[Accessed 11 August 2024].
My Assignment Help. 'Analysis Of Australian Stock Exchange And Causes Of Death In Australia' (My Assignment Help, 2020) <https://myassignmenthelp.com/freesamples/stat20029statisticsformanagerialdecisions/chartofmarketcapitalsformqgandpptshares.html> accessed 11 August 2024.
My Assignment Help. Analysis Of Australian Stock Exchange And Causes Of Death In Australia [Internet]. My Assignment Help. 2020 [cited 11 August 2024]. Available from: https://myassignmenthelp.com/freesamples/stat20029statisticsformanagerialdecisions/chartofmarketcapitalsformqgandpptshares.html.