Microsoft Excel

Question 1    4 Marks
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.    1 mark
(b)    Construct a relative frequency histogram for these data with equal class widths, the first class being “$4 to less than $6”.                                 1 mark
(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”?                                    1 mark
(d)    What proportion of stock prices were above $10?                    1 mark
(a)    Compute the mean, median, first quartile, and third quartile for each capital city (with only the data provided for that city, do not add/delete values for any new/given suburb of question 2) using the exact position, (n+1)f, where n is the number of observations and f the relevant fraction for the quartile.    1 mark
(b)    Compute the standard deviation, range and coefficient of variation from the sample data for each city.    1 mark
(c)    Draw a box and whisker plot for the median weekly rents of each city and put them side by side on the same scale so that the prices can be compared.       1mark
(d)    Compare the box plots and comment on the distribution of the data.       


Price: £ 129

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh