InstructionsAssignments must be completed on MindTap AND a completed workbook with your full completed solutions must be submitted via Sakai. You must submit both in order to receive any credit.Hardcopies or copies emailed will not be graded. There is no option for late submissions in MindTap. Failure to submit your submit your assignment on MindTap before the due date will result in zero credit.Submit your worked data in one single MS Excel Workbook. Start your solution set by using the assignment shell provided on Sakai. Use appropriately labeled worksheets for each problem/section of a problem.Pay very close attention to the final presentation of your work and make sure it is print-ready. Prepare all spreadsheets so that they are clear, attractive and easy for the untrained eye to follow and understand. While accurate content and precise execution of the techniques is critical, formatting, typographical and grammatical acuteness is also very important. General sloppiness and inconsistent formatting will lower your grade.Note: Ignore MindTap warning about text-based answers. All open ended questions will be graded as well. In fact, your grade will depend equally on the accuracy of your analytical techniques and your interpretation of the results.Assignment files should be named as follows:Asg#_FirstInitialLastname e.g. Assignment 1 for Michael Phelps would be named Asg1_MPhelps.xlsxQuestion 1. 85 pointsDecision 1 Decision 2 Decision 3Payoff/CostProbability Payoff/CostProbability Payoff/CostProbability$50,0000.1 $5,0000.6 $3,0001$10,0000.2 -$1,0000.4 -$5,0000.7 Calculate the EMV for each of the decisions in the table above (also shown in Worksheet Q1), Use what-if data tables to perform the following sensitivity analyses on the EMV for decision 1. Note: In each of the 3 cases outlined below, you are examining the sensitivity of the EMV for decision 1 and then comparing that value to the (static) values of EMV for decisions 2 and 3.The goal in each case is to see whether decision 1continues to have the largest EMV, and if not, identify the decision that has the best (largest) EMV.A.Let the payoff from the best outcome for the first decision, the value in cell A3, vary from $30,000 to $50,000 in increments of $2500.B.Let the probability of the worst outcome for the first decision, the value in cell B5, vary from 0.7 to 0.9 in increments of 0.025.Be sure to use formulas in cells B3 and B4 to ensure that they remain in the ratio 1 to 2 and the three probabilities for decision 1 continue to sum to 1.C.Use a two-way data table to let the inputs in Parts A and B (the value in cell A3 and the value in cell B5) vary simultaneously over the indicated ranges.Questions 2-6. . 15 pointsMultiple-choice questions.

You need to show all the work/steps, partial credit will be provided. Submitting just the answers (even if they are correct) does not provide for any partial credit.please answer the attached question based on our book.Quantitative Analysis for Management (12th Edition)Render, Barry

7.3-1. A machine shop manufactures toggle levers. A lever is flawed if a standard nut cannot be screwed onto the threads. Let p equal the proportion of flawed toggle levers that the shop manufactures. If there were 24 flawed levers out of a sample of 642 that were selected randomly from the production line, (a) Give a point estimate of p. (b) Use Equation 7.3-2 to find an approximate 95% confidence interval for p.(c) Use Equation 7.3-4 to find an approximate 95% confidence interval for p.(d) Use Equation 7.3-5 to find an approximate 95% confidence interval for p.(e) Find a one-sided approximate 95% confidence interval for p that provides an upper bound for p.7.3-2. Let p equal the proportion of letters mailed in the Netherlands that are delivered the next day. Suppose that y = 142 out of a random sample of n = 200 letters were delivered the day after they were mailed. (a) Give a point estimate of p. (b) Use Equation 7.3-2 to find an approximate 90% confidence interval for p.(c) Use Equation 7.3-4 to find an approximate 90% confidence interval for p.(d) Use Equation 7.3-5 to find an approximate 90% confidence interval for p.(e) Find a one-sided approximate 90% confidence interval for p that provides a lower bound for p.7.3-6. Let p equal the proportion of Americanswho select jogging as one of their recreational activities. If 1497 out of a random sample of 5757 selected jogging, find an approximate 98% confidence interval for p.7.4-1. Let X equal the tarsus length for a male grackle. (The tarsus is part of a bird’s leg between what appears to be a backward-facing “knee” and what appears to be an “ankle” .) Assume that the distribution of X is N(μ, 4.84). Find the sample size n that is needed so that we are 95% confident that the maximum error of the estimate of μ is 0.4.7.4-2. Let X equal the excess weight of soap in a “1000-gram” bottle. Assume that the distribution of X is N(μ, 169). What sample size is required so that we have 95% confidence that the maximum error of the estimate of μ is 1.5?7.4-3. A company packages powdered soap in “6-pound” boxes. The sample mean and standard deviation of the soap in these boxes are currently 6.09 pounds and 0.02 pound, respectively. If themean fill can be lowered by 0.01 pound, $14,000 would be saved per year. Adjustments were made in the filling equipment, but it can be assumed that the standard deviation remains unchanged. (a) How large a sample is needed so that the maximum error of the estimate of the new μ is ε = 0.001 with 90% confidence?(b) A random sample of size n = 1219 yielded x = 6.048 and s = 0.022. Calculate an approximate 90% confidence interval for μ.(c) Estimate the savings per year with these new adjust-ments.(d) Estimate the proportion of boxes that will now weigh less than six pounds.7.4-9. A die has been loaded to slightly change the prob-ability of rolling a six. In order to estimate p, the new probability of rolling a six, how many times must the die be rolled so that we are approximately 99% confident that themaximumerrorof theestimateof p is ε = 0.02?