Weddings

Couple's Income Bride's age Payor Wedding cost Attendance Value Rating
$130,000 22 Bride's Parents $60,700.00 300 3
$157,000 23 Bride's Parents $52,000.00 350 1
$98,000 27 Bride & Groom $47,000.00 150 3
$72,000 29 Bride & Groom $42,000.00 200 5
$86,000 25 Bride's Parents $34,000.00 250 3
$90,000 28 Bride & Groom $30,500.00 150 3
$43,000 19 Bride & Groom $30,000.00 250 3
$100,000 30 Bride & Groom $30,000.00 300 3
$65,000 24 Bride's Parents $28,000.00 250 3
$78,000 35 Bride & Groom $26,000.00 200 5
$73,000 25 Bride's Parents $25,000.00 150 5
$75,000 27 Bride & Groom $24,000.00 200 5
$64,000 25 Bride's Parents $24,000.00 200 1
$67,000 27 Groom's Parents $22,000.00 200 5
$75,000 25 Bride's Parents $20,000.00 200 5
$67,000 30 Bride's Parents $20,000.00 200 5
$62,000 21 Groom's Parents $20,000.00 100 1
$75,000 19 Bride's Parents $19,000.00 150 3
$52,000 23 Bride's Parents $19,000.00 200 1
$64,000 22 Bride's Parents $18,000.00 150 1
$55,000 28 Bride's Parents $16,000.00 100 5
$53,000 31 Bride & Groom $14,000.00 100 1
$62,000 24 Bride's Parents $13,000.00 150 1
$40,000 26 Bride's Parents $7,000.00 50 3
$45,000 32 Bride & Groom $5,000.00 50 5
 Weddings

Wedding cost Couple's Income Bride's age Attendance Value Rating Payor
$60,700.00 $130,000 22 300 3 Bride's Parents
$52,000.00 $157,000 23 350 1 Bride's Parents
$47,000.00 $98,000 27 150 3 Bride & Groom
$42,000.00 $72,000 29 200 5 Bride & Groom
$34,000.00 $86,000 25 250 3 Bride's Parents
$30,500.00 $90,000 28 150 3 Bride & Groom
$30,000.00 $43,000 19 250 3 Bride & Groom
$30,000.00 $100,000 30 300 3 Bride & Groom
$28,000.00 $65,000 24 250 3 Bride's Parents
$26,000.00 $78,000 35 200 5 Bride & Groom
$25,000.00 $73,000 25 150 5 Bride's Parents
$24,000.00 $75,000 27 200 5 Bride & Groom
$24,000.00 $64,000 25 200 1 Bride's Parents
$22,000.00 $67,000 27 200 5 Groom's Parents
$20,000.00 $75,000 25 200 5 Bride's Parents
$20,000.00 $67,000 30 200 5 Bride's Parents
$20,000.00 $62,000 21 100 1 Groom's Parents
$19,000.00 $75,000 19 150 3 Bride's Parents
$19,000.00 $52,000 23 200 1 Bride's Parents
$18,000.00 $64,000 22 150 1 Bride's Parents
$16,000.00 $55,000 28 100 5 Bride's Parents
$14,000.00 $53,000 31 100 1 Bride & Groom
$13,000.00 $62,000 24 150 1 Bride's Parents
$7,000.00 $40,000 26 50 3 Bride's Parents
$5,000.00 $45,000 32 50 5 Bride & Groom
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.864184788807118
R Square 0.746815349205604
Adjusted R Square 0.696178419046725
Standard Error 7297.56010327766
Observations 25

ANOVA
df
Regression 4
Residual 20
Total 24

Coefficients
Intercept 910.090656077559
Couple's Income 0.325207829253003
Bride's age -399.719555982552
Attendance 46.7190733680698
Value Rating 837.651650203824

RESIDUAL OUTPUT

Observation Predicted Wedding cost

1 50921.9551883842
2 59963.4973902285
3 31508.8458671649
4 26265.2601634328
5 33077.6983649009
6 28507.4636771583
7 21492.0790429171
8 37967.9638629337
9 26648.0535065704
10 25818.1898030555
11 25853.3925482125
12 28040.3227631569
13 21911.8691525237
14 25438.6601291329
15 28839.761875122
16 24239.5014611853
17 18188.4243811409
18 27226.8222422062
 19 18808.8143134528
20 20775.0741520679
21 16464.5392853074
22 11264.3583580384
23 19325.2193815968
24 8374.60398966628
25 9277.62910044363

Wedding cost=910+0.325*CoupleIncome*-399.7*Brideage+46.7*Attendacne+837.7*Value Rating

Standard Residuals

Mean 0.0000000000000005151
Standard Error 0.2
Median -0.0697325247916449
Mode #N/A
Standard Deviation 1
Sample Variance 1
Kurtosis 0.793066022302726
Skewness 0.982472366299632
Range 3.68890663083296
Minimum -1.32694679138137
Maximum 2.36195983945159
Sum 1.28785870856518E-14
Count 25
1

99% data thuộc khoảng -3SD đến 3SD +Mean (nằm trong khoảng từ -2 đến 2)
Mean=0, Standark deviation = 1
Thay thành 95%

d)
Wedding cost=910+0.325*CoupleIncome*-399.7*Brideage+46.7*Attendacne+837.7*Value Rating
19904
 SS MS F
3141674730.781 785418682.695251 14.7484325543113
1065087669.219 53254383.4609498
4206762400

Standard Error t Stat P-value

11713.1542415631 0.0776981705617927 0.938840230130541
0.0803090308379218 4.04945528366954 0.000626692148177508
441.619218378741 -0.905122647175524 0.376175321867173
28.8345822110932 1.62024450453442 0.120840701715214
1055.15427521768 0.793866517795241 0.436591572309253

Phần dư
Residuals Standard Residuals
9778.04481161583 1.46779351888116
-7963.49739022853 -1.19540972476612
15491.1541328351 2.32539491015148
15734.7398365672 2.36195983945159
922.301635099087 0.138447756022119
1992.53632284172 0.29910191220724
8507.92095708289 1.27713377066185
-7967.96386293368 -1.19608019210547
1351.9464934296 0.202942238367811
181.810196944472 0.0272917371399841
-853.392548212545 -0.128103733973465
-4040.32276315694 -0.606497482902186
2088.13084747629 0.313451715915693
-3438.66012913291 -0.516181214999186
-8839.76187512204 -1.32694679138137
-4239.50146118526 -0.636396425655839
1811.57561885906 0.271937693429844
-8226.82224220621 -1.23493772024371
 191.185686547215 0.0286991026348624
-2775.07415206788 -0.416569563066541
-464.53928530735 -0.0697325247916449
2735.6416419616 0.410650303758336
-6325.21938159677 -0.949485934323004
-1374.60398966628 -0.206343381108614
-4277.62910044363 -0.642119809304807

deage+46.7*Attendacne+837.7*Value Rating

This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file format will
permanently break the chart.

trong khoảng từ -2 đến 2)

deage+46.7*Attendacne+837.7*Value Rating
 Significance F
9.16563278866682E-06

Lower 95% Upper 95% Lower 95.0%

-23523.1209440103 25343.3022561654 -23523.1209440103
0.157686126439751 0.492729532066255 0.157686126439751
-1320.92110313073 521.481991165624 -1320.92110313073
-13.4288111414531 106.866957877593 -13.4288111414531
-1363.36159912657 3038.66489953422 -1363.36159912657

PROBABILITY OUTPUT

Percentile Wedding cost

2 5000
6 7000
10 13000
14 14000
18 16000
22 18000
26 19000
30 19000
34 20000
38 20000
42 20000
46 22000
50 24000
54 24000
58 25000
62 26000
66 28000
70 30000
 74 30000
78 30500
82 34000
86 42000
90 47000
94 52000
98 60700

ile format will

 Upper 95.0%
25343.3022561654
0.492729532066255
521.481991165624
106.866957877593
3038.66489953422

Normal Proba
80000
60000
Wedding cost

40000
20000
0
0 20 40
Sample Pe
 Normal Probability Plot

20 40 60 80 100 120
Sample Percentile
100 120