Car Dealer Number of Number Cars Sold 1 23 2 31 3 13 4 7 5 17 6 23 7 25 8 16 9 40 10 25 11 23 12 18 13 7 14 38 15 18 16 17 17 7 18 39 19 24 20 16 21 39 22 18 23 16 24 15 25 15 26 22 27 18 28 13 29 11 30 35 31 27 32 13 33 15 34 39 35 40 36 33 37 9 38 8 39 6 40 22 OrderDate Region Representive 1/6/2014 1/23/2014 2/9/2014 2/26/2014 3/15/2014 4/1/2014 4/18/2014 5/5/2014 5/22/2014 6/8/2014 6/25/2014 7/12/2014 7/29/2014 8/15/2014 9/1/2014 9/18/2014 10/5/2014 10/22/2014 11/8/2014 11/25/2014 12/12/2014 12/29/2014 1/15/2015 2/1/2015 2/18/2015 3/7/2015 3/24/2015 4/10/2015 4/27/2015 5/14/2015 5/31/2015 6/17/2015 7/4/2015 7/21/2015 8/7/2015 8/24/2015 9/10/2015 9/27/2015 10/14/2015 10/31/2015 11/17/2015 12/4/2015 12/21/2015 West East East East West West East East West West East West West West East West East West West East East West East East West West East East West East East East West East East West East West West East East East East Brendan Robert Katie Scott Jennifer Brendan Andrews Katie Thompson Brendan Morgan Howard Parent Brendan Smith Brendan Morgan Brendan Parent Robert Smith Parent Scott Smith Brendan Jennifer Katie Andrews Howard Scott Scott Robert Brendan Morgan Robert Jennifer Scott Jennifer Thompson Andrews Katie Katie Andrews Item Pencil Notebook Pencil Pen Pencil Notebook Pencil Pencil Pencil Notebook Pencil Notebook Notebook Pencil Desk Pen Set Notebook Pen Pen Pen Set Pencil Pen Set Notebook Notebook Notebook Notebook Pen Set Pencil Pen Pencil Notebook Desk Pen Set Pen Set Pen Set Desk Pencil Pen Notebook Pencil Notebook Notebook Notebook Units Unit Cost 73 47 75 68 53 40 72 55 41 63 68 65 46 54 60 52 66 47 50 73 78 61 65 53 61 45 46 56 41 68 55 51 46 58 78 56 78 76 65 73 64 69 77 3.97 3.67 21.53 19.62 12.08 5.19 11.04 13.29 6.63 23.36 4.38 4.94 12.64 11.05 16.33 16.92 10.3 21.58 8.45 3.33 19.01 16.96 23.15 18.05 7.28 18.28 11.19 9.86 5.95 19.28 15.16 15.66 4.13 17.58 5.12 20.3 13.26 7.1 13.01 23.19 14.88 20.03 4.22 Total $ Sales 289.81 172.49 1614.75 1334.16 640.24 207.6 794.88 730.95 271.83 1471.68 297.84 321.1 581.44 596.7 979.8 879.84 679.8 1014.26 422.5 243.09 1482.78 1034.56 1504.75 956.65 444.08 822.6 514.74 552.16 243.95 1311.04 833.8 798.66 189.98 1019.64 399.36 1136.8 1034.28 539.6 845.65 1692.87 952.32 1382.07 324.94 Student Study Time Grade 1 3 65 2 3.5 76 3 0.9 47 4 5.8 99 5 0.5 40 6 3 64 7 4.4 93 8 3.1 71 9 4 85 10 0.8 40 11 0.8 44 12 2.1 64 13 3.6 76 14 0.8 45 15 3.9 83 16 5.7 98 17 5.2 98 18 1.6 59 19 2.1 63 20 1.1 48 21 6.5 100 22 3.4 74 23 4.8 97 24 3.6 83 25 4.1 88 Dealership Identifier Number of sales people New Car Brand Number of New cars sold each week A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A14 A15 A16 A17 A18 A19 A20 A21 A22 A23 A24 A25 A26 A27 A28 A29 A30 A31 A32 A33 A34 A35 A36 A37 A38 A39 A40 8 9 15 9 8 8 6 13 16 7 14 17 10 12 15 6 5 11 14 10 14 19 7 10 15 18 16 12 6 5 6 6 5 8 9 6 19 8 11 7 Dodge VW Honda Honda Ford Dodge Toyota Honda Dodge Dodge Ford VW VW Toyota VW Ford Ford Dodge Ford Honda Toyota Honda Dodge VW Dodge Honda VW Dodge Toyota Ford Dodge Ford Honda Honda Toyota Dodge Dodge VW Honda VW 12 9 6 6 13 11 8 3 15 5 11 12 3 13 9 8 12 12 13 6 5 15 8 13 12 9 5 3 9 8 5 13 12 8 10 12 11 5 13 5 Number of Used Better Business Cars sold each Bureau Rating week 3 3 5 8 6 7 3 2 2 8 4 4 7 6 8 3 5 4 6 6 3 8 3 7 3 3 3 6 2 6 4 8 5 3 6 3 6 5 8 8 AA AA+ A AA+ AA AA+ A A AA+ AA+ A AAA AA AA AA+ AA AA+ AA AA+ AAA AA+ AAA AA AA AA+ A AA AA AA+ A AA AA AAA A AA AA AAA AA+ AA AA Profit from New Profit from Used Car Sales Car Sales 35892 30600 19920 23256 40352 41514 32432 11004 46290 14000 38533 42384 8682 38064 27900 29208 36888 43584 53443 18120 20295 45765 31944 48243 43236 29907 18300 9621 37053 28136 19195 48399 47436 30240 29850 45804 37048 19905 53001 14075 2422 13271 2260 15864 3388 15770 -1369 -2108 9782 14896 2796 17492 4258 3250 19336 700 15835 4060 18788 22188 12725 21816 1753 6946 11159 1166 529 6796 10646 1874 3372 7000 20165 -1600 6376 3232 21174 12610 8624 11936 Profit 38314 43871 22180 39120 43740 57284 31063 8896 56072 28896 41329 59876 12940 41314 47236 29908 52723 47644 72231 40308 33020 67581 33697 55189 54395 31073 18829 16417 47699 30010 22567 55399 67601 28640 36226 49036 58222 32515 61625 26011 Beverage Regular Coke Diet Coke Coke Zero Pibb Extra Sprite Regular Pepsi Diet Pepsi Regular Mountain Dew Diet Mountain Dew Pepsi Max RC Cola 7up Regular Dr. Pepper Diet Dr. Pepper Brand Sales Coca Cola 1272 Coca Cola 926 Coca Cola 872 Coca Cola 326 Coca Cola 417 Pepsico 1122 Pepsico 896 Pepsico 1217 Pepsico 829 Pepsico 426 Independent 317 Independent 508 Independent 1006 Independent 627 YIEP MBA624-MSF624 (Summer 2016) - HW 1 Use the data in various worksheets of this Excel file to solve several questions on this exam. 1) Use the following data for questions 1-3. The data is from a political donor spreadsheet. \"Marital Status\" is measured as a(n)_________ variable. A. Ordinal B. Interval C. Nominal D. Ratio 2) A. B. C. D. How many data variables are quantitative? 1 2 3 4 3) A. B. C. D. \"Amount Donated\" is measured as a(n)_________ variable. Ratio Nominal Interval Ordinal 4) Use spreadsheet named \"Q4-5\" in the Excel data file to solve related problems. The data shows number of cars sold in several dealerships. Use the method described in your book to compute the number of classes to display the data in a histogram. A. 3 B. 4 C. 5 D. 6 5) Use spreadsheet named \"Q4-5\" in the Excel data file to solve related problems. What would you recommend for class width, using method described in the book? A. 4 B. 5 1 C. 6 D. 7 6) Use spreadsheet named \"Q6-7\" in the Excel data file to solve related problems. The data relates to office supply sales. Which region has more Total $ sales? A. North B. East C. West D. South 7) Use spreadsheet named \"Q6-7\" in the Excel data file to solve related problems. The data relates to office supply sales. Which type of office supply has the highest Total $ Sales? A. Notebook B. Pen C. Pen Set D. Pencil 8) Use spreadsheet named \"Q8-10\" in the Excel data file to solve related problems. The data relates to the relationship between students' grade and study hours. Which is the dependent variable? A. They are both axial variables B. Study Time C. Grade D. No relationship 9) Use spreadsheet named \"Q8-10\" in the Excel data file to solve related problems. The data relates to the relationship between students' grade and study hours. Which stem and leaf display is correct for displaying the grade column data? 10) Use spreadsheet named \"Q8-10\" in the Excel data file to solve related problems. The data relates to the relationship between students' grade and study hours. Which scatter plot 2 display is correct for displaying the relationship between grade and hours studied? 11) For Questions 11 to 20, use the data in the embedded spreadsheet on tab \"Q11-20\". The data is a sample of 40 car dealerships. What is the standard deviation for the number of Sales People? A. 4.24 B. 17.95 C. 4.18 D. 14.00 12) What is the interquartile range for profit (note: use excel as described in the book) A. $63,335 B. $40,811 C. $25,057 D. $28,832 13) What is the average number of New Cars Sold Each Week? A. 9 B. 9.2 C. 5 D. 10 14) Which of the following statements are true regarding profit from car sales? A. Profit from new cars is more variable than profit from used cars B. Profit from used cars is more variable than profit from new cars C. Profit from new car sales has a higher standard deviation than profit from used car sales D. Both B and C are correct 15) Which of the statements are true? Use z-scores to answer. A. There are no outliers in the Sales People variable B. There are at least two outliers in the New cars sold each week variable C. There are no outliers in the Profit variable 3 D. Both A and C are correct 16) Ben, the Sales Manager, believes that as he increases staff (i.e., increases the number of sales people), his profit should go up. Which of the following is true regarding Ben's belief? A. Ben is correct, the more sales people you have the more customers you can properly service B. Ben is correct because the sample correlation coefficient is 0.156 (which is really good) C. Ben is not correct because the sample correlation coefficient is 0.156 (which is not very good) D. Ben is correct because the sample correlation coefficient is positive showing that as sales people increase profit increases E. A, B and D are correct 17) The 35th percentile for Used Cars Sold Each Week is (note: use excel)? A. 3.35 B. 4.00 C. 8.00 D. 5.00 18) What is the mode Better Business Bureau Rating? A. AA B. 16 C. AA+ D. Can't be determined as it is qualitative data 19) The range for New Cars sold each week is? A. 9 B. 12 C. 6 D. 8 20) Assuming Profit follows a bell shaped distribution, over what range must at least 95% of the data fall within? A. Approximately $17,373 to approximately $64,661 B. Approximately $25,254 to approximately $56,780 C. Approximately $9,492 to approximately $72,543 D. Approximately $33,136 to approximately $48,899 4 21) Use spreadsheet named \"Q21-25\" in the Excel data file to solve related problems. The data is the reported sales of 20-Oz soda bottles at a local convenience store. What is the probability that a soda sold is a Regular Mountain Dew? A. 0.1901 B. 0.1131 C. 0.0770 D. 0.4172 22) For the convenience store soda sales, what is the probability that a soda sold will be from an independent brand? A. 0.2284 B. 0.3543 C. 0.0472 D. 0.1518 23) For the convenience store soda sales, what is the probability a soda sold will be Sprite or Regular Dr. Pepper? A. 0.0935 B. 0.0388 C. 0.1322 D. 0 24) For the convenience store soda sales, what is the probability that a soda sold will be a 7up and from the Coca-Cola brand? A. 0.3543 B. 0.4015 C. 0.0472 D. 0 25) For the convenience store soda sales, given that a soda sold was from the Coca-Cola brand, what is the probability that it was a Pibb Extra? A. 0.0303 B. 0.3543 C. 0.2284 D. 0.0855 26) Given the following: P(A) = 0.8 P(B) = 0.7 P(A or B) = 0.6 What is P(A and B)? A. B. C. D. 0.90 0.48 0.42 0.56 5 27) There are 16 finalists in the Olympic 100 meter dash. How many different ways can the gold, silver, and bronze medals be awarded? A. 20,160 B. 560 C. 3,360 D. 4,096 28) A local business is having a sales contest. The salespeople who finish in the top 5 each get a 7% raise. There are 45 salespeople. How many different ways can the raises be awarded? Assume the top 5 are not ordered in any particular manner. A. 146,611,759 B. 225 C. 184,528,125 D. 1,221,759 29) A student enrolls in a statistics class. There is a probability of 0.6 that they will be assigned to Professor Jones's class, and a probability of 0.4 that they will be assigned to Professor Smith. Historically the probability of getting a B or higher in Professor Jones's class was 0.7 while in Professor Smith's class it was 0.9. What is the probability that the student will get a B or better? A. 0.78 B. 0.80 C. 0.36 D. 0.22 30) Using the same data as Question 29 answer the following question. Given that a student achieved less than a B, what is the probability that the student had Professor Smith as an instructor? A. 0.5385 B. 0.4615 C. 0.8182 D. 0.1818 31) Use the following data for questions 31 and 32. Cars Sold 0 1 2 3 4 5 6 Probabilit y 0.06 0.14 0.24 0.30 0.12 0.08 0.06 6 The above is the probability of a car salesman making a certain number of sales during a month. What is the expected value of the number of sales a salesman would make? A. 3.00 B. 2.76 C. 3.50 D. 2.42 32) What is the standard deviation of the cars sold by the salesmen? A. 2.2624 B. 2.7600 C. 1.5041 D. 1.2561 33) The following chart shows the probability of time it will take to finish a project and the amount of profit expected if the project is completed in that time. What is the expected value of the profit from this project? Project length less than 30 days 30 to 45 days more than 45 days A. B. C. D. profit 100,00 0 75,000 60,000 Probabilit y 0.2 0.3 0.5 78,667 82,750 65,000 72,500 34) A person making calls to sell insurance has a 0.15 probability of success. If that person makes 20 calls in a day, what is the probability they will have at least 4 successful calls? Assume binomial variable. A. 0.1701 B. 0.2428 C. 0.3522 D. 0.1821 35) Customers arrive at a local restaurant at a mean rate of 24 customers per hour. What is the probability that less than 3 will arrive in the next 15 minutes? Assume Poisson arrivals. A. 0.0620 B. 0.1512 C. 0.0892 D. 0.0113 36) Use the information below for this problem and the next problem. When a customer places an order with Rudy's On-Line Office Supplies, a computerized 7 accounting information system (AIS) automatically checks to see if the customer has exceeded his or her credit limit. Past records indicate that the probability of customers exceeding their credit limit is 0.05. Assume that the number of customers that the AIS detects as having exceeded their credit limit is distributed a binomial variable. A. B. C. D. Suppose that, on a given day, 20 customers place orders. What is the probability that two or more customers will exceed their credit limits? 0.6415 0.0755 0.2642 0.9245 37) For Rudy's On-Line Office Supplies problem, what is the mean and the standard deviation of the number of people who exceed their credit limit? A. Mean = 0.975, standard deviation = 1 B. Mean = 1, standard deviation = 0.975 C. Mean = 1, standard deviation = 0.95 D. Mean = 0.95, standard deviation = 0.975 38) Use the information below to answer this problem and the next two problems. The quality control manager of Marilyn's Cookies is inspecting a batch of chocolate-chip cookies that has just been baked. If the production process is in control, the mean number of chocolate chip parts per cookie is 6.0. Assume Poisson distribution applies. A. B. C. D. What is the probability that in any particular cookie being inspected fewer than five chocolate-chip parts will be found? 0.2851 0.4457 0.1606 0.3588 39) Use information provided for Marilyn's Cookies. What is the probability that in any particular cookie being inspected either four or five chocolate-chip parts will be found? A. 0.1339 B. 0.1606 C. 0.2945 D. 0.4457 40) Use information provided for Marilyn's Cookies. How many cookies in a batch of 100 should the manager expect to discard if company policy requires that all chocolate-chip cookies sold have at least four chocolate-chip parts? Round your answer to the nearest integer. A. 10 B. 15 C. 18 D. 22 8 41) Use the information below to answer this question and the next 3 problems. In 2012, the per capita consumption of soft drinks in the United States was reported to be 44 gallons. Assume that the per capita consumption of soft drinks in the USA is approximately normally distributed with a mean of 44 gallons and a standard deviation of 14 gallons. A. B. C. D. What is the probability that someone in the United States consumed more than 60 gallons of soft drinks in 2012? 0.3752 0.1395 0.2588 0.1265 42) Refer back to the soft drink consumption data. What is the probability that someone in the USA consumed between 15 and 30 gallons of soft drinks in 2012? A. 0.1265 B. 0.3752 C. 0.0316 D. 0.1395 43) Refer back to the soft drink consumption data. What is the probability that someone in the USA consumed less than 18 gallons of soft drinks in 2012? A. 0.1265 B. 0.0316 C. 0.0543 D. 0.1395 44) Refer back to the soft drink consumption data. You must quantify the soft drink consumption of an individual who was among the top 2% of soft-drink consumers in the USA in 2012. How many gallons of soft drinks did such an individual consume? A. 72.8 B. 15.2 C. 72.0 D. 65.7 45) Use the information below to answer this question and the next two problems. How long does it take to download a two-hour movie from the iTunes store? According to Apple's technical support site, downloading such a movie using a 5 Mbit/s broadband connection should take 18 to 24 minutes. Assume that the download times are uniformly distributed between 18 to 24 minutes. Also assume you use a 5 Mbit/s broadband connection. A. B. C. D. If you download a two-hour movie, what is the probability that the download time will be less than 19 minutes? 0.7917 0.5281 0.1667 0.2639 9 46) Refer back to the movie download information. If you download a two-hour movie, what is the probability that the download time will be between 15 to 21 minutes? A. 1.00 B. 0.50 C. 0.33 D. 0.67 47) Refer back to the movie download information. If you download a two-hour movie, what is the probability that the download time will be exactly 21 minutes? A. 0.00 B. 0.19 C. 0.50 D. 0.72 48) Use the information below to answer this question and the two that follow. Telephone calls arrive at the information desk of a large computer software company at a rate of 15 per hour. Assume time between arrivals of calls is exponentially distributed. A. B. C. D. What is the probability that the next call will arrive within 3 minutes? 0.4512 0.5276 0.3607 0.7384 49) Refer to the information desk problem. What is the probability that the next call will arrive within 15 to 20 minutes? A. 0.9765 B. 0.4561 C. 0.0168 D. 0.2273 50) Refer to the information desk problem. What is the probability that the next call will take longer than 18 minutes to arrive? A. 0.0111 B. 0.1011 C. 0.1711 D. 0.2101 10