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