Questions 1-9 refer to the following information about Ames Community Bank:Ames Community Bank is open six days a week and calculates an average of the daily deposits for each week. For the last year, the average of those averages is $106 million with an average range of $10 million. The bank has noticed an apparent recent decline in the daily demand deposits. The demand deposits for the past six days have been $110, $102, $96, $87, $115, and $106 million.1. What is Xbarbar? a. $106 million b. $106.67 million c. $10 million d. $28 million 2. What is Rbar?a. $10 million b. $106 million c. $28 million d. $87 million 3. In the statement above, what does $96 million represent?a. A single day of deposits (X) b. An average of six deposits (Xbar) c. A new average of Xbar values (Xbarbar) d. Rbar4. Which one of the following is NOT needed to calculate the control limits for the Xbar and R Charts?a. A2 = 1.88 b. A2 = .48 c. D3 = 0 d. D4 = 2.00 5. What is the Xbar value?a. $102.67 million b. $106 million c. $110 million d. $87 million 6. What is the Range for the data?a. $28 million b. $10 million c. $4 million d. $20 million 7. What is the UCL and LCL for the Xbar Chart?a. $110.80 million and $101.20 million, respectively b. $115. million and $87 million, respectively c. $107.47 million and $97.87 million, respectively d. $106 million and $102.67 million, respectively 8. What is the UCL and LCL for the R Chart?a. $20 million and $0 million, respectively b. $10 million and $0 million, respectively c. $28 million and $10 million, respectively d. $28 million and $20 million, respectively 9. Graph both the Xbar Chart and the R Chart with the data provided. Is the process in control? a. The Xbar Chart is in control, but the R Chart is not in control. So the process is out of control. b. The Xbar Chart is in control. So the process is in control. c. The R Chart is in control. So the process is in control. d. Neither the Xbar Chart, nor the R Chart are in control. So the process is out of control.

For this assignment, you will group data and resolve query errors via solutions appropriate to each. You will use Microsoft SQL Server and the content from the AdventureWorks databases, as directed by your instructor, to complete the assignment. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL queries used to explore the database tables, and answer the following questions. Query Scenarios Problem One Your manager needs you to compile a list of all the products the company sells as well as the time required to manufacture them in order to provide this information to the sales department for the presentation of timelines in an upcoming company-wide sales meeting. Your manager specifically needs to know which products take (1) less than 4 days to manufacture, or (2) more than 4 days to manufacture. Looking at the "Production.Product" and using CASE logic, identify each product with a tag of "Under 4 days" or "More than 4 days" and title the field "Timeframe." Problem Two Using the query you created from Problem One as a basis, your manager wants to know the numbers of products that fall into each of the two categories. Note: This process requires two separate SUM statements using CASE logic through the "Manufacturing time." Problem Three Also related to the upcoming sales meeting, the sales manager is building a report for which a list of states using a custom market name is required. Using the "Person.StateProvince" table, use CASE logic to turn "TerritoryID" into a named market for each of the following: Western Market, North Eastern Market, Mid-Western Market, South Western Market, and South Eastern Market. Make sure to include the "TerritoryID" and to order your results by this field. Problem Four The sales manager has also identified a need to know "Year to Date" sales by the new market segments using the same descriptions you developed in Problem Three. Problem Five Now that you have provided the sales manager with year-to-date sales by market segment in Problem Four, the sales manager would like you to provide year-to-date sales by state. This is not realistically possible through the existing company database setup. Explain why and what would be needed for the database to accomplish this dataset in the future