This assignment will provide you with an opportunity to practice essential data analysis skills by working with data in Excel to summarize different variable types and to evaluate potential relationships among them. This week, you will practice data$-$driven decision$-$making with a real$-$world example, applying descriptive analytics to scrutinize statistics and generate insights. This method of data examination allows you to answer critical questions. As a result, you will create a narrative enhanced by traditional business intelligence $($BI$)$ and visualizations $($graphs and$/$or charts$),$ ultimately organizing the data to present a business problem in an understandable manner for all stakeholders.

Task

You are a data analyst at a consulting firm that specializes in eCommerce solutions for manufacturing companies. Recently, you conducted a survey to understand the attitudes of middle managers in manufacturing firms towards online distribution channels and third$-$party digital platforms. Respondents were selected based on specific criteria:$$

They must be employed in a manufacturing company,

Hold a managerial position $($at least at the middle management level$),$

Supervise at least two subordinates,$$

and be fluent in English.$$

To ensure relevance, all respondents confirmed that their companies market products through online distribution channels.

For this assignment, you will complete the following tasks based on the survey conducted on manufacturers$$ eCommerce practices using the Week $4$ Problem Set. Your task includes:

Purpose. Explain the business problem and summarize the variables utilizing descriptive statistics.$$

Results and Relationship Identification. Utilizing Excel and statistical methods, analyze and identify relationships among the following variables:$$

Age, gender, and attitudes towards investing in online distribution channels $($INT$14)$Attitudes towards the eCommerce platform $($CMS $13)$Attitudes towards third$-$party digital platforms $($TPMP $13)$ and internal skill sets $($COM$14)$

Recommendations. Based on your analysis, provide actionable recommendations for improving the company's online distribution strategy and digital platform engagement.

Submission

Your completed analysis should be an original work consisting of $3-4$ pages in Microsoft Word, excluding the cover page, reference list, tables, graphs, and appendices.

The document should adhere to the following APA formatting requirements: $12-$point Times New Roman or $11-$point Arial, $1-$inch margins, and double$-$spacing.

Data visualization $($tables$/$graphs$)$ included with proper labeling of numbers, statistics and labeling figures in APA format.