Word count: 3000 words and calculations. So one things excel calculation you don’t put directly in the assignment. You have to put excel work in the paint and take it as a picture. The answer to your assignment should be in the form of a business report. Marks awarded will be based on presentation (5%) as well as the rest (90%). The report will provide you with an opportunity to demonstrate proficiency in integrating Excel with a word processor, Word. Note that you can easily import Excel output to Word.

Your report must include: An Executive Summary (100 to 150 words). In this section you summarize the main conclusions of the report in business language. It should also describe the primary purpose of the study, the general methodology used, the significant findings of each section, as well as key general conclusions and recommendations. A Table of Contents with page numbers. Business Problem as given in the question in business language. Statistical problem using the language of statistics (i.e. methods you have used to do your analysis).

Analysis: This section should present statistical output and discuss the results from all the analyses conducted. Outline required steps and show necessary computer output. Clearly label tables and graphs. General Conclusion: This section should briefly review the study, summarize the inference(s) stemming from it, and highlight the evidence supporting each inference. Where appropriate, indicate the limitations of the results. The conclusions should be written in business language and in terms of the variables under discussion. Implications: bearing in mind why the study was undertaken, briefly describe the implications and consequences of the conclusions drawn. You should include your recommendations for action (based on what you have found in your study). Write clearly and precisely. A precise report is a clear report, one that is composed of unambiguous statements.

The word limit is 3000 words. More information on this assessment will be provided during the session time including the presentation of the assignment and submission to Turnitin. Please note that you should submit the assignment according to the format given in the Moodle site. If you have any queries on assignments, please do not hesitate to contact me. GOOD LUCK.

Marking Criteria - Correct identification, use and interpretation of statistical techniques. Appropriate interpretation of computer output. Overall, you are required to demonstrate the following knowledge and skills in this assessment: Demonstrate the use of visualising data in presentation of real world data. Demonstrate the use of statistical concepts/techniques in business data. Demonstrate how to conduct various hypothesis tests and analysis of variance using computer software such as Excel. Demonstrate the use of computer software to get necessary statistical output. Demonstrate the skills of preparation of a managerial report.

Assessment Submission - Handover the hard copy of the assignment to your lecturer during the lecture time. You should submit your assignment to Turnitin site in the Moodle and get a copy of Turnitin report. This report should attached to your hard copy of your assignment. This assessment task has been set up to be checked by Turnitin, a tool for checking if it has unreferenced content. This may not apply to all assignments. You can submit your assessment task to Turnitin prior to the due date and Turnitin may give you an originality report. You may then make any changes that may be required and re-submit your final version by the due date.