GSDM7514 Excel Data Analysis – Descriptive & Predictive Analytics Guide
Assignment Type
Individual Assignment
Subject
GSDM7514 Business Analytics
Uploaded by Malaysia Assignment Help
Date
03/26/2025
Assignment 1 (Introduction to Data Analysis Using Excel) – 30%
Start: Week 2
Due Date/s: Week 4
Learning Outcome/s:
- Learn to structure, clean, and manipulate datasets for analysis in Excel.
- Apply statistical functions, pivot tables, and data analysis tools to extract meaningful insights.
- Create charts and graphs to visualize data, and present findings clearly and professionally.
Module 1: Introduction to Reporting in Excel
Scenario
This “Employee’s Annual Salary” dataset consists of 2000 employees and includes quantitative and qualitative variables related to employee salary, performance, and workplace characteristics. The dataset is structured as follows:
Column Descriptions
| Attribute | Description |
|---|---|
| Gender | Employee gender (Male, Female) |
| Job Role | Type of job (e.g., Manager, Developer, HR Specialist) |
| Department | Business function (e.g., IT, Sales, HR) |
| Salary | Employee’s annual salary |
| Years of Experience | Total years of work experience |
| Education Level | Employee’s highest level of education (Diploma, Bachelor’s, Master’s, PhD) |
| Projects Completed | Number of projects completed by the employee |
| Work Mode | Work arrangement (Remote, On-site, Hybrid) |
| Work Hours Per Week | Average weekly working hours |
| Performance Rating | Employee’s performance rating (scale of 1 to 5) |
Stuck in This Assignment? Deadlines Are Near?
Ensure that you start your analysis with the data cleaning process.
Task 1: Descriptive Analytics
Using the provided “Employee’s Annual Salary” dataset, create a Pivot Table for each of the following: –
- Summarize sum salary by “Gender”.
- Compare average performance ratings by “work mode”.
- Summarize standard deviation for years of experience by “education level”.
- Group the employees by “Job Role”.
Write a short summary for each table explaining the key insights from the data.
Task 2: Descriptive Analytics
Prepare the following charts for each of the given categories:
- Prepare a pie chart for “Job Role”.
- Prepare a clustered bar chart for “Job Role” and “Salary”.
- Prepare a scatter plot for “Work Hours Per Week” and “Salary”.
Write a short summary for each chart explaining the key insights from the data.
Task 3: Predictive Analytics
Perform an independent samples t-test to determine whether there is a significant difference in average “Salary” based on “Gender”. Ensure that you check the assumption of equal variances, report the t-statistic and p-value, and provide a brief interpretation of the results.
Task 4: Predictive Analytics
Perform a regression analysis to examine the relationship between “Years of Experience” and “Salary.” Interpret the regression results by analysing the coefficients, the significance of the findings, and the overall fit of the model. Additionally, discuss any limitations of the model and its practical implications.
Get 30% Discount on This Assignment Answer Today!
Recommended Assignments for You
Related University Assignments
- GSFM7514 Accounting and Finance for Decision Making Assignment Questions 2026
- EDU61034 Curriculum Development Final Assessment 2026 | Unitar
- BUS 4333 Principles of Marketing Assignment 1 Brief 2026 | Unitar
- BAT75014 / GSDM7514 Business Analytics Assignment Brief 2026 | UNITAR
- ITWB2053 Object Oriented Programming Assignment 1 Semester Jan 2026 | UNITAR
- GSFM7223 / ECO75014 Economic for Managers Coursework Details JAN 2026 | UNITAR
- BDS 204 Business Law Assignment Case Study 2026 | UNITAR Malaysia
- ENG6113 Intermediate Academic Reading and Writing Assignment Project | UNITAR
- ITWB2043 Algorithms and Data Structures Group Assignment September 2025
- ITB 6113 Introduction to Information Technology Group Assignment 2 | UNITAR International University (UIU)
Convincing Features
