Order from us for quality, customized work in due time of your choice.
Assessment Content
https://libguides.derby.ac.uk/c.php?g=703820&p=5067707
Leadership & future thinking
You must write an individual report analysing only the data provided. The data is real UK data from a specialist database. There are more than 70,000 organisations operating in the UK Metal and Metal Products sector, but consistent data on the variables in this data set is only available for the sample you have in the data set for the latest year available, 2023. The data includes measurements of performance, size, and other variables. The overall aim of your analysis is to help the client link performance in the UK Metal and Metal Products sector to their plans to invest in the sector. The client is thinking about investing in this sector and wants you to analyse the available data provided in the Excel file. You should use your analysis to provide the client with a better understanding of the performance potential of different groups of companies in the sector. Your report must provide only the analysis that the client has requested, and your discussion must explain why the analysis might be relevant to the client as they think about investing in the sector. Your job is not to decide whether the client should invest or not, or to do financial analysis for the client. Your job is to provide the analysis that the client requests, and provide recommendations drawn directly from the analysis. Only use the data provided. Do not add new or additional data or information from other sources. Only use the techniques we have covered in the lectures. Do not use evidence or techniques that we have not covered in the lectures.
Any evidence that students have colluded or copied each other or used the work of a source without reference and citation will be investigated and may result in a plagiarism investigation. If you use
techniques we have not covered in the lectures, it will be treated as a major failure to meet the requirements of the CW2 brief.
The Client’s Requirements
The client is a business investor. This client has not invested in the UK Metal and Metal Products sector before. The client wants you to analyse the data they have provided and present the analysis as a business report of no more than 2,500 words (excluding tables, charts and appendices). The report should help the client in their aim to better understand company performance in the UK Metal and Metal Products sector and how the information from this data set might be used when thinking about investing in the sector. The client has requested the following from you:
The client requires you to provide:
A) An analysis of the distribution of profit margin across companies in the UK Metaland Metal products sector (use all the companies in the sample).
B) An analysis of the difference in the distribution of profit margin between the large and SME (small & medium-sized) companies in the UK Metal and Metal Products sector.
C) An analysis of the difference in the distribution of profit margin between UK Metal and Metal Products companies which are exporters and UK Metal and Metal Products companies which only sell in the domestic market.
D) An analysis of the export status of UK Metal and Metal Products companies against their size (measured by whether they are large or SME companies).
E) An analysis of the extent to which the Return on Shareholder Funds in companies in the UK Metal and Metal products sector is associated with the other quantitative variables in the data set.
F) An analysis of the extent to which the profit margin of companies in the UK Metal and Metal Products sector can be predicted using multivariate regression using all the available variables in the data set.
1. To meet the client’s requirements, you MUST use all the following methods in your analysis in the report:
a. Analysis of required variable distributions (using descriptive statistics, histograms and confidence interval estimates of the mean) with appropriate explanations and comments on what your findings imply for the Client’s aim.
Hypothesis tests of the difference of means and difference of variances, with appropriate explanations of hypotheses and comments on what the test results imply in relation to the Client’s aim.
Cross tab analysis with appropriate probability pattern discussion, and associated Chi- squared test with explanations of what the results imply in relation to the Client’s aim.
Correlation analysis with appropriate tests of significance, and explanations of what the results imply in relation to the Client’s aim.
Multivariate linear regression analysis with appropriate regression models (including dummy variables), regression equations, hypothesis tests, and results, fully supported with appropriate explanations of what the models, regressions, tests and results imply in relation to the Client’s aim.
You must provide evidence in the form of an Excel sheet showing how you conducted the analysis and calculated your results. You should submit the Excel sheet with your results through the Turnitin submission link. Additionally, please submit your report in Word format using a separate Turnitin submission link.
You must choose which techniques and variables to use for each of the client’s stated requirements.
Each part of the analysis must be explained. You must say why you chose the variables, and why you chose the technique, and give appropriate explanations of any results (any calculations should be put in the appendix and not in the body of the report). You need to ensure you interpret the results of techniques used but you do not need to explain calculations to the client. You must provide a full discussion of what your results mean for the client within each part of the analysis (not at the end of the report). Failure to do this will result in very low marks. Marks are mainly awarded for presenting and interpreting the output of Excel for the Client in terms of what it means, not for getting Excel to produce the output. For example, if you say the distribution is skewed, you need to show the evidence and explain why this might be of interest to the client in terms of their understanding of company performance in the UK Metal and Metal Products sector and the client’s plans to invest in the sector.Any tables or charts used must be ‘fit for purpose’ – You must adapt the Excel tables and charts so that they meet the client’s needs and are fit for presentation in a formal business report. When you have done this, you can cut and paste them into the report.
Any fit for purpose charts or tables should be put in the body of the report (not in the appendix) and every table and chart should be numbered, with titles, and have beneath it, a full explained and discussion saying what the table or chart shows and how this relates to the client’s aim.
The report must be set out as follows:
Write your analysis as a typed report with an appropriate title page, contents page, section headings, numbered and labelled figures and tables, and appendices. You do not need an Executive Summary.
You must provide an introduction to your report. Your introduction must state your overall aim and your objectives in order to meet the client’s requirements.
You must provide numbered and headed sections that clearly report the analysis required by the client.
You must provide a conclusion with a summary of your results and recommendations. Your conclusion should summarise what you have already discussed in your analysis, and summarise your recommendations, which should already have been discussed within the analysis. Summarise your findings. Clearly state whether your analysis has met your objectives and why. If you think your report has some weakness, explain what it is and why. Your recommendations must be linked to your conclusions. You will gain marks for this type of critical review.
The word count (excluding tables and appendices) is a MAXIMUM OF 2,500 words for the whole report. This report can be well done in fewer than 2,500 words if well-written and well-focused. You should choose how many words are appropriate for each section in your report. You must provide a word count on the Front Page of the Report. If you exceed the word limit you will lose marks as follows:
10 marks deducted for exceeding the word limit by up to 250 words
20 marks deducted for exceeding the word limit by 251-500 words
30 marks deducted for exceeding the word limit by 501-750 words
50 marks deducted for exceeding the word limit by more than 750 words.
You should reference your sources. You are not required to read about companies in the UK Metal and Metal Products sector or consult any other evidence on the UK Metal and Metal Products sector. However, you are expected to cite sources that relate to your
Excel analysis and statistical techniques. You should cite and reference all materials you use including lecture notes, web pages, online books, hard-copy books, etc. A citation should be provided whenever you are using a statistical technique. These will include textbooks, websites, and lecture notes. Remember, the client may want to consult a source if they are not familiar with your technique, so a citation in a report can be used to guide the reader to some supporting material. References to sources must be provided using the Harvard method in the text of the report and all sources should be fully identified in a bibliography at the end of the report.
Order from us for quality, customized work in due time of your choice.