Use data in worksheet named Q1-4 to answer questions 1 4. Assume the sample data was published in a business magazine. 1) Which of the following is true about the data? A. Class is qualitative and ordinal B. Class is qualitative and nominal C. 3 Month Return is quantitative and ordinal D. 3 Month Return is quantitative and interval 2) Study the graphic panels shown below and decide which one of them is a true reflection of the Excel dataset. Then pick the correct answer option listed below. A. Only panel A B. Only panel B C. Both A and B D. None of the panels is correct 3) The data in the worksheet is best described as: A. Time series data B. Survey C. Primary data D. Secondary data E. Direct observation 4) Create a frequency distribution with four classes for 3 Month Return. Set the upper limit of the classes to be: -10, 0, 10, 20. What is the cumulative percent frequency for third class (which has upper limit of 10)? A. 89% B. 100% C. 45% D. 73% 5) Assume you have collected monthly net profit data for a particular company over a 3 year period. The best graphical tool to display the data is: A. Bar chart B. Pie chart C. Line chart D. Stem and Leaf Display E. Scatter Diagram 6) You have collected data about 20 different houses. For each house, you know the square footage of the house and annual cost of utilities. The best graphical tool to display the data is: A. Bar chart B. Pie chart C. Line chart D. Stem and Leaf Display E. Scatter Diagram Use data in worksheet labeled Q7. 7) Rustys Used Cars randomly selected 20 days of sales data over the last year. Using the provided data for sales on these dates, what is the standard deviation of cars sold? A. 20.69 B. 4.33 C. 4.55 D. 5.12 Use data in worksheet labeled Q8. 8) Two different classes at a local University had tests on the same day. A sample of test scores from each class was compared. The test from class 1 was graded out of 100 points. The test from class 2 was graded out of 200 points. From the data provided which class had the most consistent test scores. A. The test from class 1 was most consistent. B. The test from class 2 was most consistent C. The tests are equally consistent D. It cannot be determined 9) A data set of unknown distribution had a mean of 65 and a standard deviation of 10. At least how much of the data is within 2 standard deviations of the mean A. 95.44% B. 75% C. 80% D. Exactly 65% Use data in worksheet named Q10 to answer question 10 (also shown below). A recent survey of 111 customers entering an appliance store asked how much money they planned to spend on appliances. Amount Frequency $500 or more 12 $250-$499 32 $100-$249 64 Less than $100 3 10) What is the probability that a randomly selected customer is planning to spend between $100 and $499 for appliances? A. .146 B. .643 C. .865 D. .997 Use data in worksheet named Q11-12 to answer questions 11-12 (data also shown below). The table indicates the number of appliance customers who purchased extended warranties. The table also identifies the age group of customers. Age Group Warranty No Warranty Less than 30 12 16 30 or Older 15 22 11) What is the probability a randomly selected customer chose to purchase a warranty? A. .230 B. .415 C. .824 D. .992 12) What is the probability that a randomly selected customer was 30 years or older and chose to purchase a warranty? A. .231 B. .415 C. .824 D. .992 Use the following information to answer Questions 13-15. Crustys pizza management has been judiciously collecting data on their customers spending habits. Management has determined that 67% of the people that order a small pizza also order breadsticks. Assume binomial distribution. 13) In a random sample of 15 customers who order a small pizza, what is the probability that 9 or more will order breadsticks? A. 0.8049 B. 0.1114 C. 0.7528 D. 0.6412 14) In a random sample of 15 customers who order a small pizza, what is the probability exactly 12 will order breadsticks? A. 0.3215 B. 0.9167 C. 0.1338 D. 0.0894 15) What is the expected number of customers who order breadsticks with their small pizza order? A. 7.50 B. 10.05 C. 15.00 D. 4.95 Use the following information to answer Questions16-19. Crustys Pizza management has been weighing their large pepperoni pizzas. They have found that the weight follows the normal distribution with a mean of 23.8oz and a standard deviation of 2.3oz. 16) What is the probability that a pepperoni pizza weights more than 21.6oz? A. 0.1098 B. 0.8902 C. 0.1794 D. 0.8306 17) What is the probability that a pepperoni pizza weights exactly 23.8oz? A. 0.0000 B. 0.5000 C. 0.8745 D. 0.4812 18) What is the weight of a pepperoni pizza that weights more than 90% of all the pepperoni pizzas made? A. 29.75oz B. 20.85oz C. 26.75oz D. 18.42oz 19) When using a standard control chart, which of the following indicate a process may be out of control? A. A point above the upper control limit B. 8 consecutive points above the mean C. A point that is 1.5 standard deviations above the mean. D. Both A and B Use the data in Worksheet named Q20. 20) A local delivery service is contracted to deliver 50 packages every day. The data in Excel file shows the number of packages that were late each day for a 30-day period. What is the upper control limit? A. 0.33 B. 0.025 C. 0.109 D. -0.043 Use data provided in the Worksheet named Q21. 21) A local restaurant has customers fill out a rating/comment card at the time of payment. It shows the number of negative comments the restaurant received over a 14-day period. What are the upper and lower control limits? A. 1.93, -2.24 B. 5.79, 0 (does not exist) C. 6.09, -2.24 D. 6.09, 0 (does not exist) Use the following information and data in Excel Worksheet Q22-24 to answer Q22 Q24. The data is collected from a breakfast cereal production line. X-bar and R charts were constructed with the data. Filled cereal boxes were weighed each hour for 8 hours. In each sample 10 boxes were weighed. The mean and range for each sample was computed and recorded. Use the data supplied for these cases to answer questions 22, 23 and 24. 22) What are the upper and lower control limits of the Range chart? A. 0.41, 0.05 B. 15.21, 14.79 C. 0.43, 0.03 D. 15.09, 14.95 23) What are the UCL and LCL for the X-bar chart? A. 0.41, 0.05 B. 15.21, 14.79 C. 0.43, 0.03 D. 15.09, 14.95 24) ASSUME that UCL and LCL were calculated to be 0.67and 0.01 for the range chart and the UCL and LCL were calculated to be 15.06 and 14.75 for the mean chart. What could be said about the packaging process? A. Both the process mean and process variability are in statistical control B. The process mean is in statistical control but the process range is not C. The process range is in statistical control but the process mean is not D. Both the process mean and range are out of statistical control 25) A process of filling water bottles has a mean of 16.07 and an average range of 0.31. The company does not want water bottles processed above a weight of 16.3 ounces or below a weight of 15.7 ounces. Six bottles were sampled each time. Calculate the Cpk. A. 1.01 B. 1.34 C. 0.82 D. 0.63 26) What is true about the process in question 25? A. CPU is higher than CPL; the process average is closer to the LSL B. Cpk is lower than 1.00; the process is not capable at 3 sigma level C. CPL is higher than CPU; the process average is closer to the USL D. Both A and B are correct E. Both B and C are correct Use data in worksheet named Q27-29 to answer question 27-29 (data also shown below). A rural police force would like to investigate the relationship between the amount of time to complete an obstacle course (Minutes) and age of their police officers (years). Age (years) Completion Time (minutes) 22 18 25 19 31 16 42 31 45 22 27) What is the correlation coefficient between age and completion time of the obstacle course? A. .325 B. .469 C. .672 D. .997 28) Is the correlation statistically significant at the alpha=.05 level? A. Absolutely, a correlation that high must be statistically significant B. Yes, the test statistic falls within the rejection range C. No, the test statistic does not fall within the rejection range D. Need more data points to compute this 29) Which variable is the dependent variable (age or completion time)? A. Age is the dependent variable B. Both age and completion time are dependent on one another C. The completion time is the dependent variable D. Completion time is the independent variable Use data in worksheet named Q30-34 to answer question 30-34. Data is also shown below and depicts the height and weight (dependent variable) of Mr. Perrys middle school class. 30) For Mr. Perrys class, what percentage of the total variation of the dependent variable is explained by the independent variable A. 44% B. 62% C. 88% D. 96% 31) What is the Sum of Square Errors for the model? A. 286.6 B. 7252.3 C. 7259.7 D. 12003.4 32) What is the slope for this regression equation? A. 1.325 B. 2.478 C. 3.231 D. 6.720 33) What p-value is associated with the slope, and is it statistically significant at the alpha .05 level? A. 7.127E-19, no not statistically significant B. 5.326E-17, yes statistically significant C. 3.127E-14, yes statistically significant D. 1.777E-12, yes statistically significant 34) What is the estimated weight of a child who is 50 inches tall in Mr. Perrys class? A. 110.33 B. 122.34 C. 160.52 D. 150.93 Use Excel worksheet Q35-39. The data shows orders delivered per month for 10 months. Month Orders Delivered Month Orders Delivered Jan. 120 June 50 Feb. 90 July 75 March 100 Aug. 130 April 75 Sep. 111 May 110 Oct. 94 35) Compute a 3-month weighted moving average forecast for November. Assume weights are 9, 5, 1, on Oct., Sep., Aug., respectively. A. 121.3 B. 111.7 C. 105.8 D. 102.1 36) Compute the single exponential smoothing forecast for November. Use smoothing constant alpha = 0.37. Assume forecast for January was 105. A. 97.2 B. 99.4 C. 103.8 D. 105.6 37) Compute a trend projection line for the time series. Forecast orders delivered for the upcoming January. Round the answer to nearest integer. A. 102 B. 96 C. 112 D. 124 E. 98 38) Compute 2-month moving average forecasts for the time series and compute MAD. What is MAD? A. 5.7 B. 13.2 C. 0 D. 24.7 39) Compute 2-month moving average forecasts for the time series and compute MAPD. What is MAPD? A. 15% B. 18% C. 29% D. 32% Use Excel worksheet Q40-41, also shown below. It is demand for apples at Big Apple Farms. Demand (1000s) Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 1 14.2 7.5 5.9 16.7 44.3 2 16.4 9.7 7 17.8 50.9 3 16.9 10.3 7.8 18.8 53.8 Total 47.5 27.5 20.7 53.3 149 40) Compute the seasonal factor for Quarter 3. Round off to two decimals. A. 0.14 B. 0.18 C. 0.33 D. 0.22 41) Compute a seasonally adjusted forecast for Quarter 3 of Year 5. Round off final answer to nearest integer. A. 12 B. 9 C. 10 D. 8 42) If a time series has long-term up-or-down movement in the data, which of the following is appropriate to forecast it? A. Adjusted exponential smoothing B. A seasonally adjusted model C. Trend projection D. Both A and B E. Both A and C Use the following data for problems 43-45 (all times are in days) Activity Optimistic Most likely pessimistic A 5 7 12 B 4 9 10 C 2 3 4 D 6 12 20 43) What is expected completion time for activity D? A. 12.000 B. 12.667 C. 12.333 D. 13.152 44) What is the variance for activity A? A. 1.000 B. 1.361 C. 5.444 D. 4.315 45) The critical path is: A, B, D. What is the probability of completing the project in less than 26 days? A. 0.2190 B. 0.4516 C. 0.7125 D. 0.1245 Use the following data for problems 46-48. Crustys pizza management has been recording data regarding the time it takes to make a pepperoni pizza and bread sticks (see table) Activity Predecessors Time (seconds) 1. Weigh dough 145 2. Make carry out box 15 3. Weight Cheese 35 4. Measure 15oz of secret sauce 48 5. Roll out bread sticks 1 215 6. Spin dough to proper size 1 180 7. Shape dough on pizza pan 6 64 8. Spread the secret sauce 4, 7 23 9. Place 35 pepperonis 8 65 10. Sprinkle cheese on pizza 3, 9 43 11. Add 15 pepperonis 10 24 12. Place pizza in oven & cook 11 900 13. Place breadsticks in oven & cook 5 330 14. Slice pizza 12 23 15. Place in carry out box 13, 14 14 46) What is the expected project completion time? A. 1579 seconds B. 1481 seconds C. 1234 seconds D. 2124 seconds 47) Which activities are not on the critical path? A. 2, 3, 4, 5, 13 B. 1, 6, 7 ,8, 9, 10, 11, 12, 14, 15 C. 2, 3, 4, 8, 12, 15 D. 1, 2, 3, 6, 11, 13, 15 48) What is the latest start time for place breadsticks in oven and cook? A. 690 seconds B. 360 seconds C. 1467 seconds D. 1137 seconds Use the following data for problems 49 and 50 (all times are days) Activity Activity time Crash time Normal Cost Crash Cost Predecessor 1 Predecessor 2 Predecessor 3 1 5 2 25 35 2 4 1 30 40 3 12 9 45 60 1 2 4 6 4 15 45 1 2 5 15 10 21 28 1 2 6 9 6 16 20 3 5 7 14 12 32 41 3 4 5 8 16 8 64 80 6 9 21 14 14 28 7 10 8 6 25 30 8 9 11 35 25 30 42 9 12 6 4 10 16 10 49) Which of the following is true? A. The normal time to complete the project is 90 days and the shortest time is 63 days B. The normal time is complete the project is 151 days and the shortest time is 101 days C. The normal time to complete the project is 85 days and the shortest time is 51 days D. The normal time to complete the project is 121 days and the shortest is 85 days 50) To complete the project in 69 days, what should you do? A. Crash activity 1 for 1 day, 2 for 1 day, 3 for 2 days, 5 for 5 days, 7 for 2 days, 9 for 7 days and 11 for 10 days B. Crash activity 1 for 1 day, 5 for 3 days, 9 for 7 days, and 11 for 10 days C. Crash activity 1 for 3 day, 2 for 1 day, 3 for 2 days, 5 for 5 days, 7 for 2 days, 9 for 7 days and 11 for 12 days D. Cant complete the project in 69 days 3