(NAAC “A” Grade Accredited, NBA Accreditation from 1/01/2026 to 31/12/2028)
1. Course, Subject & Experiment Details
Name of the
Swaroop Shingre Roll No. 10990
student
Estimated
Course & Branch F.E. (ECS) -
Time
Current Semester Semester -I Subject Name ECSE
Data analysis using
Chapter No. & Unit 6 Chapter Title
spreadsheet
Software
Experiment Type Subject Code PCC11CS02
Performance
2. Aim & Objective of Experiment
1. To Perform data analysis using spreadsheet.
3. Expected Outcome of Experiment
1. To understand basic different functions for data analysis using spreadsheet
4. Brief Description of the experiment
Activity 1: Download [Link]
1. Calculate the average, median, minimum, and maximum Salary and Years of
Experience for all employees.
2. Calculate the standard deviation for Salary.
3. Use a pivot table to display the average Salary and Years of Experience by
Department.
4. Count the number of employees in each Department.
5. Identify and use a function to count how many employees are older than 30.
6. Identify and use a function to calculate the total salary of employees with more than 5
years of experience.
Activity 2: Download product_sales.xls
1. Create a bar chart to compare the total sales of different product categories.
2. Create a line chart to show sales trends over time (using the Date and Sales columns).
3. Create a pie chart showing the proportion of total sales for each product category.
4. Create a histogram showing the distribution of Quantity Sold.
5. Create a scatter plot showing the relationship between Sales and Profit. Add a trendline
to show the correlation.
6. Write observations
(NAAC “A” Grade Accredited, NBA Accreditation from 1/01/2026 to 31/12/2028)
Results(Activity 1):
1.
3.
(NAAC “A” Grade Accredited, NBA Accreditation from 1/01/2026 to 31/12/2028)
4.
5.
6.
Results(Activity 2):
1.
2.
(NAAC “A” Grade Accredited, NBA Accreditation from 1/01/2026 to 31/12/2028)
3.
4.
5.
(NAAC “A” Grade Accredited, NBA Accreditation from 1/01/2026 to 31/12/2028)
6. Observations (Product Sales Data)
1. Total Sales by Product Category(Bar Chart):
The bar chart show that different product categories contribute unequally to total
sales. Some categories have significantly higher total sales, indicating stronger demand
or better performance compared to others.
2. Sales Trend Over Time(Line Chart):
The line chart indicates that sales vary over time. There are noticeable periods of
increase and decrease, which may be due to seasonal demand, promotions, or market
conditions.
3. Sales Distribution by Product Category(Pie Chart):
The pie chart clearly represents the proportion of total sales contributed by each
product category. A few categories dominate overall sales, while oters contribute a
smaller share.
4. Distribution of Quantity Sold(Histogram):
The histogram shows how the quantity sold is distributed across different ranges Most
sales fall within a certain quantity range, while very hight or very low quantities occur
less frequently.
5. Relationship Between Sales and Profit(Scatter Plot):
The scatter plot shows a positive relationship between sales and profit. As sales
increase, profit generally increases as well. The trend line confirms a positive
correlation between sales and profit.