Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes N0 N0 N0 N0 N0 N0 N0 N0 1493 1519 1434 1151 1406 1573 1433 1420 1305 1354 1770 1587 1587 1664 1216 1507 1525 1980 1460 1890 1475 1357 1708 1528 1425 1606 1734 1176 1664 1546 1271.19 993.87 1331.94 813.65 1167.72 1192.41 1101.74 1106.49 866.07 1033.29 1245.99 1097.08 1344.95 1053.97 936.56 1156.56 1065.3 1278.97 840.73 1347.28 1129.51 841.64 1084.75 1062.87 1076.89 1140.16 1126.53 916.14 1024.29 1184.57 b. If some of the companies you randomly selected refused to be interviewed, how would that be a problem? [2 marks] An alternate strategy proposed is to randomly sample cities from among those in the database, then conduct the interviews with all companies whose headquarters are found in the selected cities, until 100 companies have been selected. c. What would you call this sampling strategy? What advantages and disadvantages would it have? [2 marks] Q3. Considering the data set commerce . xl sx contains the data collected by the The Cutter Consortium as described in Question 1. The variables measured are: Variable Description/Value Sim Company's size (Small, Medium, Large) ecommerce [f the company has an overall ecommerce Strategy (Yes, No) PYOdUCtS Number of product lines you delivered over the internet in the last year tcvcnut' Company's total revenue (in thousands of dollars) in the last scal year a) Calculate the summary statistics for revenue and use them to complete the table below. [3 marks] Statistic - - - - - - - 1:) Does the revenue depend on the company's size? Create a boxplot showing the revenue versus size. Interpret the plot in words. [3 marks] (Hint: Filter the data by company Size, then copy the revenue valuesfor each company size into the BOX_pl 0 ts . Xl t template which can be found on the Stream webpage under the Resources/Excel_ Templa tes link.) Insert your graph here 131,02 your comments here size ecommerce products revenue Small Yes 218 196.63 Small Yes 410 180.51 Small Yes 269 165.32 Small Yes 483 357.9 Small Yes 282 177.18 Small Yes 290 161.56 Smal Yes 284 212.19 Small Yes 442 412.31 Smal Yes 315 192.96 Small Yes 276 263.38 Small Yes 174 91.88 Small Yes 249 135.62 Small Yes 293 251.27 Smal Yes 417 391.37 Small Yes 187 172.59 Smal Yes 244 233.66 Small Yes 234 136.01 Smal Yes 370 421.65 Small Yes 180 151.14 Small Yes 416 182.37 Smal Yes 174 56.79 Small Yes 234 141.83 Smal Yes 269 224.7 Small Yes 314 151.12 Small Yes 345 236.04 Small Yes 404 302.19 Small Yes 218 207.06 Smal Yes 341 202.15 Small Yes 311 268.32 Smal Yes 219 183.25 Small Yes 416 301.8 Smal Yes 210 175.73 Small Yes 253 214.43 Small Yes 319 290.46 Smal Yes 336 191.45 Small Yes 542 295.69 Smal Yes 343 180.34 Small No 421 306.51 Small No 326 222.51 Smal No 251 208.89 Small No 316 274.87 Smal No 357 329.48 Small No 416 276.46 Smal No 296 188.05 Small No 240 193.98 Small No 152 109.25 Smal No 235 170.23 Small No 282 182.54 Smal No 324 197.78 Small No 278 207.81 Smal No 234 160.24 Small No 327 215.17 Small No 237 206.35 Small No 338 261.42 Small No 384 345.64 Smal No 340 208.7 Small No 355 143.98 Smal No 386 258.63 Small No 147 13 88Small No 147 43.88 Smal No 334 170.38 Small No 330 229.91 Small No 356 243.16 Small No 229 213.01 Small No 231 168.1 Small No 363 356.15 Small No 172 93.09 Smal No 269 47.99 Small No 312 187.18 Smal No 188 132.8 Small No 203 2.52 Small No 303 211.63 Small No 285 191.73 Small No 421 214.69 Smal No 297 197.15 Small No 322 153.71 Small No 230 203.74 Small No 350 248.05 Small No 359 292.12 Small No 217 173.28 Small No 342 223.75 Medium Yes 387 131.68 Medium Yes 838 693.65 Medium Yes 486 454.83 Medium Yes 563 242.68 Medium Yes 574 530.14 Medium Yes 646 445.67 Medium Yes 618 525.59 Medium Yes 737 633.72 Medium Yes 575 356.72 Medium Yes 513 275.73 Medium Yes 757 456.87 Medium Yes 700 549.15 Medium Yes 663 473.43 Medium Yes 266 193.6 Medium Yes 505 306.33 Medium Yes 562 441.68 Medium Yes 504 412.08 Medium Yes 327 184.5 Medium Yes 398 133.04 Medium Yes 153 -20.89 Medium Yes 830 561.52 Medium Yes 413 284.55 Medium Yes 605 578.42 Medium Yes 647 339.04 Medium Yes 619 283.18 Medium No 597 177.36 Medium No 860 604.11 Medium No 466 308.37 Medium No 326 353.31 Medium No 690 589.49 Medium No 570 358.04 Medium No 551 506.72 Medium No 525 296.98 Medium No 525 441.83 Medium No 860 439.29 Medium No 572 352.56 Medium No 460 359.28 Medium No 552 340.72 Medium No 566 360.11 Medium No 240 37.36 Large Yes 1497 1193.84 Large Yes 1743 1116.21 Large Yes 1512 871.8 Large Yes 1485 973.68ASSIGNMENT 1 Total: 30 marks Q1 The Cutter Consortium surveyed 154 US. companies to determine the extent of their involvement in electronic commerce (recommerce). Four of the questions they asked follow. 1. Do you have an overall e-commerce strategy? 2. If you don't already have an ecommerce plan, when will you implement one? a. Short term; b. Medium term or c. Long term 3. How many different product lines did you deliver over the intemet in the last year? 4. What was your company's total revenue (in millions of dollars) in the last scal year? a. For each of the above questions, classify the resulting variable as categorical or numerical. If numerical, state whether discrete or continuous; if categorical, state whether nominal or ordinal. [4 marks] b. Explain the difference between parameter and statistic. [2 marks] c. Give two examples of statistics that could be calculated from the data generated from questions 1 to 4 above. [2 marks] Q2. The Cutter Consortium has a database of the names, tax number, physical address (including state and city) and size (small, medium and large) of all the 2500 companies of interest. A researcher from the consortium intends to visit the head ofce of a sample of companies, and conduct face-toface interviews. a. Explain how you would select a sample of 100 companies using the following schemes: i. Simple random sample [3 marks] ii. Stratied sample having company sizes as strata. [3 marks] b. If some of the companies you randomly selected refused to be interviewed, how would that be a problem? [2 marks]