INTERPRET AND USE FINANCIAL STATISTICS AND TOOLS

100 views 11:01 am 0 Comments June 27, 2023

STUDENT ASSESSMENT

INTERPRET AND USE FINANCIAL STATISTICS AND TOOLS – FNSINC602

Instructions

You are advised to commence work on your assessment from week 1 and all tasks must be submitted by the due dates provided.

All assessments must be completed and delivered individually. Where an assessment involves group discussions, you should consider the input of your group but submit an individual assessment to your trainer.

Please read all instructions on completing each assessment. Instructions for completion are provided at the beginning of each assessment.

All written answers must be typed in a word document using Arial font, 12 size and single spacing if similar instructions are not provided in the assessment.

Your trainer will not be able to assist you in answering questions. However, your trainer will address any issues concerning questions requiring further explanation.

You may refer to your student learning resources or any other relevant resources when completing your assessment.

Assessments are due for submission as specified in the assessment schedule. Any variations to this arrangement must be approved by your trainer prior to the due date for submission.

You have access to computers which are equipped with Microsoft suite of products or any other relevant software and printing facility.

Use assessment templates if provided, to complete relevant sections of the assessment. You can also create your known templates for assessment evidence.

You must achieve a satisfactory result for all tasks to achieve competency in this unit.

All assessment answers should be submitted to the trainer in required format (soft or hard copy) as per trainer instructions with completed assessment cover sheet (if required).

Assessment Schedule

Task

Due Date

Task 1

Week 1

Task 2 – Q1

Week 2

Task 2 – Q2

Week 3

These materials were originally developed by Enhance Your Future Pty Ltd but may now be altered from the original form. Enhance Your Future Pty Ltd does not accept any liability for the Materials, the content and/or any reliance thereon.’

Task 1: Theory Assessment

Student Instructions

Type all the answers in a word document if required.

You can conduct internet research to answer these questions.

Provide explanation of 2-3 lines when answering ‘Describe’ questions.

Provide detailed workings for calculations questions.

Provide answers in table format wherever possible.

Question 1 – Written Answers

Provide answers to questions below in 1-2 paragraphs.

What statistical analyses methods are commonly used in the financial services industry?

What areas of your business would you examine before applying statistical analysis?

How can you implement statistics and apply mathematical models that reflect your organisational demands and conditions?

What is economical modelling?

What are liquidity ratios?

Where can you source information for financial and economic statistical and analytical data?

Briefly describe mean, median, mode, range, and standard deviation.

What is the aim and purpose of data analysis?

What do records tell us?

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.

Question 2 – Statistical Analysis

For this task you must answer the following questions:

Explain the following statistical analysis methods.

Linear and non-linear regression

Multivariate analysis

Time series analysis

Trend analysis

Moving average analysis

Cash flow forecasting

The most commonly used tools for accessing financial information from reports and statements are ratios. Describe the following types of ratios.

Liquidity ratios

Profitability ratios

Activity analysis ratios

Capital structure analysis ratios

Capital market analysis ratios

Explain the following sampling techniques used in the field of statistics.

Survey

Descriptive statistics and inferential statistics

Trends over time

Statistical associations

Variability

Provide a description of the following graphs used in statistical modelling and reporting.

Line Graph

Bar Chart

Pictogram

Pie Charts

The following table records the number of vehicles owned by staff in a local business. Answer the following:

Represent the following data in a Pictogram and a Pie Chart.

What statistical modelling software could you use?

Person

How many vehicles they have owned

Elizabeth Smith

6

Jack Olsen

3

Tristen Piper

4

Jacqui Welsh

1

Edward Montgomery

9

Susie Elliott

7

Sylvia Orr

7

Jacinta Hero

11

Kole Gover

4

Honey Welsh

4

Task 2: Case Study and Practical Assessment

Student Instructions

Type all the answers in a word document if required.

You can conduct internet research to answer these questions.

Provide explanation of 2-3 lines when answering ‘Describe’ questions.

Provide detailed workings for calculations questions.

Provide answers in table format wherever possible.

Question 1 – Australian Financial Services Industry

Written Report

For this task you are to write a report detailing how you could interpret and use financial statistics and tools in the financial services industry. You may use information from the links below for additional information:

Business.gov.au industry factsheet: https://www.business.gov.au/info/plan-and-start/develop-your-business-plans/industry-research/financial-and-insurance-services-industry-fact-sheet

Regulations information: http://asic.gov.au/regulatory-resources/financial-services/

You report must include details on the following:

Where can you source and access external data and information relevant to the financial services industry?

What are statistical standards and why is it important to follow them?

What elements need validation in a statistical standard?

What organisational requirements and priorities do you need to consider when applying statistics to the workplace?

What techniques can you use to counter and avoid data errors?

How can you efficiently record, file and store records for easy retrieval while meeting all security requirements?

The annual salaries (in $000) of the seven junior research officers at a university research Centre are as follows: 42, 45, 40, 46, 44, 40, 43

Find the median salary of the employee.

In Australian defence force recently recruited new soldiers from Victoria. The heights of the soldiers are as follows: 700mm, 600 mm, 470 mm, 350 mm, 450mm, and 300 mm.

Find mean, the variance and the standard deviation.

Question 2 – Herry’s Transport Pty Ltd

Assessment Information

You are a management consultant specialising in statistical data analysis and you have been engaged by Herry’s Transport Pty. Ltd. to provide expert advice with regard to a recent statistical analysis of Herry’s business.

Instructions to complete this assessment

In order to complete this assessment, you are required to complete the following section Details and specific instructions are provided within each section and on the form/templates provided.

Section – Prepare Client Advice

Download and review the case study Herry’s Data, located in Appendix.

Step 2: Herry, the owner of Herry’s Transport Pty. Ltd. wants you to respond to the following in a report template provided in Appendix C:

Herry’s company employs 76 drivers. 20 are aged over 50 years, and of these, 5 go to a gym regularly. Of the drivers under 50 years, 36 attend a gym regularly. As long distance driving is physically demanding Herry is concerned that the lack of regular exercise may affect the performance of the over 50 drivers. Herry has asked you to look at the available data, specifically gym membership, sick days and Kms. driven, to see if there is any statistical evidence to show performance is affected by not having gym membership. Respond to Herry with supporting statistical evidence.

Herry’s pays his drivers a fixed weekly wage, which varies according to age and experience. Some of the drivers are asking to be paid on a $ rate per kilometre basis as they say the current pay basis favours older drivers and penalises younger ones. Herry does not, in principle, have a problem with this, but he would like some statistical data to enable him to make a decision. Are the younger drivers correct in their assertion? Support your answer with appropriate statistical data.

Herry has a “gut feeling” that his business is both seasonal and trending downwards. Using the Orders Received and Sales Invoiced data, identify any seasonality and trend in the 201X year.

Herry would like to see in graphical form

A comparison of sales invoiced by customer with orders received by customer, and

Amount invoiced by kilometre by customer

Create illustrative graphs and add any comments that Herry might be interested in.

Recommend a methodology to Herry for the secure recording and storage of statistical data relevant to his business.

Appendix

Case Study – Herry’s Transport Pty Ltd

Herry’s Data Client Report

References / recommended resources

Interpret and use financial statistics and tools – FNSINC602, Enhance Your Future.

Tags: , , , , , , , , , , ,