1. Descriptive StatisticsAnalyze attitudes toward eCommerce adoption by calculating key…

1. Descriptive StatisticsAnalyze attitudes toward eCommerce adoption by calculating key statistics:
Central Tendency (Mean, Median, Mode)
Investment in online distribution (INT1–4)
eCommerce platform satisfaction (CMS1–3)
Third-party marketplace perception (TPMP1–3)
Confidence in internal skills (COM1–4)
Variability (Standard Deviation, Range)
Do responses within each category show high agreement or variation?
Categorical Breakdown:
Company size, industry, and work territory distributions
Age group and seniority breakdown
2. Correlation Analysis
Use Excel’s built-in correlation function to examine relationships between key variables. Interpret correlations using the following scale:
Corelation Coefficient Relationship Strength
0.00 – 0.20 Weak or No Relationship
0.21 – 0.40 Weak Relationship
0.41 – 0.60 Moderate Relationship
0.61 – 0.80 Strong Relationship
0.81 – 1.00 Very Strong Relationship
Analyze the following relationships and create scatterplots with trendlines to visualize key correlations.
Investment in online distribution (INT1–4) vs. eCommerce platform satisfaction (CMS1–3)
Investment in online distribution (INT1–4) vs. third-party platform perception (TPMP1–3)
Confidence in internal skills (COM1–4) vs. investment, CMS, and TPMP scores
3. Demographic Comparisons
Use Pivot Tables to group responses by age and gender, and analyze:
Average scores for INT1–4, CMS1–3, and TPMP1–3
Variations in digital adoption attitudes across age groups and gender
Bar charts to compare attitudes across different groups
4. Visualizing Key Insights
Use Excel charts to present findings:
Bar Chart: Compare attitudes by industry, company size, or seniority level
Scatter Plot: Show relationships between investment in online distribution and eCommerce satisfaction
Box Plot or Histogram: Analyze variations in confidence in internal digital capabilities
5. Strategic Recommendations
Based on your findings, provide three strategic recommendations for improving digital adoption in manufacturing.
How should manufacturing firms approach eCommerce investment?
What role do internal digital skills play in eCommerce adoption?
Should companies focus more on third-party platforms or their own eCommerce platforms?