Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Some elements of the income statement of XYZ Limited are provided below: J F M A M J J A S 0 ND Sales
Some elements of the income statement of XYZ Limited are provided below: J F M A M J J A S 0 ND Sales k Cost of Sales k 800 880 1120 1360 1280 2720 1840 1280 960 960 880 1200 400 440 560 656 720 1440 880 640 400 480 320 560 Salaries k 240 240 320 320 360 320 400 480 480 480 480 560 No. Orders K 8 12 10.4 12 11.2 16 16 12 9.6 8.8 8 12 No. Customer Complaints 184 144 56 56 48 40 56 48 56 56 72 160 ouerbe Frequency a) Calculate the correlations between complaints and sales and complaints and orders. Please do in full and check by using Excel. Comment on the results. (5 marks) b) Briefly discuss the weaknesses of correlation analysis (6 marks) c) Below are histograms of data sets following either pareto, normal or uniform distribution. Identify which distribution most likely generated each histogram and justify your choice. Additionally, state whether more data would be required for confirmation of these decisions. (4 marks) 02 04 08 Value (d) Explain the use of spreadsheet software in business and apply this to the work of a management accountant. (5 marks) (Total 20 marks) (LOS: 4,5)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started