Question

Product	Cereal Name	Manufacturer	Calories	Sodium	Fiber	Carbs	Sugars	Cost/box	Weight/OZ	Protein	Cholesterol
53	Rice Chex	Ralston Purina	110	240	0	11	2	2.3	16	2	1
54	Rice Krispies	Kellogg	110	290	0	12	3	2.4	16	2	2
30	Golden Grahams	General Mills	110	280	0	16	9	2.5	16	2	1
64	Trix	General Mills	110	140	0	18	12	1.35	18	2	3
18	Count Chocula	General Mills	110	180	0	21	13	2.8	18	2	2
61	Total Corn Flakes	General Mills	110	200	0	12	3	1.54	14	3	2
39	Kix	General Mills	110	260	0	12	3	2.65	12.5	3	0
48	Puffed Rice	Quaker	50	0	0	13	0	1.8	12	3	2
44	Nut & Honey Crunch	Kellogg	120	190	0	15	9	2.4	14.5	3	0
34	Honey Comb	Post	110	180	0	17	11	3.1	12	3	2
29	Fruity Pebbles	Post	110	135	0	18	12	2.3	13	3	0
41	Lucky Charms	General Mills	110	180	0	19	12	3.1	15.4	3	0
10	Cap'n'Crunch	Quaker	120	220	0	20	12	1.8	18	3	0
12	Cinnamon Toast Crunch	General Mills	120	210	0	15	9	3.3	16	4	1
15	Corn Chex	Ralston Purina	110	280	0	12	3	2.6	14.5	5	0
14	Cocoa Puffs	General Mills	110	180	0	21	13	2.9	14	5	2
20	Cream of Wheat	Nabisco	100	80	1	10	0	3.1	14	1	1
21	Crispix	Kellogg	110	220	1	12	3	2.1	14	1	2
37	Just Right Crunchy Nugget	Kellogg	110	170	1	14	6	3	14	1	2
17	Corn Pops	Kellogg	110	90	1	18	12	2.4	18	2	0
24	Froot Loops	Kellogg	110	125	1	21	13	2.8	14	2	0
49	Puffed Wheat	Quaker	50	0	1	5	0	3	14	3	0
25	Frosted Flakes	Kellogg	110	200	1	17	11	2.4	18	3	0
6	Apple Jacks	Kellogg	110	125	1	21	14	3.1	12	3	0
58	Smacks	Kellogg	110	70	1	23	15	2.54	12.5	3	0
59	Special K	Kellogg	110	230	1	12	3	2	18	4	0
47	Product 19	Kellogg	100	320	1	13	3	2.6	18	4	1
23	Double Chex	Ralston Purina	100	190	1	13	5	3.5	14	4	0
4	Almond Delight	Ralston Purina	110	200	1	15	8	2.3	14	4	0
35	Honey Graham Ohs	Quaker	120	220	1	17	11	1.97	12	4	1
16	Corn Flakes	Kellogg	100	290	1	11	2	1.8	12.5	6	0
67	Wheaties Honey Gold	General Mills	110	200	1	15	8	2	14	6	1
5	Apple Cinn Cheerios	General Mills	110	180	1.50	17	10	3.2	18	2	0
36	Honey Nut Cheerios	General Mills	110	250	1.50	17	10	2.33	14	3	1
45	Oatmeal Raisin Crisp	General Mills	130	170	1.50	17	10	2.3	14.5	4	2
40	Life	Quaker	100	150	2	14	6	2.65	12.5	2	0
11	Cheerios	General Mills	110	290	2	10.50	1	2.2	16	3	0
38	Just Right Fruit &Nut	Kellogg	140	170	2	15	9	2.87	14.3	3	0
22	Crispy Wheat & Raisins	General Mills	100	140	2	16	10	3.6	14	3	0
50	Quaker Oat Squares	Quaker	100	135	2	14	6	2.6	14	5	0
43	Multi-Grain Cheerios	General Mills	100	220	2	14	6	2.3	14.5	5	0
13	Clusters	General Mills	110	140	2	15	7	2.3	18	5	1
7	Basic 4	General Mills	130	210	2	15	8	1.9	14	5	1
52	Raisin Squares	Kellogg	90	0	2	13.50	6	2.3	18	6	0
56	Shredded Wheat	Nabisco	80	0	3	7	0	1.86	14	1	1
33	Great Grains Pecan	Post	120	75	3	13	4	2	14	1	0
31	Grape Nuts Flakes	Post	100	140	3	13	5	1.76	16	1	1
32	Grape-Nuts	Post	110	170	3	11	3	1.94	16.6	2	0
63	Total Whole Grain	General Mills	100	200	3	11	3	3	12.5	2	2
60	Strawberry Fruit Wheels	Nabisco	90	15	3	13	5	3.3	18	2	2
55	Shrdded Wht Spn Size	Nabisco	90	0	3	8	0	1.76	18	3	1
26	Frosted Mini-Whests	Kellogg	100	0	3	14	7	2.4	18	4	1
42	Mueslix Crispy Blend	Kellogg	160	150	3	21	13	1.9	12	4	1
66	Wheaties	General Mills	100	200	3	11.50	3	1.98	14	5	2
65	Wheat Chex	Ralston Purina	100	230	3	12	3	1.65	16.5	5	3
57	Shredded Wheat n Bran	Nabisco	90	0	4	9	0	2.65	14.5	1	1
8	Bran Chex	Ralston Purina	90	200	4	14	6	2.25	14	1	2
19	Cracklin' Oat Bran	Kellogg	110	140	4	15	7	2.7	14	3	1
62	Total Raisin Bran	General Mills	140	190	4	22	14	2	14	4	1
27	Fruit & Fibre	Post	120	160	5	16	10	3.1	14.5	2	1
28	Fruitful Bran	Kellogg	120	240	5	20	12	3.6	14	2	0
9	Bran Flakes	Post	90	210	5	13	5	1.9	14.5	4	1
51	Raisin Bran	Kellogg	120	210	5	20	12	2.6	14.5	5	0
46	Post Nat. Raisin Bran	Post	120	200	6	22	14	2.8	14	3	1
2	AlI-Bran	Kellogg	70	260	9	13	5	3.5	15.4	4	2
1	100% Bran	Nabisco	70	130	10	14	6	3	16	4	1
3	All-Bran w/Extra Fiber	Kellogg	50	140	14	10	0	2.2	14.5

2. Draw appropriate charts of your choice on 7 selected cereal brands for the amount of their Calories, Sugar, and Sodium used in their cereal.

6. Randomly select 30 Cereal Brands as your samples. Describe your sampling method. (EXCEL)

Answer 1

Hi i attach Above charts and data for que2) also find below the table for 7 selected cereal.

Product	Cereal Name	Manufacturer	Calories	Sodium	Fiber	Carbs	Sugars	Cost/box	Weight/OZ	Protein	Cholesterol
64	Trix	General Mills	110	140	0	18	12	1.35	18	2	3
44	Nut & Honey Crunch	Kellogg	120	190	0	15	9	2.4	14.5	3	0
15	Corn Chex	Ralston Purina	110	280	0	12	3	2.6	14.5	5	0
17	Corn Pops	Kellogg	110	90	1	18	12	2.4	18	2	0
59	Special K	Kellogg	110	230	1	12	3	2	18	4	0
35	Honey Graham Ohs	Quaker	120	220	1	17	11	1.97	12	4	1
11	Cheerios	General Mills	110	290	2	10.5	1	2.2	16	3	0

-------------------------------------------------------------------

Ans6)

give nuberind to our data like 1 ,2 3 ...and so on

there are total 64 observation in our data set and we want to select 30 out of 64.

type = randbetween(1,64)

and drop down the cursor upto 30 cell so this is our 30 random generated number . now select take data corresponding to this 30 generated no. from nuberig data. you can do this wih using vlookup.

Inthis way i got data as below, if you use this function in youe excel file you get different data , as excel take different random sample each time.

Product	Cereal Name	Manufacturer	Calories	Sodium	Fiber	Carbs	Sugars	Cost/box	Weight/OZ	Protein	Cholesterol
53	Rice Chex	Ralston Purina	110	240	0	11	2	2.3	16	2	1
54	Rice Krispies	Kellogg	110	290	0	12	3	2.4	16	2	2
54	Rice Krispies	Kellogg	110	290	0	12	3	2.4	16	2	2
18	Count Chocula	General Mills	110	180	0	21	13	2.8	18	2	2
61	Total Corn Flakes	General Mills	110	200	0	12	3	1.54	14	3	2
39	Kix	General Mills	110	260	0	12	3	2.65	12.5	3	0
48	Puffed Rice	Quaker	50	0	0	13	0	1.8	12	3	2
48	Puffed Rice	Quaker	50	0	0	13	0	1.8	12	3	2
48	Puffed Rice	Quaker	50	0	0	13	0	1.8	12	3	2
34	Honey Comb	Post	110	180	0	17	11	3.1	12	3	2
41	Lucky Charms	General Mills	110	180	0	19	12	3.1	15.4	3	0
41	Lucky Charms	General Mills	110	180	0	19	12	3.1	15.4	3	0
10	Cap'n'Crunch	Quaker	120	220	0	20	12	1.8	18	3	0
36	Honey Nut Cheerios	General Mills	110	250	1.5	17	10	2.33	14	3	1
14	Cocoa Puffs	General Mills	110	180	0	21	13	2.9	14	5	2
14	Cocoa Puffs	General Mills	110	180	0	21	13	2.9	14	5	2
20	Cream of Wheat	Nabisco	100	80	1	10	0	3.1	14	1	1
21	Crispix	Kellogg	110	220	1	12	3	2.1	14	1	2
21	Crispix	Kellogg	110	220	1	12	3	2.1	14	1	2
6	Apple Jacks	Kellogg	110	125	1	21	14	3.1	12	3	0
35	Honey Graham Ohs	Quaker	120	220	1	17	11	1.97	12	4	1
49	Puffed Wheat	Quaker	50	0	1	5	0	3	14	3	0
25	Frosted Flakes	Kellogg	110	200	1	17	11	2.4	18	3	0
6	Apple Jacks	Kellogg	110	125	1	21	14	3.1	12	3	0
58	Smacks	Kellogg	110	70	1	23	15	2.54	12.5	3	0
59	Special K	Kellogg	110	230	1	12	3	2	18	4	0
47	Product 19	Kellogg	100	320	1	13	3	2.6	18	4	1
23	Double Chex	Ralston Purina	100	190	1	13	5	3.5	14	4	0
7	Basic 4	General Mills	130	210	2	15	8	1.9	14	5	1
35	Honey Graham Ohs	Quaker	120	220	1	17	11	1.97	12	4	1

------------------

Thanks