Survey data analysis pattern in Data Analysis Python - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ data_output

intermediate

Calculate the average satisfaction score by gender

You have a survey dataset with columns Gender and Satisfaction (scale 1-5). What is the average satisfaction score for each gender?

Data Analysis Python

import pandas as pd

data = pd.DataFrame({
    'Gender': ['Male', 'Female', 'Female', 'Male', 'Female'],
    'Satisfaction': [4, 5, 3, 2, 4]
})

result = data.groupby('Gender')['Satisfaction'].mean()

A {'Female': 4.0, 'Male': 3.0}

B {'Female': 4.0, 'Male': 3.5}

C {'Female': 4.0, 'Male': 2.0}

D {'Female': 4.5, 'Male': 3.0}

💡 Hint

Use groupby on Gender and then calculate the mean of Satisfaction.

The average satisfaction for females is (5 + 3 + 4) / 3 = 4.0, and for males is (4 + 2) / 2 = 3.0.

🧠 Conceptual

intermediate

Identify the correct interpretation of a Likert scale distribution

A survey question uses a 5-point Likert scale (1=Strongly Disagree to 5=Strongly Agree). The distribution of responses is skewed towards 5. What does this indicate?

A Responses are evenly spread across all options.

B Most respondents strongly disagree with the statement.

C Most respondents strongly agree with the statement.

D Most respondents chose the neutral option.

💡 Hint

Think about what a skew towards 5 means on a 1 to 5 scale.

A skew towards 5 means many respondents selected the highest agreement level, indicating strong agreement.

🔧 Debug

advanced

Fix the error in filtering survey data by age group

The code below tries to filter respondents aged 30 or older but raises an error. Identify the cause.

Data Analysis Python

import pandas as pd

data = pd.DataFrame({'Age': [25, 30, 35, 40]})

filtered = data[data['Age'] >= 30]

A SyntaxError due to incorrect bracket placement in the filter condition.

B KeyError because 'Age' column does not exist.

C TypeError because comparison is done between string and int.

D No error; code runs correctly.

💡 Hint

Check how the condition inside the brackets is written.

The condition data['Age' >= 30] is invalid because the comparison is done inside the brackets incorrectly. It should be data['Age'] >= 30.

❓ visualization

advanced

Choose the correct plot to show satisfaction distribution by department

You want to visualize how satisfaction scores vary across different departments in a survey. Which plot type is best?

A Scatter plot of satisfaction vs. age for all respondents.

B Line plot connecting average satisfaction scores over time.

C Pie chart showing percentage of respondents per department.

D Box plot showing satisfaction score distribution per department.

💡 Hint

Think about showing distribution and comparison across categories.

A box plot effectively shows the spread and central tendency of satisfaction scores for each department, making it ideal for this purpose.

🚀 Application

expert

Calculate the response rate from survey data

You have a dataset with 1000 invited participants. The survey data contains 750 rows of responses. How do you calculate the response rate?

A Response rate = 750 - 1000 = -250

B Response rate = (750 / 1000) * 100 = 75%

C Response rate = (1000 / 750) * 100 = 133.33%

D Response rate = 1000 + 750 = 1750

💡 Hint

Response rate is the percentage of invited participants who responded.

Response rate is calculated by dividing the number of responses by the number invited, then multiplying by 100 to get a percentage.