I. Specific Instructions You will be assigned data in EXCEL format. Based on this data, you are required to identify a management decision problem or a research question – that can be addressed using the variables in the data. You can use Excel (or other software such as SPSS) to conduct an analytic for the problem, elaboration on the results, and make managerial implications. Your coursework will be marked according to the following criteria:
1. Description of the management decision problem; 2. Application of analytics theory and techniques;
3. Discussions on the result; 4. Making managerial recommendations.
1. 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 database, 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. II. Steps to be taken 1. Please go to the module webpage in Unihub;
2. Go to the section named “Individual Coursework";
3. Open the file name “Assignment of Excel file”;
4. Identify the data file (e.g., Data 2) that is associated with your student ID.
5. Click on list of data set; 6. Open the Excel file that you find in step
4. For example, if your student ID is associated with Data 2, then you will work on Data
2. III. Some suggestions on how to proceed with the assignment The best way to think about this assignment is to consider it a simplified version of your master dissertation which you are going to do soon! As such, you can apply knowledge acquired from the Dissertation Module, and any other modules to work on the assignment. In what follows, we would like to provide you with some suggestions on how to explore the EXCEL data to write the report. Let’s assume you are given a data that have information about HR. In this data you have variables such as age, gender, work experience, education, salary, tenure and so on.
1. How to define a management decision problem or research question? It is sufficient to define just one research question. In this example, you can propose a question such as “ Does there exist a link between gender and wage differential?”. In other words, you want to study whether female employees and male employees have the same salary level if they have the same level of education, work experience…. It is also important to elaborate on why you think this is an interesting and relevant question. To do so, it’s a good idea to incorporate some existing academic references that address the link between gender and salary.
2. How to do the data analysis
2.1. Descriptive analysis You can report some measure of central tendency such as mean, median, standard deviation, frequency of the main variables in the Excel file;
2.2. Regression analysis In this example, salary would be the dependent variable. You then can run the regression using the analytics tools and techniques we talk in class. 3. Interpretation of the results It’s important to provide some discussion on your findings. For example, if you find that the coefficient for men is positive i.e., men have higher salary than women. You can explain why this might be the case. Also, it’s good idea to make references to academic studies that may or may not support your results. 4. Recommendation What would be the managerial implications for your results? For example, if men have higher salary then women, what would you like to recommend either from the government’s policy perspective, and/or from the firm’s HR practices perspective.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
