You are given a dataset of monthly sales revenues for a retail business over the past two years. Using Excel, create a histogram to visualize the distribution of sales revenues. Ensure to use the “

QUESTION 1: HISTOGRAM CREATION AND ANALYSIS IN EXCEL
You are given a dataset of monthly sales revenues for a retail business over the past two years.

1. Using Excel, create a histogram to visualize the distribution of sales revenues. Ensure to use the “Data Analysis” toolpack.
2. Interpret the histogram, commenting on the skewness of the data and what this could imply for future sales forecasting.
3. Based on your analysis, explain whether the business is experiencing consistent sales performance or if there are fluctuations that may need attention.

QUESTION 2: LINEAR REGRESSION ANALYSIS IN EXCEL

You have data on housing prices, including features such as square footage, number of bedrooms, and age of the house.

1. Using Excel, create a linear regression model to predict housing prices based on square footage.
2. Analyze the regression output: Interpret the R-squared value, the significance of the coefficients, and the overall model fit.
3. Discuss the limitations of your model, such as assumptions about linearity, and suggest ways to improve it.

QUESTION 3: HISTOGRAM COMPARISON

You are tasked with comparing the risk profiles of two investment portfolios over the past year.

1. Using Excel, create histograms for the returns of each portfolio.
2. Compare the histograms in terms of their skewness, spread, and shape. Discuss how these differences may affect a potential investor’s decision.
3. Based on your interpretation, suggest which portfolio would be better suited for a risk-averse investor.

QUESTION 4: DATA MINING IN RAPIDMINER
You are provided with a dataset containing customer demographics and purchasing behavior.

1. Using RapidMiner, build a basic decision tree model to classify customers as high or low spenders based on their demographic features.
2. Interpret the results of the decision tree, including the key variables influencing the classification.
3. Discuss how businesses can use this model to tailor marketing strategies or product offerings to specific customer groups.

QUESTION 5: DATA-DRIVEN STORYTELLING

You are preparing a presentation for senior management on the impact of recent marketing campaigns.

1. Create a series of charts and visualizations in Excel to summarize the results of these campaigns (e.g., sales growth, customer acquisition).
2. Based on your visualizations, write a brief narrative to effectively communicate the business impact of the marketing campaigns. Be sure to highlight key insights that will guide future marketing decisions.
3. Discuss how the choice of visuals (e.g., bar charts vs. line graphs) influences the clarity and effectiveness of the message.