Scribd
Upload
32 views2 pages

Sales Data Analysis

The document analyzes sales data across different regions and products using a matrix representation. It includes descriptive statistics for each product, revenue calculations through matrix multiplication, and insights on the mean and coefficient of variation. Additionally, it discusses the real-world applications of matrix multiplication in data science and analytics.

Uploaded by

mayakamauya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
32 views2 pages

Sales Data Analysis

The document analyzes sales data across different regions and products using a matrix representation. It includes descriptive statistics for each product, revenue calculations through matrix multiplication, and insights on the mean and coefficient of variation. Additionally, it discusses the real-world applications of matrix multiplication in data science and analytics.

Uploaded by

mayakamauya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Sales Data Analysis

Part 1: Understanding the Data

Dataset (Matrix D)
Each row represents a region and each column represents a product (A, B, C).

D=
[ 4 8 12 ]
[ 6 10 15 ]
[5 7 9]
[3 6 9]

Data Types
The matrix elements represent quantitative ratio data (e.g., sales counts). They are numeric,
countable, and have a true zero (no sales).

Descriptive Statistics
Product Mean Median Std Dev Range Variance

A 4.5 4.5 1.12 3 1.25

B 7.75 7.5 1.71 4 2.92

C 11.25 10.5 2.5 6 6.25

Part 2: Linear Algebra

Matrix Transpose
Dᵗ =
[4 6 5 3]
[ 8 10 7 6 ]
[12 15 9 9 ]

Revenue Calculation (Matrix Multiplication)


Price vector P = [5 10 15]
Revenue per region = D × Pᵗ:

 Region 1: 280
 Region 2: 355
 Region 3: 230
 Region 4: 210

Highest Revenue & Product Revenue


Highest Revenue: Region 2 (355)

Total revenue per product:

 Product A: 90
 Product B: 310
 Product C: 675

Part 3: Conceptual Questions

Mean Interpretation
The mean indicates the typical sales of each product across all regions. Product C has the
highest mean (11.25), suggesting it is the top-selling product.

Coefficient of Variation
Product Mean Std Dev CV

A 4.5 1.12 0.25

B 7.75 1.71 0.22

C 11.25 2.5 0.22

Real-world Use of Matrix Multiplication


Matrix multiplication is widely used in data science and analytics. Examples include:
- Revenue calculations (sales × price)
- Recommendation systems (users × preferences)
- Image processing (filters × pixel matrices)
- Feature transformations in ML (PCA, normalization)

You might also like