Prices and Research

Questions: 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 CCL (Coca-Cola Amatil Limited), and find out details about the company. Your task will be to get the opening prices of a CCL share for every quarter from January 2001 to December 2015. If you are working with the monthly prices, read the values in the beginning of every Quarter (January, April, July, October) for every year from 2001 to 2015. It is part of the assignment task to test your ability to find the information from an appropriate website. If you are unable to do so, you may read the values from the chart provided below obtained from Etrade Australia. Obviously, reading from the chart will not be accurate and you may expect around 60 percent marks with such inaccuracy. After you have recorded the share prices, answer the following questions: a. List all the values in a table and then construct a stem-and-leaf display for the data. b. Construct a relative frequency histogram for these data with equal class widths, the first class being $4 to less than $6. c. Briefly describe what the histogram and the stem-and-leaf display tell you about the data. What effects would there be if the class width is doubled, which means the first class will be $4 to less than $8? d. What proportion of stock prices were above $10? Answers: a. The List of the share prices at the beginning of every quarter are given below: All units are in Dollars Year 1-Jan 1-Apr 1-Jul 1-Oct 2001 4.91 4.65 4.85 5.02 2002 6.37 6 6.3 5.28 2003 5.73 5.69 5.86 5.89 2004 6.35 6.89 7.02 7.36 2005 7.85 8.28 7.81 7.62 2006 7.68 7.28 6.85 6.96 2007 7.83 9.51 9.16 10.2 2008 9.36 8.41 7.72 8.05 2009 9.15 9.14 9.33 10.64 2010 10.93 11.22 11.47 11.14 2011 11.24 11.94 11.3 12.3 2012 11.55 12.45 13.93 13.45 2013 13.84 15.14 12.85 12.9 2014 11.69 9.25 9.31 9.15 2015 9.7 10.27 9.28 9.11 Next we display the data in stem and Leaf plot : 3 4 689 9 5 026788 16 6 0333889 25 7 023667888 28 8 024 (12) 9 111112233357 20 10 2269 16 11 12234569 8 12 3489 4 13 489 1 14 1 15 1 b. The histogram with the specified class intervals is given below: Class Interval Frequency 4-6 9 6-8 16 8-10 15 10-12 12 12-14 7 14-16 1 Total 60 The Histogram is shown below: c. After considering the stem and leaf diagram and the histogram plotted we can conclude that the distribution is nearly symmetric in nature. If we double class widths, then the diagram would not be good enough to judge the data and hence we could not give proper interpretations of the data. d. The proportion of stock Prices above 10 is 20/60=0.3333 (upto 4 decimal places).