Statistic problems

QBA337Exam2WorkingPapersFA20201.xls

Home >Mathematics homework help >Statistics homework help >Statistic problems

Problem 1


	Problem 1
	You work for a major Sporting Goods Retailer, and are responsible for evaluation of personnel. There are employees of different years of service “Less than 1 Year”, “1 to 2 Years”, “3 to 5 Years” and “Over 5 Years”. Management wants to investigate the “Invoicing Department” employee’s subjective evaluations by Department Managers. Managers had been required to turn in evaluations ranking employees by performance groups of, “Below Average”, “Average”, and “Above Average”. Assume you sampled data from 80 employee evaluations.
	We want to be 90% confident about the independence of "Managers Employee Ratings" with the different “Employee Years of Service”. Be prepared to answer questions about a hypothesis of your findings. Show your work. Make your calculations in this Excel spreadsheet and attach back to the blackboard location.
			Actual		Years of Service
			Manager Ranking		Less Than 1 Year	1 to 2 Years	3 to 5 Years	Over 5 Years
			Average		10	8	6	2
			Outstanding		8	8	8	8
			Exceptional		2	4	6	10
		X2 Table
			Area in Upper Tail
		Degrees of Freedom	0.995	0.99	0.975	0.95	0.9	0.1	0.05	0.025	0.01	0.005
		1	0.0000	0.0002	0.0010	0.0039	0.0158	2.7055	3.8415	5.0239	6.6349	7.8794
		2	0.0100	0.0201	0.0506	0.1026	0.2107	4.6052	5.9915	7.3778	9.2103	10.5966
		3	0.0717	0.1148	0.2158	0.3518	0.5844	6.2514	7.8147	9.3484	11.3449	12.8382
		4	0.2070	0.2971	0.4844	0.7107	1.0636	7.7794	9.4877	11.1433	13.2767	14.8603
		5	0.4117	0.5543	0.8312	1.1455	1.6103	9.2364	11.0705	12.8325	15.0863	16.7496
		6	0.6757	0.8721	1.2373	1.6354	2.2041	10.6446	12.5916	14.4494	16.8119	18.5476
		7	0.9893	1.2390	1.6899	2.1673	2.8331	12.0170	14.0671	16.0128	18.4753	20.2777
		8	1.3444	1.6465	2.1797	2.7326	3.4895	13.3616	15.5073	17.5345	20.0902	21.9550
		9	1.7349	2.0879	2.7004	3.3251	4.1682	14.6837	16.9190	19.0228	21.6660	23.5894
		10	2.1559	2.5582	3.2470	3.9403	4.8652	15.9872	18.3070	20.4832	23.2093	25.1882
		11	2.6032	3.0535	3.8157	4.5748	5.5778	17.2750	19.6751	21.9200	24.7250	26.7568
		12	3.0738	3.5706	4.4038	5.2260	6.3038	18.5493	21.0261	23.3367	26.2170	28.2995
Show your work below this area. Then attach back to where you downloaded this spreadsheet in BlackBoard.

Problem 2


	Problem 2
	You work for a major Sporting Goods Retailer as a clothing buyer. You are considering developing a durable store brand of hunting clothes to market. Three different fabrics weaves (Denim, Twill, and Canvas) have been selected for testing.
	In order to test the durability the of these weaves, 5 different fiber blends were created. Each fabric weave was created in each of these fiber blends: 65 Pol/35 Cot, 45 Pol/35 Cot/20 Ray, 50 Cot/50 Pol, 75 Cot/25 Pol, 100 Cot. Each of the weaves by fiber blend was tested using a rub test (Martindale Abrasion Test). Each item was mechanically rubbed and when the fabric started to ware the test stopped and the number of rubs were recorded below. The design is randomized using two factors of weave and blend. Discussion was to block on different fiber blends, because the blend may have a different effect that cannot be controlled. We want to be 95% confident about our conclusions
	.
	Are the three fabrics equally durable? Be prepared to answer any questions concerning this problem. Make your calculations in this Excel spreadsheet and attach back to the blackboard location.
			# of Rubs in 000
		Fiber	Denim	Twill	Canvas
		65/35 Poly/Cotton	18	17	19
		45/35/20 Poly/Cotton/Rayon	12	13	15
		50/50 Cotton/Poly	19	20	18
		75/25 Cotton/Poly	20	21	19
		100 Cotton	25	24	22
Show your work below this area. Then attach back to where you downloaded this spreadsheet in BlackBoard.