Solve each of the non-parametric test exercises with Excel:

1. An advertising agency is researching what types of ads pay more attention to the teenagers. 11 children are observed, 6 are shown advertisements about food and the remaining 5 they are shown advertisements about drinks. All notices have a similar duration. The attention span (in seconds) of the 11 children. The data is summarized below:

Type of ads	B	C	B	B	B	B	C	C	C	C	C
Sorted data	23	25	28	30	35	38	41	42	45	47	50

Apply a non-parametric test to determine if there are statistically significant differences significant between both groups. If there are any, say which is the group of notices to which the children lend greater attention. Show the whole procedure. Calculate the statistic, and draw conclusions.

2. A sample of 82 Institute students and another with 46 have been randomly selected. students from private centers and the note in Physical Education has been considered for each one from them. The data obtained are summarized in the following contingency table.

	Insuf	Suf or Good	Notable	Very Good	Total
Private Center	7	14	17	9	47
Institute	30	32	17	3	82
	37	46	34	12	129

We want to test the hypothesis that the distribution of grades in Physical Education is independent of the type of educational center

3. A zoologist wants to determine if testosterone levels are different in three strains roosters (Hampton, 1994, p. 147). The child data:

Strain A	439	568	134	897	229	329
Strain B	103	115	098	126	115	120
Strain C	107	099	102	105	089	110

Apply a test that allows the zoologist to test your hypothesis. Draw conclusions and draw the region of rejection. Calculate the p-value of the test.

4. The effectiveness of advertising for two rival products (Brands X and Y) were compared. HE did market research at a local mall, where participants were given displays an advertisement for two rival coffee brand products, which they will rate on a scale from 1 (I will definitely NOT buy the product) to 10 (definitely YES I will buy the product). Half of the participants were shown an advertisement for a product while the other half that of the other product. The data obtained are the following:

Brand X Brand Y

Participant	Rating	Participant	Rating
1	3	1	9
2	4	2	7
3	2	3	5
4	6	4	10
5	2	5	6
6	5	6	8

Apply a hypothesis test to determine if both brands have the same acceptance. in case if not, indicate which brand is more accepted. Draw conclusions. Calculate the test statistic. Graph of the rejection region. Calculate the p-value of the test (p-value).