0% found this document useful (0 votes)
9 views8 pages

MBA Salary Analysis and Predictions

Python codes

Uploaded by

sumedh.mba24070
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views8 pages

MBA Salary Analysis and Predictions

Python codes

Uploaded by

sumedh.mba24070
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

IIM Kashipur

Master of Business Administration


Analytics in Business, Term III, Academic Year 2024-26

AB Assignment 4

Section A
Submitted to: Prof. Rajiv Kumar
Submitted on: 09th February 2025

(Group 6)
MBA24040 – Yash Kulkarni
MBA24012 – Ashutosh Singh
MBA24019 – Devansh Rawat
MBA24307 – Rigzin Angmo
MBA24070 – Sumedh Inamdar
MBA24005 – Akash Bhanja
Q1. Clean the data (You may find 999, 998 values, which need to be taken care. You can
exclude those responses)

Code:

import pandas as pd
import [Link] as plt
file_path = "MBA Starting [Link]"
xls = [Link](file_path)
df = pd.read_excel(xls, sheet_name="Salaries")
# Define columns to clean (assuming numerical values should not contain 999 or 998)
columns_to_clean = ["salary", "satis"] # You can add more columns if needed
# Remove rows where any of the selected columns contain 999 or 998
cleaned_df = df[~df[columns_to_clean].isin([999, 998]).any(axis=1)]
# Plotting the cleaned data
[Link](figsize=(8, 5))
[Link](cleaned_df['salary'], bins=20, color='orange', edgecolor='black')
[Link]('Salary')
[Link]('Frequency')
[Link]('Distribution of Cleaned Salaries')
[Link]()
Output

1
Q2. Is there any variable (e.g., age, gender, language spoken, work experience) that
affect how much a student can expect to make?
Code:
import pandas as pd
import seaborn as sns
import [Link] as plt
# Load and clean data
file_path = "MBA Starting [Link]"
df = pd.read_excel(file_path, sheet_name="Salaries")
df = df[~df[["salary", "satis"]].isin([999, 998]).any(axis=1)]
# Correlation analysis
salary_correlation = [Link]()["salary"].sort_values(ascending=False)
# Visualization: Boxplot of salary by gender
[Link](figsize=(8, 5))
[Link](x=df["sex"], y=df["salary"])
[Link]("Gender (1=Male, 2=Female)")
[Link]("Salary")
[Link]("Salary Distribution by Gender")
[Link]()
# Display correlation results
salary_correlation

2
Output:

The correlation analysis reveals that most academic and experience-related factors do not
strongly influence starting salaries.
• No significant correlation exists between GMAT scores, GPA, work experience, and
salary, indicating that higher academic performance or prior experience does not
necessarily lead to higher pay.
• A weak but significant positive correlation is found between satisfaction and salary,
suggesting that students who earn higher salaries may feel more satisfied with the MBA
program.
• Work experience has a weak positive correlation with Spring GPA but a weak negative
correlation with GMAT scores, possibly indicating that students with more experience
scored slightly lower on GMAT but performed slightly better academically during the
program.
• GPA (Spring & Fall) shows a strong positive correlation, meaning students who perform
well in one semester tend to maintain their performance.

3
Q3. Is there any correlations exists between the variables (e.g., GMAT Total Score,
Salary, Spring Grades, Years of Work Experience, Satisfaction with
program)?
Code:
import pandas as pd
import seaborn as sns
import [Link] as plt
import [Link] as st
# Load and clean data
df = pd.read_excel("MBA Starting [Link]", sheet_name="Salaries").dropna()
df = df[~[Link]([999, 998]).any(axis=1)]
#All the correlation and p-values
corr_vars = [
('gmat_tot', 'satis'),
('salary', 'work_yrs'),
('s_avg', 'salary'),
('f_avg', 'salary'),
('gmat_tot', 'salary'),
('satis', 'salary'),
('work_yrs', 's_avg'),
('gmat_tot', 'work_yrs'),
('s_avg', 'f_avg'),
('satis', 'work_yrs')
]
for var1, var2 in corr_vars:
corr, p_val = [Link](df[var1], df[var2])
print(f"Correlation between {var1} and {var2}: r = {corr:.2f}, p-value = {p_val:.4f}")
# Correlation and visualization
[Link](df[["gmat_tot", "salary", "s_avg", "work_yrs", "satis"]].corr(), annot=True,
cmap="coolwarm", fmt=".2f")
[Link]()

4
Output:

• Satisfaction & Salary: A weak but significant positive correlation (r = 0.1564, p =


0.0298).
• Work Experience & Spring GPA: Weak positive correlation (r = 0.1591, p = 0.0270).
• GMAT & Work Experience: Weak negative correlation (r = -0.1737, p = 0.0157).
• No relationship between GMAT Score & Salary or GPA & Salary.

Overall, the findings suggest that academic performance and work experience have minimal
impact on starting salaries.

5
Q4. Can starting salaries be Predicted Based on Graduating Data (i.e., GPA,
gender, work experience)?
Code:
import pandas as pd
import [Link] as sm
# Load and clean data
df = pd.read_excel("MBA Starting [Link]" , sheet_name="Salaries").dropna()
df = df[~[Link]([999, 998]).any(axis=1)]
#Building regression model
x=df[["s_avg", "sex", "work_yrs"]]
x=sm.add_constant(x)
print(x)
y=df[["salary"]]
print(y)
model=[Link](y,x).fit()
print([Link]())

Output:

6
The regression model aimed to predict starting salary based on GPA (Spring), gender, and
work experience, but the results indicate poor predictive power.
• Adjusted R² = -0.0014 → The model performs worse than a baseline model (mean
salary prediction) and explains virtually 0% of salary variation.
• P-values for GPA, gender, and work experience are all > 0.05, meaning none of these
factors have a statistically significant impact on salary.
• Negative Adjusted R² suggests that including these variables adds no real explanatory
power and may even introduce unnecessary complexity.
Conclusion
The regression analysis confirms that GPA, gender, and work experience do not significantly
predict starting salaries. The negative Adjusted R² suggests that salary variations are likely
driven by other external factors, such as industry trends, negotiation skills, job location, or
personal networking.
This aligns with the correlation analysis, reinforcing that traditional academic and experience
metrics are poor indicators of salary outcomes.

Common questions

Powered by AI

The weak positive correlation between satisfaction and salary (r = 0.1564) suggests that higher salaries might contribute to greater satisfaction with the program . This relationship could imply that financial rewards enhance perceived program value or just personal contentment with career outcomes. However, the weak correlation also underscores that satisfaction is likely influenced by other factors beyond salary, such as personal growth, learning experience, and networking opportunities. Therefore, while salary contributes to some extent to satisfaction, a holistic view should be taken to understand what drives satisfaction among graduates .

The weak negative correlation between work experience and GMAT scores (r = -0.1737) suggests that students with more workplace experience tend to have slightly lower scores on the GMAT . This might be due to experienced individuals focusing less on test preparation due to time constraints or prioritizing practical experience over standardized testing skills. It may also indicate that professionals might rely on their experience to compensate for lower GMAT scores during MBA applications . Such a trend reflects a trade-off between work experience and standardized test preparation.

The correlation analysis reveals a weak positive correlation between work experience and Spring GPA (r = 0.1591) and a weak negative correlation between work experience and GMAT scores (r = -0.1737). This suggests that individuals with more work experience might perform slightly better academically during their program, indicated by the positive correlation with Spring GPA. On the other hand, the negative correlation with GMAT scores implies that experienced students possibly score lower on standardized tests but might leverage their experience for better academic performance later in the program. This infers a nuanced view of how prior professional experience affects educational outcomes .

Using linear regression in this context has limitations, as indicated by the poor predictive power of the model. The key limitations include an Adjusted R² of -0.0014, signaling that the model explains virtually none of the variance in salary . Additionally, p-values for GPA, gender, and work experience are all greater than 0.05, showing that these variables do not have a statistically significant impact on salary. This suggests that linear regression with these predictors may introduce unnecessary complexity without meaningful insight, likely due to the omission of other influential factors such as industry trends, negotiation skills, job location, or networking .

The data cleaning process involves excluding rows where selected numerical columns contain the values 999 or 998 . This exclusion is critical as these values likely represent placeholders for errors or missing data, which could skew the analysis if not removed. By ensuring only valid data points are included, the analysis can be more accurately interpreted without the distortion from erroneous entries .

The explored regression model does not directly address multicollinearity, but signs of its absence can be inferred from the poor predictive power and insignificant p-values associated with the predictors (GPA, gender, and work experience). Multicollinearity often affects the model's ability to assign appropriate significance to predictors, but in this case, the Adjusted R² is negative, suggesting that none of the variables contribute meaningfully to the explanation of salary variance in isolation or in combination. A further investigation using statistical diagnostics like the Variance Inflation Factor (VIF) would be necessary to conclusively identify multicollinearity .

The findings suggest that GPA, gender, and work experience might not predict starting salaries significantly due to various external factors that play a more dominant role. The regression model highlights an Adjusted R² of -0.0014 and non-significant p-values for these variables , indicating poor predictive value. This could be because salary outcomes are more influenced by market conditions, demand in specific industries, negotiation skills, and networking capabilities rather than just academic or demographic backgrounds. The unseen variables likely mask the impact of traditional metrics, highlighting a disconnect between academic performance and actual financial outcomes in the job market .

The exclusion technique improves the robustness of data analysis by removing rows with placeholder or erroneous values (999, 998) that don't represent real data. By eliminating these anomalies, the dataset becomes cleaner, and analyses such as correlation or regression are more reliable, as they are not impacted by outliers or incorrect entries that could distort results . This cleaning ensures that conclusions drawn are based on accurate reflections of the data, thereby enhancing the reliability of any insights related to salary expectations .

The absence of a significant correlation between academic metrics like GMAT and GPA with salary suggests that traditional assumptions in MBA education—such as the belief that higher academic scores directly result in higher pay—may not hold true . This revelation indicates that salary is likely influenced by other factors outside academia, undermining the predictive power of such metrics. This challenges educators to reconsider the weight placed on standardized testing and grades when defining what prepares students effectively for the workforce, acknowledging that skills like networking, personal initiatives, and industry-specific knowledge may play more pivotal roles .

The correlation analysis challenges the traditional assumptions by showing that academic metrics like GMAT scores, GPA, and work experience have minimal impact on starting salaries . Notably, there is no significant correlation between GMAT scores or GPA with salary, which contradicts the expectation that higher academic achievements lead to better pay. Furthermore, while there is a weak positive correlation between satisfaction and salary, it suggests satisfaction is somewhat influenced by salary levels . This indicates that other non-academic factors might be more critical for salary outcomes.

You might also like