Reference no: EM132333686

Interpret and Use Financial Statistics and Tools

Learning Outcomes

On successful completion of this unit, the learner/trainee will be able to;

• Apply statistical methods to work
• Source and interpret statistical data
• Analyse data using appropriate techniques and tools
• Record statistical data analysis results and records

Assessment Task 1: Apply Statistical Methods

Description:

These assessment tasks are given as formative tasks that need to be completed within designated assessment sessions during the academic term.

Trainers/assessors may vary the data for the task for different students. Tasks may be scheduled according to classroom learning sessions and organised over a number of sessions to coincide with the relevant lessons and activities.

1. Below is a table of the selling price of bananas (B) per kilogram in dollars compared with the number sold in of kilograms (N).

B	1.50	1.98	5	6	7	8	9	12
N	250	220	180	200	190	124	67	15

(a) Draw a scatter diagram of the data.
(b) Estimate the degree of correlation

2. Below is a table is data related to hours of use of a photocopier (P) and the hours of maintenance (M).

P	70	55	125	90	140	100
M	6	4	8	6	15	6

(a) Draw a scatter diagram of the data.
(b) Estimate the degree of correlation

3. Using a three-year moving average applied to growth factors, prepare a forecast of sales for 2010.

Year	Sales
1998	23 156
1999	24 569
2000	25 689
2001	30 987
2002	32 176

2003	33 467
2004	35 908
2005	36 809
2006	36 911
2007	39 081
2008	42 164
2009	45 789
2010	49 012
2011	50 324
2012	55 609
2013	60 911

(a) Calculate the revenue growth rate %.
(b) Predict the sales for 2013.
(c) Graph on the same axis the functions.

4. From the given annual report of a sample organisation (ASX listed), calculate;

(a) Liquidity ratios
(b) Profitability ratios
(c) Capital structure analysis ratios
(d) Capital market analysis ratios

5. What is Time Series Analysis? Research and outline key concepts of TSA with appropriate examples.

6. Research and briefly describe role and functions of the following organisations and institutions;

(a) Reserve Bank of Australia
(b) Australian Taxation Office (ATO)
(c) Australian Bureau of Statistics (ABS)
(d) National Statistical Service (NSS)
(e) Australian Securities and Investments Commission (ASIC)
(f) Australian Prudential Regulation Authority (APRA)
(g) Industry association data and information
(h) Organisational data and information (public record)
(i) International government and organisation data and information

Ensure that you acknowledge all external sources using an appropriate referencing system (e.g. Harvard Referencing System).

Assessment Task 2: Source and Apply Statistical Data

Description:

This assessment task has two parts. Trainers/assessors may vary the data for the task for different students. Tasks may be scheduled according to classroom learning sessions and organised over a number of sessions to coincide with the relevant lessons and activities.

Part A

1. The following table shows the number of mobile phones females and males owned.

Age	Males	Females
0 < 10	64	90
10 < 20	199	175
20 < 30	365	210
30 < 40	190	255
40 < 50	121	205
50 < 60	43	55
60 < 70	18	10

Calculate the mean, median, mode standard deviation and co-efficient of variation.

2. The monthly charges for using the tolls from two suburbs are:

Cost of toll($)	Dandenong	Frankston
30 < 60	40	10
60 < 90	124	60
90 < 120	192	131
120 < 150	101	122
150 < 180	30	81
180 < 210	7	42
210 < 240	3	28
240 < 270	2	15
270 < 300	1	11

Calculate the mean, median, mode standard deviation and co-efficient of variation

Part B

1. Complete the following tasks using the given data set.

Assets
	$
Cash	200 000
Accounts receivable	400 000
Inventory	1 200 000
Plant	600 000
Total assets	2 400 000
Liabilities
	$
Accounts payable	800 000
Long-term debt	400 000
Capital	1 200 000
	2 400 000
Profit and loss
Sales	1 600 000
Cost of goods sold	1 000 000
Operating expenses	200 000
Interest	100 000
Taxes	100 000
Net profit	200 000

Find the following:
(a) Current ratio
(b) Quick asset ratios
(c) Inventory turnover
(d) Collection period
(e) Fixed asset turnover
(f) Times interest covered
(g) Net profit margin
(h) Return on total assets
(i) Return on capital.

Norts Ltd
Balance sheet Extract

		20XX	20XY
		$	$
Paid up capital ($1 fully paid shares)	200 000 250 000
Retained profits	10 000 15 000
General reserve	5 000 10 000
	215 000 275 000
Total liabilities	85 000 125 000
Total Equities	300 000 400 000

Calculate for both years:
(a) Earnings per share
(b) Earnings yield
(c) Dividend yield
(d) Price per earnings ratio.

2. The following data represents sales for 2005 to 2015:

Year	Sales
2005	10 000
2006	11 000
2007	12 000
2008	12 500
2009	16 000
2010	18 000
2011	25 000
2012	40 000
2013	41 000
2014	43 000
2015	50 000

Based on the data,

(a) Plot the data on a graph.
(b) Draw the secular trend line of best fit using semi-average method.
(c) Predict sales for 2019.

Assessment Task 3: Interpret and Analyse Statistical Data

Description:

This assessment task has two parts. Trainers/assessors may vary the data for the task for different students. Tasks may be scheduled according to classroom learning sessions and organised over a number of sessions to coincide with the relevant lessons and activities.

Part A

1. An auto analyst is conducting a satisfaction survey, sampling from a list of 10 000 new car buyers. The list includes 2500 Ford buyers, 2500 GM buyers, 2500 Honda buyers and 2500 Toyota buyers. The analyst selects a sample of 400 car buyers, by randomly sampling 100 buyers of each brand.

Is this an example of a simple random sample?

A. Yes, because each buyer in the sample was randomly sampled.
B. Yes, because each buyer in the sample had an equal chance of being sampled.
C. Yes, because car buyers of every brand were equally represented in the sample.
D. No, because every possible 400-buyer sample did not have an equal chance of being chosen.
E. No, because the population consisted of purchasers of four different brands of car.

Briefly explain your answer.

2. Draw a scatter diagram for the following:

(a) y = 2x + 3 using the values for x -3,0,3
(b) y = 4x - 2 using the values for x 1,2,6,8

3. Draw a bar graph using the equation y = 4x - 2 and the values 1,2,3,4.

4. Represent the following information as a pictogram.

Age Purchase of trees
10-20 6
20-30 12
30-40 15
40-50 3
50-60 2

5. Briefly explain how you will validate statistical data in an organisational setting. What steps would you take to ensure data security and access given the confidential nature of statistical data?

Part B

1. The data below shows the amount of coffees bought by a class of students in a week.

3 0	2	4	0	3	0	0	0	1	3	1	2
1	1	1	5	2	1	3	1	1	2	2	3
4	2	2	2	2	3	3	3	2	2	2	4
2	2	5

Required:
(a) Draw a frequency table.
(b) Draw a histogram.

2. You are given the following data:

2  1  1  2  1  1  3  1  2  1  0

1  1  3  2  1  4  1  1  1  0  2

Required:
(a) Draw a histogram.
(b) Draw a frequency table.
(c) Draw a frequency polygon.

3. Calculate the mean and standard deviation for the following data:

100<120 4
120<140 6
140<160 9
160<180 12
180<200 15
200<220 9
220<240 10

4. Calculate the mean and standard deviation for the following data.

50 < 60 7
60 < 70 12
70 < 80 26
80 < 90 4
90 < 100 31
100 < 110 15
110 < 120 22