B341 HR Analytics and Technology Assignment, Singapore

Objective 1: Correlation Between Product Knowledge, Region, and Sales Performance

1. Steps to Follow:
   • Data Cleaning and Organization:
     • Organize the dataset into columns for region (Singapore or Vietnam), product knowledge scores, and sales performance metrics.
   • Statistical Test Selection:
     • Use Pearson Correlation Coefficient to measure the linear relationship between product knowledge and sales performance for each region.
   • Hypothesis Testing:
     • Null Hypothesis (H0H_0H0​): Product knowledge has no significant effect on sales performance.
     • Alternative Hypothesis (HaH_aHa​): Product knowledge significantly affects sales performance.
   • Tools:
     • Perform the calculations in Excel or Python to calculate the correlation coefficient ($r$) and p-value for significance testing.
   • Visualization in Tableau:
     • Use scatter plots to visualize the relationship between product knowledge and sales performance.
     • Include filters for region-specific views.
2. Output:
   • Correlation coefficients and p-values for Singapore and Vietnam regions.
   • Insights into whether product knowledge affects sales performance differently in the two regions.

Objective 2: Evaluate the MBTI Personality and Sales Success Hypothesis

1. Steps to Follow:
   • Group Data by MBTI Personality Type:
     • Segment sales consultants by their MBTI types and analyze their sales performance.
   • Statistical Test Selection:
     • Use ANOVA (Analysis of Variance) to test if there is a statistically significant difference in sales performance across the different MBTI types.
   • Hypothesis Testing:
     • Null Hypothesis (H0H_0H0​): There is no significant difference in sales performance among MBTI types.
     • Alternative Hypothesis (HaH_aHa​): Sales performance significantly varies by MBTI type.
   • Tools:
     • Perform ANOVA in Excel or Python to compute the F-statistic and p-value.
   • Visualization in Tableau:
     • Create bar charts comparing average sales performance across MBTI types.
2. Output:
   • Results of the ANOVA test (F-statistic and p-value).
   • Recommendations based on findings, including whether restricting hiring to ESTP, ESFJ, and ENTJ is justified.

Objective 3: Formulate a Promotion List Using Statistical Analysis

1. Steps to Follow:
   • Filter Dataset:
     • Extract consultants who have exceeded annual sales performance for the past three years.
   • Statistical Test Selection:
     • Use ranking methods to identify top performers based on aggregated sales data.
   • Visualization in Tableau:
     • Create a table or leaderboard showcasing the top 5 performers.
   • Additional Analysis:
     • Assess other factors (e.g., tenure, region) that might influence the promotion list.
2. Output:
   • Finalized list of top 5 consultants for promotion.
   • Tableau visualizations to justify the selection process.

General Assignment Guidelines

• Structure and Presentation (Format Marks):
  • Ensure slides are visually appealing and free from typographical errors.
  • Use consistent formatting, with clear section headers and bullet points.
  • Include graphs, tables, and other visual aids for clarity.
• Individual Reflection (Reflection Marks):
  • Reflect on the methodology used, challenges faced, and learnings.
  • Provide insights into the decision-making process and how the analysis supports PFP’s goals.
• Submission:
  • Zip the following:
    • PowerPoint presentation (with notes).
    • Excel sheet with data and statistical calculations.
    • Tableau project file.