Stat

Dr.bdu
HW3-Data.xlsx
Home>Mathematics homework help>Statistics homework help>Stat

Question 1

Sales Person Intelligence Extroversion $ Sales/Week
1 89 21 2625
2 93 24 2700
3 91 21 3100
4 122 23 3150
5 115 27 3175
6 100 18 3100
7 98 19 2700
8 105 16 2475
9 112 23 3625
10 109 28 3525
11 130 20 3225
12 104 25 3450
13 104 20 2425
14 111 26 3025
15 97 28 3625
16 115 29 2750
17 113 25 3150
18 88 23 2600
19 108 19 2525
20 101 16 2650

Question 2

height weight sat gmat salary
72.00 175.00 1450.00 730.00 200000.00
64.00 125.00 1200.00 630.00 100000.00
65.00 165.00 1170.00 620.00 85000.00
67.00 100.00 1350.00 650.00 150000.00
75.00 168.00 1220.00 640.00 100000.00
61.00 118.00 1340.00 720.00 85000.00
67.00 185.00 1300.00 680.00 100000.00
70.00 160.00 1360.00 720.00 500000.00
73.00 195.00 1200.00 650.00 300000.00
67.00 142.00 1370.00 650.00 150000.00
74.00 175.00 1350.00 720.00 200000.00
70.00 150.00 1220.00 660.00 425000.00
69.00 155.00 1440.00 790.00 125000.00
74.00 185.00 1200.00 680.00 150000.00
66.00 125.00 1400.00 670.00 120000.00
70.00 160.00 1480.00 720.00 350000.00
63.00 140.00 1460.00 730.00 200000.00
74.00 195.00 1560.00 700.00 200000.00
73.00 165.00 1290.00 720.00 300000.00
72.00 185.00 1160.00 680.00 250000.00
72.00 200.00 1270.00 680.00 50000.00
63.00 115.00 1400.00 670.00 75000.00
75.00 190.00 1250.00 700.00 200000.00
74.00 195.00 1240.00 670.00 200000.00
66.00 124.00 1100.00 630.00 80000.00
71.00 165.00 1340.00 700.00 100000.00
65.00 138.00 1320.00 670.00 225000.00
73.00 170.00 1100.00 650.00 170000.00
67.00 122.00 1380.00 680.00 175000.00
72.00 170.00 1000.00 600.00 300000.00
70.00 155.00 1300.00 730.00 200000.00
70.50 185.00 1140.00 690.00 250000.00
70.00 190.00 1300.00 690.00 125000.00
70.00 156.00 1450.00 760.00 120000.00
73.00 215.00 1520.00 700.00 125000.00
70.00 163.00 1380.00 710.00 250000.00
70.50 159.00 1290.00 670.00 100000.00
67.00 160.00 1420.00 710.00 150000.00

Question 3

food decor service price
18.00 22.00 17.00 41.00
24.00 22.00 22.00 54.00
18.00 17.00 14.00 32.00
18.00 9.00 13.00 20.00
21.00 12.00 16.00 25.00
27.00 24.00 26.00 53.00
16.00 16.00 17.00 27.00
21.00 12.00 19.00 29.00
20.00 17.00 18.00 40.00
19.00 8.00 13.00 15.00
17.00 14.00 18.00 20.00
20.00 22.00 21.00 29.00
18.00 11.00 14.00 18.00
14.00 23.00 13.00 28.00
23.00 22.00 21.00 50.00
19.00 17.00 20.00 32.00
17.00 18.00 15.00 26.00
17.00 12.00 12.00 15.00
21.00 19.00 19.00 31.00
18.00 14.00 18.00 32.00
16.00 7.00 14.00 16.00
23.00 15.00 21.00 36.00
14.00 17.00 14.00 27.00
21.00 14.00 18.00 41.00
19.00 18.00 18.00 38.00
22.00 8.00 16.00 18.00
19.00 26.00 20.00 46.00
22.00 19.00 23.00 40.00
21.00 17.00 20.00 27.00
16.00 16.00 15.00 25.00
19.00 15.00 19.00 34.00
19.00 17.00 18.00 40.00
20.00 13.00 14.00 23.00
21.00 6.00 13.00 11.00
16.00 20.00 20.00 23.00
19.00 14.00 17.00 25.00
19.00 14.00 16.00 26.00
24.00 19.00 20.00 33.00
20.00 19.00 20.00 39.00
21.00 22.00 20.00 41.00
22.00 20.00 21.00 44.00
18.00 16.00 19.00 35.00
18.00 15.00 18.00 25.00
20.00 23.00 16.00 44.00
26.00 27.00 26.00 65.00
21.00 11.00 16.00 34.00
21.00 14.00 19.00 41.00
18.00 14.00 16.00 20.00
20.00 15.00 19.00 42.00
14.00 21.00 17.00 36.00
19.00 18.00 16.00 36.00
14.00 13.00 10.00 19.00
22.00 20.00 21.00 46.00
17.00 15.00 15.00 29.00
16.00 17.00 15.00 23.00
22.00 20.00 21.00 42.00
18.00 13.00 15.00 22.00
16.00 18.00 15.00 33.00
23.00 16.00 21.00 32.00
20.00 19.00 16.00 34.00
19.00 14.00 17.00 29.00
20.00 12.00 17.00 22.00
21.00 17.00 20.00 44.00
17.00 16.00 14.00 21.00
20.00 16.00 17.00 45.00
17.00 17.00 16.00 26.00
20.00 22.00 20.00 35.00
22.00 20.00 19.00 42.00
18.00 13.00 20.00 30.00
23.00 9.00 16.00 30.00
20.00 18.00 20.00 48.00
21.00 21.00 19.00 33.00
19.00 14.00 16.00 34.00
17.00 16.00 16.00 22.00
19.00 12.00 18.00 37.00
20.00 18.00 18.00 26.00
21.00 19.00 20.00 42.00
24.00 17.00 20.00 39.00
18.00 15.00 17.00 25.00
21.00 10.00 15.00 14.00
19.00 15.00 18.00 30.00
21.00 2.00 16.00 22.00
15.00 22.00 15.00 11.00
18.00 15.00 16.00 21.00
21.00 16.00 19.00 29.00
24.00 20.00 21.00 55.00
16.00 22.00 14.00 37.00
23.00 21.00 21.00 56.00
21.00 16.00 18.00 47.00
22.00 22.00 19.00 44.00
18.00 17.00 18.00 34.00
19.00 16.00 18.00 25.00
17.00 13.00 15.00 27.00
21.00 15.00 18.00 29.00
21.00 18.00 19.00 43.00
19.00 18.00 19.00 37.00
24.00 20.00 21.00 46.00
19.00 16.00 17.00 29.00
20.00 21.00 19.00 33.00
20.00 15.00 19.00 41.00
21.00 16.00 19.00 31.00
21.00 21.00 19.00 33.00
21.00 28.00 23.00 64.00
24.00 14.00 21.00 53.00
22.00 19.00 18.00 44.00
23.00 23.00 23.00 56.00
17.00 8.00 12.00 22.00
18.00 16.00 20.00 28.00
17.00 9.00 14.00 21.00
20.00 21.00 18.00 40.00
18.00 14.00 16.00 30.00
17.00 17.00 18.00 34.00
20.00 22.00 21.00 51.00
19.00 14.00 15.00 23.00

Question 4

ClassRank GPA
4 3.24
4 2.95
1 3.66
3 3.45
4 3.33
1 3.20
2 2.83
3 3.80
2 3.43
1 3.90
4 3.66
4 2.60
1 2.41
3 3.43
3 3.73
4 3.60
1 3.49
3 3.84
3 2.54
2 2.94
4 3.27
2 2.45
4 3.75
4 3.71
1 3.74
1 2.93
1 3.33
1 3.22
4 2.87
1 3.95
2 2.52
2 3.68
1 2.50
3 2.96
1 3.03
2 2.53
4 3.16
4 3.11
4 2.59
3 2.60
1 3.32
1 3.20
2 2.79
1 2.61
2 2.49
2 3.09
4 2.71
2 2.75
2 3.86
4 3.43
1 2.49
4 2.66
4 3.47
3 2.55
3 3.78
4 2.69
3 2.45
4 2.76
1 2.95
4 3.16
1 3.22
3 2.99
3 2.45
3 2.65
1 2.85
4 3.42
3 2.84
4 3.03
3 3.38
2 3.58
2 3.40
3 2.80
4 2.94
4 2.89
2 2.71
1 3.57
4 2.73
4 2.64
1 3.97
1 4.00
3 3.24
3 2.87
4 3.27
1 3.30
3 3.73
3 3.06
1 3.30
3 3.59
2 2.58
4 2.60
1 2.46
2 3.59
3 2.99
1 2.92
2 3.62
3 3.53
3 2.60
2 2.51
2 2.70
2 2.78
1 3.73
3 2.61
1 3.72
2 3.72
1 3.37
2 3.16
1 3.71
1 3.65
4 3.73
1 2.83
4 3.34
1 3.07
3 2.91
2 2.68
3 3.45
2 2.54
3 3.67

Question 5

ownPrice competitorPrice Sales
5.13567 5.2042 144.49
3.49546 8.0597 637.25
7.27534 11.676 620.79
4.66282 8.3644 549.01
3.58454 2.1503 20.43
5.16792 10.153 713.01
3.38409 4.9466 346.71
4.29306 7.7606 595.78
4.36909 7.4289 457.65
7.2266 10.7113 591.45
7.43643 12.4483 745.23
4.35665 4.3073 177.4
4.86475 11.0556 856.25
6.96966 9.745 449.19
5.48986 7.9044 481.93
5.46023 7.6302 443.34
8.45962 14.8897 911.86
5.23121 8.1032 507.66
3.49585 9.9692 847.43
8.80711 14.1371 812.64
5.45605 8.8422 572.46
4.325 6.471 379.81
5.23705 7.0961 354
4.61478 6.9579 445.97
4.8088 6.8521 399.89
3.8296 6.6789 466.11
4.91714 10.6093 759.89
5.96973 12.5892 880.07
3.36004 5.2346 290.19
4.50369 10.1673 805.51
4.70028 9.4272 666.96
5.42889 8.2601 494.04
4.82462 7.8154 535.65
4.77565 10.3393 765.17
1.67795 2.572 284.73
4.09735 2.6367 43.96
4.94351 7.1008 435.57
6.34616 8.0416 404.03
5.73615 8.7319 512.79
6.0395 9.4089 548.78
3.76536 3.3578 176.64
5.4907 7.2457 349.23
5.73368 6.4362 259.62
4.60315 6.4325 337.97
2.13686 0.7337 -43.68
6.09998 10.1357 596.66
5.5207 11.3468 751.41
2.51308 5.74 512.88
5.12549 8.0809 452.47
6.1765 11.4716 710.9
3.94825 5.3026 292.72
5.2788 6.8068 367.46
1.99072 5.1921 510.9
6.47039 10.4509 628.37
6.38963 10.4061 609.69
4.53539 5.7201 281.11
3.92085 9.6856 792.16
1.35945 3.1703 343.88
6.46952 10.7416 645.53
6.76722 11.0022 633.87
5.294 10.0941 693.54
4.864 9.7121 664.89
5.73444 11.9226 864.94
2.63174 6.1496 576.46
4.20874 10.2859 841.3
5.10869 9.7362 691.47
2.0161 5.0815 462.9
4.1162 4.7868 219.66
3.20347 5.9175 415.57
1.9652 4.0777 404.53
8.69792 13.6441 800.65
7.05065 9.9138 495.75
4.58623 9.7792 688.27
4.91741 6.3876 334.36
7.08949 13.4635 897
4.77727 4.6437 106.14
7.20496 13.5573 927.12
7.79692 12.0858 682.15
0.47244 0.9041 178.85
2.3962 9.3071 883.11
5.0874 10.4219 745.34
2.85361 7.6922 680.23
3.74802 6.2279 432.72
7.21676 11.9934 715.64
4.41862 7.8028 520.01
5.16239 6.4206 296.7
1.0391 -1.2589 -128.1
4.43248 2.8593 -20.34
2.4088 5.3087 477.39
7.10072 8.3304 324.61
1.10558 3.1707 287.36
3.47381 6.4331 445.56
4.23023 12.6986 1130.88
3.91041 7.035 482.82
2.5424 2.9536 179.57
6.06947 8.8234 516.93
4.22226 10.5961 875.2
7.50482 14.8819 1018.1
5.78936 7.7333 382.2
4.73001 6.4888 357.14