Topic: Checking for QualityScenario: A venture capitalist has just given you several million dollars to develop your dream product! Explain in detail what this product is and why people would buy it. (Think Steve Jobs and the iPhone - did people really think we needed “smartphones” back in 2007?)Main Post: Now your dream product has gone into production and the manager is asking you, as the statistical expert, to use statistical methods to ensure quality control. See Example (attached) and DB starter video in Unit 10 LiveBinder.1. You will generate a random dataset of N samples of defective proportions by completing the following steps:a) You will start with a random number by combining the last 2 digits of the year in which you were born plus the day of the month in which you were born. For example, if you were born October 3, 1990, your number would be 90 + 3 = 93. (If your number exceeds 100, subtract 100 from the total.) Call this X and it will seed your random number generation.b) Choose a number of samples, N. (N should be between 5 and 10 samples.)c) In Excel, type =RAND()*X in a cell. Repeat N times. This will generate the proportion of defective products (out of 100) for your N samples.2. Use Excel to create a p-chart for a sample size, 100, and the number of samples, N.3. Write a professional memo to your business/company owner describing the production quality so far and prioritizing any control measures necessary to guarantee high quality products. Address the following items and questions in your professional memo:Describe your product, its use, and societal value. (Humor is encouraged.)Share and summarize your p-chart.What is your Lower Control Limit (LCL) and Upper Control Limit (UCL)?Is the product in control? If not in control, what sample(s) was outside of the limits, i.e., below LCL or above UCL?What measures could be taken now to address the data points that out of control?What recommendations would you suggest to optimize quality in future production?

InstructionsA local law firm has hired G&B consulting to help determine a business strategy. There is a competing firm in the area and recently the two firms have begun talks in regards to a merger. The merger would mean there are more shared resources than either had before individually. There would also be less competition for both companies. Both would be able to operate more efficiently, however it would take a strong commitment from both sides for the merger to be successful. The law firm that has hired you wants to know their optimum strategy in this situation.What to SubmitTo complete this assignment, you must first you download the word document.Your step-by-step breakdown of the problems, including explanations, should be present within the word document provided.

Attached Files: Heart Rate Data Set.xlsx (16.008 KB) Unit 3: Descriptive StatisticsEvaluation Title: Assignment 3 RubricInstructions: In this assignment, you will be required to calculate descriptive statistics for each numeric variable in the Heart Rate DatasetStepsOpen the Heart Rate Dataset in ExcelSort the quantitative variables by class (e.g., Male at-rest heart rate and Female at-rest heart rate)Use the Data Analysis tools of Excel to calculate each of the following statistics:Mean of each quantitative variableSample variance of each quantitative variableSample standard deviation of each quantitative variableCreate a table in Excel that summarizes the statistics for each variable.Transfer your summary results to Word, and briefly explain your calculated results. Additional Instructions:Your assignment should be typed into a Word or other word processing document,formatted in APA style. The assignments must includeRunning head A title page withAssignment nameYour nameProfessor’s nameCourseEstimated time to complete: 3 hours