Note : Use excel for the calculations while providing a detailed explanation of each step for clarity

A multinational company wants to assess the impact of its recent marketing campaign on sales across different regions. They have collected sales data before and after campaign launch. The dataset includes sales figures from various regions over a specific period.

Given the following dataset, perform the following task:

Region	Sales Before Campaign	Sales After Campaign	Campaign Expenditure
Region A	500	700	1000
Region B	800	1000	1500
Region C	600	750	1200
Region D	400	600	900
Region E	700	900	1300

Data Exploration (10 Points):

1. Describe the dataset's key features, including the variables and their types.
2. Present summary statistics and visualizations to provide an initial understanding of the data.

Hypothesis Testing ( 10 Points):

1. Formulate a null and alternative hypothesis regarding the campaign's effect on sales.
2. Choose an appropriate statistical test to analyze the hypothesis.
3. Perform the test and interpret the results.

Regression Analysis ( 10 Points ):

1. Choose an appropriate regression model to predict sales based on relevant factors ( e.g., campaign expenditure, regions, etc. ).
2. Interpret the coefficients and significance of variables in the model.
3. Assess the model's goodness of fit and discuss its predictive capability.

Segmentation and comparison ( 10 Points ):

1. Segment the data based on regions or any other relevant factor.
2. Conduct comparative analysis among different segments using suitable statistical techniques.
3. Interpret the variations observed among segments and draw meaningful conclusions.

Conclusion and recommendations ( 10 Points ):

1. Summarize the key findings from the analysis conducted.
2. Provide actionable recommendations to the company based on the results obtained.