PLEASE USE AND SHOW EXCELL FORMULAS AND FUNCTIONS

A) Based on the problem description, Name of the "Factor"

experimented in this study.

B) Based on the problem description. Name of the "Treatments" in this

experimental study.

C) Name the Experimental Design you would use for analyzing the data

in this study.

D) State the Null Hypotheses for this analysis using parameter labels (Greek

letter labels). [1 point]

State the Alternative Hypotheses for this analysis (Greek letter labels). [1

point]

Name all the parameter labels (specify what each label in the above

hypothesis stands for). [1 point]

E) Type in the Excel function (along with inputs) that you can use to

calculate the p-value in the box below. [1 point].

Type in the p-value that you would use for conducting the Hypothesis

Test in this problem in the box below. [1 point].

F) Conduct the hypothesis test at a 0.02 level of significance using p-value

approach (specify the logic). [1 point]

What is the decision on the Hypothesis test?

G) Type in the Excel function along with inputs you can use to calculate the

critical-value (at a 0.02 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.

H) Conduct the hypothesis test at a 0.02 level of significance using critical-

value approach (specify the logic). [1 point]

What is the decision on the Hypothesis test?

I) State the conclusion (as an English sentence) based on p-value and

critical-values approaches for the hypothesis tests you have conducted

in the previous questions above.

J) Conduct the LSD tests in Excel (showing all the steps) at a 0.02 level

of significance to identify which Treatment/s provides different

performance with respect to "Tensile Strength" among the ones tried.

Copy-Paste the results in the box below.

K) Which Treatment provides the best Tensile Strength based on your LSD

test results? [1 point]

Why do you say so? Provide reasoning for your answer in a sentence.

A product developer is investigating the tensile strength of a new synthetic fiber used for making clothes. Strength is affected by the percentage of cotton used in the blend of materials used to make synthetic fiber. The company conducts a randomized experiment with 3 levels of cotton content and obtained four observations for each level. We can assume that tensile strength follows a normal distribution, the population variance is the same, and the observations are all independent for all levels of cotton content. Is there evidence to support the claim that the cotton content affects the mean tensile strength at 0.02 level. Use Fisher's LSD method to compare the pairs of means. What percentage of cotton will lead to the best tensile strength (higher the better). \begin{tabular}{|l|l|l|l|} \hline Observation & Cotton15% & Cotton25% & Cotton35% \\ \hline 1 & 7 & 14 & 7 \\ \hline 2 & 7 & 19 & 10 \\ \hline 3 & 11 & 18 & 15 \\ \hline 4 & 9 & 18 & 11 \\ \hline \end{tabular} A product developer is investigating the tensile strength of a new synthetic fiber used for making clothes. Strength is affected by the percentage of cotton used in the blend of materials used to make synthetic fiber. The company conducts a randomized experiment with 3 levels of cotton content and obtained four observations for each level. We can assume that tensile strength follows a normal distribution, the population variance is the same, and the observations are all independent for all levels of cotton content. Is there evidence to support the claim that the cotton content affects the mean tensile strength at 0.02 level. Use Fisher's LSD method to compare the pairs of means. What percentage of cotton will lead to the best tensile strength (higher the better). \begin{tabular}{|l|l|l|l|} \hline Observation & Cotton15% & Cotton25% & Cotton35% \\ \hline 1 & 7 & 14 & 7 \\ \hline 2 & 7 & 19 & 10 \\ \hline 3 & 11 & 18 & 15 \\ \hline 4 & 9 & 18 & 11 \\ \hline \end{tabular}