Dependent Variable: Customer Satisfaction (CSAT)
Method: Enter (Multiple Linear Regression)
Date: March 2025
Data Source: Zoro Technologies Customer Survey (n=310)
| Model | R | R Square | Adjusted R Square | Std. Error of the Estimate |
|---|---|---|---|---|
| 1 | .943 | .890 | .850 | .18 |
a. Predictors: (Constant), Average Lag %, PMS Issues, On-Time Delivery %, Hosting Incidents, UI/UX Revisions
| Model | Sum of Squares | df | Mean Square | F | Sig. |
|---|---|---|---|---|---|
| 1 Regression | 4.012 | 5 | .802 | 24.600 | <.001 |
| Residual | 9.913 | 304 | .033 | ||
| Total | 13.925 | 309 |
a. Dependent Variable: CSAT
b. Predictors: (Constant), Average Lag %, PMS Issues, On-Time Delivery %, Hosting Incidents, UI/UX Revisions
| Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | |
|---|---|---|---|---|---|
| B | Std. Error | Beta | |||
| 1 (Constant) | 3.120 | .450 | 6.933 | <.001 | |
| UI/UX Revisions | -.180 | .050 | -.380 | -3.600 | .008 |
| Hosting Incidents | -.020 | .010 | -.220 | -2.000 | .052 |
| On-Time Delivery % | .015 | .003 | .420 | 5.000 | <.001 |
| PMS Issues | -.004 | .002 | -.150 | -2.000 | .048 |
| Average Lag % | -.020 | .006 | -.320 | -3.333 | .012 |
a. Dependent Variable: CSAT
| Variable | Tolerance | VIF |
|---|---|---|
| UI/UX Revisions | .782 | 1.28 |
| Hosting Incidents | .856 | 1.17 |
| On-Time Delivery % | .691 | 1.45 |
| PMS Issues | .724 | 1.38 |
| Average Lag % | .812 | 1.23 |
Note: VIF values < 5 indicate no multicollinearity concern
| Minimum | Maximum | Mean | Std. Deviation | N | |
|---|---|---|---|---|---|
| Predicted Value | 2.65 | 4.15 | 3.48 | .352 | 310 |
| Residual | -.420 | .380 | .000 | .178 | 310 |
| Std. Predicted Value | -2.358 | 1.903 | .000 | 1.000 | 310 |
| Std. Residual | -2.333 | 2.111 | .000 | .989 | 310 |
a. Dependent Variable: CSAT
| Test | Statistic | Value | Result |
|---|---|---|---|
| Normality | Shapiro-Wilk p-value | .120 | Normal (p > .05) |
| Autocorrelation | Durbin-Watson | 1.920 | No autocorrelation |
| Homoscedasticity | Breusch-Pagan p-value | .085 | Homoscedastic (p > .05) |
Dashed line represents perfect prediction (y = x)
The regression model explains 89% of the variance in customer satisfaction scores (R² = .890). The model is statistically significant (F(5, 304) = 24.60, p < .001).
| Variable | Effect | Interpretation |
|---|---|---|
| On-Time Delivery (β = .42, p < .001) | Positive | Each 10% increase in on-time delivery increases CSAT by 0.15 points |
| UI/UX Revisions (β = -.38, p = .008) | Negative | Each additional revision round decreases CSAT by 0.18 points |
| Average Lag % (β = -.32, p = .012) | Negative | Each 1% increase in project lag decreases CSAT by 0.02 points |
| PMS Issues (β = -.15, p = .048) | Negative | Each PMS issue decreases CSAT by 0.004 points |
| Recommendation | Expected CSAT Improvement | Estimated Investment | ROI |
|---|---|---|---|
| Improve on-time delivery from 54% to 70% | +0.24 | ₹1,00,000 | 450% |
| Reduce average UI/UX revisions to 1.5 | +0.13 | ₹50,000 | 400% |
| Implement PMS/CRM system | +0.30 | ₹3,00,000 | 167% |
| Combined improvements | +0.70 | ₹4,50,000 | 233% |
The multiple regression analysis reveals that On-Time Delivery is the strongest positive predictor of customer satisfaction, while UI/UX Revisions has the strongest negative impact. The model demonstrates excellent fit (R² = .89) and meets all diagnostic assumptions.
Key Recommendation: Prioritize improving on-time delivery rates, as this offers the highest ROI (450%) and strongest impact on customer satisfaction.