Construct a relative frequency histogram for CSR

Assignment Help Applied Statistics

Reference no: EM132105793

Question 1

Visit the Australian Stock Exchange website, www.asx.com.au and from "Prices and research" drop-down menu, select "Company information". Type in theASX code "CSR" (CSR Limited), and find out details about the company. Also, type in the ASX code "SFR" (Sandfire Resources NL), and find out the details about that company. Both these companies belong to material 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 CSR and SFRshares 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 chartsaccompany this question obtained from ANZ Share Investing, Australia. After you have researched share prices and financial sector, answer the following questions:

(a) List all the quarterly opening price values in two tables, one for CSR and the other for SFR. Then construct a stem-and-leaf display with one stem value in the middle, and CSRleaves on the right side and SFR leaves on the left side. (Must use EXCEL or similar for the plot.)

(b) Construct a relative frequency histogram for CSR and a frequency polygon for SFR on the same graph with equal class widths, the first class being "$0 to less than $1". Use two different colours for CSR and SFR. Graph must be done in EXCEL or similar software.

(c) 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 similar products or do similar business as CSR or SFR with at least AUD100 million in market capital. Graphing must be done in EXCEL or with similar software.

(d) If one wishes to invest in CSR or SFR, 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)?

Question 2

The table below lists the prices of apartments with 2 bedrooms and 2 bathrooms sold between January and July of 2018 in Australian state capital city centres (Sydney NSW 2000, Melbourne VIC 3000, Brisbane QLD 4000, Adelaide SA 5000, Perth WA 6000, and Hobart TAS 7000). The data are available in the website www.realestate.com.au/sold and the prices are given in thousand Australian dollars. Consider the information as sample data since some selling prices were undisclosed.

From the information provided in the table above,

(a) Compute the mean, median, first quartile, and third quartile of sold prices for each city using the exact position, (n+1)f, where n is the number of observations and f the relevant fraction for the quartile.

(b) Compute the standard deviation, mean absolute deviation and range for each city.

(c) Draw a box and whisker plot for the sold prices of each city and put them side by side on one graph with the same scale so that the sold prices for different cities can be compared.(This graph must be done in EXCEL or similar software and cannot be hand-drawn.)

(d) Write a paragraph on 2 bed, 2 bathapartment prices of each city, number of apartments sold, and recent trends in apartment prices in the Australian capital citiesafter doing some research.

Question 3

The Table below is taken from the Australian Bureau of Statistics (ABS) website OpenDocument in Employee type Excel sheet Table 6. It provides data onemployment type and occupation in Australia.

Answer parts (a), (b) and (c) of the following based on the table above:

(a) What is the probability that an employee in Australia selected at random will be a Professional?

(b) What is the probability that an employee in Australia selected at random will be a Male and a Sales worker?

(c) Given that a female employee is working part-time, what is the probability that she belongs to the category of Clerical and administrative workers?

(d) Visit the ABS website (Employment type, Table 6) and determine the ratio for total persons in 2013 between Owner managers of incorporated enterprises to Owner managers of unincorporated enterprises.

Question 4

(a) The following data collected from the Australian Bureau of Meteorology Website gives the daily rainfall data (includes all forms of precipitation such as rain, drizzle, hail and snow) for the year 2017 in Hobart, Tasmania. The zero values indicate no rainfall and the left-most column gives the date. Assuming that theweekly 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? 1 mark
(ii) What is the probability that there will be 3 or more days of rainfall in a week? 1 mark
(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 3mm and 9mm of rainfall?
(ii) What is the amount of rainfall if only 15% of the weeks have that amount of rainfall or higher?

Question 5

Download Absenteeism at work data from the UCI machine learning data repository. The dataset is about unapproved absenteeism from work in hours (given in the last column of the table, column U). From the data provided, answer the questions below.

(a) Test for normality of the following variables using normal probability plot:
Transportation expense, Distance from Residence to Work, Service time, Age, and Body mass index.

(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 Absenteeism time in hours for less than 10 and Absenteeism time in hours for 10 or more.In other words, there will be two confidence interval constructions for each normally distributed variable - one for all data with less than 10 in the last column and the other for 10 or higher value in the last column. After all the confidence intervals have been constructed, identify the variable(s) which are likely to influence absenteeism from work (i.e., identify the variables where the confidence intervals do not overlap).

Attachment:- Assessment.rar

Reference no: EM132105793

Questions Cloud

Discuss the effects on the stability of employment : Play the Social Security Game to solve the Social Security problem. Detail your choices, noting the why's of your choices and also discuss the effects.

What variables would be used : Please let me know of a real life scenario where a logistic regression model could be created and what variables would be used.

Using techniques such as focus groups and observation : What are some of the benefits of "soft" market research data gathered using techniques such as focus groups and observation?

Find the probability that finn took : Over the next 2 days, find the probability that Finn took more than 40.5 minutes to get to work on the first day or more than 38.5 minutes to get to work

Construct a relative frequency histogram for CSR : ACC 707 Auditing and Assurance Services - Construct a relative frequency histogram for CSR and a frequency polygon for SFR on the same graph with equal class

Management that are problematic for health care system : What are the two factors that are used in the application of all methods of inventory management that are problematic for the health care system.

Take the normal route to work everyday : Finn changes his mind and, from now on, decides to take the normal route to work everyday. On any given day,the time(in minutes) it takes Finn to get to work

What is the goal of statistical process control : What is a functionally structured organization. What is the goal of statistical process control? Explain and provide an example

What percent are between 500 and 600 : The weights of seeds of a variety of winged beans are approximately normal with a mean of 525 mg and a standard deviation of 110 mg.

Reviews

len2105793

9/6/2018 12:16:16 AM

• For those questions where Excelis not used to do the computations, all formulae and working must be included to obtain full marks. • Only one file will be accepted in any of the formats mentioned above. No zipped file or any other file extension will be accepted. • There will be late submission penalty for submissions beyond the deadline unless prior approval is obtained from the Unit Coordinator through the extension system in Moodle. Under no circumstances any submission that is late beyond 14 days from the deadline of Friday of Week 10 will be marked, or get any score other than zero. Assignment markers will be looking for answers which • demonstrate the student’s ability to interpret and apply the statistical techniques in the scenarios and • use statistical techniques as decision making tools in the business environment. Full marks will not be awarded to answers which simply demonstrate statistical procedures without comment, interpretation or discussion (as directed in the questions).

9/6/2018 12:16:08 AM

Assessment criteria • This assignment must be typed, word-processed or clearly hand-written (but plots and graphs must be done using EXCEL or equivalent software),and submitted online as a single file through Moodle.Important note:The file size must not be over 100MB. • MicrosoftExcel allows students to cut and paste information easily into Microsoft Word documents. Word also allows the use of Microsoft Equation Editor to produce all necessary formulae (use of these are recommended). • It is expected that Excel would be used to assist in statistical calculations for questions in this assignment.Where Excel is used, use copy function, “Snipping tool” or similar to cut and paste relevant parts of the spreadsheet to verify that you have done the work. (In that case there is no need to write the equations.)

Write a Review

Required(*) Message

User Account

All Pages