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 "WPL" (Woodside Petroleum Limited), and find out details about the company. Also, type in the ASX code "WOR" (WorleyParsons Limited), and find out the details about that company. Both these companies trade in energy 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 WPL and WOR shares for every quarter from January 2003 to December 2015 (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 2003 to 2015. 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 energy sector, answer the following questions:
(a) List all the quarterly opening price values in two tables, one for WPL and the other for WOR. Then construct a stem-and-leaf display with one stem value in the middle, and WPL leaves on the right side and WOR leaves on the left side. (Must use EXCEL or similar for the plot.)
(b) Construct a relative frequency histogram for WPL and a frequency polygon for WOR on the same graph with equal class widths, the first class being "$0 to less than $10". Use two different colours for WPL and WOR. Graph must be done in EXCEL or similar software.
(c) For sector comparisons, draw a bar chart of market capital in 2015 (in Australian dollars) of the following companies in energy sector listed in ASX: WPL, WOR, ORG, STO, CTX and SOL. Graphing must be done in EXCEL or with similar software.
(d) What proportion of stock prices (quarterly opening values) were above $40 for each of WPL and WOR?
Question 2 -
The following table provides the prices of textbooks (in US dollars) randomly selected from five publishers from the website www.bookdepository.com. ISBN-13 of each book is provided along with the price. From the data answer the questions below for the publishers. (Website accessed on 10 Aug 2016.)
(a) Compute the mean, median, first quartile, and third quartile of prices for each publisher (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.
(b) Compute the standard deviation, range and coefficient of variation from the sample data of each publisher.
(c) Draw a box and whisker plot for the prices of each publisher and put them side by side on one graph with the same scale so that the prices can be compared. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.)
(d) Visit the www.bookdepository.com website and select a textbook ISBN-13 from the table above which has the same last digit as the last digit of your student ID and provide the full citation of that in Harvard citation style.
Question 3 -
The Table below is taken from the Australian Bureau of Statistics website. It provides data on water use in Australian agricultural farms. (You can get the data from the URL:
https://www.abs.gov.au/ausstats/[email protected]/0/A5A4DA2DF9F997A0CA2571AD007DDFD4?Opendocument.
Totals provided may be higher since all possibilities may not be listed. The totals are not incorrect. MDB stands for Murray-Darling Basin and ML is megalitres).
Based on the information available in the table above -
(a) If a farm is randomly selected in Australia, what is the probability that it gets water from on-farm dams or tanks?
(b) If a farm is randomly selected in Australia, what is the probability that it gets water from groundwater and is located in Queensland?
(c) Given that a farm is located in the Murray-Darling basin (MDB, which spans parts of the states of NSW, VIC, ACT, QLD and SA), what is the probability that it takes water from rivers, creeks or lakes?
(d) In New South Wales what proportion of farms do not take water from either irrigation channels or pipelines or river, creeks or lakes?
Question 4 -
(a) The following data collected from the Australian Bureau of Meteorology Website (https://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 2015 in Hobart, Tasmania. 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 29 December 2014 - you are expected to visit the website and get the daily values which are not given in the table below. Make sure you put the correct station number. Ignore the last few days of 2015 if it exceeds 52 weeks.):
(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 3 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 6 mm and 12 mm of rainfall?
(ii) What is the amount of rainfall if only 20% of the weeks have that amount of rainfall or higher?
Question 5 -
The following data is taken from the UCI machine learning data repository (https://archive.ics.uci.edu/ml/datasets/Forest+Fires). It lists values of a few meteorological variables during forest fires. The table is only a part and the last 140 instances of the dataset - use only the values provided in the table and do not bring in additional instances from the website to answer the questions below.
(a) Test for normality of the variables Temperature, Relative humidity and Wind separately using normal probability plot.
(b) Construct a 95% confidence interval for each of the variables in part (a).
(c) Test the hypothesis that more areas in the forest burn when the temperature is above 250C than when it is below 250C. Use 1% level of significance.