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 ordinalB. Class is qualitative and nominalC. 3 Month Return is quantitative and ordinalD. 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 AB. Only panel BC. Both A and BD. None of the panels is correct 3) The data in the worksheet is best described as:A. Time series dataB. SurveyC. Primary dataD. Secondary dataE. 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 chartB. Pie chartC. Line chartD. Stem and Leaf DisplayE. 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 chartB. Pie chartC. Line chartD. Stem and Leaf DisplayE. Scatter Diagram Use data in worksheet labeled Q7.7) Rusty’s 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.69B. 4.33C. 4.55D. 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 consistentC. The tests are equally consistentD. 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 meanA. 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. AmountFrequency$500 or more12$250-$49932$100-$24964Less than $1003 10) What is the probability that a randomly selected customer is planning to spend between $100 and $499 for appliances?A. .146B. .643C. .865D. .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 GroupWarrantyNo WarrantyLess than 30121630 or Older1522 11) What is the probability a randomly selected customer chose to purchase a warranty?A. .230B. .415C. .824D. .992 12) What is the probability that a randomly selected customer was 30 years or older and chose to purchase a warranty?A. .231B. .415C. .824D. .992 Use the following information to answer Questions 13-15.Crusty’s 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.8049B. 0.1114C. 0.7528D. 0.641214) In a random sample of 15 customers who order a small pizza, what is the probability exactly 12 will order breadsticks?A. 0.3215B. 0.9167C. 0.1338D. 0.0894 15) What is the expected number of customers who order breadsticks with their small pizza order?A. 7.50B. 10.05C. 15.00D. 4.95 Use the following information to answer Questions16-19.Crusty’s 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.1098B. 0.8902C. 0.1794D. 0.8306 17) What is the probability that a pepperoni pizza weights exactly 23.8oz?A. 0.0000B. 0.5000C. 0.8745D. 0.4812 18) What is the weight of a pepperoni pizza that weights more than 90% of all the pepperoni pizzas made?A. 29.75ozB. 20.85ozC. 26.75ozD. 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 limitB. 8 consecutive points above the meanC. 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.33B. 0.025C. 0.109D. -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.24B. 5.79, 0 (does not exist)C. 6.09, -2.24D. 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.05B. 15.21, 14.79C. 0.43, 0.03D. 15.09, 14.95 23) What are the UCL and LCL for the X-bar chart?A. 0.41, 0.05B. 15.21, 14.79C. 0.43, 0.03D. 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 controlB. The process mean is in statistical control but the process range is notC. The process range is in statistical control but the process mean is notD. 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.01B. 1.34C. 0.82D. 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 LSLB. Cpk is lower than 1.00; the process is not capable at 3 sigma levelC. CPL is higher than CPU; the process average is closer to the USLD. Both A and B are correctE. 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)22182519311642314522 27) What is the correlation coefficient between age and completion time of the obstacle course?A. .325B. .469C. .672D. .997 28) Is the correlation statistically significant at the alpha=.05 level?A. Absolutely, a correlation that high must be statistically significantB. Yes, the test statistic falls within the rejection rangeC. No, the test statistic does not fall within the rejection rangeD. Need more data points to compute this 29) Which variable is the dependent variable (age or completion time)?A. Age is the dependent variableB. Both age and completion time are dependent on one anotherC. The completion time is the dependent variableD. 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. Perry’s middle school class. 30) For Mr. Perry’s class, what percentage of the total variation of the dependent variable is explained by the independent variableA. 44%B. 62%C. 88%D. 96% 31) What is the Sum of Square Errors for the model?A. 286.6B. 7252.3C. 7259.7D. 12003.4 32) What is the slope for this regression equation?A. 1.325B. 2.478C. 3.231D. 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 significantB. 5.326E-17, yes statistically significantC. 3.127E-14, yes statistically significantD. 1.777E-12, yes statistically significant 34) What is the estimated weight of a child who is 50 inches tall in Mr. Perry’s class?A. 110.33B. 122.34C. 160.52D. 150.93 Use Excel worksheet Q35-39. The data shows orders delivered per month for 10 months. MonthOrdersDelivered MonthOrdersDeliveredJan.120June50Feb.90July75March100Aug.130April75Sep.111May110Oct.9435) Compute a 3-month weighted moving average forecast for November.Assume weights are 9, 5, 1, on Oct., Sep., Aug., respectively.A. 121.3B. 111.7C. 105.8D. 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.2B. 99.4C. 103.8D. 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. 102B. 96C. 112D. 124E. 98 38) Compute 2-month moving average forecasts for the time series and compute MAD.What is MAD?A. 5.7B. 13.2C. 0D. 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)YearQuarter 1Quarter 2Quarter 3Quarter