data analysis

INTRO

UNIT 5 GLOSSARY

CORRELATION

COEFFICIENT OF CORRELATION

DEPENDENTS VARIABLE (EFFECT)

INDEPENDENT VARIABLE (CAUSE)

POSITIVE CORRELATION

NEGATIVE CORRELATION

SCATTER DIAGRAM

REGRESSION ANALYSIS

REGRESSION EQUATION

COEFFICIENT OF DETERMINATION: (r2)

SLOPE

INTERCEPT

_x000D_&1#&"Calibri"&10&K000000 INTERNAL - RESTRICTED

PROJECT 5.1

Advertising Spend	Nights_Booked
36,970 €	776		Using this data set complete the following task:
61,970 €	1384			1. Correlation Coeficient
53,400 €	1247			2.Scatter Plot showing regression equation and regression line
31,920 €	655			3. Interpretation
43,060 €	1032			4. Expected nights booked if Ad_Spent = 90 000 €
69,820 €	1232
20,880 €	552
44,850 €	871
65,190 €	1277
39,600 €	760
41,850 €	1020
48,860 €	1146
67,900 €	1339
42,330 €	1007
44,670 €	1035
44,790 €	991
76,470 €	1835
76,240 €	1471
62,050 €	1319
54,630 €	1138
58,850 €	1215
67,890 €	1441
38,770 €	863
64,110 €	1251
34,950 €	844
42,350 €	1104
60,890 €	1409
32,860 €	816
48,320 €	981
39,660 €	936
46,930 €	1175
16,420 €	638
28,740 €	761
41,600 €	905
61,130 €	1276
47,920 €	1155
50,030 €	1183
58,260 €	1038
39,450 €	989
53,400 €	1247
40,340 €	820
29,270 €	635
45,310 €	925
56,890 €	1142
54,060 €	1003
49,860 €	1135
78,710 €	1522
54,950 €	1181
61,740 €	1252
76,860 €	1614
34,470 €	699
37,530 €	905
70,920 €	1523
40,420 €	1027
50,360 €	1343
62,830 €	1080
60,690 €	1331
71,060 €	1394
67,950 €	1192
62,830 €	1432
40,730 €	1093
59,540 €	1225
53,770 €	1193
34,080 €	806
67,010 €	1458
59,690 €	1380
50,550 €	1151
47,200 €	1091
35,620 €	992
52,390 €	1123
55,620 €	1312
40,030 €	822
63,950 €	1544
36,830 €	952
24,520 €	593
62,480 €	1071
45,160 €	1013
48,490 €	931
39,950 €	955
30,730 €	927
65,060 €	1390
41,730 €	930
69,930 €	1500
59,690 €	1309
46,220 €	748
36,970 €	894
41,210 €	1016
35,450 €	807
75,050 €	1668
51,970 €	1120
63,800 €	1440
34,790 €	1099
52,170 €	1128
64,130 €	1121
45,980 €	987
62,370 €	1116
36,990 €	939
33,640 €	963
54,550 €	1265
45,450 €	1057
57,700 €	1161
26,270 €	862
58,550 €	1344
81,180 €	1695
49,700 €	1119
50,410 €	1121
52,150 €	1193
27,660 €	624
55,110 €	1375
30,740 €	772
44,870 €	1080
64,910 €	1316
41,180 €	986
56,010 €	934
62,150 €	1185
53,340 €	1156
33,550 €	645
46,010 €	1321
73,510 €	1323
25,700 €	704
46,690 €	1239
43,370 €	1038
51,450 €	1089
58,980 €	1195
69,300 €	1528
46,760 €	946
59,750 €	1261
56,000 €	1291
55,690 €	1166
43,230 €	989
38,030 €	848
36,800 €	746
40,920 €	1079
53,860 €	1337
59,130 €	1226
53,880 €	1138
43,410 €	960
71,670 €	1555
68,230 €	1319
45,750 €	1013
40,120 €	954
51,560 €	1205
65,210 €	1040
53,990 €	1220
56,680 €	1262
47,460 €	1175
55,480 €	1135
68,530 €	1371
47,120 €	1193
51,720 €	943
53,050 €	1350
53,400 €	1468
33,060 €	852
27,480 €	792
37,760 €	701
52,020 €	1053
56,650 €	1347
43,630 €	1029
66,530 €	1376
48,280 €	1097
50,240 €	1165
47,670 €	1023
51,610 €	1125
58,450 €	1248
57,990 €	1118
39,220 €	945
68,280 €	1646
36,860 €	1071
50,950 €	940
46,710 €	1109
37,410 €	954
49,100 €	1035
41,110 €	824
50,870 €	957
54,840 €	1134
67,660 €	1460
53,690 €	1147
42,670 €	895
45,300 €	866
51,680 €	1172
51,120 €	1248
67,520 €	1304
66,740 €	1455
45,690 €	797
43,420 €	903
19,320 €	635
43,410 €	847
38,260 €	816
45,740 €	1194
54,700 €	1097
52,130 €	1036
49,640 €	1163
52,390 €	1378
48,490 €	1044
52,360 €	1235
11,230 €	564
46,770 €	1081
48,670 €	1044
45,900 €	921
47,380 €	882
58,440 €	1385
42,820 €	993
76,410 €	1735
58,260 €	1367
49,920 €	1025
47,520 €	913
48,960 €	1131
39,020 €	826
48,860 €	1125
53,340 €	1072
56,950 €	1122
56,960 €	1208
46,700 €	1153
33,010 €	831
41,970 €	1097
69,350 €	1300
60,750 €	1167
54,440 €	1169
40,860 €	1195
50,040 €	1182
34,930 €	701
43,380 €	972
47,060 €	1074
45,660 €	954
61,480 €	1380
32,980 €	775
39,610 €	877
33,500 €	954
35,150 €	628
51,490 €	1011
30,790 €	656
59,050 €	1161
47,040 €	959
50,830 €	1173
53,870 €	1301
44,790 €	1116
62,390 €	1201
47,670 €	1045
57,130 €	1283
47,610 €	1086
53,490 €	1320
53,360 €	1079
53,000 €	1173
38,310 €	842
55,230 €	1224
46,170 €	902
57,570 €	1125
24,170 €	547
32,420 €	716
54,360 €	1364
72,360 €	1643
60,020 €	1255
41,810 €	973
29,700 €	543
58,910 €	1239
49,030 €	1102
57,090 €	1365
51,380 €	1164
50,360 €	1158
85,500 €	1775
49,930 €	1131
48,090 €	898
48,540 €	1024
43,000 €	1146
61,880 €	1413
45,750 €	1083
57,630 €	1245
53,420 €	1241
64,630 €	1250
55,040 €	1001
35,440 €	792
34,080 €	878
66,900 €	1417
42,700 €	1090
34,150 €	857
41,960 €	961
65,180 €	1532
32,960 €	929
39,600 €	901
42,000 €	824
34,990 €	721
35,790 €	825
31,780 €	728
44,470 €	1199
45,740 €	822
41,810 €	945
30,160 €	615
65,040 €	1385
34,050 €	859
53,340 €	1111
37,100 €	932
58,020 €	1221
61,470 €	1285
39,470 €	860
26,920 €	763
58,350 €	1267
72,510 €	1694
54,990 €	1342
51,930 €	1201
59,840 €	1018
59,180 €	1087
40,050 €	1039
42,090 €	901
57,330 €	1260
48,270 €	993
65,800 €	1447
41,550 €	1063
59,010 €	1117
54,110 €	1076
48,480 €	873
64,110 €	1382
58,160 €	1047
37,940 €	839
57,680 €	1301
66,500 €	1644
48,430 €	1116
47,020 €	1197
41,960 €	986
49,840 €	1134
58,230 €	1223
40,190 €	877
33,840 €	950
45,490 €	1064
33,440 €	842
56,280 €	1140
44,880 €	966
28,940 €	969
45,820 €	1017
47,690 €	1218
55,390 €	1135
48,260 €	1165
72,420 €	1538
43,780 €	940
49,250 €	1164
48,770 €	893
46,610 €	1108
51,710 €	1225
56,490 €	1250
66,080 €	1547
31,170 €	753
43,880 €	972
44,630 €	1046
61,250 €	1407
45,720 €	1091
27,260 €	663
51,050 €	1000
49,600 €	1172
52,160 €	1044
37,520 €	777
70,630 €	1393
46,110 €	1037
47,740 €	964
39,200 €	769
38,830 €	820
35,330 €	814
45,280 €	1070
38,510 €	901
74,680 €	1415
27,340 €	720
36,460 €	895
45,180 €	959
58,080 €	1150
45,030 €	915
58,110 €	1182
38,160 €	1153
50,710 €	1006
70,930 €	1509
38,390 €	805
55,030 €	1130
52,480 €	1060
22,980 €	710
42,930 €	1018
63,570 €	1329
51,620 €	1190
35,450 €	927
58,290 €	1147
44,250 €	1062
54,320 €	1092
54,520 €	1282
36,580 €	947
59,480 €	1319
37,910 €	857
34,330 €	755
39,410 €	878
45,850 €	1118
51,310 €	1042
40,730 €	939
58,940 €	1051
53,020 €	1186
41,660 €	826
60,670 €	1134
63,930 €	1413
48,820 €	1104
47,420 €	1000
28,710 €	681
45,110 €	1285
46,500 €	1014
52,940 €	1129
47,980 €	1142
52,930 €	1163
68,410 €	1550
43,640 €	1019
44,110 €	1085
34,290 €	870
49,900 €	1176
61,720 €	1306
28,990 €	748
42,010 €	924
50,430 €	1180
60,200 €	1122
54,590 €	1270
53,910 €	1290
47,310 €	1141
55,780 €	1192
62,170 €	1380
29,490 €	638
58,740 €	1358
48,810 €	947
43,640 €	1057
20,680 €	636
33,440 €	851
70,380 €	1413
41,740 €	1042
36,980 €	645
44,520 €	1095
41,060 €	962
51,490 €	1253
68,200 €	1452
42,960 €	1194
51,850 €	1020
36,230 €	925
68,240 €	1322
52,270 €	1126
37,020 €	955
60,850 €	1370
64,400 €	1609
51,940 €	1093
30,330 €	900
71,420 €	1455
53,720 €	1083
64,050 €	1158
43,390 €	1001
45,220 €	951
51,330 €	1226
63,360 €	1277
51,720 €	1074
34,920 €	871
53,140 €	1363
69,550 €	1321
50,790 €	1236
51,550 €	1233
34,850 €	801
33,160 €	878
42,350 €	928
46,080 €	1314
51,250 €	1109
51,990 €	1145
69,220 €	1407
50,700 €	909
62,770 €	1298
49,530 €	1119
67,390 €	1593
27,560 €	755
42,820 €	948
61,800 €	1320
47,940 €	1102
61,180 €	1256
54,620 €	1265
61,350 €	1499
57,360 €	1189
58,080 €	1390
67,910 €	1528
61,840 €	1378
61,930 €	1328
50,250 €	1145
43,020 €	948
42,090 €	1178
59,010 €	1176
20,740 €	709
34,310 €	1004
38,440 €	853
47,030 €	1186
18,420 €	549
65,100 €	1379
57,200 €	1221
73,810 €	1335
62,750 €	1395
62,360 €	1496
77,010 €	1502
43,150 €	1078
31,960 €	765
47,210 €	919
40,100 €	1042
46,920 €	1247
37,400 €	778
56,810 €	1249
56,160 €	1038
49,680 €	1089
53,740 €	1226
48,300 €	1280
59,020 €	1449
50,840 €	1312
46,810 €	979
61,160 €	1271
65,130 €	1173
66,050 €	1303
38,120 €	712
43,590 €	1028
29,580 €	649
47,140 €	916
54,990 €	1147
48,410 €	929
73,170 €	1554
45,130 €	1046
36,940 €	827
56,820 €	1135
51,800 €	972
56,600 €	1285
53,650 €	1193
52,930 €	1208
24,530 €	605
41,290 €	917
42,920 €	1146
45,820 €	953
44,620 €	966
54,950 €	1278
57,210 €	1266
36,420 €	610
58,240 €	1046
57,030 €	1147
55,590 €	1310
32,990 €	874
55,290 €	1258
50,990 €	1193
61,530 €	1191
71,410 €	1558
69,060 €	1332
51,350 €	1238
49,980 €	1038
57,580 €	1270
36,620 €	634
32,590 €	625
44,330 €	1129
64,650 €	1447
46,030 €	882
68,030 €	1579
16,540 €	367
30,950 €	760
48,520 €	1016
60,660 €	1181
49,160 €	1225
48,850 €	1282
48,540 €	1095
28,850 €	902
63,900 €	1316
41,810 €	966
63,070 €	1351
49,150 €	946
62,820 €	1391
54,120 €	1259
48,720 €	1056
52,720 €	946
32,320 €	826
50,070 €	920
70,590 €	1373
65,700 €	1398
38,180 €	795
56,070 €	1240
52,980 €	1126
59,810 €	1081
51,130 €	1140
47,200 €	1120
65,970 €	1509
52,600 €	1103
65,070 €	1364
61,690 €	1131
46,110 €	1266
48,000 €	1245
73,160 €	1513
52,300 €	1126
40,900 €	585
35,600 €	965
61,690 €	1378
51,920 €	1232
40,490 €	880
58,100 €	1189
51,920 €	986
30,070 €	835
57,060 €	1377
66,000 €	1523
80,720 €	1675
50,420 €	1068
52,790 €	1024
69,280 €	1363
52,020 €	1193
53,300 €	1125
42,430 €	1161
33,270 €	937
60,950 €	1225
34,720 €	679
63,690 €	1281
40,540 €	1058
53,180 €	1094
45,530 €	1085
64,100 €	1286
53,610 €	1206
73,510 €	1587
37,000 €	984
54,970 €	1361
50,570 €	1267
53,360 €	1097
69,150 €	1427
57,020 €	1086
36,230 €	824
56,400 €	1218
45,010 €	962
44,320 €	937
62,550 €	1450
42,770 €	1079
45,440 €	1066
50,390 €	954
61,350 €	1328
56,980 €	1180
47,190 €	1207
46,730 €	825
36,080 €	782
40,880 €	865
42,150 €	903
48,210 €	1183
73,840 €	1247
41,890 €	929
46,450 €	1138
25,370 €	774
57,210 €	1164
31,070 €	678
39,120 €	946
62,510 €	1343
24,740 €	654
51,150 €	665
59,610 €	1138
68,310 €	1326
38,960 €	978
42,510 €	792
71,650 €	1364
49,700 €	1076
41,160 €	786
41,390 €	1022
38,330 €	843
44,720 €	1225
63,060 €	1259
60,650 €	1223
35,910 €	943
52,580 €	1068
45,170 €	1195
59,390 €	1327
48,120 €	1030
54,460 €	1161
48,100 €	1408
23,750 €	686
50,560 €	1128
34,740 €	809
58,970 €	1386
41,840 €	771
42,740 €	948
49,890 €	758
56,930 €	1161
47,960 €	1165
69,710 €	1621
69,790 €	1529
70,590 €	1547
47,190 €	843
32,220 €	698
64,640 €	1540
45,000 €	947
50,460 €	1092
57,540 €	1139
30,750 €	641
69,550 €	1395
60,500 €	1210
54,230 €	1291
60,690 €	1318
56,680 €	1343
51,400 €	959
46,310 €	1181
41,130 €	943
53,450 €	1383
54,330 €	1172
63,000 €	1155
52,410 €	1297
39,760 €	899
31,090 €	501
48,470 €	1090
49,670 €	1122
48,820 €	1208
31,630 €	339
62,890 €	1470
62,870 €	1275
40,120 €	1153
59,670 €	1068
61,430 €	1371
50,460 €	1158
38,620 €	844
69,360 €	1356
54,570 €	1137
46,990 €	1004
59,270 €	1117
69,470 €	1570
44,030 €	862
58,300 €	1372
73,320 €	1305
36,600 €	838
43,410 €	962
42,830 €	969
48,100 €	1181
47,480 €	1030
53,610 €	1110
40,160 €	899
42,530 €	1083
53,620 €	1020
51,860 €	1011
60,490 €	1054
54,910 €	1432
59,260 €	1128
36,280 €	627
45,400 €	920
72,180 €	1426
54,700 €	1361
58,970 €	1206
53,270 €	1194
55,100 €	977
47,230 €	1075
92,860 €	1674
45,250 €	977
49,540 €	1001
20,900 €	583
63,280 €	1415
43,370 €	820
49,270 €	950
43,660 €	1009
48,340 €	1153
46,590 €	1209
49,480 €	1034
49,370 €	910
48,150 €	1089
47,990 €	968
65,700 €	1272
60,580 €	1459
60,650 €	1366
41,210 €	854
65,080 €	1369
63,580 €	1334
43,360 €	1000
68,290 €	1380
41,800 €	724
27,900 €	585
63,220 €	1274
48,570 €	1078
61,720 €	1181
40,950 €	959
34,860 €	782
64,780 €	1275
33,110 €	644
31,270 €	816
26,890 €	735
16,470 €	592
37,530 €	941
23,970 €	706
49,570 €	1138
23,160 €	406
36,870 €	830
77,980 €	1432
54,140 €	1339
50,630 €	1110
30,550 €	902
47,050 €	923
50,580 €	1099
30,740 €	785
51,510 €	1088
64,290 €	1380
45,820 €	1203
47,630 €	934
25,490 €	342
33,210 €	990
62,690 €	1233
42,060 €	1092
38,840 €	977
41,690 €	924
49,310 €	1133
36,100 €	713
51,520 €	1138
33,680 €	878
59,290 €	1174
37,320 €	826
65,840 €	1423
49,880 €	1257
39,850 €	917
60,940 €	1245
33,510 €	786
43,440 €	1121
50,000 €	1023
48,550 €	1038
25,900 €	590
38,950 €	877
52,020 €	1162
34,160 €	939
65,200 €	1119
55,940 €	1274
43,830 €	882
47,360 €	1124
72,340 €	1651
61,230 €	1422
54,560 €	1201
33,010 €	894
69,560 €	1339
62,630 €	1319
48,220 €	1250
43,400 €	887
47,750 €	1083
35,580 €	796
44,350 €	975
59,160 €	1314
28,310 €	677
46,230 €	1032
51,370 €	1064
51,240 €	903
35,850 €	869
35,810 €	897
63,070 €	1501
35,310 €	820
62,100 €	1151
44,210 €	905
62,960 €	1398
44,950 €	999
36,000 €	882
60,280 €	1243
49,790 €	1321
67,380 €	1620
60,710 €	1181
47,250 €	1160
44,600 €	1039
50,280 €	1107
52,280 €	1038
39,420 €	1104
60,100 €	1422
45,230 €	839
44,920 €	1175
43,510 €	979
52,770 €	1078
41,700 €	833
51,620 €	1243
83,200 €	1746
49,360 €	984
44,790 €	909
29,990 €	693
50,600 €	1049
36,690 €	924
45,490 €	1064
51,820 €	1056
29,230 €	527
51,890 €	974
53,650 €	1270
34,430 €	700
45,290 €	1029
28,030 €	493
68,910 €	1488
53,970 €	1402
47,840 €	902
48,040 €	1131
63,580 €	1377
48,870 €	1190
53,970 €	1156
68,220 €	1461
45,850 €	1047
36,890 €	933
40,110 €	821
67,140 €	1432
51,100 €	1217
43,970 €	1132
61,680 €	1370
61,980 €	1180
44,290 €	811
38,340 €	939
31,150 €	639
28,470 €	814
46,820 €	1008
39,280 €	1028
72,300 €	1757
50,700 €	1105
26,690 €	667
67,020 €	1528
51,940 €	1263
58,460 €	1456
58,180 €	1271
53,560 €	1088
56,280 €	1214
52,870 €	1077
36,720 €	890
54,400 €	1075
62,290 €	1429
47,480 €	1138
56,620 €	1236
55,040 €	1194
71,790 €	1469
46,970 €	1203
46,500 €	1179
48,600 €	1092
48,770 €	975
22,730 €	468
42,290 €	996
53,600 €	1088
49,900 €	1155
40,410 €	881
42,020 €	1049
45,730 €	1048
40,380 €	1047
43,840 €	721
43,530 €	956
60,740 €	1559
62,200 €	1019
61,200 €	1403
55,120 €	1242
41,500 €	1101
61,520 €	1286
46,230 €	1175
50,280 €	1251
66,060 €	1413
51,010 €	978
52,970 €	1263
33,050 €	678
55,840 €	1189
38,240 €	1002
62,140 €	1450
47,780 €	1018
23,170 €	692
45,700 €	838
47,260 €	994
55,830 €	1381
58,050 €	1406
46,070 €	1110
62,150 €	1302
12,000 €	518
41,430 €	943
36,650 €	880
34,950 €	840
61,520 €	1214
59,950 €	1366
40,690 €	804
64,140 €	1448
51,220 €	1007
44,940 €	922
41,680 €	609
40,660 €	913
55,670 €	1225
57,800 €	1340
52,860 €	1309
25,400 €	478
53,560 €	1282
56,780 €	1166
41,970 €	947
50,520 €	1097
27,630 €	643
35,240 €	728
46,110 €	1063
46,280 €	1130
54,220 €	1025
35,760 €	841
45,910 €	951
44,120 €	1126
56,340 €	1273
67,050 €	1588
70,650 €	1286
31,180 €	885
49,420 €	1109
36,650 €	773
49,220 €	1145
55,080 €	1379
50,980 €	1310
49,410 €	1188
67,800 €	1301
58,650 €	1293
46,730 €	1082
50,290 €	1254
60,450 €	1268
57,320 €	1234
44,900 €	930
28,700 €	797
35,780 €	818
51,750 €	1154
28,560 €	658
48,170 €	1073
44,560 €	872
61,990 €	1335
34,180 €	743
26,820 €	767
44,960 €	1231
57,620 €	1339
62,840 €	1197
39,090 €	860
55,640 €	1008
36,660 €	862