Homework answers / question archive / Individual Report  This assignment requires you to build and estimate a model using Microsoft Excel or specialist software to address policy/business/management related questions

Individual Report  This assignment requires you to build and estimate a model using Microsoft Excel or specialist software to address policy/business/management related questions

Management

Share With

Individual Report 
This assignment requires you to build and estimate a model using Microsoft Excel or specialist software to address policy/business/management related questions. Please upload both your report file on Moodle. 
Specifics 
You are required to find a management decision problem in any company. Using Excel (or specialised software), conduct an analytics for the problem, and interpret the results. You are required to submit a technical report (1,500 words) that discusses the managerial problem, the results, their implications and makes recommendations for improvement. 
Your report will be marked according to the following criteria: problem description; modelling and solution; discussion on the result; managerial recommendations. 
The grade components will be approximately distributed as follows: 
Introduction (5%) Descriptive analysis (20%) Regression analytics (25%) Managerial interpretations and implications (40%) Conclusion (10%) 
Introduction 
In this section, you will identify your research question - based on the Excel Data you are assigned. It is important to give reasons for why you think it’s interesting to explore such question. 
Descriptive analysis: Import the raw data to the data platform of your chosen software (e.g., MS excel), make sure it imported correctly, identify the main tables and relationships between, produce relevant visualizations. 
Regression analysis: 
Using appropriate regression models to address the managerial problem that you have identified in the Introduction.