In: Statistics and Probability
1. What is the mean and median?
2. what is the standard deviation?
3. what is the minimum and maximum at a minimum?
Years | Weekend | Daily Tour Income | Daily Gross Revenue | Number of Tourists |
1 | Friday | 3378 | 4838.95 | 432 |
1 | Saturday | 1198 | 3487.78 | 139 |
1 | Sunday | 3630 | 4371.3 | 467 |
2 | Friday | 4550 | 6486.48 | 546 |
2 | Saturday | 2467 | 3437.39 | 198 |
2 | Sunday | 3593 | 4571.43 | 452 |
3 | Friday | 898 | 2515.15 | 119 |
3 | Saturday | 2812 | 5462.11 | 342 |
3 | Sunday | 2650 | 5498.89 | 321 |
4 | Friday | 3230 | 5071.14 | 402 |
4 | Saturday | 4798 | 8051.43 | 523 |
4 | Sunday | 3253 | 4291.95 | 353 |
5 | Friday | 2848 | 4545 | 347 |
5 | Saturday | 4632 | 8865.01 | 534 |
5 | Sunday | 3767 | 4710.64 | 412 |
6 | Friday | 4499 | 10752.74 | 529 |
6 | Saturday | 3868 | 6435.63 | 422 |
6 | Sunday | 2489 | 3389.37 | 288 |
7 | Friday | 3448 | 6129.58 | 367 |
7 | Saturday | 3612 | 7357.12 | 406 |
7 | Sunday | 1937 | 2121.76 | 216 |
8 | Friday | 2548 | 4738.86 | 294 |
8 | Saturday | 2833 | 4141.98 | 317 |
8 | Sunday | 2214 | 4878.35 | 284 |
9 | Friday | 1520 | 4102.49 | 169 |
9 | Saturday | 4322 | 8639.55 | 462 |
9 | Sunday | 1833 | 3946.71 | 203 |
10 | Friday | 2271.63 | 4236.31 | 235 |
10 | Saturday | 2407.88 | 5613.27 | 266 |
10 | Sunday | 1772.17 | 5580.17 | 182 |
11 | Friday | 1494 | 3833.52 | 177 |
11 | Saturday | 1998 | 3986.57 | 213 |
11 | Sunday | 1388 | 2721.56 | 165 |
12 | Friday | 1925 | 3952.19 | 190 |
12 | Saturday | 2695 | 6281.3 | 243 |
12 | Sunday | 1525 | 3356.14 | 172 |
13 | Friday | 1725 | 3822.59 | 187 |
13 | Saturday | 2450 | 4141.75 | 253 |
13 | Sunday | 1407.5 | 3312.41 | 173 |
14 | Friday | 2394 | 4571.5 | 242 |
14 | Saturday | 3012 | 6363.3 | 311 |
14 | Sunday | 2058 | 3502.22 | 239 |
15 | Friday | 2427 | 5881.13 | 267 |
15 | Saturday | 3189 | 10409.13 | 336 |
15 | Sunday | 2109 | 4955.05 | 178 |
16 | Friday | 2244 | 4347.41 | 184 |
16 | Saturday | 3195 | 4935.17 | 274 |
16 | Sunday | 1017 | 3486.27 | 114 |
17 | Friday | 3470 | 6290.99 | 325 |
17 | Saturday | 5323 | 13132.55 | 478 |
17 | Sunday | 2345 | 5014.45 | 242 |
18 | Friday | 1671 | 2740.23 | 177 |
18 | Saturday | 2321.94 | 4423.31 | 246 |
18 | Sunday | 1542 | 2650.48 | 182 |
1. What is the mean and median?
mean(Daily Tour Income ) =sum of values /total values=144204.1/54=2670.447
mean(Daily Gross Revenue)=sum/total=276379.76/54=5118.144
mean(Number of Tourists)=sum of values/total values=15795/54=292.5
median=middlemost value after sorting data in ascending order
median(Daily Tour Income )=2458.5
median(Daily Gross Revenue)=4571.465
median(Number of Tourists)=266.5
Solution2:
for std deviation create following table
Daily Tour Income(X) | xbar | x-xbar | (x-xbar)^2 |
3378 | 2670.447 | 707.553 | 500631.2478 |
1198 | 2670.447 | -1472.447 | 2168100.168 |
3630 | 2670.447 | 959.553 | 920741.9598 |
4550 | 2670.447 | 1879.553 | 3532719.48 |
2467 | 2670.447 | -203.447 | 41390.68181 |
3593 | 2670.447 | 922.553 | 851104.0378 |
898 | 2670.447 | -1772.447 | 3141568.368 |
2812 | 2670.447 | 141.553 | 20037.25181 |
2650 | 2670.447 | -20.447 | 418.079809 |
3230 | 2670.447 | 559.553 | 313099.5598 |
4798 | 2670.447 | 2127.553 | 4526481.768 |
3253 | 2670.447 | 582.553 | 339367.9978 |
2848 | 2670.447 | 177.553 | 31525.06781 |
4632 | 2670.447 | 1961.553 | 3847690.172 |
3767 | 2670.447 | 1096.553 | 1202428.482 |
4499 | 2670.447 | 1828.553 | 3343606.074 |
3868 | 2670.447 | 1197.553 | 1434133.188 |
2489 | 2670.447 | -181.447 | 32923.01381 |
3448 | 2670.447 | 777.553 | 604588.6678 |
3612 | 2670.447 | 941.553 | 886522.0518 |
1937 | 2670.447 | -733.447 | 537944.5018 |
2548 | 2670.447 | -122.447 | 14993.26781 |
2833 | 2670.447 | 162.553 | 26423.47781 |
2214 | 2670.447 | -456.447 | 208343.8638 |
1520 | 2670.447 | -1150.447 | 1323528.3 |
4322 | 2670.447 | 1651.553 | 2727627.312 |
1833 | 2670.447 | -837.447 | 701317.4778 |
2271.63 | 2670.447 | -398.817 | 159054.9995 |
2407.88 | 2670.447 | -262.567 | 68941.42949 |
1772.17 | 2670.447 | -898.277 | 806901.5687 |
1494 | 2670.447 | -1176.447 | 1384027.544 |
1998 | 2670.447 | -672.447 | 452184.9678 |
1388 | 2670.447 | -1282.447 | 1644670.308 |
1925 | 2670.447 | -745.447 | 555691.2298 |
2695 | 2670.447 | 24.553 | 602.849809 |
1525 | 2670.447 | -1145.447 | 1312048.83 |
1725 | 2670.447 | -945.447 | 893870.0298 |
2450 | 2670.447 | -220.447 | 48596.87981 |
1407.5 | 2670.447 | -1262.947 | 1595035.125 |
2394 | 2670.447 | -276.447 | 76422.94381 |
3012 | 2670.447 | 341.553 | 116658.4518 |
2058 | 2670.447 | -612.447 | 375091.3278 |
2427 | 2670.447 | -243.447 | 59266.44181 |
3189 | 2670.447 | 518.553 | 268897.2138 |
2109 | 2670.447 | -561.447 | 315222.7338 |
2244 | 2670.447 | -426.447 | 181857.0438 |
3195 | 2670.447 | 524.553 | 275155.8498 |
1017 | 2670.447 | -1653.447 | 2733886.982 |
3470 | 2670.447 | 799.553 | 639284.9998 |
5323 | 2670.447 | 2652.553 | 7036037.418 |
2345 | 2670.447 | -325.447 | 105915.7498 |
1671 | 2670.447 | -999.447 | 998894.3058 |
2321.94 | 2670.447 | -348.507 | 121457.129 |
1542 | 2670.447 | -1128.447 | 1273392.632 |
total | 56778322.5 |
Formula is
sample standard deviation=sqrt(56778322.5/54-1)
=sqrt(1071289)
= 1035.031
I cannot paste table for other variables
sample standard deviation(Daily Gross Revenue)=2138.661108
sample standard deviation(Number of Tourists)= 117.9379034