Skip to content
Solved Assignments

Statistical Analysis of ASX Stock and Petrol Price Trends

Evaluation of trends in ASX stock prices and petrol market fluctuations.

Preview 6 of 19 pages

See the first 6 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    1 of 6 Statistical Analysis of ASX Stock and Petrol Price Trends Assessment details for all students Assessment item 2 — Assignment 2 Due date: 6 :00pm, Friday Week 10 ASSESSMENT Weighting: 20% 2 Format : Submit one file online as .doc, .docx, .rtf or .pdf Assessment criteria • This assignment must be typed, word - processed or clearly hand - written (since the assignment must be submitted electronically as a single file ) and an appropriate equation editor should be used. Important note: There is no need to include the text of the assignment questions in your submission. • Microsoft Excel allow s 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. • For those qu estions where E xcel is not used, 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 Course Coordinator through the extension system in Moodle. Under no circumstances any submission that is late beyond 14 days from the deadline 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).

  2. Page 2
  3. Page 3
    Read page 3 as text

    2 of 6 Plagiarism CQU values academic honesty. Consequently, plagiarism will not be tolerated in assessment items. This assignment must be completed by each student individually. Question 1 4 Marks Visit the Australian Stock Exchange website, www.asx.com.au and from “Prices and research” drop - down menu, select “Charting”. Type in the ASX code “ORI” (Orica Limited), select OLHC Bar, and Timeframe “Monthly prices over 10 years”. Click on “Create chart”. After you create the chart, read the values in the beginning of every Quarter (January, April, July, October) for every year from 2001 to 2014 . (ASX information may be incomplete and the values adjusted, not original, which will give you at most 6 0 percent marks. Read the note below if you wish to score higher marks.) (a) List all the values in a table and then c onstruct a stem - and - leaf display for the data. 1 mark For accurate values, searched the internet and obtained monthly open prices from the following links and ensured the prices by verifying randomly. http://www.nasdaq.com/symbol/ori/historical https://au.finance.yahoo.com/q/hp?s=ORI.AX&a=00&b=29&c=1988&d=08&e=21&f=2015&g= m The values are in the attached excel sheet ‘HistoricalQuotes’. From the raw data, copied values in the beginning of every Quarter for every year from 2001 to 2014 and pasted in the tab’Sheet1’ Construction of stem - and - leaf diagram by using excels : Creation of stem and leaf using excel add in ‘Megastat’ Step 1: first open the excel options and select Add_ins Step 2: Select ‘Megastat’ and click buttion ‘Go’ Step 3: Then select ‘Megastat’ from ‘Add - Ins’ pop up and click ‘OK’ Step 4: Click Add - ins option in the excel and then select ‘Megastat’ option Step 5: Select ‘Descriptive Statistics’ option and click ‘Stem and Leaf Plot’ option. Step 6: Input the data range for the graph and click ‘OK’ Step 7: if need you can select option for output of the graph in the same tab or a new tab. Below is the output of the data. Descriptive statistics Open price count 56

  4. Page 4
    Read page 4 as text

    3 of 6 Stem and Leaf plot for Open price stem unit = 10 leaf unit = 1 Frequency Stem Leaf 3 0 4 4 4 6 0 5 7 7 8 9 9 8 1 0 0 1 3 3 4 4 4 5 1 6 7 7 8 9 20 2 0 0 0 0 0 1 1 1 2 2 2 3 3 4 4 4 4 4 4 4 12 2 5 5 5 5 5 6 6 6 8 8 8 9 2 3 0 2 56 (b) Construct a relative frequency histogram for these data with equal class inter vals, the first class being “$0 to less than $5 ”. 1 mark Relative frequency histogram with equal class intervals, using excel Analysis tool pak Step 1; Here first class being “$0 to less than $5” so first writes down the classes as ‘ 0 to less than $5’, ‘$5 to less than $10’ and so on to ‘$35 and above’ and then write down the bins ( upper limits) of each class in the excel. Step 2: then select the ‘Data’ option in menu bar Step 3: select ‘Data Analysis’ option available on top right corner Step 4: Select Histogram and click ‘OK’ Step 4: Select ‘Input Range’ and ‘Bin Range’ ‘chart output’ and click ‘OK’ Step 5: Click the graph and select the data for x - axis is class interval ‘CI’ Below is the output of relative frequency distribution and graph of Histogram. CI Bin Frequency $0 to less than $5 4.9999 3 $05to less than $10 9.9999 6 $10 to less than $15 14.9999 8 $15 to less than $20 19.9999 5 $20 to less than $25 24.9999 20

  5. Page 5
    Read page 5 as text

    4 of 6 $25 to less than $30 29.9999 12 $30 to less than $35 34.9999 2 $35 or above More 0 Graph of Histogram is (c) Briefly describe what the histogram and the stem - and - leaf display tell you about the data. What effects wo uld there be if the interval size is doubled, which means the first class will be “$0 to less than $10”? 1 mark Histogram is a good graphical representation of the summarized data. From the Histogram it was observed that typical class is $20 to less than $25. The median lies in the class. More number of observations below the median class. The tail of the left side is more than the right side. So the distribution is slightly skewed. Mean is less than Median. The stem and leaf diagram is a good representation of the raw data. The advantage of this graph over histogram is that we can find the actual data in this graph. Total number of observations in the data set is 56. The typical class is $20 to less than $ 25. From the graph we can observe left - hand side tail is more than right side so the distribution is negatively skewed. No outliers present in the data. (d) What proportio n of stock prices were above $25 ? 1 mark The number of stock prices above $25 is 13 0 5 10 15 20 25 $0 to less than $5 $05to less than $10 $10 to less than $15 $15 to less than $20 $20 to less than $25 $25 to less than $30 $30 to less than $35 $35 or above Frequency Bin Histogram Frequency

  6. Page 6
    Read page 6 as text

    5 of 6 The proportion of stock prices were above $25 is 13 0.232143 23.21% 56 = = (Note: To get more accurate values you will need to search the Internet – it is part of the assignment task to tes t your ability to find the correct information. If you use Etrade Australia, for example, as given in the figure below, use the opening price for the given quarter , which is the whisker to the left of each bar. For higher accuracy, use the interactive chart, and as you move the cursor in the interactive chart, the values will display in dollars and cents at the top .) Explanation of ASX chart terms The red line represents the price of the primary security over the requested time frame. The actual price level is shown on the right axis. The chart may not show actual share prices as share prices are adjusted . The blue line represents the price or value of the secondary security over the requested time frame. The actual price or value is shown on the left axis. The green line represents the moving average for the primary security. The dark green bars represent the turnover for the primary security. The burgundy line represents the volume moving average for the primary security. Adjustments - The charts are adjusted to smooth out the effect of bonus issues, rights issues, special dividends, share splits, consolidations, capital reductions, or to link historical values that represent the company's primary equity security. The chart also assumes that all company issued options and convertible securities are converted into ordinary shares. Moving average - The average value of a security over a period of time. A moving average helps to smooth out volatility in a security's price or volume. For example, a 20 - day average of closing prices is calculated by adding the last 20 closing prices for the security and dividing by 20.

13 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document
See all

Study this document with CramX

Once it is in your library, every tool can work from it.