BizMetrics is a consulting firm that provides data analysis and business intelligence services to various industries. Recently, BizMetrics has collected detailed data on 200 businesses, including information on business characteristics, financial metrics, and customer satisfaction ratings. The dataset contains variables such as:
Business ID
Business Name
Industry
Number of Employees
Annual Revenue
Profit Margin
Market Share (%)
Business Age
Customer Satisfaction
Region
BizMetrics’ management is keen to analyze this data to understand the profile of its business clients better, assess the effectiveness of different business strategies, and improve overall customer satisfaction.

Specifically, they want to explore the distribution of business metrics across different industries, identify trends in financial performance, and evaluate customer satisfaction levels. They are also interested in identifying potential outliers that might represent unique opportunities or risks.
The goal of this analysis is to provide BizMetrics with actionable insights that can guide strategic decisions, enhance service offerings, and improve client satisfaction. The findings will also help the company in segmenting its clients more effectively and tailoring its consulting and advisory strategies. Through this analysis, BizMetrics hopes to reinforce its position as a data-driven, customer-centric organization.
Tasks/Assignments

Understanding Data Attributes

Identify whether each of the following variables is quantitative or qualitative.
For each of the following variables, identify the scale of measurement used (Nominal, Ordinal, Interval, or Ratio) and provide a brief explanation.
Industry
Number of Employees
Annual Revenue
Profit Margin
Market Share (%)
Business Age
Customer Satisfaction
Region
Summary Statistics Using Excel’s Data Analysis Toolpak
Using the Data Analysis Toolpak, calculate the following summary statistics for the “Annual Revenue” variable:
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Interpretation: Interpret the calculated statistics. What does the mean tell you about the Annual Revenue? How does the standard deviation inform you about the variability in revenue? Discuss the implications of the skewness and kurtosis values.
Calculating Percentiles

Using Excel’s PERCENTILE.EXC function, calculate the 25th, 50th (Median), and 75th percentiles for the “Profit Margin” variable.
Interpret the results and explain what each percentile indicates about the distribution of profit margins among the businesses.

Last Completed Projects