$1.$ Descriptive Statistics

Analyze attitudes toward eCommerce adoption by calculating key statistics:

Central Tendency $($Mean$,$ Median, Mode$)$

Investment in online distribution $($INT$14)$eCommerce platform satisfaction $($CMS$13)$Third$-$party marketplace perception $($TPMP$13)$Confidence in internal skills $($COM$14)$

Variability $($Standard Deviation, Range$)$

Do responses within each category show high agreement or variation?

Categorical Breakdown

Company size, industry, and work territory distributionsAge 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\mathrm{.}00-0\mathrm{.}20$Weak or No Relationship$0\mathrm{.}21-0\mathrm{.}40$Weak Relationship$0\mathrm{.}41-0\mathrm{.}60$Moderate Relationship$0\mathrm{.}61-0\mathrm{.}80$Strong Relationship$0\mathrm{.}81-1\mathrm{.}00$Very Strong Relationship

$$

Analyze the following relationships and create scatterplots with trendlines to visualize key correlations.

Investment in online distribution $($INT$14)$ vs$.$ eCommerce platform satisfaction $($CMS$13)$

Investment in online distribution $($INT$14)$ vs$.$ third$-$party platform perception $($TPMP$13)$

Confidence in internal skills $($COM$14)$ vs$.$ investment, CMS$,$ and TPMP scores

$3.$ Demographic Comparisons

Use Pivot Tables to group responses by age and gender, and analyze:

Average scores for INT$14,$ CMS$13,$ and TPMP$13$

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?