# Use excel solving the following problems

Description

Use excel solving the following problems and transfer the answer into printable version.

25.
23. Fusible interlinings are being used with increasing fre-
quency to support outer fabrics and improve the shape and
drape of various pieces of clothing. The article
“Compatibility of Outer and Fusible Interlining
Fabrics in Tailored Garments” (Textile Res. J., 1997:
137–142) gave the accompanying data on extensibility
(%) at 100 gm/cm for both high-quality (H) fabric and
poor-quality (P) fabric specimens.
H 1.2 .9 .7 1.0 1.7 1.7 1.1
.9
1.7
1.9 1.3 2.1 1.6 1.8 1.4 1.3 1.9 1.6
.8 2.0 1.7 1.6 2.3 2.0
P 1.6 1.5 1.1 2.1 1.5 1.3 1.0 2.6
Construct normal probability plots to verify the plau-
sibility of both samples having been selected from
normal population distributions.
b. Construct a comparative boxplot. Does it suggest
that there is a difference between true average
extensibility for high-quality fabric specimens and
that for poor-quality specimens?
c. The sample mean and standard deviation for the high-
quality sample are 1.508 and .444, respectively, and
those for the poor-quality sample are 1.588 and .530.
Use the two-sample t test to decide whether true aver-
age extensibility differs for the two types of fabric.
36. Consider the accompanying data on breaking load
(kg/25 mm width) for various fabrics in both an
Effect of Wet Abrasive Wear on the Tensile Properties
of Cotton and Polyester-Cotton Fabrics,” J. Testing
and Evaluation, 1993: 84–93). Use the paired t test, as
did the authors of the cited article, to test Ho: MD
versus H : Mp> 0 at significance level .01.
I
C
=
Fabric
1
2
3
4
5
6
7
8
I
(
U
A
36.4
28.5
55.0
20.0
51.5
46.0
38.7
34.5
43.2
36.5
48.8
52.5
25.6
26.5
49.8
46.5