Data Analysis for Decision Makers (MIS 2001S) BBS41 Hong Kong Problem Sheet component of Assignment 1 Deadline: First day of the lecture session This is an official UCD assessment, all academic regulations apply Instructions: Type your name, student number and programme intake on the top of your answer sheet. Include a Statement of Authorship with your answer sheet. Answers should be presented in one typed document, which should be submitted in hard copy to your Programme Manager and uploaded to Blackboard through Safe Assign. Complete all 5 questions. Each carries 10 marks. Note that this is an individual assignment. Throughout this problem sheet, y and z denote the last two digits of your student number (eg. If your number is 12345678, then y =7 and z = 8). Question 1 The U.S Department of Energy provides fuel economy information for a variety of motor vehicles. A sample of 10 automobiles is shown as below (Fuel Economy website, February 22, 2008). Data show the size of the automobile (compact, midsize, or large), the number of cylinders in the engine, the city driving miles per gallon (MPG), the highway driving miles per gallon, and the recommended fuel (diesel, premium, or regular). 1 Car Size Cylinders Highway MPG 19 25 25 18 33 33 26 Fuel 12 6 6 8 4 4 6 City MPG 13 17 16 13 24 25 17 Audi A8 BMW 328Xi Cadillac CTS Chrysler 300 Ford Focus Hyundai Elantra Jeep Grand Cherokee Pontiac G6 Toyota Camry Volkswagen Jetta Large Compact Midsize Large Compact Midsize Midsize Compact Midsize Compact 6 4 5 15 21 21 22 31 29 Regular Regular Regular Premium Premium Regular Premium Regular Regular Diesel Required: a. How many elements are in this data set? b. How many variables are in this data set? c. Which variables are categorical and which variables are quantitative? d. What type of measurement scale is used for each of the variables? Question 2 The following data represent daily water consumption per household in a suburban water district during a recent summer. Reason for water usage Bathing and showering Dishwashing Drinking and cooking Laundering Lawn watering Toilet Miscellaneous Total Gallons per day 99 13 11 33 150 88 20 414 Required: a. Form a Pareto diagram. b. If the water district wants to develop a water reduction plan, which reasons for water usage should it focus on? 2 Question 3 The below data contains the overall miles per gallon of small vehicles: 20 22 yz 22 23 26 22 zy 10+y 24 22 14+z 22 21 21 22 19 16 Use Excel or a calculator to determine the mean, median, mode and standard deviation. Question 4 Having read the module materials on probability, write a short paragraph showing how these ideas relate to business applications. Question 5 A manufacturing company regularly conducts quality control checks at specified periods on the products it manufactures. Historically, the failure rate for LED light bulbs that the company manufactures is 5%. Suppose a random sample of 10 LED light bulbs is selected. What is the probability that: Required: a. None of the LED light bulbs are defective? b. Exactly one of the LED light bulbs is defective? c. Two or fewer of the LED light bulbs are defective? d. Three or more of the LED light bulbs are defective? End of Assignment 1 3