Statistical Analysis of ASX Stock and Petrol Price Trends
- Finance
- 19 pages
- Shared May 2025
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.
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).
Page 2 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
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
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
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 documentMore Finance study materials
See all
Textbook GuidesSolution Manual For Investments, 12th Edition
Finance
314 pages161downloadsFeb 2025
Exam GuidesTest Bank for Principles of Managerial Finance, 8th Edition
Finance
851 pages158downloadsFeb 2025
Textbook GuidesSolution Manual for Financial Institutions Management: A Risk Management Approach, 8th Edition
Finance
486 pages154downloadsFeb 2025
Exam GuidesTest Bank for Principles of Managerial Finance, Arab World Edition
Finance
373 pages148downloadsFeb 2025
Textbook GuidesMultinational Financial Management, Study Guide, 6th Edition Solution Manual
Finance
278 pages146downloadsFeb 2025
Textbook GuidesFinancial Markets and Institutions, 7th Edition Solution Manual
Finance
194 pages136downloadsFeb 2025
Certification GuidesWiley Finra Series 3 Exam Review (2019)
Finance
253 pages131downloadsFeb 2025
Exam GuidesTest Bank For Essentials of Investments, 8th Edition
Finance
368 pages130downloadsFeb 2025
Study this document with CramX
Once it is in your library, every tool can work from it.

