\$20 Bonus + 25% OFF

# STAT20029 Statistics For Managerial Decisions

0 Download3 Pages / 685 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
• Course Code: STAT20029
• University: Central Queensland University
• Country: Australia

## Questions:

### 1.

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 “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 stem-and-leaf 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)?

### 2.

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 price-earnings 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 price-earnings ratio Year TLS SPK TPM CNU VOC 2007-08 15.3 11.9 39.6 2008-09 11.5 10.3 8.6 27.1 2009-10 10.4 11.8 21.5 3 2010-11 11 10.6 15.8 10.6 2011-12 10.3 16.5 13.6 13.6 13.3 2012-13 14.1 12.4 14.8 6.7 16.2 2013-14 13.4 13.3 23.4 6.7 20.8 2014-15 17.1 15.5 27.2 8.3 24.8 2015-16 16 15.3 27.8 17.3 23.7 2016-17 14.6 15.7 15.2 18 34.3

Compute the mean, median, first quartile, and third quartile of average price-earnings 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 price-earnings 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 hand-drawn.)

Write a paragraph on price-earnings ratio values related to it being indicative of a share being a good investment or a poor investment.

### 3.

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.

### 4.

• 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 left-most 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 52nd 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?

### 5.

Download glass data from the UCI machine learning data repository (https://archive.ics.uci.edu/ml/machine-learning-databases/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 non-float glass. In the last column, the numbers 1 and 3 represent float glass, all other numbers indicate non-float 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 non-float glass observations. After all the confidence intervals have been constructed, identify the variable(s) which are significantly different in composition between float and non-float type of glasses (i.e., identify the variables where the confidence intervals do not overlap).

### Cite This Work

My Assignment Help (2020) Statistics For Managerial Decisions [Online]. Available from: https://myassignmenthelp.com/free-samples/stat20029-statistics-for-managerial-decisions/chart-of-market-capitals-for-mqg-and-ppt-shares.html
[Accessed 30 November 2020].

My Assignment Help. 'Statistics For Managerial Decisions' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/stat20029-statistics-for-managerial-decisions/chart-of-market-capitals-for-mqg-and-ppt-shares.html> accessed 30 November 2020.

My Assignment Help. Statistics For Managerial Decisions [Internet]. My Assignment Help. 2020 [cited 30 November 2020]. Available from: https://myassignmenthelp.com/free-samples/stat20029-statistics-for-managerial-decisions/chart-of-market-capitals-for-mqg-and-ppt-shares.html.

### Latest Statistics Samples

#### HLT362v Statistics

• Course Code: HLT362V
• University: Grand Canyon University
• Country: United States

Answer: Exercise 31 Calculating t-tests for Independent Samples 1. The given data meets all the assumptions for an independent samples t-test. The validation for this is that: Independent observations: Each case represents a different statistical unit (Controlled and supported employment). Normality: The dependent variable follows a normal distribution in the population. The test for normality is as shown in the table below: Table 1...

#### STAT51300 Statistical Quality Control

Answer: SPC in Communication Centres Statistical Process Control (SPC) is viewed as a standardized industrial technique used for quality measurement and control during a given continuous process. For instance, a tissue donation program can use phone calls to request for funds or resources from people. In this case, the assessment and monitoring of data quality in real-time demands the recording of phone calls in communication centres.  T...

#### PVB 301 Statistical Mechanics Lattice Vibrations Electronic

Answer: It is assumed that the valence electrons can be treated as free, or at least moving in a region of constant potential and non- interacting(Arora, 2013). References Arora, C. L. (2013). S.Chand'S Success Guide R/C B.Sc Physics Vol -3. New Delhi: S. Chand Publishing. Avison , J. (2014). The World of Physics. Cape Town: Nelson Thornes. Harris, S. (2012). An Introduction to the Theory of the Boltzmann Equation. Chelmsford: Courier Co...

#### KMA153 Data Handling And Statistics 1

• Course Code: KMA153
• University: University Of Tasmania
• Country: Australia

Answer: Introduction 1.1 Background Road accident has been identified as one of the major contributor to national deaths in so many countries. The accidents have been found to be caused by various reasons such as reckless driving, unroadworthy vehicles, driving while under the influence of alcohol and poor states of roads to mention but a few (Sidhu & Sodi, 2013). The accidents have not only claimed the life of the occupants of the vehic...

Read More Tags: Australia Melbourne Management University of Melbourne

#### SIT741 Statistical Data Analysis

Answer: Reliability: Transformational Data: Reliability Statistics Cronbach's Alpha N of Items .930 24 The value of the Cronbach’s alpha = 0.930. It indicates that the transformational data set is highly reliable. It may also be a manipulated data (as Cronbach’s alpha = 0.85 to 1). Item-Total Statistics   Scale Mean if Item Deleted Scale Variance if Item ...

Next

### Save Time & improve Grade

Just share requirement and get customized Solution.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

647 Order Completed

98% Response Time

#### Singapore, Singapore

5/5

798 Order Completed

97% Response Time

### Benjamin Blakeman

#### London, United Kingdom

4/5

248 Order Completed

100% Response Time

### Lloyd Bernabe

#### London, United Kingdom

5/5

2830 Order Completed

97% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

Very nice answers. All of the questions were well answered and allowed me to understand the subject very well.

#### User Id: 472407 - 29 Nov 2020

Australia

The quality of work is excellent! Since I have so many assignments to do, I am scared of late submission. They give me back the work on the same day. High efficiency.

#### User Id: 554448 - 28 Nov 2020

Australia

I needed help with a english assignment my grade was a 93/100 good job! This was my second time using yall services.

#### User Id: 514251 - 27 Nov 2020

Australia

The outcome was as I was wanted to be. Nicely done. Thank you.Thank you.Thank you.Thank you.Thank you.Thank you.Thank you.Thank you.Thank you.

Australia