An investment company asks you to perform the statistical calculations

An investment company asks you to perform the

This preview shows page 14 - 19 out of 26 pages.

An investment company asks you to perform the statistical calculations regarding to the returns of David’s All Wealthy Fund (Variance): A B 1 Date Monthly Return (%) 2 Apr-14 7.00 14 Kent Institute Australia -Interpret and use financial statistics and tools (FNSACC602), V1.3-08.17  
Image of page 14
Subject Name: Financial Management (DAC03-C) Unit Name: Interpret and use financial statistics and tools (FNSACC602) 3 May-14 5.00 4 Jun-14 -4.00 5 Jul-14 4.50 6 Aug-14 4.00 7 Sep-14 -3.00 8 Oct-14 8.00 9 Nov-14 0.10 10 Dec-14 1.00 11 Jan-15 -5.00 12 Feb-15 2.00 13 Mar-15 4.00 14 Apr-15 7.00 You are required to use MS Excel to calculate: 1) Mean = 2.35 2) Median = 4 3) Mode = 7 4) Deviation and squared deviation in a table. 5) Sum of the squared deviation = 222.23 6) Mean of the squared deviation = 17.09 7) Square root of the mean (standard deviation) = 4.13 A B C D 1 Date Monthly Return (%) Deviation Squared Deviation 2 Apr-14 7 4.65 21.59 3 May-14 5 2.65 7.00 4 Jun-14 -4 -6.35 40.37 5 Jul-14 4.5 2.15 4.61 6 Aug-14 4 1.65 2.71 7 Sep-14 -3 -5.35 28.66 8 Oct-14 8 5.65 31.88 15 Kent Institute Australia -Interpret and use financial statistics and tools (FNSACC602), V1.3-08.17
Image of page 15
Subject Name: Financial Management (DAC03-C) Unit Name: Interpret and use financial statistics and tools (FNSACC602) 9 Nov-14 0.1 -2.25 5.08 10 Dec-14 1 -1.35 1.83 11 Jan-15 -5 -7.35 54.08 12 Feb-15 2 -0.35 0.13 13 Mar-15 4 1.65 2.71 14 Apr-15 7 4.65 21.59 Criteria for evaluation for task 2: The Final grade for this assessment task must require being Competent by achieving Satisfactory in each task. Did the student demonstrate the knowledge of the following S atisfactory N ot S atisfactory Place a tick ( ) apply statistical methods to work in the financial services industry source and access statistical and other data, and produce and interpret statistics use financial data tools and calculations to produce accurate and informative statistical reports from data efficiently record and store data for retrieval explain and apply mathematical principles and statistical methods describe the range of statistical ratios and analysis tools relevant to the financial services industry outline sources of relevant information available to the financial services industry, and their relevance recognise and explain types of graphs, charts, diagrams and tables used in statistical modelling and reporting explain the principles of statistical standards and sampling techniques that are used to gather valid data. Assessment Outcome: SATISFACTORY NOT YET SATISFACTORY 16 Kent Institute Australia -Interpret and use financial statistics and tools (FNSACC602), V1.3-08.17
Image of page 16
Subject Name: Financial Management (DAC03-C) Unit Name: Interpret and use financial statistics and tools (FNSACC602) Did the student demonstrate the knowledge of the following S atisfactory N ot S atisfactory Place a tick ( ) Feedback to student: 17 Kent Institute Australia -Interpret and use financial statistics and tools (FNSACC602), V1.3-08.17
Image of page 17
Subject Name: Financial Management (DAC03-C) Unit Name: Interpret and use financial statistics and tools (FNSACC602) Assessment Task 3 - Case Study and Presentation.
Image of page 18
Image of page 19

You've reached the end of your free preview.

Want to read all 26 pages?

  • Three '18
  • Accounting, Statistics, Kent Institute Australia, Management (DAC03-C), Institute Australia -Interpret

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture