Question

Home Insert Page Layout Formulas Dats Reve ROTECTED VIEW Be careful fFiles from the Internet can contain vinuses. Unless you need to edit, it's saler to stay in Protected View C D Strength 48.5 52.3 53.5 50.5 50.3 49.6 The CEO of Durable Bags Inc. is planning to introduce a new, improved version of the company's trash bag. The new trash bag utilizes a new formula that is being touted as the strongest bag on the market Previously, one of Durable Bags' competitors was advertising that their bags could hold up to 50 lbs. of trash without breaking 51.0 48.3 50.6 50.2 52.5 The CEO of Durable Bags has contacted you and asked you to design a research study that proves that the new Durable Bag is the strongest on the market 47.5 509 roceed through the 6 step process (as outlined in the Study Guide) 49.8 50.0 50.8 53.0 50.9 49.9 Provide details on what must be accomplished in each of the 6 steps. Notes As in all cases, the sample has already been selected (see data on the left) Let me assure you that the sampling design is completely valid 50.1 50.7 The data collected is based on a test where random bags were selected and filled with weight until the bag tore The recorded weight is in pounds 48.2 51.5 49.0 51.7 53.2 51.1 Be sure to support each decision you make with appropriate rationale 52.6 Make sure you put your name on all submissions 1 2 Data Sheet2 Sheet3 O Type here to search 02. 1. Complete the Six Step Process (SSP) as defined Step Process (Version 1)," the Ch. 9 & 10 PPT slides and the Wk. 3 SG. You should note that I ha inseited background information and additional notes related to the case within the Excel worksheet in the reference titled"Hypothesis Testing the Six You will need to submit an Excel file containing your statistical output plus a Word document that contains all of your discussion points related to each step in the SSP Please use a format in which you include each Step of the Six-Step Process as a Section header within your document, This will help to organize your discussion, and it will make your paper easier to grade For example: 2. Step 1 Discuss all of the issues and pertinent information that you (as the analyst) must provide before moving on to Step 2 Step 2: Provide the appropriate discussion relevant to this section of the SSP Davis AA #3a [Compatibility Mode]. Excel (Product Activation Failed) me Insert Page Layout Formulas Review View Show Queries EE From Tablke Ll Connections Flash Fill Ba Consolidate Properties B- Remove Duplicates Relationships Sort Filter Advanced Columns Data Validation. Manage Data Model Ann ssrroheet Subi . Lo Recent Sources A Text to Edit Links : what-if Forecast 2§Ung Advanced Columns Eo Data ValidationManage Data Model Analysis Sheet All- Get & Transform Connections Sort & Filter Data Tools Forecast Column1 Column 1 Column1 50.575 0.259900129 50.65 50.9 1.643752742 2.701923077 -0.215103263 0.0549271 50.575 0.259900129 50.65 50.9 Mean 50.575 0.259900129 Mean Standard Error Standard Error Standard Error Median Median Median 50.65 50.9 1.643752742 Mode Standard Deviation Mode Mode Standard Deviation Standard Deviation Sample Variance Kurtosis 1.643752742 Sample Variance Kurtosis 2.701923077 0.215103263 0.0549271 Sample Variance Kurtosis 2.701923077 0.215103263 0.0549271 7.2 46.8 54 Skewness Skewness Skewness Range Minimum Range Range 46.8 54 Minimum 46.8 Minimum Maximum Maximum Maximum 2023 2023 2023 Sum Count Count 0703786985 Confidence Level(95.0%) 0.525697631 Confidence Level(99.0%) Confidence Level(90.0%) 0.437899261 Var List Data Q1 Output Q2 Outout Step 1 State null and alternate hypotheses- Step 2: Select a level of significance- Step 3: Identify the test statistic- . Step 4: Formulate a decision rule- Step 5: Take a sample, arrive at decision- Step 6: Interpret the result-

Answer 1

Answer:

The null and altermative hypotheses are Ha: μ > 50 By using excel, and s 1.644 The test statistic is 50.575, n 40 t_x_μ 50.575-50 sn1.644/40 df n-1-40-1 39 - 2.212 For right tailed test at α 0.05, the critical value is 1.685 Since test statistic falls in critical region, reject the null hypothesis There is sufficient evidence to support the claim that new durable bag is the strongest on the market