代写BUS1102 assignment 1代做留学生SQL 程序

BUS1102 assignment 1 Please submit the assignment according to the format and deadline set by your instructor.

Q1.5 p51 (in addition, state the level of measurement)

1.5 The following information is collected from students as they exit the campus bookstore during the first week of classes.a. Number of computers ownedb. Nationalityc. Heightd. Dorm hall of residenceClassify each of these variables as categorical or numerical. If the variable is numerical, determine whether the variable is discrete or

Q2.45 p100 (CallDuration) Excel

2.45 The financial services call center in Problem 2.44 also monitors call duration, which is the amount of time spent speaking to customers on the phone. The file S contains the following data for the time, in seconds, spent by agents talking to 50 customers.243 290 199 240 125 151 158 66 350 1141 251 385 239139 181 111 136 250 313 154 78 264 123 314 135 99420 112 239 208 65 133 213 229 154 377 69 170 261230 273 288 180 296 235 243 167 227 384 331a. Construct a percentage histogram and a percentage polygon.b. Construct a cumulative percentage polygon.c. What can you conclude about call center performance if a call duration target of less than 240 seconds is set?

Q2.101 p120 (part e & f only) (Hotel Prices) Excel

2.101 What was the average price of a room at two-star, threestar, and four-star hotels around the world during 2016? The file Hotel Ptices contains the average hotel room prices in Canadian dollars (about U.S. $0.75 as of December 2016) per night paid by Canadian travelers.Source: Data extracted from Hotels.com Hotel Price Index," bit.ly/2qmzNAW.e. Construct separate scatter plots of the cost of two-star hotels versus three-star hotels, two-star hotels versus four-star hotels, and three-star hotels versus four-star hotels.f. What conclusions can you reach about the relationship of the price of two-star, three-star, and four-star hotels?

Q3.63 p195 (Teabags) (exclude the box-plot in (d), but do state the skewness) Excel

3.63 A quality characteristic of interest for a tea-bag-filling process is the weight of the tea in the individual bags. If the bags are underfilled, two problems arise. First, customers may not be able to brew the tea to-be-as strong as they wish. Second, the compañy may be in violation of the truth-in-labeling laws. For this product, the label weight on the package indicates that, on average, there are 5.5 grams of tea in a bag. If the mean amount of tea in a bag exceeds the label weight, the company is giving away product. Getting an exact amount of tea in a bag is problematic because of variation in the temperature and humidity inside the factory, differences in the density of the tea, and the extremely fast filling operation of the machine (approximately 170 bags per minute). The file Teabags contains these weights, in grams, of a sample of 50 tea bags produced in one hour by a single machine:

5.65 5.44 5.42 5.40 5.53 5.34 5.54 5.45 5.52 5.415.57 5.40 5.53 5.54 5.55 5.62 5.56 5.46 5.44 5.515.47 5.40 5.47 5.61 5.53 5.32 5.67 5.29 5.49 5.555.77 5.57 5.42 5.58 5.58 5.50 5.325.50|5.53 5.585.615.455.445.25 5.56 5.635.505.575.675.36

a. Calculate the mean, median, first quartile, and third quartile.b. Calculate the range, interquartile range, variance, standard deviation, and coefficient of variation.c. Interpret the measures of central tendency and variation within the context of this problem. Why should the company producing the tea bags be concerned about the central tendency and variation?d. Construct a boxplot. Are the data skewed? If so, how?e. Is the company meeting the requirement set forth on the label that, on average, there are 5.5 grams of tea in a bag? If you were in charge of this process, what changes, if any, would you try to make concerning the distribution of weights in the individual bags?