Statistics Assignment

Use the dataset attached and answer the questions below

Descriptive Statistics:

What is the average weekly sales for all Walmart stores in the dataset?

What is the distribution of weekly sales across different departments in Walmart?

Trend Analysis:

How have weekly sales trended over the years for Walmart as a whole?

Is there a seasonal trend in sales within specific departments or regions?

Correlation Analysis:

Is there a correlation between weekly sales and specific external factors like unemployment rates or fuel prices?

How does the temperature or weather condition correlate with sales?

Store Performance Analysis:

Which Walmart store has the highest and lowest average weekly sales?

Can we identify specific stores that perform exceptionally well during holiday seasons?

Departmental Analysis:

Which department generates the highest sales on average? Are there any seasonal trends within departments?

Do specific departments show a strong correlation between sales and promotional events or holidays?

Customer Behavior Analysis:

Is there a difference in sales between regular weeks and weeks with promotional events or holidays?

Can we identify any shopping patterns or trends based on day$-$of$-$week sales?

Forecasting:

Using historical sales data, can we forecast the sales for the upcoming quarter or year for selected stores or departments?

How accurate are the sales forecasts based on different forecasting models $($e$.$g$.,$ ARIMA, Prophet$)?$

Inventory Management:

Is there a relationship between inventory levels and weekly sales? How does inventory turnover vary across stores and departments?

Regional Analysis:

Are there geographical differences in sales patterns among Walmart stores in different regions?

How do economic factors like GDP or population growth relate to sales in different regions?

Promotional Strategy Evaluation:

What is the effectiveness of specific promotional strategies or events in driving sales? Can we quantify the impact of promotions?