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.

A study was conducted to understand how American college stu…

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is greater than $820 at 0.02 level of significance? 1h) Given the problem description and based on statistical theory, the “sampling distribution of Xbar” will approximate to a ________________.

A study was conducted to understand how American college stu…

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is greater than $820 at 0.02 level of significance? 1l) What kind of Hypothesis Test is this one?

A study was conducted to understand how American college stu…

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is greater than $820 at 0.02 level of significance? 1n) What is the numerical value of the “Test Statistic” in this problem (approximated to two digits after the decimal)?

A study was conducted to understand how American college stu…

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is greater than $820 at 0.02 level of significance? 1m) What is the desired Type-I error for this Hypothesis Test?

A study was conducted to understand how American college stu…

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is greater than $820 at 0.02 level of significance? 1g) Based on the problem description, the problem is a ________________.

A study was conducted to understand how American college stu…

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is greater than $820 at 0.02 level of significance? 1e) Based on the problem description, this hypothesis testing problem is a ________________.

A study was conducted to understand how American college stu…

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is greater than $820 at 0.02 level of significance? 1d) Based on the given problem description, it is safe to assume that the shape of the population distribution is ________________.