Ignore this data set please look below there's a more clear version of the same two data sets.
please consider these clear data sets for the posted question :
Problem 2: Actors versus Actresses Earlier in the course we looked at the age of academy award winning best actors and academy award winning best actresses. The question I posed is are best actresses significantly younger than best actors? We can now address this question a) Using the data in the Actor Actress worksheet, let population 1 be the best actress data and population 2 best the best actor data. Find a 95% confidence interval for Xi - X. Interpret the result using a complete sentence: Is their evidence to suggest that best actresses are younger than best actors? b) There are a number of outliers in each data set (remember an outlier is 1.5 times the IQR above 03 or 1.5 times the IQR below Q1. Remove all outliers from both data sets and redo problem a. Does your answer change? c) Are the two data sets best actresses and best actors independent or dependent? Explain Problem 3: Cereal and Shelf Placement The last dataset concerns the placement of cereal on one of three shelves at a grocery store. The category shelf is either 1 = low shelf, 2 = middle shelf or 3 = high shelf. The other category of interest to you is grams of sugar per serving (category sugar) a) Let population one be the cereal of shelf 1 and population 2 be the cereals on shelf 2 and population 3 be the cereals on shelf 3. Calculate a 95% confidence interval for the average grams of sugar per serving for each shelf b) Based on the results from part a what can you conclude comparing the sugar content on each shelf? N 99 IF 19 15 > S 20 15 SP a RE SP 2 SE CE ST 21 TE TE TE 10 CE SE 24 TE 23 9 ST ot R 5 V F G 1 D at pro modum fiber 15 4 cartas 10.5 15 17 10 G 2 200 1 2 Apple Arron Cher Branches 4 Cheerion 5 Cam Cw Com Flak 7 Frobe Flak le Golden 2 2 calore 110 90 110 110 100 110 100 110 110 100 110 su 110 1 2 0 0 0 2 0 1 1 21 14 1 ILS 2 0 neyMeer 10 10 Howych 11 M-Grande 1 2 1 0 1 0 1.5 0 2 0 0 15 zug 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 0 0 0 0 0 0 16 19 0 6 1 3 16 17 17 16 11 12 1 Ricer 14 Shredded W 15 Shredded Wheat 'Wran ... 16 shredded Weapon 17 Special Wheat Ches 19 Whate 20 What Honey Gold 21 Apple 22 CapCrunch 2 auton Tom Crunch 2 Coco Putte I. 25 Com Papa 26count Checus 27 Cream of Whetto) Frost Fred Weals Fry Potter 125 0 2 1 1 0 210 1 2 0 0 1 0 1 1 a 12 13 12 21 0 1 0 1 10 1 1 0 2 14 110 100 100 110 110 120 120 110 110 110 1.00 110 wa 100 110 LID 110 120 ace 110 100 110 LID 100 10 120 wa 120 I 110 90 110 70 120 wa 12 an Cad Gratura 15 12 1 Honey Graham Om 20 wa 1 1 190 12 12 12 Lucky Churma Howy. Ourich 1 1 1 15 19 10 10 1 mach 15 berry Frid_W 15 15 an 12 10 15 14 w 110 sas 130 14 un um in 210 num num 7 7 10 1 20 num 10 --- 110 110 LI 110 100 100 100 120 120 100 100 110 1 3 190 160 12 0 Selange 0 Natural -Gran_with_Datraer and Dette danie ala so Crack Out Bran SIC Clipy What All 5 Des Fruit & Fibre_Db_Walnuts, and Fran . Nuts Flak sa Great Grain Pecan 50th our out Pt Fruit & Nut GL Medaillen Daten & Armand Med Rabin, Peach & Pacar Morphed Nutri-Grain Almond-Railin Nuti-grain What Go Out Parap GT Pont_at_Palin_Bran Product 19 Puffed Rice 70 Puffed Wheat 71 uker Oak Square 72 Ralin_lut_Bran 170 110 1 17 170 170 16 150 150 IGO 150 150 17 0 17 15 115 90 130 120 100 135 140 1 2 2.5 100 100 90 110 140 100 110 74 Total Com Flake Total Porn 70 Total Whole Grain 77 Trip 70 79 12 14 105 15 21 15 16 21 4 1 1 1 1 2 250 0 A B 1 2 Actresses 21 22 3 6 8 9 10 11 12 13 14 15 15 17 18 19 20 21 22 23 24 25 25 27 28 29 30 31 32 33 34 35 36 37 38 39 40 441 43 | 24 24 25 25 25 25 26 26 26 26 27 27 27 27 28 28 28 28 29 29 29 29 29 29 29 30 30 30 31 31 31 32 32 32 33 33 33 33 33 33 34 Actors 29 30 30 31 32 32 32 34 34 34 35 35 36 36 36 37 37 37 37 38 38 38 38 38 39 39 39 40 40 40 41 41 41 41 41 41 42 42 42 42 42 42 43 JK C 43 44 45 46 8 49 50 51 52 53 54 55 56 57 58 59 60 61 52 53 64 55 65 57 58 69 70 71 72 73 74 75 75 77 78 79 80 81 82 83 84 A 33 34 34 34 35 35 35 35 35 35 35 36 37 37 38 38 38 38 39 39 40 41 41 41 41 41 42 42 43 45 45 46 49 50 54 60 61 61 63 74 60 B 42 43 43 43 43 44 44 44 45 45 45 45 46 47 47 47 48 48 49 49 49 50 51 51 52 52 52 52 53 54 56 56 57 57 60 60 60 62 62 62 76 B1 X fx calories A B D E F H fat 2 fiber 1.5 sugars 10 1 4 6 2 2 0 protein 2 2 6 2 2 1 2 3 1 shelf 1 1 1 1 1 1 1 0 0 0 1 3 2 11 15 10 11 1 1 0 0 1 1 1.5 0 0 1 2 1 2 6 1 1 1 0 0 0 0 3 0 sodium 180 200 290 280 290 200 45 250 180 220 240 290 0 0 0 230 230 200 200 125 220 210 180 90 2 2 3 3 6 0 calories 110 90 110 110 100 110 100 110 110 100 110 110 80 90 90 110 100 100 110 110 120 120 110 110 110 100 110 100 110 4 1 1 1 1 1 1 0 0 1 name 2 Apple_Cinnamon_Cheerios 3 Bran_Chex 4 Cheerios 5 Corn_Chex 6 Corn Flakes 7 Frosted_Flakes 8 Golden_Crisp 9 Honey Nut Cheerios 10 Honey-comb 11 Multi-Grain_Cheerios 12 Rice Chex 13 Rice_Krispies 14 Shredded_wheat 15 Shredded Wheat_'n'Bran 16 Shredded_Wheat_spoon_size 17 Special_K 18 Wheat Chex 19 Wheaties 20 Wheaties_Honey_Gold 21 Apple_Jacks 22 Cap'n'Crunch 23 Cinnamon_Toast_Crunch 24 Cocoa_Puffs 25 Corn_Pops 26 Count_Chocula 27 Cream_of_Wheat_(Quick) 28 Froot_Loops 29 Frosted_Mini-Wheats 30 Fruity_Pebbles 31 Golden_Grahams 32 Honey_Graham_Ohs 33 Kix 34 Life 35 Lucky_Charms 36 Maypo 37 Nut&Honey_Crunch 38 Raisin_Bran 39 Smacks 40 Strawberry_Fruit_Wheats 41 Trix 42 100%_Bran 43 100%_Natural_Bran 1 1 carbo 10.5 15 17 22 21 14 11 11.5 14 15 23 22 16 19 20 16 17 17 16 11 12 13 12 13 12 21 11 14 13 15 12 21 12 12 3 1 3 3 1 1 0 3 3 2 2 1 1 1 1 1 0 2 3 1 0 0 2 3 0 0 0 3 3 3 8 14 12 9 13 12 13 0 13 7 12 9 11 3 6 12 3 1 1 0 0 1 0 1 1 3 0 1 1 3 2 3 1 1 1 2 0 1 110 1 0 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 1 2 1 2 180 80 125 0 135 280 220 260 150 180 0 190 210 70 15 140 130 15 0 2 0 2 1 1 0 16 120 110 100 110 100 120 120 110 90 110 70 120 1 0 5 1 2 3 2 2 1 4 1 1 0 1 3 15 14 9 15 13 5 8 12 15 5 12 6 8 2 1 0 10 2 3 5 A B D E F G - H 10 5 6 2 1 5 1 0 2 8 7 8 5 0 8 3 3 3 3 8 9 14 1 2 5 2 2 8 3 3 3 3 0 2 3 4 0 1 2 3 4 4 2 3 3 3 3 2 2 2 3 3 3 3 3 2 3 1 5 42 100%_Bran 43 100%_Natural_Bran 44 All-Bran 45 All-Bran_with_Extra_Fiber 46 Almond_Delight 47 Basic_4 48 Bran_Flakes 49 Clusters 50 Cracklin_Oat_Bran 51 Crispix 52 Crispy_Wheat_&_Raisins 53 Double_Chex 54 Fruit_&_Fibre_Dates, Walnuts,_and_Oat: 55 Fruitful Bran 56 Grape_Nuts_Flakes 57 Grape-Nuts 58 Great_Grains_Pecan 59 Just_Right_Crunchy_Nuggets 60 Just_Right_Fruit_&_Nut 61 Muesli_Raisins,_Dates,_&_Almonds 62 Muesli_Raisins, Peaches,_&_Pecans 63 Mueslix_Crispy_Blend 64 Nutri-Grain_Almond-Raisin 65 Nutri-grain_Wheat 66 Oatmeal_Raisin_Crisp 67 Post_Nat._Raisin_Bran 68 Product_19 69 Puffed_Rice 70 Puffed Wheat 71 Quaker Oat_Squares 72 Raisin_Nut_Bran 73 Raisin_Squares 74 Total_Corn_Flakes 75 Total_Raisin_Bran 76 Total_Whole_Grain 77 Triples 78 1 0 2 0 1 0 3 1 70 120 70 50 110 130 90 110 110 110 100 100 120 120 100 110 120 110 140 150 150 160 140 90 130 120 100 50 50 100 100 90 110 140 100 110 130 15 260 140 200 210 210 140 140 220 140 190 160 240 140 170 75 170 170 95 150 150 220 170 170 5 5 7 7 3 10 5 10 12 5 3 4 6 9 1 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 2 3 3 3 3 3 1.5 6 14 18 13 13 10 21 11 18 12 14 15 17 13 17 20 16 16 17 21 18 13.5 11 20 13 10 14 10.5 15 21 15 16 21 3 3 2 2 0 2 1 4 3 3 3 3 3 200 3 0 1 3 1 0 0 1 2 2 11 11 13 7 2 10 14 3 0 0 6 8 6 3 14 3 3 2.5 320 0 0 135 140 0 200 190 200 250 2 0 1 2 0 1 1 1 m N N mm N 2 0 3 3 3 3 3 3 3 3 3 3 0 1 Problem 2: Actors versus Actresses Earlier in the course we looked at the age of academy award winning best actors and academy award winning best actresses. The question I posed is are best actresses significantly younger than best actors? We can now address this question a) Using the data in the Actor Actress worksheet, let population 1 be the best actress data and population 2 best the best actor data. Find a 95% confidence interval for Xi - X. Interpret the result using a complete sentence: Is their evidence to suggest that best actresses are younger than best actors? b) There are a number of outliers in each data set (remember an outlier is 1.5 times the IQR above 03 or 1.5 times the IQR below Q1. Remove all outliers from both data sets and redo problem a. Does your answer change? c) Are the two data sets best actresses and best actors independent or dependent? Explain Problem 3: Cereal and Shelf Placement The last dataset concerns the placement of cereal on one of three shelves at a grocery store. The category shelf is either 1 = low shelf, 2 = middle shelf or 3 = high shelf. The other category of interest to you is grams of sugar per serving (category sugar) a) Let population one be the cereal of shelf 1 and population 2 be the cereals on shelf 2 and population 3 be the cereals on shelf 3. Calculate a 95% confidence interval for the average grams of sugar per serving for each shelf b) Based on the results from part a what can you conclude comparing the sugar content on each shelf? N 99 IF 19 15 > S 20 15 SP a RE SP 2 SE CE ST 21 TE TE TE 10 CE SE 24 TE 23 9 ST ot R 5 V F G 1 D at pro modum fiber 15 4 cartas 10.5 15 17 10 G 2 200 1 2 Apple Arron Cher Branches 4 Cheerion 5 Cam Cw Com Flak 7 Frobe Flak le Golden 2 2 calore 110 90 110 110 100 110 100 110 110 100 110 su 110 1 2 0 0 0 2 0 1 1 21 14 1 ILS 2 0 neyMeer 10 10 Howych 11 M-Grande 1 2 1 0 1 0 1.5 0 2 0 0 15 zug 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 0 0 0 0 0 0 16 19 0 6 1 3 16 17 17 16 11 12 1 Ricer 14 Shredded W 15 Shredded Wheat 'Wran ... 16 shredded Weapon 17 Special Wheat Ches 19 Whate 20 What Honey Gold 21 Apple 22 CapCrunch 2 auton Tom Crunch 2 Coco Putte I. 25 Com Papa 26count Checus 27 Cream of Whetto) Frost Fred Weals Fry Potter 125 0 2 1 1 0 210 1 2 0 0 1 0 1 1 a 12 13 12 21 0 1 0 1 10 1 1 0 2 14 110 100 100 110 110 120 120 110 110 110 1.00 110 wa 100 110 LID 110 120 ace 110 100 110 LID 100 10 120 wa 120 I 110 90 110 70 120 wa 12 an Cad Gratura 15 12 1 Honey Graham Om 20 wa 1 1 190 12 12 12 Lucky Churma Howy. Ourich 1 1 1 15 19 10 10 1 mach 15 berry Frid_W 15 15 an 12 10 15 14 w 110 sas 130 14 un um in 210 num num 7 7 10 1 20 num 10 --- 110 110 LI 110 100 100 100 120 120 100 100 110 1 3 190 160 12 0 Selange 0 Natural -Gran_with_Datraer and Dette danie ala so Crack Out Bran SIC Clipy What All 5 Des Fruit & Fibre_Db_Walnuts, and Fran . Nuts Flak sa Great Grain Pecan 50th our out Pt Fruit & Nut GL Medaillen Daten & Armand Med Rabin, Peach & Pacar Morphed Nutri-Grain Almond-Railin Nuti-grain What Go Out Parap GT Pont_at_Palin_Bran Product 19 Puffed Rice 70 Puffed Wheat 71 uker Oak Square 72 Ralin_lut_Bran 170 110 1 17 170 170 16 150 150 IGO 150 150 17 0 17 15 115 90 130 120 100 135 140 1 2 2.5 100 100 90 110 140 100 110 74 Total Com Flake Total Porn 70 Total Whole Grain 77 Trip 70 79 12 14 105 15 21 15 16 21 4 1 1 1 1 2 250 0 A B 1 2 Actresses 21 22 3 6 8 9 10 11 12 13 14 15 15 17 18 19 20 21 22 23 24 25 25 27 28 29 30 31 32 33 34 35 36 37 38 39 40 441 43 | 24 24 25 25 25 25 26 26 26 26 27 27 27 27 28 28 28 28 29 29 29 29 29 29 29 30 30 30 31 31 31 32 32 32 33 33 33 33 33 33 34 Actors 29 30 30 31 32 32 32 34 34 34 35 35 36 36 36 37 37 37 37 38 38 38 38 38 39 39 39 40 40 40 41 41 41 41 41 41 42 42 42 42 42 42 43 JK C 43 44 45 46 8 49 50 51 52 53 54 55 56 57 58 59 60 61 52 53 64 55 65 57 58 69 70 71 72 73 74 75 75 77 78 79 80 81 82 83 84 A 33 34 34 34 35 35 35 35 35 35 35 36 37 37 38 38 38 38 39 39 40 41 41 41 41 41 42 42 43 45 45 46 49 50 54 60 61 61 63 74 60 B 42 43 43 43 43 44 44 44 45 45 45 45 46 47 47 47 48 48 49 49 49 50 51 51 52 52 52 52 53 54 56 56 57 57 60 60 60 62 62 62 76 B1 X fx calories A B D E F H fat 2 fiber 1.5 sugars 10 1 4 6 2 2 0 protein 2 2 6 2 2 1 2 3 1 shelf 1 1 1 1 1 1 1 0 0 0 1 3 2 11 15 10 11 1 1 0 0 1 1 1.5 0 0 1 2 1 2 6 1 1 1 0 0 0 0 3 0 sodium 180 200 290 280 290 200 45 250 180 220 240 290 0 0 0 230 230 200 200 125 220 210 180 90 2 2 3 3 6 0 calories 110 90 110 110 100 110 100 110 110 100 110 110 80 90 90 110 100 100 110 110 120 120 110 110 110 100 110 100 110 4 1 1 1 1 1 1 0 0 1 name 2 Apple_Cinnamon_Cheerios 3 Bran_Chex 4 Cheerios 5 Corn_Chex 6 Corn Flakes 7 Frosted_Flakes 8 Golden_Crisp 9 Honey Nut Cheerios 10 Honey-comb 11 Multi-Grain_Cheerios 12 Rice Chex 13 Rice_Krispies 14 Shredded_wheat 15 Shredded Wheat_'n'Bran 16 Shredded_Wheat_spoon_size 17 Special_K 18 Wheat Chex 19 Wheaties 20 Wheaties_Honey_Gold 21 Apple_Jacks 22 Cap'n'Crunch 23 Cinnamon_Toast_Crunch 24 Cocoa_Puffs 25 Corn_Pops 26 Count_Chocula 27 Cream_of_Wheat_(Quick) 28 Froot_Loops 29 Frosted_Mini-Wheats 30 Fruity_Pebbles 31 Golden_Grahams 32 Honey_Graham_Ohs 33 Kix 34 Life 35 Lucky_Charms 36 Maypo 37 Nut&Honey_Crunch 38 Raisin_Bran 39 Smacks 40 Strawberry_Fruit_Wheats 41 Trix 42 100%_Bran 43 100%_Natural_Bran 1 1 carbo 10.5 15 17 22 21 14 11 11.5 14 15 23 22 16 19 20 16 17 17 16 11 12 13 12 13 12 21 11 14 13 15 12 21 12 12 3 1 3 3 1 1 0 3 3 2 2 1 1 1 1 1 0 2 3 1 0 0 2 3 0 0 0 3 3 3 8 14 12 9 13 12 13 0 13 7 12 9 11 3 6 12 3 1 1 0 0 1 0 1 1 3 0 1 1 3 2 3 1 1 1 2 0 1 110 1 0 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 1 2 1 2 180 80 125 0 135 280 220 260 150 180 0 190 210 70 15 140 130 15 0 2 0 2 1 1 0 16 120 110 100 110 100 120 120 110 90 110 70 120 1 0 5 1 2 3 2 2 1 4 1 1 0 1 3 15 14 9 15 13 5 8 12 15 5 12 6 8 2 1 0 10 2 3 5 A B D E F G - H 10 5 6 2 1 5 1 0 2 8 7 8 5 0 8 3 3 3 3 8 9 14 1 2 5 2 2 8 3 3 3 3 0 2 3 4 0 1 2 3 4 4 2 3 3 3 3 2 2 2 3 3 3 3 3 2 3 1 5 42 100%_Bran 43 100%_Natural_Bran 44 All-Bran 45 All-Bran_with_Extra_Fiber 46 Almond_Delight 47 Basic_4 48 Bran_Flakes 49 Clusters 50 Cracklin_Oat_Bran 51 Crispix 52 Crispy_Wheat_&_Raisins 53 Double_Chex 54 Fruit_&_Fibre_Dates, Walnuts,_and_Oat: 55 Fruitful Bran 56 Grape_Nuts_Flakes 57 Grape-Nuts 58 Great_Grains_Pecan 59 Just_Right_Crunchy_Nuggets 60 Just_Right_Fruit_&_Nut 61 Muesli_Raisins,_Dates,_&_Almonds 62 Muesli_Raisins, Peaches,_&_Pecans 63 Mueslix_Crispy_Blend 64 Nutri-Grain_Almond-Raisin 65 Nutri-grain_Wheat 66 Oatmeal_Raisin_Crisp 67 Post_Nat._Raisin_Bran 68 Product_19 69 Puffed_Rice 70 Puffed Wheat 71 Quaker Oat_Squares 72 Raisin_Nut_Bran 73 Raisin_Squares 74 Total_Corn_Flakes 75 Total_Raisin_Bran 76 Total_Whole_Grain 77 Triples 78 1 0 2 0 1 0 3 1 70 120 70 50 110 130 90 110 110 110 100 100 120 120 100 110 120 110 140 150 150 160 140 90 130 120 100 50 50 100 100 90 110 140 100 110 130 15 260 140 200 210 210 140 140 220 140 190 160 240 140 170 75 170 170 95 150 150 220 170 170 5 5 7 7 3 10 5 10 12 5 3 4 6 9 1 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 2 3 3 3 3 3 1.5 6 14 18 13 13 10 21 11 18 12 14 15 17 13 17 20 16 16 17 21 18 13.5 11 20 13 10 14 10.5 15 21 15 16 21 3 3 2 2 0 2 1 4 3 3 3 3 3 200 3 0 1 3 1 0 0 1 2 2 11 11 13 7 2 10 14 3 0 0 6 8 6 3 14 3 3 2.5 320 0 0 135 140 0 200 190 200 250 2 0 1 2 0 1 1 1 m N N mm N 2 0 3 3 3 3 3 3 3 3 3 3 0 1
