Visit the Australian Stock Exchange website, www.asx.com.au and from “Prices and research” drop-down menu, select “Company information”. Type in the ASX code “NAB” (National Australia Bank), and find out details about the company. Also, type in the ASX code “ANZ” (Australa & New Zealand Banking Group), and find out the details about that company. 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 NAB and ANZ shares for every quarter from January 2011 to December 2019 (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 2011 to 2019 (Total 36 observations). After you have researched share prices, answer the following questions:
(a)List all the quarterly opening price values in two tables, one for NAB and the other for ANZ. Then construct a stem-and-leaf display with one stem value in the middle, and NAB leaves on the right side and ANZ leaves on the left side. (Must use EXCEL or similar for the plot.
(b)Construct a relative frequency histogram for NAB and a frequency polygon for ANZ on the same graph with equal class widths. Use two different colours for NAB and ANZ. Graph must be done in EXCEL or similar software.
(c)Draw a bar chart of market capitals (or total assets) in 2019 (in million Australian dollars) of 6 companies listed in ASX that trade in similar products or do similar business as NAB or ANZ with at least AUD 500 million in market capital. Graphs must be done in EXCEL or with similar software.
(d)If one wishes to invest in NAB or ANZ, 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, debt and Beta)?
The table below lists the new motor vehicles sales between January 2016 and December 2016 in 8 Australian states
New motor vehicles sales by State between Jan 2016 - Dec 2016
From the information provided in the table above,
(a) Calculate the mean and standard deviation for each state.
(b)Calculate the Minimum, Q1, Median, Q3 and Maximum values for each state.
(c)Draw a box and whisker plot for the number of new vehicles sales of each state and put them side by side on one graph with the same scale for comparison. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.)
(d)Discuss the number of new vehicles sales of each state, and the trends in new vehicles sales in different Australian states.
The Table below is taken from the Australian Bureau of Statistics (ABS) website. It provides data on Australian households with internet access at home from the Household Use of Information Technology Survey.
From the information provided in the table above,
(a)What is the probability that a randomly selected household lives in South Australia?
(b)What is the probability that a randomly selected household has an internet access in 2012-13 or 2014-15?
(c)Given that a household has an internet access in 2010-11, what is the probability that a randomly selected household lives in New South Wales?
What is the probability that a randomly selected household lives in Victoria and has an internet access in the year 2016-2017?
(a)The local police station found that the speed of vehicles travelling around the suburb in the 60 km/hour zone varies uniformly between 55 km/hour and 62 km/hour. What is the probability that the speed of vehicles will be less than 58 km/hour?
(b)A marketing company is conducting an experiment in which participants are to taste one of two different brands of coffee. Their task is to correctly identify the brand tasted. A random sample of 150 participants is taken and it is assumed that the participants have no ability to distinguish between the two brands.
(i) What is the probability that the sample percentage of correct identifications is greater than 70?
(ii) What is the probability that the sample will have between 40% and 50% of the identifications correct?
(c)A survey conducted by Burwood train station found that the average time of train arrival at the station is normally distributed, with a mean of 36 minutes and a standard deviation of 3 minutes. What value does the upper 5% of the time exceed
(a)A family restaurant wants to estimate the mean amount that customers spend on their dinner between Monday and Friday. Find the 95% confidence interval estimate of the mean given the following random sample of $131, $118, $95, $110, $105, $65, $84, $123, $80.
(b)A survey conducted by a pharmaceutical company found that the probability of success in the clinical trial is 0.75. Suppose five hundred clinical trials are performed in the study, what is the probability of succeeding in the clinical trial between 275 and 420 times? Use normal approximation of the binomial distribution
(c)An airline company found that 395 out of 800 travellers cancelled their airline bookings after they had selected their flight details. At 0.01 level of significance, is there evidence that the population proportion of travellers who select their flights and cancel their bookings is less than 0.45?