Subject Code & Title :- LA022352 Interpret And Use Financial Statistics And Tools
Assessment Type :- Assignment 2
What you have to do
This assessment consists of 5 Tasks. Each task assesses different elements of competencies.
You are required to complete every question in each task in the assessment.
LA022352 Interpret And Use Financial Statistics And Tools Assignment
Competency requirements :-
Students must achieve a satisfactory result in each element to pass this assessment. If you do not satisfactorily complete any of the questions (i.e. you do not achieve the nominated passing mark for that question) then you will be required to do a gap assessment or a resubmit of the entire assessment. Please note you will not be able to attempt the assessment more than twice.
To achieve a satisfactory result in these topics you must achieve the following results for each question:
Task 1
Part A
Explain the following measures of central tendency:
a. Mean
b. Mode
c. Median
d. Mean Deviation
e. Standard Deviation
Part B
You have been provided with the following car sales volume data for the year:
Using the functionality within excel complete the table below and answer the following questions in spaces provided (show all your workings).
a. Mean
b. Median.
Using an excel table – present your data in an ascending array and use excel formulas to calculate the median. Also show the manual calculation for finding Median
c. Mode
d. Range
e. Mean Deviation
f. Standard Deviation
Task 2
An insurance company’s employee pay rates per hour are grouped in the following ranges
Using the functionality within excel complete the table below and answer the following questions in spaces provided (show all your workings).
a. Mean
b. Median
c. Mode
d. Standard deviation
e. Mean Deviation
Task 3
A mobile service company has recorded the length of time taken to repair the machines for each job. Below are the times taken (in minutes) for a selection of jobs randomly:
23, 25.37, 27, 61, 42, 45, 27, 47
Calculate the Range Inter-Quartile Range semi-inter quartile Range and Mean deviation from the data set below:
Task 4
You have been asked to present the following sales data for the year to the Financial
Controller
1.You are required to create a frequency distribution using FREQUENCY function in Excel for the data provided above.
2.You are also required to use the data and present it using the following:
a. A histogram presenting the frequency distribution created in part a.
b. Create a Frequency curve or Polygon
c. Create a pie chart
3.Explain two types of graphs and charts that are used in statistical modelling and reporting What purpose do they serve?
4. List two sources of primary data and one source of secondary data available for use with in an organisation.
Task 5
The following pie-chart shows the percentage distribution of the expenditure incurred in publishing a book. Study the pie-chart and then answer the questions based on it.
a. If for a certain quantity of books the publisher has to pay $22,800 as printing cost then what will be amount of Promotion Cost to be paid for these books?
b. If the price of the book is marked 25% above the Cost Price. If the marked price of the book is $160, than what is the cost of the book?
c. The price of the book is marked 25% above the Cost Price. If the marked price of the book is $160, then what is the cost of the paper used in a single copy of the book?
d. Using the information in the Pie Chart and the Printing cost of the book being $22,800 how much less is the promotion cost than the printing cost on the book?
e. Using the information in the Pie Chart and if the Printing cost of the book being $30,800 how much less is the promotion cost than the printing cost on the book?
ORDER This LA022352 Interpret And Use Financial Statistics And Tools NOW And Get Instant Discount
Read More :
LA022354 Interpret And Use Financial Statistics And Tools Assignment
