Limited Time OfferFLAT 20% off & $20 bonus sign up. Order Now
New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now
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 “CWN” (Crown Resorts Limited), and find out details about the company. Also, type in the ASX code “TAH” (Tabcorp Holdings Limited), and find out the details about that company. Both these companies belong to leisure and entertainment 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 CWN and TAH shares for every quarter from January 2008 to July 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 39 observations, October 2017 price will not be available). 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 leisure and entertainment sector, answer the following questions:
List all the quarterly opening price values in two tables, one for CWN and the other for TAH. Then construct a stem-and-leaf display with one stem value in the middle, and CWN leaves on the right side and TAH leaves on the left side. (Must use EXCEL or similar for the plot.)
Construct a relative frequency histogram for CWN and a frequency polygon for TAH on the same graph with equal class widths, the first class being “$0 to less than $2”. Use two different colours for CWN and TAH. Graph must be done in EXCEL or similar software.
Draw a bar chart of market capitals (or total assets) in 2016 (in million Australian dollars) of 5 companies listed in ASX that trade in leisure and entertainment (may include gaming, gambling and cinema) with over AUD500 million in market capital. Graphing must be done in EXCEL or with similar software.
If one wishes to invest in CWN or TAH, 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.
There are four major banks in Australia, which are Commonwealth Bank (CBA), National Australia Bank (NAB), Australia and New Zealand Banking Group (ANZ) and Westpac Bank (WBC). The following table provides the annual dividends per share for each of these banks. From the data answer the questions below for these banks. (Work only with the data provided, do not add any other data.)
Annual dividends per share (AUD) | ||||
Year | CBA | NAB | ANZ | WBC |
2006-07 | 2.56 | 2.646 | 2.048 | 1.83 |
2007-08 | 2.66 | 2.572 | 1.478 | 1.943 |
2008-09 | 2.28 | 1.861 | 1.665 | 1.217 |
2009-10 | 2.9 | 2.048 | 1.95 | 1.895 |
2010-11 | 3.2 | 2.393 | 2.098 | 1.99 |
2011-12 | 3.34 | 2.325 | 2.183 | 2.08 |
2012-13 | 3.64 | 2.443 | 2.163 | 2.216 |
2013-14 | 4.01 | 2.105 | 2.624 | 2.433 |
2014-15 | 4.2 | 2.235 | 2.684 | 2.521 |
2015-16 | 4.2 | 2.417 | 1.934 | 2.242 |
Compute the mean, median, first quartile, and third quartile of annual dividends for each bank (with only the data provided in the table, do not add or change anything in the table) 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, range and coefficient of variation from the data in the table for each bank.
Draw a box and whisker plot for the annual dividends of each bank and put them side by side on one graph with the same scale so that the dividends can be compared.
Australia’s financial regulator, Australian Prudential Regulation Authority, or APRA, has increased pressure on the banks on lending in recent times. Please explain what this pressure is about and how it is affecting the banks.
Mean | -0.577129993 | 0.808646991 | -0.042955237 | 5.312791272 | -0.082213992 | 1.028756197 |
Standard Error | 0.511614606 | 0.096467662 | 0.08299356 | 1.069064158 | 0.024167739 | 0.027738543 |
Median | 0.023486 | 0.53643 | 0.14894 | 1.9929 | 0.021383 | 0.96583 |
Mode | 0 | 0.25081 | 0.25848 | 0 | 0 | 0.87703 |
Standard Deviation | 15.42498946 | 2.90846401 | 2.502224856 | 32.23188544 | 0.728648301 | 0.836306716 |
Sample Variance | 237.9302998 | 8.459162897 | 6.261129229 | 1038.894439 | 0.530928346 | 0.699408923 |
Kurtosis | 899.3735795 | 469.2294751 | 758.2259254 | 387.4779455 | 181.746892 | 478.0727162 |
Skewness | -29.91954038 | 20.68866213 | -26.42950973 | 18.69932471 | -12.21248784 | 19.64575889 |
Range | 466.2423 | 72.416 | 73.067 | 769.295 | 14.01913 | 22.56639 |
Minimum | -463.89 | 0 | -72.067 | -16.015 | -13.337 | -0.16439 |
Maximum | 2.3523 | 72.416 | 1 | 753.28 | 0.68213 | 22.402 |
Sum | -524.611164 | 735.060115 | -39.04631 | 4829.327266 | -74.732519 | 935.139383 |
Count | 909 | 909 | 909 | 909 | 909 | 909 |
Confidence Level(95.0%) | 1.004084593 | 0.189325504 | 0.1628815 | 2.098123936 | 0.04743112 | 0.054439109 |
Lower Limit | -1.581214587 | 0.619321487 | -0.205836737 | 3.214667336 | -0.129645113 | 0.974317088 |
Upper Limit | 0.4269546 | 0.997972495 | 0.119926264 | 7.410915207 | -0.034782872 | 1.083195306 |
No matter how close the deadline is, you will find quick solutions for your urgent assignments.
All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.
Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.
We offer academic help services for a wide array of subjects.
We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.
15,000+ happy customers and counting!