Question

What excel codes would one need to complete the following functions?

From the original sample of 100 data values you generated (including any outliers), create a new data column and label it as Measles. Use the following criteria to define the measles percent as either low, mid or high.

Low	Measles immunization is 60 percent or younger
Mid	Measles immunization is between 60 and 90 excluding endpoints
High	Measles immunization is 90 percent and more

Answer 1

in column A= sample No.

column B= Measles

column C=measles percent

In cell C2 below formulae

=IF(B2<0.6,"LOW",IF(B2>0.9,"High","Mid"))

NO	Measles	measles percent
1	0.226424735	LOW=IF(B2<0.6,"LOW",IF(B2>0.9,"High","Mid"))
2	0.157284477	LOW
3	0.602069104	Mid
4	0.854921984	Mid
5	0.916435669	High
6	0.646335907	Mid
7	0.648411497	Mid
8	0.594022377	LOW
9	0.87713427	Mid
10	0.37376562	LOW
11	0.458470962	LOW
12	0.499297665	LOW
13	0.68924998	Mid
14	0.758372267	Mid
15	0.210103149	LOW
16	0.177148581	LOW
17	0.396066427	LOW
18	0.695011637	Mid
19	0.547205955	LOW
20	0.537493203	LOW
21	0.952000562	High
22	0.023243284	LOW
23	0.726077225	Mid
24	0.460714862	LOW
25	0.488979779	LOW
26	0.227830975	LOW
27	0.251018795	LOW
28	0.108124385	LOW
29	0.415588467	LOW
30	0.727487602	Mid
31	0.599042305	LOW
32	0.285520737	LOW
33	0.620042243	Mid
34	0.179177936	LOW
35	0.863120861	Mid
36	0.417113581	LOW
37	0.789727509	Mid
38	0.234013921	LOW
39	0.807477421	Mid
40	0.653099476	Mid
41	0.127030934	LOW
42	0.07065674	LOW
43	0.018685953	LOW
44	0.811562673	Mid
45	0.674758806	Mid
46	0.951317776	High
47	0.58486144	LOW
48	0.618627303	Mid
49	0.762594556	Mid
50	0.724765911	Mid
51	0.247014725	LOW
52	0.691309672	Mid
53	0.459113071	LOW
54	0.083758481	LOW
55	0.020676937	LOW
56	0.34317289	LOW
57	0.882284067	Mid
58	0.345914213	LOW
59	0.309518215	LOW
60	0.178722064	LOW
61	0.342040297	LOW
62	0.936576435	High
63	0.843351278	Mid
64	0.941231229	High
65	0.966953746	High
66	0.962891481	High
67	0.406761789	LOW
68	0.604274379	Mid
69	0.600526175	Mid
70	0.8429802	Mid
71	0.662996579	Mid
72	0.072191405	LOW
73	0.201457628	LOW
74	0.065136423	LOW
75	0.996665894	High
76	0.846881918	Mid
77	0.547702001	LOW
78	0.010955008	LOW
79	0.917905235	High
80	0.68546425	Mid
81	0.988215907	High
82	0.28414439	LOW
83	0.328919901	LOW
84	0.590063874	LOW
85	0.674776673	Mid
86	0.028369399	LOW
87	0.44429167	LOW
88	0.827366064	Mid
89	0.855388886	Mid
90	0.51421615	LOW
91	0.731810245	Mid
92	0.663635792	Mid
93	0.702559627	Mid
94	0.096048616	LOW
95	0.635230482	Mid
96	0.664860043	Mid
97	0.408388281	LOW
98	0.209617399	LOW
99	0.093132456	LOW
100	0.709528429	Mid