statistic 5

QBA337test4WorkingPapers1.xlsx

Problem 1

Bronson Clothing Manufacturing needs to reduce the number of lines presented for the spring season. They currently have two lines of coordinated sportswear and they need to determine which line would be best to produce. They invite 15 major company buyers, during spring showing, to determine if there is a preference for the two different clothing lines. Both have the same procuction cost. The buyers are provided note sheets for each of the lines as well as a card to evaluate the preference. We want to be 95% certain about our decision.
Show your work on this spreadsheet for this problem.
Subject	Description	Code
1	Line 1	+
2	No Preference
3	Line 2	-
4	No Preference
5	Line 1	+
6	Line 1	+
7	Line 1	+
8	Line 2	-
9	No Preference
10	Line 2	-
11	Line 1	+
12	Line 1	+
13	Line 1	+
14	No Preference
15	No Preference

Bronson Clothing Manufacturing needs to reduce the number of lines presented for the spring season. The VP of Merchandising does not beleive that the small sample size of 15 buyers is enough to represent the entire country and requested that the test be repeated at the next showing of the lines. The next buying office showing will contain 50 buyers from different size companies. She beleives that the mix and number of buyers will provide a better understanding of the preference of the two lines of coordinated sportswear. The buyers are provided note sheets for each of the lines as well as a card to evaluate the preference. We want to be 95% certain about our decision.
Show your work on this spreadsheet for this problem.
Subject	Description	Code
1	Line 2	-
2	No Preference
3	Line 1	+
4	Line 1	+
5	Line 1	+
6	No Preference
7	Line 2	-
8	No Preference
9	Line 1	+
10	Line 1	+
11	Line 1	+
12	Line 2	-
13	No Preference
14	Line 2	-
15	Line 1	+
16	Line 1	+
17	Line 1	+
18	No Preference
19	Line 2	-
20	Line 1	+
21	Line 1	+
22	Line 1	+
23	Line 1	+
24	Line 2	-
25	Line 1	+
26	Line 1	+
27	Line 2	-
28	Line 2	-
29	No Preference
30	No Preference
31	Line 1	+
32	Line 2	-
33	Line 1	+
34	Line 2	-
35	Line 2	-
36	Line 1	+
37	Line 1	+
38	Line 1	+
39	Line 1	+
40	Line 1	+
41	Line 1	+
42	Line 1	+
43	Line 2	-
44	Line 2	-
45	Line 2	-
46	Line 1	+
47	Line 1	+
48	Line 1	+
49	Line 1	+
50	Line 2	-

Bronson Clothing Manufacturing needs to identify the best method for production of the spring jacket in the clothing line. There are 10 workers producing the jacket. The designer beleives method 1 is best and the patern maker beleives method 2 is the best. The production workers record the following production for each method (one day production for each method). Prove which method is the best?
Show your work on this spreadsheet for this problem.
		Method
	Worker	1	2	Difference
	1	100	95
	2	950	990
	3	93	87
	4	105	102
	5	98	104
	6	103	95
	7	107	106
	8	100	100
	9	113	108
	10	107	101

Bronson Clothing Manufacturing needs to identify the best fabric for production of the spring jacket in the clothing line. There are 3 fabrics that are evaluated using a rub testing procedure to determine durability of the fabricc. There is not a preference for any of the three fabrics. Is there a significant difference among the three fabrics?
Show your work on this spreadsheet for this problem.
Fabric Evaluation Ratings
Fabric A	Fabric B	Fabric C
640	550	700
500	640	730
590	500	680
630	510	590
590	580	690
710	470	720
	650	670

Bronson Clothing Manufacturing needs the input from the selling staff on the new clothing line they are responsible to sell. Using the past 2 years of spring product line unit sales by salesperson to help identify if there is an association between the salesperson opinion and prior actual sales.
Show your work on this spreadsheet for this problem.
Selling Staff Product Evaluation (1 to 5 Likert Scale)							Selling Staff Prior Years Unit Sales
n	Salesperson	Color	Fabric	Style	Total	Rank	n	Salesperson	Unit Sales	Rank
1	A	2	1	3	6		1	A	500
2	B	3	3	3	9		2	B	450
3	C	4	4	4	12		3	C	400
4	D	1	1	1	3		4	D	390
5	E	4	4	3	11		5	E	385
6	F	3	2	3	8		6	F	450
7	G	5	5	4	14		7	G	325
8	H	5	5	5	15		8	H	350
9	I	3	2	2	7		9	I	310
10	J	4	3	3	10		10	J	490