Dagum Four-Parameter Model Excel Sheet Exercise Help the model is the picture 1, picture 2 is the datas for the excel. use the model to make the excel and

Dagum Four-Parameter Model Excel Sheet Exercise Help the model is the picture 1, picture 2 is the datas for the excel.

use the model to make the excel and graph(picture 4 is an example of excel ), in the files one, but there is something with numerator, the numerator need to *100, the others are correct to be referenced.

picture 3 is an example of final version, the work should be look similar to it, if you do it correctly

here is the value you need for the excel

chi-sqrd= 7.350389261597

alpha=8.064381E-09

lambda=25.124

delta=2.1476

beta=19.1182

k=0.28804 y
h
0
0
5
10
10
10
15
15
15
20
20
20
25
30
30
30
35
40
45
45
45
50
55
60
60
60
65
70
75
75
alpha
lambda
delta
beta
chi sq
K
0
3,692
3,692
3,692
0
5,044
5,044
0
3,038
3,038
0
1,32
1,32
1,32
0
0,391333
0,391333
0,391333
0,391333
0
0,122
0,122
0,122
0,122
0
0,050666
0,050666
0,050666
0,050666
0
0
15,03701
2,141401
9,816099
1,652
0,018
f(y)
#DIV/0!
#DIV/0!
1,6632E-06
4,2624E-06
4,2624E-06
4,2624E-06
2,2458E-06
2,2458E-06
2,2458E-06
1,1324E-06
1,1324E-06
1,1324E-06
6,2034E-07
3,6878E-07
3,6878E-07
3,6878E-07
2,3442E-07
1,5719E-07
1,1004E-07
1,1004E-07
1,1004E-07
7,9782E-08
5,9548E-08
4,5541E-08
4,5541E-08
4,5541E-08
3,5557E-08
2,8261E-08
2,2811E-08
2,2811E-08
[]
#DIV/0!
#DIV/0!
10822,2113
4222,96043
4222,96043
4222,96043
8014,92011
8014,92011
8014,92011
15895,1872
15895,1872
15895,1872
29016,1539
48808,9928
48808,9928
48808,9928
76786,6524
114510,102
163576,788
163576,788
163576,788
225614,778
302279,03
395248,7
395248,7
395248,7
506225,051
636929,763
789103,508
789103,508
Spain Yuerong Tang
6
5
25.22
Dagum Model
alpha=0
delta=2.141401
beta=9.816099
chi sq=1.652
K=0.018
4
36.92
3
15.19
2
13.2
1
1.83
5.87
0.76
0
0
5
10
15
20
25
30
35
40
h
45
f(y)
50
55
60
65
70
75
80
y
h
0
0
5
10
10
10
15
15
15
20
20
20
25
30
30
30
35
40
45
45
45
50
55
60
60
60
65
70
75
75
alpha
lambda
delta
beta
chi sq
K
0
3,692
3,692
3,692
0
5,044
5,044
0
3,038
3,038
0
1,32
1,32
1,32
0
0,391333
0,391333
0,391333
0,391333
0
0,122
0,122
0,122
0,122
0
0,050666
0,050666
0,050666
0,050666
0
0
15,03701
2,141401
9,816099
1,652
0,018
f(y)
#DIV/0!
#DIV/0!
1,6632E-06
4,2624E-06
4,2624E-06
4,2624E-06
2,2458E-06
2,2458E-06
2,2458E-06
1,1324E-06
1,1324E-06
1,1324E-06
6,2034E-07
3,6878E-07
3,6878E-07
3,6878E-07
2,3442E-07
1,5719E-07
1,1004E-07
1,1004E-07
1,1004E-07
7,9782E-08
5,9548E-08
4,5541E-08
4,5541E-08
4,5541E-08
3,5557E-08
2,8261E-08
2,2811E-08
2,2811E-08
[]
#DIV/0!
#DIV/0!
10822,2113
4222,96043
4222,96043
4222,96043
8014,92011
8014,92011
8014,92011
15895,1872
15895,1872
15895,1872
29016,1539
48808,9928
48808,9928
48808,9928
76786,6524
114510,102
163576,788
163576,788
163576,788
225614,778
302279,03
395248,7
395248,7
395248,7
506225,051
636929,763
789103,508
789103,508
Spain Yuerong Tang
6
5
25.22
Dagum Model
alpha=0
delta=2.141401
beta=9.816099
chi sq=1.652
K=0.018
4
36.92
3
15.19
2
13.2
1
1.83
5.87
0.76
0
0
5
10
15
20
25
30
35
40
h
45
f(y)
50
55
60
65
70
75
80
Dagum four-Parameter Model
f(y) = (1 – a)AB8
y1+8 (1 + 2y=8)1+8
1
1-a
F(y) = a +
(1+2y-8) 8
France
0.0 – 10.0
6.38
10.0 – 15.0
14.9
20.5
15.0 – 20.0
20.0-30.0
30.0-45.0
32.2
17.8
45.0-60.0
4.9
1.68
60.0-75.0
75+
1.53
T-Mobile
hw3 Bagum.xlsx
@ @ 76%
Dagum
Dagum1
Spain Yuerong Tang
6
4
2
0
0
20
40
60
80
100
Of(y)
?h
Dagum
Dagum1
?
h
0
0
5
10
10
10
15
15
15
20
20
20
25
30
30
30
35
40
45
45
45
50
55
60
60
60
65
70
75
75
f(y)
[]
0
3.692
3.692 0.0000016632 10822.21126
3.692 0.0000042624 4222.960425
0 0.0000042624 4222.960425
5.044 0.0000042624 4222.960425
5.044 0.0000022458 8014.920113
0 0.0000022458 8014.920113
3.038 0.0000022458 8014.920113
3.038 0.0000011324 15895.18717
0 0.0000011324 15895.18717
1.32 0.0000011324 15895.18717
1.32 0.0000006203 29016.15392
1.32 0.0000003688 48808.99278
0 0.0000003688 48808.99278
0.391333 0.0000003688 48808.99278
0.391333 0.0000002344 76786.65242
0.391333 0.0000001572 114510.1017
0.391333 0.00000011 163576.7881
0 0.00000011 163576.7881
0.122 0.00000011 163576.7881
0.122 0.0000000798 225614.7785
0.122 0.0000000595 302279.0302
0.122 0.0000000455 395248.6995
0 0.0000000455 395248.6995
0.050666 0.0000000455 395248.6995
0.050666 0.0000000356 506225.0513
0.050666 0.0000000283 636929.7632
0.050666 0.0000000228 789103.5084
0 0.0000000228 789103.5084
alpha
lambda
delta
beta
0
15.03701
2.141401
9.816099
1.652
0.018
chi sq
K

Purchase answer to see full
attachment