findings and data analysis
TRANSCRIPT
-
7/23/2019 Findings and Data Analysis
1/18
Findings and Data Analysis:
1. Age
Table 2.1: Age Analysis
Age GroupRespondents AgeGroup
below 20 19
below 20 20
21-30 28
21-30 26
21-30 24
31-40 32
31-40 33
31-40 38
31-40 32
31-40 40
31-40 38
31-40 35
31-40 40
41-50 43
41-50 42
41-50 45
41-50 48
41-50 42
above 50 53above 50 52
Table 2.2: Age Frequency Distribution
Age Group Frequency
Below 20 221-30 3
31-40 8
41-50 5
Above 50 2
Total 20
-
7/23/2019 Findings and Data Analysis
2/18
below 20; 10%
21-30; 15%
31-40; 40%
41-50; 25%
above 50; 10%
Age Analysis
Figure 2.1: Age Analysis
below 20 21-30 31-40 41-50 above 50
0
2
46
8
10
2 3
8
5
2
Age Frequency Distribution
Age Groups
Frequency
Figure 2.2: Age Frequency Distribution
The Figure 2.1 an 2.2 !how! re!"onen#! o$ ieren# age grou"
"ar#i&i"a#e in #he !urve'. The highe!# nu(ber 40% o$ #he re!"onen#!
were o$ #he age grou" o$ 31-40) 25% o$ #he re!"onen#! were $ro( age
*ean 36.5
*eian 38+#anar,evia#ion 9.8
-
7/23/2019 Findings and Data Analysis
3/18
grou" o$ 41-50) 15% were $ro( #he age grou" o$ 21-30) 30% an #he
lowe!# i.e 10% o$ #he re!"onen#! $ro( below 20 an above 50.
Manual Calculation:
! !2 10 203 25.5 106.58 35.5 2845 41.5 20.52 51.5 10320 "21
Mean
/ $ / 36.05
$
*eian / 1 2 - &$ 7 &
$
*eian &la!! / +ie o$ 2#hi#e(
/ +ie o$ 202#hi#e( / 10#h
/ 31-40
Median/ 31 10 - 5 9
8
/ 31 6 7 9
8
/ 31 6.5 / 3.5
#tandard De$iation:
+, / $ - 2
/ 10
2. %our &ont'ly 'ouse'old inco&e.
-
7/23/2019 Findings and Data Analysis
4/18
(nco&eFrequency
Below 000 1
001 - 12000 3
12001 - 1000 61001 - 22000 4
22001 - 2000 2
2001 - 32000 2
Above 32000 2
Total 20
Table ).1: (nco&e Analysis
Table ).2: (nco&e Frequency Distribution
The average hou!ehol in&o(e o$ re!"onen#! in a !a("le i! A, 18)5
"er (on#h. *oal &la!! i! A, 1001 : 22000 a! #he (o!# $reuen#l'
o&&urring. *eian i! a""ro./A, 1)500) in#er-uar#ile range i! a""ro.
(nco&e Range (nco&e
Below 000 6500
001 - 12000 8000
001 - 12000 10000
001 - 12000 11000
12001 - 1000 13000
12001 - 1000 15000
12001 - 1000 16000
12001 - 1000 13000
12001 - 1000 100012001 - 1000 15000
1001 - 22000 19000
1001 - 22000 20000
1001 - 22000 22000
1001 - 22000 18000
22001 - 2000 25000
22001 - 2000 25000
2001 - 32000 26000
2001 - 32000 2000
Above 32000 35000Above 32000 34000
-
7/23/2019 Findings and Data Analysis
5/18
be#ween A, 001 an 12000. The (oe &an be a""roi(a#e a! A,
13)000.
0123456
1
)
*
+
2 2 2
(nco&e Distribution
(nco&e
Frequency
Figure ).1: (nco&e Frequency Distribution
The Figure 3 !how! re!"onen#! o$ ieren# in&o(e grou" "ar#i&i"a#e in
#he !urve'. The highe!# nu(ber 30% o$ #he re!"onen#! were o$ #he
-
7/23/2019 Findings and Data Analysis
6/18
,
Mean:
/ $ / 35008.5 / 1850.425
$ 20
*eian / 1 2 - $ &
$
*eian =la!! / !ie o$ 202#h/ 10#hi#e(
/ 12001 10 - 4 7 4999
6
/ 1)000
(nterquartile range:
>1/ +ie o$ #h/ 20 / 5#h
4 4
1/ 12001) /5) &$/6) $/6) & / 4999
4
>1/12)001 - 5 : 4 7 4999 6
/ 12001 4999
6
/ 12001 8331.66 / 12)834
>3- >1/ 12)834.3/ +ie o$ 3 / 3 5 / 15#h
4
1/ 22)001) &$ /14) $/2
>3 / 22001 15 -14 4999
2
/ 22001 4999
2
/ 24500.500
>3- >1/ 24500.500 -12)834. 166
-
7/23/2019 Findings and Data Analysis
7/18
/ 11)666.5
Mode/ 3 (eian - 2 *ean
/ 3 7 1000 - 2 7 1850.425
/ 51)000 - 3500.85
/ 13499.15
-
7/23/2019 Findings and Data Analysis
8/18
). /rice range o your current car
/rice range o your currentcar
Frequency
Below 25000 2
25001 - 35000 235001 - 45000 3
45001 - 55000 1
55001 - 65000 1
65001 - 5000 1
5001 - 85000
85001 an above 3
Total 20
Figure ".1: /rice range o respondents current car/rice range o your currentcar /rice
Below 25000 18000
Below 25000 22000
25001 - 35000 31000
25001 - 35000 29000
35001 - 45000 38000
35001 - 45000 42000
35001 - 45000 45000
45001 - 55000 5200055001 - 65000 58000
65001 - 5000 2000
5001 - 85000 8000
5001 - 85000 80000
5001 - 85000 83000
5001 - 85000 85000
5001 - 85000 9000
5001 - 85000 8000
85001 an above 90000
85001 an above 15000085001 an above 98000
Table ".2: /rice range o respondents car
The average "ri&e range o$ #he re!"onen#! in a !a("le i! A, 64)632 "er
(on#h. *oal &la!! i! A, 55)001 : 65)000 a! #he (o!# $reuen#l'
o&&urring. *eian i! a""ro./A, 2)000) in#er-uar#ile range i! a""ro.
-
7/23/2019 Findings and Data Analysis
9/18
be#ween A, 35)001 an 45)000 41)500. The (oe &an be
a""roi(a#e a! A, 8)000.
02468
2 2)
1 1 1
"
)
/rice range o respondents car
/rice Range o Cars
Frequency
Figure ": /rice range o respondents car
The Figure !how! "ri&e range o$ re!"onen#! &ar who "ar#i&i"a#e in #he
!urve'. The highe!# nu(ber i.e 35% o$ #he re!"onen#! ha &ar! $ro(
"ri&e range be#ween 5)001 : 85)000) 15% o$ #he re!"onen#! ha &ar!
$ro( "ri&e range be#ween 35)001 -45)000 an 85)001 an above) 10%
were $ro( "ri&e range below 25)000 an 25)001 -35)000 an lowe!# being
5% $ro( "ri&e range be#ween 65)001 : 5)000) 55)001 : 65)000 an
45)001 -55)000.
Manual Calculation:
! !2 20)000.5 400012 30)000.5 600013 40)000.5 120001.
51 50)000.5 50)000.51 60)000.5 60)000.51 0)000.5 0)000.5 80)000.5 560003.
53 90)000.5 20000
20 12)000-.,
-
7/23/2019 Findings and Data Analysis
10/18
Mean:
/$ / 61500.290
$
(nterquartile range:
>2/ 65000.5 10 - 9 10)000
1
Median / 65)000.5 10)000 / 5)000.5
>1/ 5 o$ #h/ 20 / 5#h. i#e(
4 4
>1/ 35)000.5 5 - 4 10)000
3
/ 35)000.5 3333.333
/ 38) 333.833
>3/ !ie o$ 3 / 3 7 5/ 15#h
4/ 5000.5 15 - 10 10000
/ 82140.5
>3- >1/ 43806.66
-
7/23/2019 Findings and Data Analysis
11/18
214 -1-3
/ 5)000.5 6 7 10)000
28 -1-3
/ 5)000.5 60)000
24
/ 500.5
-
7/23/2019 Findings and Data Analysis
12/18
4. ?ha# i! #he &ar "ri&e range 'ou woul &on!ier "ur&ha!ing $or@ u!e
"ri&e range!
Car price range you ould considerpurc'asing Frequency
Below 25000 0
25001 - 35000 0
35001 - 45000 1
45001 - 55000 1
55001 - 65000 4
65001 - 5000 4
5001 - 85000 3
85001 an above
Total 20
Table 1): Car &ae respondents considering to purc'ase
Car price /rice
Below 25000 0
25001 - 35000 0
35001 - 45000 42000
45001 - 55000 53000
55001 - 65000 6400055001 - 65000 61000
55001 - 65000 65000
55001 - 65000 60000
65001 - 5000 2000
65001 - 5000 5000
65001 - 5000 0000
65001 - 5000 6000
5001 - 85000 82000
5001 - 85000 80000
5001 - 85000 8300085001 an above 88000
85001 an above 90000
85001 an above 92000
85001 an above 150000
85001 an above 98000
85001 an above 125000
85001 an above 130000
Table 1): Car &ae respondents considering to purc'ase
-
7/23/2019 Findings and Data Analysis
13/18
The average "ri&e range o$ #he re!"onen#! "re$erre &ar in a !a("le i!
A, 4)864 "er (on#h. *oal &la!! i! A, 85001 an above a! #he (o!#
$reuen#l' o&&urring. +#anar evia#ion o$ #he !a("le 35) 228.9. *eian
i! a""ro./A, 3)500) in#er-uar#ile range i! a""ro. be#ween A,25)001 an 35)000 2)50.
Manual Calculation:
! !0 20)000.5 00 30)000.5 01 40)000.5 40)000.51 50)000.5 50)000.5
4 60)000.5 2400024 0)000.5 2800023 80)000.5 240000 90)000.5 630000
20 1+-000,
Mean
/ $ / 4000.25
$Median >2/ +ie o$
#h/ 10#h
2
>2/ 65)000.5 10 - 6 10)000 / 5)000.5
4
(nterquartile range
>1/ +ie o$ / 5#h
4
>1/ 55)000.5 5 - 2 10)000 / 62)500.5
4
>3/ 3 7 5#h/ 15#h
>3/ 85)000.5 15-13 10)000 / 8)85.642
/ >3- >1/ 25)35.14
#tandard De$iation:
-
7/23/2019 Findings and Data Analysis
14/18
+, / $ - 2
2)68)944)000 20
1)343)92)000/ 36)660.22
02468
0 0 1 1+ + )
"
Car price range t'at respondents ill be considering
Car /rice Range
Frequency
Figure 1): Car &ae respondents considering to purc'ase
The Figure 13 !how! "ri&e range o$ re!"onen#! &on!iering #o
"ur&ha!e &ar. The highe!# nu(ber i.e 35% o$ #he re!"onen#! "re$err
&ar! o$ "ri&e range be#ween 85)001 an above) 20% o$ #he re!"onen#!
"re$erre &ar! $ro( "ri&e range be#ween 55001 : 65000 an 65)001
-5)000) 15% were $ro( "ri&e range below 5)001 : 85000) 5% an
lowe!# being 5% $ro( "ri&e range be#ween 65)001 : 5)000) 55)001 :
65)000 an 45)001 -55)000.
Regression Analysis
3o. Toyota &odel 4ilo&eters A5D
1 200 146000 20002 2013 48000 51000
-
7/23/2019 Findings and Data Analysis
15/18
3 2008 138000 25000
4 2011 55961 38500
5 2009 95000 29000
6 2013 3600 45000
2008 11000 33000
8 2009 95000 29000
9 2012 38000 55000
10 2010 31000 42000
11 2009 58159 33500
12 2012 43000 52000
13 2010 139000 41000
14 2009 102000 36000
Table 1".1: Toyota Corolla &ileage and price obser$ations
0 50000 100000 150000 200000
0
10000
20000
30000
40000
50000
60000
$ / - 0.13 490.33
C / 0.31
#catter grap' in 000
Milage6 4& in 000
/rice6 in 000 A5D
Figure 1,: #catter grap' in 000
r70.-).ega#ive "ar#ial &orrela#ion ei!#! be#ween &ar (ileage an re#ail
"ri&e. =orrela#ion i! ui#e !#rong.
R270.)1226 31% o$ varia#ion! in re#ail "ri&e! &an be e"laine b'
varia#ion! in (ileage!. Aroun 69% o$ varia#ion! &an be e"laine b'
o#her $aor! &ar &oni#ion) &ar !"e&iD&a#ion) e#&
-
7/23/2019 Findings and Data Analysis
16/18
3o.Toyotacorolla&odel
Milage64& 8000
9!
/rice6A5D8000
9y!y ;
-
7/23/2019 Findings and Data Analysis
17/18
-
7/23/2019 Findings and Data Analysis
18/18
Manual Calculations:
53)00 / 14a b 10)31 ua#ion 1
381)264)850 / a 10)31 b 7 106439041 .
ua#ion 2
669.4 7 ua#ion 1
669.4 7 53)00 / 14 7 669.4 7 a b 7 669.4 10) 31
411)846)80 / 10361 a 8234549 7 b .ua#ion 3
ua#ion 3 - ua#ion 2
30)581930 / -243963292 7 b
.G. b / - H.1253
+ub!#i#u#e b in ua#ion 1
53)00 / 14a -0.1253 7 10) 31
/ 14a - 13459.5
14a / 6)159.5
a / 49.10
' / a b
' / 49.10 - 0.1253