+1 4853618276 support@regentessays.com

Quantitative Methods,Assignment 1 – 2011 Trimester 3,,General guidelines for submission,,_ The assignment should be produced in Microsoft Word and a printed copy need to be,submitted by due date.,_ You may use Microsoft Excel or any other statistical software and embedded or copied and pasted into the Microsoft word document.,,,,QUESTION 2,The data for this question are stored in the file A1Q2.xls. This file contains the dividend yield,(as a percentage) for 150 companies registered on the Australian Stock Exchange for the,year 2005. The sample has been divided into two halves. Column A records the dividend,yield for the largest 75 companies in the sample (measured by the value of the shares they,have issued) while column B records the dividend yield for the smallest 75 companies in the,sample.,,(a) Use Excel to find the mean and standard deviation (s) for each group of companies. (4,marks),,(b) If the dividend yields are normally distributed (bell shaped, use Empirical Rule to find the,minimum proportion of observations that will lie within one standard deviations of the mean.,(2 marks),,(c) For each group of companies, use Excel to count the number of observations that lie,within one standard deviation of the mean. Convert those numbers to proportions. Are they,much larger than what you found in (b)? [Hint: Begin by counting the number of,observations greater than (sample mean)? – 2s and less than ? + 2s. Use commands such as,=COUNTIF(A2:A76, “>a”) and =COUNTIF(A2:A76, “