Unit 3 Assignment Directions: Dataset Assignment

399582. 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
Many manufacturing firms are navigating challenges in adopting eCommerce strategies. Your analysis should address::

How do manages perceive online distribution channels?
What are the key concerns regarding third-party platforms (e.g., Amazon, Alibaba)?
Does confidence in internal digital skills influence investment in eCommerce?
Your findings will help your consulting firm develop data-driven strategies for improving digital adoption in manufacturing.
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?
Your recommendations should be supported by insights from descriptive statistics and correlation analysis.

Submission

Submit a 3–4 page analysis in Microsoft Word (excluding cover page, reference list, tables, graphs, and appendices).
Write from the perspective of a data analyst, providing actionable insights for business decision-makers.
Ensure originality, demonstrating your ability to interpret data and develop strategic recommendations.
Use proper APA citations for any industry reports, academic research, or business frameworks referenced.
Formatting: 12-point Times New Roman or 11-point Arial, 1-inch margins, and double-spacing.
Include tables and graphs, properly labeled in APA format.