Problem 2 Description [10 + 24 = 34 points]: The accompanyin…
Problem 2 Description [10 + 24 = 34 points]: The accompanying data resulted from a fabric flammability study. Four randomly selected specimens from three different fabrics were tested to determine their burn times. Perform appropriate analysis to determine which Fabric gives the best performance at 0.04 level of significance. Specimen Fabric 1 Fabric 2 Fabric 3 1 17.8 11.8 13.9 2 16.2 11 10.8 3 15.9 9.2 12.8 4 15.5 10 11.7 2a) Copy-Paste your Excel Report in the box under this question. [10 points]. Answer the following questions (Questions 2 through 14) for the remaining 24 points. Attaching an Excel report/file alone is not sufficient to earn all the points. You must demonstrate your understanding and ability for utilizing the report to answer specfic questions below to earn points. You will earn these points ONLY if I see you actually work (and NOT pretend to work) in EXCEL in your Honorlock recording and your answers for the questions match with your answers with your Excel report. If I do not see you work in Excel and if I do not see you use Excel functions and formulas (wherever relevant) in the Honorlock recording OR your answers in Excel and the Exam do not match, you will earn Zero points.
Read Details2j) Type in the Excel function along with inputs you can use…
2j) Type in the Excel function along with inputs you can use to calculate the critical-value (at a 0.04 level of significance) in the box below. [1 point] Type in the critical-value that you would use for conducting the Hypothesis Test in this problem in the box below. [1 point] Note: You become eligible to earn these points ONLY if you answer all the questions asked.
Read Details