PloTTdockDFH&MWinTxEncdDC3DcCncdCCFnTbFnIOArialTxEnTPdcKCmpTPdcKCntDsCnDCCnJCmRf &CDNdCDclCDSrDCMd)AtRfDCco P(2DColKCmpDCmp DCol Collection 1KCntDsCn_ClCnJCmRfInSt-CoIn ?UUUUUUCDNdCDScCollJ cerealCDNdCDScCDHlClCsAuAtLsCCsAAttrCsAtCCsAnamePrLsSPrLCCsAAttrCsAtCCsAmfrPrLsSPrLCCsAAttrCsAtCCsAtypePrLsSPrLCCsAAttr!CsAtCCsAcaloriesPrLsSPrLCCsAAttr CsAtCCsAproteinPrLsSPrLCCsAAttrCsAtCCsAfatPrLsSPrLCCsAAttrCsAtCCsAsodiumPrLsSPrLCCsAAttrCsAtCCsAfiberPrLsSPrLCCsAAttrCsAtCCsAcarboPrLsSPrLCCsAAttrCsAtCCsAsugarsPrLsSPrLCCsAAttrCsAtCCsApotassPrLsSPrLCCsAAttr!CsAtCCsAvitaminsPrLsSPrLCCsAAttrCsAtCCsAshelfPrLsSPrLCCsAAttrCsAtCCsAweightPrLsSPrLCCsAAttrCsAtCCsAcupsPrLsSPrLCCsAAttrCsAtCCsAratingPrLsSPrLCCsAAttr#CsAtCCsA self_categPrLsSPrLif[id[equal[(**)string[(**)"shelf"],num[1,"1"]]],string[(**)q"lower"],if[id[equal[(**)string[(**)"shelf"],num[2,"2"]]],string[(**)q"middle"],string[(**)q"upper"]]]CCmAAttr CmAt*CCmADisplay PrLsSPrLAtLsCCmAAttrCmAtzCCmAOriginPrLsSPrLAtLsnCCsAAttrCsAtCCsAxPrLsSPrLCCsAAttrCsAtCCsAyPrLsSPrLCCmAAttr CmAt&CCmAPicturePrLsSPrLAtLsCCsAAttrCsAtCCsAimagePrLsSPrLCCsAAttrCsAtCCsAxPrLsSPrLCCsAAttrCsAtCCsAyPrLsSPrLCCsAAttrCsAtCCsAwidthPrLsSPrLCCsAAttrCsAtCCsAheightPrLsSPrLCCmAAttr!CmAtCCmA_CaptionPrLsSPrLAtLsCCsAAttr CsAtCCsAcaptionPrLsSPrLstring[(**)"name"]CCsAAttrCsAtCCsAxPrLsSPrLCCsAAttrCsAtCCsAyPrLsSPrLCDNdCDScCDHlABHmCAAtLsA8HCAtAttrCsAtHCAtmnamePrLsSPrLGnCAHmCDGnCAYM  100% Bran 100% Natural BranAll-Bran All-Bran with Extra Fiber Almond Delight Apple Cinnamon Cheerios  Apple JacksBasic 4  Bran Chex  Bran Flakes  Cap'n'CrunchCheerios Cinnamon Toast CrunchClusters  Cocoa Puffs  Corn Chex  Corn Flakes  Corn Pops  Count Chocula Cracklin' Oat Bran Cream of Wheat (Quick)Crispix Crispy Wheat & Raisins  Double Chex  Froot Loops Frosted Flakes Frosted Mini-Wheats &Fruit & Fibre Dates; Walnuts; and Oats  Fruitful Bran Fruity Pebbles  Golden Crisp Golden Grahams Grape Nuts Flakes  Grape-Nuts Great Grains Pecan Honey Graham Ohs Honey Nut Cheerios  Honey-comb Just Right Crunchy Nuggets Just Right Fruit & Nut Kix Life  Lucky Charms Maypo  Muesli Raisins; Dates; & Almonds !Muesli Raisins; Peaches; & Pecans Mueslix Crispy Blend Multi-Grain Cheerios Nut&Honey Crunch Nutri-Grain Almond-Raisin Nutri-grain Wheat Oatmeal Raisin Crisp Post Nat. Raisin Bran  Product 19  Puffed Rice  Puffed Wheat Quaker Oat Squares Quaker Oatmeal  Raisin Bran Raisin Nut Bran Raisin Squares  Rice Chex  Rice Krispies Shredded Wheat Shredded Wheat 'n'Bran Shredded Wheat spoon size Smacks  Special K Strawberry Fruit Wheats Total Corn Flakes Total Raisin Bran Total Whole GrainTriples Trix  Wheat ChexWheaties Wheaties Honey GoldHCAtAttrCsAtHCAtmfrPrLsSPrLGnCAHmCDGnCAMNQKKRGKGRPQGGGGRKKGKNKGRKKKPKPPGPPPQGPKKGQGARRKGKKKGPKQQQQKGKRKNNNKKNGGGGGRGGHCAtAttrCsAtHCAttypePrLsSPrLGnCAHmCDGnCAMCCCCCCCCCCCCCCCCCCCCHCCCCCCCCCCCCCCCCCCCCCCHCCCCCCCCCCCCCHCCCCCCCCCCCCCCCCCCCHCAtAttr!CsAtHCAtcaloriesPrLsSPrLGnCAHmCDGnCAMFxF2nnnZZxnxnnndnnndnddnndxxndndnxxnnnndnddxZxd22ddxdZnnPZZnnZndnnddnHCAtAttr CsAtHCAtproteinPrLsSPrLGnCAHmCDGnCAMHCAtAttrCsAtHCAtfatPrLsSPrLGnCAHmCDGnCAMHCAtAttrCsAtHCAtsodiumPrLsSPrLGnCAHmCDGnCAM}""ZP}-K_@"FHCAtAttrCsAtHCAtfiberPrLsSPrLGnCAHmCDGnCAM  ???@@HCAtAttrCsAtHCAtcarboPrLsSPrLGnCAHmCDGnCAM@%                @'  @+   @%  HCAtAttrCsAtHCAtsugarsPrLsSPrLGnCAHmCDGnCAM                         HCAtAttrCsAtHCAtpotassPrLsSPrLGnCAHmCDGnCAM@JFd}#i-i7#AxPd(-UZd-Z#<_(_7_Z(Zx-2nnn#_x(7Z#n<sn@2 H{@Ia|<@3ծ]@D3:}@6E @Da@Ff @A2~M4@6e?pX@D9q\c%@P"* 8@Grvlm@B,@F*Y}I׺@@ @?o0c@M,-@Dua@DP@<a@AP $@7@J @J}(I%@FOT@5 D5@?|57@< @BC gP7i+=@D B¤@=.@DX.@MH{R@>sjrdj@B똕_@Ds*@N`G,|@O1f@HT@Ij"O@C-^T@C @KevG@D Z@DGJDǰ@Qf'|@RDB@R3Pzk@?:ѦPa@J9@MR|@Ck|y1@<2@GTU :@C׿@;U J@Hm3 @I@BHCAtAttr#CsAtHCAt self_categPrLsSPrLFrCAHmCDFrCAMif[id[equal[(**)string[(**)"shelf"],num[1,"1"]]],string[(**)q"lower"],if[id[equal[(**)string[(**)"shelf"],num[2,"2"]]],string[(**)q"middle"],string[(**)q"upper"]]]SApCAttr CmAtFxCAGmCmAppCSApCDisplay PrLsSPrLAtLsOrGeAttrCmAtOrGeOriginPrLsSPrLAtLsHCAtAttrCsAtHCAtxPrLsSPrLRelCHmCDNCsDRelCpM@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@V@b@i@p@@@VHCAtAttrCsAtHCAtyPrLsSPrLRelCHmCDNCsDRelCpM@8@8@8@8@8@Q@Q@Q@Q@Q@\@\@\@\@\@c@c@c@c@c@i@i@i@i@i@n@n@n@n@n@r@r@r@r@r@t@t@t@t@t@w@w@w@w@w@z@@z@@z@@z@@z@@}@}@}@}@}@@@@@@@@@@@@@@@@@@@@@@@@@@`@`IcGeAttr CmAt ;FxCAGmCmIcGePicturePrLsSPrLAtLs /HCAtAttrCsAtHCAtimagePrLsSPrLGnCAHmCDGnCAM`````````````````````````````````````````````````````````````````````````````HCAtAttrCsAtHCAtxPrLsSPrLRelCHmCDNCsDRelCpMHCAtAttrCsAtHCAtyPrLsSPrLRelCHmCDNCsDRelCpMHCAtAttrCsAtHCAtwidthPrLsSPrLRelCHmCDNCsDRelCpM@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0HCAtAttrCsAtHCAtheightPrLsSPrLRelCHmCDNCsDRelCpM@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0CpGeAttr!CmAtFxCAGmCmCpGe"_CaptionPrLsSPrLAtLsHCAtAttr CsAtHCAt7captionPrLsSPrLFrCAHmCDFrCA#Mstring[(**)"name"]HCAtAttrCsAtHCAtxPrLsSPrLRelCHmCDNCsDRelCpMHCAtAttrCsAtHCAtyPrLsSPrLRelCHmCDNCsDRelCpM@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ Arial@& MClOrMMThngCmThxAtLskThngAttr Thng3Comment PrLsSPrL /Imported from C:\Users\MK\Downloads\cereal.csv.CtSLCDNdCDclCDFlDCOrClOrDCOrAbIM$INMd.?UUUUUUTnkCKCmpDCmpTnkCPlot 1KCntDsCnTPCnCmRf &TPmdCDNdCDScCDHlHmCAAtLsTPsh?MixusletMixuAtRfSepasletSepaAtRf self_categ TPdgTPdg? lowerlower middlemiddle upperupperY@I@d@? BinLsletBinLAtRf(SepasletSepajAtRf calories2TPdrTPdgTPdr9 @D40-59@N60-79@T80-99@Y100-119@^120-139@a140-159@d160-179@f180-199@i200-220@I@d@D@k?@4 \z@I@d@? StacsletStacAtRf$ZCKeyEsletKeyE"AtRfn?02O?0X?Kw|M?q-marSsletmarSAtRfnMisVsletMisVAtRf@CirciConCircAtRfaxtlAXISaxtcaxtl7calories?@I@d@4@I@daxtcAXISaxtc self_categ?AtRfAtRfimagCDNdCDclCDFlCDNdCDclCDFl,CDlf}&string[(**)"__LocalFilterAttribute__"]CDNdCDScCDHl\HmCAAtLsRHCAtAttr1CsAtHCAt__LocalFilterAttribute__PrLsSPrLGnCAHmCDGnCAMMTblCKCmpDCmp TblC Case Table 1KCntDsCnTbCnCmRf &CTmdTablSNTbHlTbGm4TGhtdbl runl@iI$I%@NN@4CTslDAtRfnameAtRfmfrAtRftypeAtRf caloriesAtRfproteinAtRffatAtRfsodiumAtRffiberAtRfcarboAtRfsugarsAtRfpotassAtRf vitaminsAtRfshelfAtRfweightAtRfcupsAtRfratingAtRf self_categ@4@4CDNdCDclCDFlCDNdCDclCDSrCmRf &textKCmptextKCntTxCnzBreakfast cereal variables: cereal name [name] manufacturer (e.g., Kellogg's) [mfr] type (cold/hot) [type] calories (number) [calories] protein(g) [protein] fat(g) [fat] sodium(mg) [sodium] dietary fiber(g) [fiber] complex carbohydrates(g) [carbo] sugars(g) [sugars] display shelf (1, 2, or 3, counting from the floor) [shelf] potassium(mg) [potass] vitamins & minerals (0, 25, or 100, respectively indicating 'none added'; 'enriched, often to 25% FDA recommended'; '100% of FDA recommended') [vitamins] weight (in ounces) of one serving (serving size) [weight] cups per serving [cups] Manufacturers are represented by their first initial: A=American Home Food Products, G=General Mills, K=Kelloggs, N=Nabisco, P=Post, Q=Quaker Oats, R=Ralston Purina) The value -1 indicates missing data. cereal from 1993.expo https://lib.stat.cmu.edu/datasets/1993.expo/ >MfsS textKCmptextKCntTxCn What are you getting when you eat a bowl of cereal? Can you get a lot of fiber without a lot of calories? Can you describe what cereals are displayed on high, low, and middle shelves? The good news is that none of the cereals for which we collected data had any cholesterol, and manufacturers rarely use artificial sweeteners and colors,nowadays. However, there is still a lot of data for the consumer to understand while choosing a good breakfast cereal. Here are some facts about nutrition that might help you in your analysis. Nutritional recommendations are drawn from the references at the end of this document: * Adults should consume between 20 and 35 grams of dietary fiber per day. * The recommended daily intake (RDI) for calories is 2200 for women and 2900 for men. * Calories come in three food components. There are 9 calories per gram of fat, and 4 calories per gram of carbohydrate and protein. * Overall, in your diet, no more than 10% of your calories should be consumed from simple carbohydrates (sugars), and no more than 30% should come from fat. The RDI of protein is 50 grams for women and 63 grams for men. The balance of calories should be consumed in the form of complex carbohydrates (starches). * The average adult with no defined risk factors or other dietary restrictions should consume between 1800 and 2400 mg of sodium per day. * The type and amount of milk added to cereal can make a significant difference in the fat and protein content of your breakfast. One possible task is to develop a graphic that would allow the consumer to quickly compare a particular cereal to other possible choices. Some additional questions to consider, and try to answer with effective graphics: * Can you find the correlations you might expect? Are there any surprising correlations? * What is the true "dimensionality" of the data? * Are there any cereals which are virtually identical? * Is there any way to discriminate among the major manufacturers by cereal characteristics, or do they each have a "balanced portfolio" of cereals? * Do the nutritional claims made in cereal advertisements stand the scrutiny of data analysis? * Are there cereals which are clearly nutritionally superior, or inferior? Are there clusters of cereals? * Is a ranking or scoring scheme possible or reasonable, and if so, are there cereals which are nutritionally superior or inferior under all reasonable weighting schemes?  >MfsS textKCmptextKCntTxCnahttps://fdc.nal.usda.gov/$>MfsS SFmsColFCmpFPdspFFltFColF@T@Ifram@u@,CmRf &CTbFCmpFPdspFFltFCTbF@yP@d fram@$@|pCmRf &TxtFCmpFPTxtF@x@tpfram@P@CmRf &TxtFCmpFPTxtF@x@cfram@P@hCmRf &TnkFCmpFPdspFFltFTnkF@(@hfram@@CmRf &DCdFCmpFPdspFDCdF@@ypfram@ @,CmRf &TxtFCmpFPTxtF@i @@fram@@CmRf & !