Construct a relative frequency histogram

Assignment Help Other Subject
Reference no: EM132375588

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 the ASX code "SYD" (Sydney Airport), and find out details about the company. Also, type in the ASX code "ALX" (Atlas Arteria), and find out the details about that company. Both these companies belong to industrials sector and within the industry group transportation. 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 SYD and ALX shares for every quarter from January 2009 to December 2018 (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 2009 to 2018 (Total 40 observations). To provide you with some guidance as to what the unadjusted prices look like, two charts accompany this question. After you have researched share prices and industrials sector (transportation group), answer the following questions:

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

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

(c) Draw a bar chart of market capitals (or total assets) in 2018 (in million Australian dollars) of 6 companies listed in ASX that trade in industrials (transportation) 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 SYD or ALX, 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 some common household white goods in Australia. Consider the information as data from simple random sampling of different sample sizes.


Prices of white goods in Australian stores.

Description

Advertised or listed price (in AUD)

50" 4K smart TV

439.99, 499.99, 880.00, 888.00, 499.00, 895.00, 595.00, 429.00, 699.00,

519.99, 1495.00, 454.00, 629.00, 602.00, 481.95, 498.00, 434.00, 752.00,

599.00, 469.95, 799.00, 480.15, 695.99, 929.33, 1395.00, 1295.00

300L frost-free Fridge

699, 449, 678, 849, 1199, 787, 694, 698, 878, 489, 595, 538, 999, 649, 1009

30L Microwave oven

180, 119, 129, 99, 139, 249, 333, 200, 168, 185, 170, 233, 165, 215, 176,

246, 280, 140, 259, 288, 348, 268, 349, 242

7kg top load clothes Washer

589, 445, 598, 744, 824, 699, 579, 649, 449, 769, 599, 597, 628

5kg vented clothes Dryer

399, 395, 495, 398, 395, 448, 418, 346, 478

From the information provided in the table above,

(a) Compute the mean, median, first quartile, and third quartile of weekly rents for each of the white goods 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 of the white goods.

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

(d) Write a paragraph on annual running cost and energy use per year in Australia for each of these white goods. Provide URLs from which you extracted the information and the dates on which you visited the Websites.

Question 3
The Table below is taken from the Australian Bureau of Statistics (ABS) website Data Cubes Table 1 - Government Financial Estimates, Australia (Table 3 inside spreadsheet). It provides data on revenue of different states in Australia as well as expenses (in million dollars).

Based on the table above on the distribution of revenues, answer parts (a), (b) and (c) of the questions below:

(a) What proportion of total income for all states and territories in Australia is coming from taxation?

(b) If Queensland government randomly picks $1 million from an income stream to be spent for an environmental cause, what is the probability that it is coming from Interest income?

(c) Given that the Federal government has some surplus money to be given as Capital grant to a state at random for rail expansion, what is the probability that the money will go to Tasmania?

(d) Visit the ABS website and determine which states are in the best and worst positions as to GFS Net Operating Balance.

Question 4

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 and hail) for the year 2018 in Innisfail, Queensland (Station number 32025). The zero values indicate no rainfall and the left-most column gives the date.

(a) 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.):
(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 4 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 20mm and 60mm 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 Spambase Data Set from the UCI machine learning data repository. The dataset is about identifying emails as being spam or non-spam. The value of 1 in the last column indicates spam and 0 indicates non-spam for a given email (Each row captures the characteristics of one email and the sample size of number of emails is 4601.). (Download both spambase.dat and spambase.names files. The actual data is contained in spambase.dat file. Open it with Excel, change text to columns with "Delimited" option followed by choosing "Comma" as Delimiter.). The name of the attribute (column title) will come from spambase.names file; for example, 1st column is "make", 2nd column is "address", 3rd column is "all", etc. The values in the table indicate the number of times (frequency) of these words occurring in a given email. From the data provided, answer the questions below:

(a) Test for normality of the variables where more than 50% of the values are non-zeros using normal probability plot (to be done in Excel or similar software. COUNTIF function in Excel can be used to find the number of zeros in any column):

(b) Construct a 90% confidence interval for each of the variables checked for normality in part (a) assuming those are normally distributed separating the data between spam and non-spam emails. After all the confidence intervals have been constructed, identify any variable(s) that can be used to distinguish between spam and non-spam emails (i.e., identify the variables where the confidence intervals do not overlap).

Attachment:- Assessment details.rar

Reference no: EM132375588

Questions Cloud

What is its total assets turnover : What is its total assets turnover? Do not round intermediate calculations. Round your answer to two decimal places.
Develop a MATLAB program to calculate the reaction forces : 1105ENG Numerical and Computing Skills - Problem Solving Assignment, Griffith University, Australia. Develop a MATLAB program to calculate the reaction forces
What you have learn about possible causes of social problem : For this Assignment, consider what you have learned about the possible causes of the social problem you selected which Child abuse and neglect.
How much money can you withdraw each year 2-6 : You deposit $50,000 now. How much money can you withdraw each year 2-6?
Construct a relative frequency histogram : Construct a relative frequency histogram for SYD and a frequency polygon for ALX on the same graph with equal class widths, the first class being
Do you think that non-human animals have interests : Do you think that non-human animals have interests? Does this mean that they also have rights? Explain. Must be at least 300 words and have 3 academic sources.
How are you going to improve writing and communication skill : Part of being successful in college is being able to reflect on your educational journey. This is an optional forum so feel free to respond to any.
How much should he set aside today for his purchase : Assume that Stephen can earn 8.79 percent. (compounded monthly) on his money. How much should he set aside today for his purchase?
Difference between primary and secondary markets : Explain how capital markets operate and use examples to explain the difference between primary and secondary markets.

Reviews

len2375588

9/24/2019 3:43:06 AM

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).

len2375588

9/24/2019 3:42:59 AM

• For those questions where Excel is 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. Also, no submission as an email attachment will be accepted.

len2375588

9/24/2019 3:42:49 AM

• 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. • Microsoft Excel 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

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd