logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

Radhika GargData mining

614 Answers

Hire Me
Jennings DyerPolitical science

729 Answers

Hire Me
StatAnalytica ExpertNursing

932 Answers

Hire Me
Laurence FarrelllPsychology

928 Answers

Hire Me
Business Statistics

Specific Instructions You will be assigned data in EXCEL format


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.


Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

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

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

360 Experts Online