LEADER 05302nam 22006851 450 001 9910464267003321 005 20200520144314.0 010 $a1-118-83986-2 010 $a1-118-66148-6 035 $a(CKB)3710000000057606 035 $a(EBL)1527439 035 $a(OCoLC)862611724 035 $a(SSID)ssj0001155641 035 $a(PQKBManifestationID)11618739 035 $a(PQKBTitleCode)TC0001155641 035 $a(PQKBWorkID)11187821 035 $a(PQKB)11289045 035 $a(MiAaPQ)EBC1527439 035 $a(CaSebORM)9781118661468 035 $a(Au-PeEL)EBL1527439 035 $a(CaPaEBR)ebr10799629 035 $a(CaONFJC)MIL576406 035 $a(EXLCZ)993710000000057606 100 $a20131107h20142014 uy 0 101 0 $aeng 135 $aurunu||||| 181 $ctxt 182 $cc 183 $acr 200 10$aData smart $eusing data science to transform information into insight /$fJohn W. Foreman 205 $a1st edition 210 1$aIndianapolis :$cWiley,$d[2014] 210 4$dİ2014 215 $a1 online resource (434 p.) 300 $aDescription based upon print version of record. 311 $a1-118-66146-X 320 $aIncludes bibliographical references and index. 327 $aCover; Title Page; Copyright; Contents; Chapter 1 Everything You Ever Needed to Know about Spreadsheets but Were Too Afraid to Ask; Some Sample Data; Moving Quickly with the Control Button; Copying Formulas and Data Quickly; Formatting Cells; Paste Special Values; Inserting Charts; Locating the Find and Replace Menus; Formulas for Locating and Pulling Values; Using VLOOKUP to Merge Data; Filtering and Sorting; Using PivotTables; Using Array Formulas; Solving Stuff with Solver; OpenSolver: I Wish We Didn't Need This, but We Do; Wrapping Up 327 $aChapter 2 Cluster Analysis Part I: Using K-Means to Segment Your Customer Base Girls Dance with Girls, Boys Scratch Their Elbows; Getting Real: K-Means Clustering Subscribers in E-mail Marketing; Joey Bag O' Donuts Wholesale Wine Emporium; The Initial Dataset; Determining What to Measure; Start with Four Clusters; Euclidean Distance: Measuring Distances as the Crow Flies; Distances and Cluster Assignments for Everybody!; Solving for the Cluster Centers; Making Sense of the Results; Getting the Top Deals by Cluster; The Silhouette: A Good Way to Let Different K Values Duke It Out 327 $aHow about Five Clusters? Solving for Five Clusters; Getting the Top Deals for All Five Clusters; Computing the Silhouette for 5-Means Clustering; K-Medians Clustering and Asymmetric Distance Measurements; Using K-Medians Clustering; Getting a More Appropriate Distance Metric; Putting It All in Excel; The Top Deals for the 5-Medians Clusters; Wrapping Up; Chapter 3 Naive Bayes and the Incredible Lightness of Being an Idiot; When You Name a Product Mandrill, You're Going to Get Some Signal and Some Noise; The World's Fastest Intro to Probability Theory; Totaling Conditional Probabilities 327 $aJoint Probability, the Chain Rule, and Independence What Happens in a Dependent Situation?; Bayes Rule; Using Bayes Rule to Create an AI Model; High-Level Class Probabilities Are Often Assumed to Be Equal; A Couple More Odds and Ends; Let's Get This Excel Party Started; Removing Extraneous Punctuation; Splitting on Spaces; Counting Tokens and Calculating Probabilities; And We Have a Model! Let's Use It; Wrapping Up; Chapter 4 Optimization Modeling: Because That "Fresh Squeezed" Orange Juice Ain't Gonna Blend Itself; Why Should Data Scientists Know Optimization? 327 $aStarting with a Simple Trade-Off Representing the Problem as a Polytope; Solving by Sliding the Level Set; The Simplex Method: Rooting around the Corners; Working in Excel; There's a Monster at the End of This Chapter; Fresh from the Grove to Your Glass...with a Pit Stop Through a Blending Model; You Use a Blending Model; Let's Start with Some Specs; Coming Back to Consistency; Putting the Data into Excel; Setting Up the Problem in Solver; Lowering Your Standards; Dead Squirrel Removal: The Minimax Formulation; If-Then and the "Big M" Constraint 327 $aMultiplying Variables: Cranking Up the Volume to 11 330 $aData Science gets thrown around in the press like it's magic. Major retailers are predicting everything from when their customers are pregnant to when they want a new pair of Chuck Taylors. It's a brave new world where seemingly meaningless data can be transformed into valuable insight to drive smart business decisions. But how does one exactly do data science? Do you have to hire one of these priests of the dark arts, the ""data scientist,"" to extract this gold from your data? Nope. Data science is little more than using straight-forward steps to process raw data into actionable insight. 606 $aData mining 606 $aWeb sites$xDesign 606 $aWeb usage mining 608 $aElectronic books. 615 0$aData mining. 615 0$aWeb sites$xDesign. 615 0$aWeb usage mining. 676 $a006.312 700 $aForeman$b John W$091588 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910464267003321 996 $aData smart$92174324 997 $aUNINA