Using MS Excel and SPSS for Data Analysis in Smile Clinic

Smile clinic DHBI A2
1

Table of Contents
INTRODUCTION...........................................................................................................................4
PART- 2...........................................................................................................................................8
Pros and cons of using MS- Excel and SPSS............................................................................11
CONCLUSION..............................................................................................................................12
REFERENCES..............................................................................................................................13
2

3

INTRODUCTION
There are various set of data that are containing huge information in it. your data is row one that
needed to be analyzed an it should be evaluated in order to gain necessary information that can
be useful for the business. The data mining has developed as a new concept with use of many
techniques and tools that can help to interpret the available data and Businessmen get useful
information.
This report will describe and analyze the useful data of the Smile Clinic. It will also examined
about the tools of data mining that will cover SPSS and Excel
PART 1
Pivot tables
Year 2012
Average
of Sales
Average of
Profit
Total aver-
age of Sales Total Average of Profit
Delivery
Truck
Express
Air
Reg
ular
Air
Delivery
Truck
Express
Air
Re
gu-
lar
Air
5274.782
1312.5
91
119
0.5
8
137.567766
3
218.67
89604
16
0.4
96
43
26 1767.953 162.9134776
Interpretation- On the basis of above data it can clearly be said that the average sales of
delivery truck is 5274 and of express air is 1312.59 and regular air has 1190. In regard to profit,
it can be said that highest average profit is made by express air that is 218.67 and regular air
earned average profit of 160. Delivery truck earned average profit of 137. So, on the basis of this
average sale of all three is: 1767 and profit is 162.
Year 2011
Delivery
Truck Express Air Regular Air
Total Average of
Sales
Total Aver-
age of Profit
4