Graphical Representation of Statistical Data using MS Excel – B.Sc. Practical

 

Graphical Representation of Statistical Data using MS Excel – B.Sc. Practical

 Aim of the Experiment

To represent statistical data graphically using Microsoft Excel for better visualization and interpretation.

Principle

Graphical representation converts numerical data into visual formats such as bar charts, line graphs, and pie charts. This makes patterns, trends, and comparisons easier to understand.

Common Graph Types:

• Bar Chart → Comparison
• Line Graph → Trends over time
• Pie Chart → Proportion/percentage

 Requirements

• Computer/Laptop
• Software: Microsoft Excel
• Sample statistical data

 Step-by-Step Procedure

Part A: Entering Data

Step 1: Open Excel

• Launch Microsoft Excel

Step 2: Create Data Table

• Enter data in rows and columns

 Example:

Sample	Value
A	10
B	20
C	15
D	25

Part B: Creating Graph

Step 3: Select Data

• Highlight the entire data table (including headings)

Step 4: Insert Chart

• Go to Insert Tab
• Click on Charts Section

Step 5: Choose Chart Type

• Select:
  • Bar Chart
  • Line Graph
  • Pie Chart

Common Types of Graphs

Bar Chart

6

Line Graph

7

Pie Chart

Part C: Customizing Graph

Step 6: Add Chart Title

• Click on chart → Add Chart Title

Step 7: Add Axis Labels

• Add:
  • X-axis (categories)
  • Y-axis (values)

Step 8: Modify Design

• Change:
  • Colors
  • Styles
  • Layout

Part D: Saving and Exporting

Step 9: Save File

• Click File → Save As
• Save in Excel format (.xlsx)

Step 10: Export (Optional)

• Copy graph to Word or PowerPoint

 Result

Statistical data successfully represented using graphs in Microsoft Excel, making interpretation easier and more effective.

 Precautions

• Enter correct data values
• Label axes clearly
• Choose appropriate graph type
• Avoid overcrowding of data

Applications

• Scientific data analysis
• Research presentations
• Laboratory reports
• Business and statistics

 Viva Voce Questions (with Answers)

1. What is graphical representation?
   Display of data in visual form.
2. Which software is used?
   Microsoft Excel
3. Which graph shows trends?
   Line graph.
4. Which graph shows proportions?
   Pie chart.
5. What is a bar chart?
   Graph for comparing values.
6. Why use graphs?
   For easy understanding of data.
7. What is X-axis?
   Horizontal axis.
8. What is Y-axis?
   Vertical axis.