TYPES OF DATABASE
Hailey College Banking and Finance, Punjab University
Subject:
Class:
3rd Semester
Database Management System
B.B.A (hons) Banking and Finance
Teacher:
Sir Muhammad Aqeel
Student:
Talha Shahid
MI4BBA 003
TYPES OF DATABASE
Descriptive Analysis
There are 30 customers opinion for the features of Sony
T.V.
1. Frequencies
1.1
What is your satisfaction level about company's Television Screen Resolution on scale 1 to 4?
Frequency
Valid
Percent
Valid Percent
Cumulative Percent
Dissatisfaction
6.7
6.7
6.7
Satisfaction
23.3
23.3
30.0
Highly Satisfaction
21
70.0
70.0
100.0
Total
30
100.0
100.0
In this table, the opinion of customers about screen resolution is
mostly highly satisfied with 70% of total. Screen resolution of
Sony TV is very good. There is no customer whose opinion is
highly dissatisfied.
TYPES OF DATABASE
1.2
What is your satisfaction level about company's Television Weight on scale 1 to 4?
Frequency
Valid
Highly Dissatisfaction
Percent
Valid Percent
Cumulative Percent
13.3
13.3
13.3
14
46.7
46.7
60.0
Satisfaction
30.0
30.0
90.0
Highly Satisfaction
10.0
10.0
100.0
30
100.0
100.0
Dissatisfaction
Total
In this table, the opinion of customers about weight of T.V is
mostly dissatisfied with 46.7% of total. And 13.3% opinion is
highly dissatisfied. Its mean weight of Sony TV is poor.
1.3
What is your satisfaction level about company's Television Warranty on scale 1 to 4?
Frequency
Valid
Percent
Valid Percent
Cumulative Percent
Dissatisfaction
3.3
3.3
3.3
Satisfaction
20.0
20.0
23.3
Highly Satisfaction
23
76.7
76.7
100.0
Total
30
100.0
100.0
In this table, the opinion of customers about warranty is mostly
highly satisfied with 76.7% of total. There is only 3.3% who are
dissatisfied about warranty of Sony T.V. Warranty of Sony TV is
excellent. There is no customer whose opinion is highly
dissatisfied.
TYPES OF DATABASE
1.4
What is your satisfaction level about company's Television Sound on scale 1 to 4?
Frequency
Valid
Percent
Valid Percent
Cumulative Percent
Highly Dissatisfaction
3.3
3.3
3.3
Satisfaction
30.0
30.0
33.3
Highly Satisfaction
20
66.7
66.7
100.0
Total
30
100.0
100.0
In this table, the opinion of customers about sound is mostly
highly satisfied with 66.7% of total. There is only 3.3% who are
dissatisfied about sound of Sony T.V. Sound of Sony TV is
excellent. There is no customer whose opinion is highly
dissatisfied.
1.5
What is your satisfaction level about company's Television Billing on scale 1 to 4?
Frequency
Valid
Percent
Valid Percent
Cumulative Percent
Highly Dissatisfaction
13.3
13.3
13.3
Dissatisfaction
30.0
30.0
43.3
15
50.0
50.0
93.3
6.7
6.7
100.0
30
100.0
100.0
Satisfaction
Highly Satisfaction
Total
In this table, the opinion of customers are mixed about billing of
Sony T.V. There is 13.3% opinions who are highly dissatisfied
about billing of Sony T.V. 50% and 6.7% opinions are satisfied and
highly satisfied respectively. Billing of Sony TV is satisfactory.
TYPES OF DATABASE
2. Descriptive
Descriptive Statistics
N
Minimum
Maximum
Mean
Std. Deviation
What is your satisfaction level about
company's Television Screen
30
2.00
4.00
3.6333
.61495
30
1.00
4.00
2.3667
.85029
30
2.00
4.00
3.7333
.52083
30
1.00
4.00
3.6000
.67466
30
1.00
4.00
2.5000
.82001
Resolution on scale 1 to 4?
What is your satisfaction level about
company's Television Weight on scale
1 to 4?
What is your satisfaction level about
company's Television Warranty on
scale 1 to 4?
What is your satisfaction level about
company's Television Sound on scale
1 to 4?
What is your satisfaction level about
company's Television Billing on scale
1 to 4?
Valid N (list wise)
30
In this table 4 numeric digits. 1 and 2 assign to highly
dissatisfied and dissatisfied respectively. 3 and 4 assign
to satisfied and highly satisfied respectively.
The mean of Screen resolution is 3.6333 it means the
opinion of customers are mostly highly satisfied and
satisfied. Its standard deviation is .61395.
The mean of weight and billing shows that customers are
not satisfied from these two features. Their opinion is
negative. There standard deviation are high as compared
with other 3 features.
TYPES OF DATABASE
The mean of warranty and sound shows that customers
are highly satisfied from these two features. Their
response is positive. There standard deviation is low as
compared with above said two feature.
3. Cross Tabulation
3.1 Compare Weight of T.V with Screen Resolution, Warranty and Sound
What is your satisfaction level about company's Television Weight on scale 1 to 4? * What is your satisfaction level
about company's Television Screen Resolution on scale 1 to 4? Cross tabulation
Count
What is your satisfaction level about company's
Television Screen Resolution on scale 1 to 4?
Highly
Dissatisfaction
What is your satisfaction level Highly Dissatisfaction
about company's Television
Weight on scale 1 to 4?
Total
Satisfaction
Satisfaction
Total
Dissatisfaction
14
Satisfaction
Highly Satisfaction
21
30
TYPES OF DATABASE
What is your satisfaction level about company's Television Weight on scale 1 to 4? * What is your satisfaction level
about company's Television Warranty on scale 1 to 4? Cross tabulation
Count
What is your satisfaction level about company's
Television Warranty on scale 1 to 4?
Highly
Dissatisfaction
What is your satisfaction level Highly Dissatisfaction
about company's Television
Weight on scale 1 to 4?
Satisfaction
Satisfaction
Total
Dissatisfaction
14
Satisfaction
Highly Satisfaction
23
30
Total
What is your satisfaction level about company's Television Weight on scale 1 to 4? * What is your satisfaction level
about company's Television Sound on scale 1 to 4? Cross tabulation
Count
What is your satisfaction level about company's
Television Sound on scale 1 to 4?
Total
Highly
Dissatisfaction
What is your satisfaction level Highly Dissatisfaction
about company's Television
Weight on scale 1 to 4?
Total
Satisfaction
Higly Satisfaction
Dissatisfaction
14
Satisfaction
Highly Satisfaction
20
30
This cross tabulation shows that screen resolution, warranty and
sound are very good because of high technology. There is one
fault in this technology which is its high weight. Parts of T.V
increase the weight of T.V because of its unique technology as
compared with other T.V.
TYPES OF DATABASE
3.2 Compare Billing of T.V with Screen Resolution, Warranty and Sound
What is your satisfaction level about company's Television Billing on scale 1 to 4? * What is your satisfaction level
about company's Television Screen Resolution on scale 1 to 4? Cross tabulation
Count
What is your satisfaction level about company's
Television Screen Resolution on scale 1 to 4?
Total
Highly
Dissatisfaction
What is your satisfaction level Highly Dissatisfaction
about company's Television
Billing on scale 1 to 4?
Satisfaction
Satisfaction
Dissatisfaction
Satisfaction
10
15
Highly Satisfaction
21
30
Total
What is your satisfaction level about company's Television Billing on scale 1 to 4? * What is your satisfaction level
about company's Television Warranty on scale 1 to 4? Cross tabulation
Count
What is your satisfaction level about company's
Television Warranty on scale 1 to 4?
Total
Highly
Dissatisfaction
What is your satisfaction level Highly Dissatisfaction
about company's Television
Billing on scale 1 to 4?
Total
Satisfaction
Satisfaction
Dissatisfaction
Satisfaction
11
15
Highly Satisfaction
23
30
TYPES OF DATABASE
What is your satisfaction level about company's Television Billing on scale 1 to 4? * What is your satisfaction level
about company's Television Sound on scale 1 to 4? Cross tabulation
Count
What is your satisfaction level about company's
Television Sound on scale 1 to 4?
Total
Highly
Dissatisfaction
What is your satisfaction level Highly Dissatisfaction
about company's Television
Billing on scale 1 to 4?
Total
Satisfaction
Higly Satisfaction
Dissatisfaction
Satisfaction
11
15
Highly Satisfaction
20
30
This cross tabulation shows that screen resolution, warranty and
sound are very good because of high technology. There is one
fault in this technology which is its high billing. Expensive parts of
T.V increase the billing of T.V because of its expensive technology
as compared with other televisions.
