Data Analysis and Interpretation: Excel Charts and Analysis Assignment

This assignment focuses on data visualization and analysis using Excel charts. It begins by differentiating between column and bar charts, followed by the creation and interpretation of various chart types. The solution includes examples of column charts illustrating cost and retail prices of grocery items, sales data categorized by product, and employee salary comparisons. Pie charts are used to represent test outcomes in mathematics and computing, offering insights into student performance. The assignment culminates in a comparative analysis of the results across subjects, highlighting the strengths and weaknesses of students based on the charts. Overall, the assignment demonstrates the effective use of Excel charts for data representation and analysis, providing a clear understanding of data trends and patterns.

CHARTS AND ANALYSIS

TABLE OF CONTENTS
1. Difference between column and bar chart..........................................................................1
2. Enclosed in excel sheet.......................................................................................................1
3. Creating column chart........................................................................................................1
4. Creating column chart with sales of every category..........................................................2
5. Creating column chart........................................................................................................2
6.1 Creating pie chart.............................................................................................................3
6.2 Creating column chart......................................................................................................4
REFERENCES................................................................................................................................5

1. Difference between column and bar chart
The column and bar chart both reflects data with application of rectangular bars which is
proportional to data value. However, its variation is in orientation as bar chart is designed
horizontally and column chart is vertically oriented (Column graphs vs. bar charts, 2019).
2. Enclosed in excel sheet
3. Creating column chart
In the above graph, cost and retial price has been plotted of various grocery products such
as cereal, milk, eggs, cheese, meat, pasta and juice whereas meat is very expensive among all
products. It has been observed that retail prices for each good is more than its cost price and
which good has the lowest or highest price.
1

4. Creating column chart with sales of every category
In the above chart, sales of each product is plotted with reference to number of units, list
price and discount given on every product. It had been clearly observed that health and beauty
products are leading and has list price of 800 with maximum discount of 100. The summer
clothes are least sold product as there listed price is 560 and discount of 30.
5. Creating column chart
2

The employees age, position and salary has been reflected, IT head has the highest annual
salary along with his age and experience because of highly qualified skills. In the same series,
administrator has the lowest annual salary and age. Further, Sarah and Tim both have similar
designation as QA executive and of same age profile but there annual compensation is different
as it might be due to experience and skills. Shaun is programmer of 34 age and annual salary is
of 28000 and Adam as IT specialist with 36 age with approx. similar salary of 35000 which is
appreciable.
6.1 Creating pie chart
In this pie chart, final test outcome of maths has been reflected of every student as Cloe
has attained highest marks as 90 and followed by Sarah and David among entire class and Simon
is at lowest with 55. In this subject, majority of students had attained more than 50%.
3

In this pie chart, final test outcome of computing has been reflected of every student as
Adam has attained highest marks as 85 followed by David and Cloe among entire class and
Simon is at lowest with 63. However, it could be evaluated that Simon is not laying focus on its
academics tutor could not be blamed.
6.2 Creating column chart
In the above scenario, final test results of both subject has been plotted which shows that
students have prepared very well as majority students gained more than 60% which is
appreciable. With other perspective, there turors are also giving high efforts which leads to great
performance. Furthermore, in computing students are highly efficient as compared to maths
majorly and it had been observed that Simon who hat attained highest marks in maths had gained
3rd position in computing. On the contrary, Adam had attained highest marks in computing is at
4th position in maths. While considering there aggregate, Cloe is at 1st positiion and David and
Sarah has maintained appropriate balance in both subject whereas they gained 2nd and 3rd position
respectively.
4

REFERENCES
Online
Column graphs vs. bar charts. 2019. [Online]. Available through <
https://www.thinkoutsidetheslide.com/column-graphs-vs-bar-charts-when-to-choose-each-
one/ >.
5