Book Description
The emphasis of the text is on data analysis, modeling, and spreadsheet use in statistics and management science. This text contains professional Excel software add-ins. The authors maintain the elements that have made this text a market leader in its first edition: clarity of writing, a teach-by-example approach, and complete Excel integration.
Customer Reviews:
Managerial Statistics Text book.......2006-11-03
It was the text book the professor wanted me to buy.
It was good.
Sanjay Chheda.......2006-10-06
The book is very good with really good explanations and examples on descriptive analysis and inferential analysis.
Better Title: Intro to Statistics using Excel Add-ins.......2001-06-04
On the positive side, this book has many excellent case studies and examples. It is well written and interesting. However, I was disappointed, as I was expecting use of Excel to rigorously solve decision making and data analysis problems. The focus of the book is mostly traditional statistics solved using a group of commercial add-ins for Excel. If this is what you want, then the book would get five stars. However, for data analysis and decision making, I think a more thorough treatment using Excel without relying so much on the add-ins would have been appropriate.
Serious Excel 2000 Problem.......2001-04-12
The text book is great. I have many of Winston's other books and they are all great. The Palisade stuff works just fine. However, the StatPro Addin that accompanies this text does not work with MS Excel 2000. I contacted the IT guy that the authors directed me to--he was stumped. He just gave up and suggested I return my book for a refund because he could not figure out it out. Again, the book is great but the StatPro Addin sucks!
No trouble with Excel.......2001-01-31
I find the text and software a useful set of tools. It assumes familiarity with basic statistics and Excel, and builds on them to develop a powerfull ability to analize data and make decisions from it. I experienced no trouble with the software install or operation.
Book Description
This applied book for engineers and scientists, written in a non-theoretical manner, focuses on underlying principles that are important in a wide range of disciplines. It emphasizes the interpretation of results, the presentation and evaluation of assumptions, and the discussion of what should be done if the assumptions are violated. Integration of spreadsheet and statistical software complete this treatment of statistics.
Chapter topics include describing and summarizing data; probability and discrete probability distributions; continuous probability distributions and sampling distributions; process control charts; estimation procedures; hypothesis testing; the design of experiments; and simple linear and multiple regression models.
For individuals interested in learning statistics—without a high level of mathematical sophistication.
Customer Reviews:
Very Practical Book.......2003-11-30
I have found this book to be very useful with practical examples and case studies. I felt that as an engineer I needed to know how to use software(to save time)along with the formulas that work in it.This book satisfies that, using a very common software EXCEL..what could be better than this.
I strongly recommend this book for a high level course in statistics.
Good for first edition.......2002-05-10
I used this textbook for a course in statistics. I must say that it was better then the first time that I had taken statistics 5 years ago. The book uses one or two data sets per chapter that helps you focus your thoughts while learning the different techniques. A nice feature about this book that wasnt available 5 years ago is the Excel and Minitab examples which saves a lot of time that is ordinarly spent on copious number crunching. I would have given the book 5 stars, however I found some obvious errors in the book that should have been edited out before the release. Good starter book for sats.
Book Description
Learn more effective modeling techniques than ever before! VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS USING MICROSOFT ® EXCEL shows you the easy way to automate methods and models and create special applications. You'll learn sophisticated techniques through a simple and clean interface, so there's no more long nights of trying to make it work. And because it works with Microsoft ® Excel, you'll be saving time while the program crunches all the numbers.
Customer Reviews:
Aimed at a very specific audience: avoid if you are not a management scientist!.......2006-07-10
I am a little surprised at the high rating that this book seems to get from the current 13 reviewers but, then again, these are probably memebers of the books target audience. When Albright refers to "modelers" in his title he is constraining the definition very tightly to those in the business world who develop models for "management science". This book has little to do with the more general concept of modelling as it might be found in the physical sciences, engingineering, the social sciences and anything else you can think of outside of management science.
What is good about this book is that it provides a fairly basic introduction to VBA in the first part in a nicely laid out fashion. It then goes on to develop example code targeted very specifically at the management science student or professional. I think this is an admirable approach and this book is probably very useful to the "management scientist" who wishes to learn VBA as it is implemented in Microsoft Excel. It is also quite nicely written. I think that within its target market this is a book that could be recommended. However, if you are not into business modelling or don't make extensive use of the Solver Add-In that ships with Microsoft Office then this book is probably not for you.
Again, I wish to emphasise that this book is very tightly focused on a particular type of VBA developer: i.e. the "management science" specialist who makes extensive use of spreadsheets. As I said, the introduction to VBA programming is well laid out but there are better texts and this one is really very basic (excuse the pun). The scope of the book is not broad so don't expect to learn a lot about much of VBA that does not fall within the fairly narrow constraints of business modelling.
For a general introduction to VBA programming that is far more wide reaching than this book try one of the editions of Walkenbachs "Power Programming with VBA". If you are already competent in VBA or VB programming and want a good reference book on VBA with excellent examples and a very far reaching scope then there is nothing better than the Wrox books by Bullen et al: my "Excel 2002 VBA" serves as an irreplacable reference bible even after 4 years and an upgrade to Excel itself.
I am not a "management science" professional. I have been developing a number of fairly extensive specialist VBA Add-Ins as a scientist/engineer for several years now and I can honestly say that this book taught me nothing new. I didn't actually find anything wrong in any of the text or code that I studied but from my point of view the code examples are highly repetetive and very simple (definitely aimed at the novice VBA programmer). Possibley a great book for management scientists wanting to learn VBA but others can find far better in terms of both introductory texts and advanced programming texts.
For mangement scientists wanting to learn VBA I would give this five stars but for all other Excel users, or potential users, of VBA I can only give it one star.
Gets your creative juices flowing!.......2005-04-14
The biggest problem that I see with learning VBA is not trying to figure out topics such as object hierarchy, syntax, or "if" statements (there are plenty of excellent VBA guides for that!) No, figuring out what to do with all of the "stuff" you just learned is the bigger challenge.
That is where Mr. Albright's book really stands out. While the first few chapters do provide some basic treatment of VBA, it's the other half of this book that really shines! Here you will find 16 full-blown programs that cover everything from industrial applications (process blending, product mix, production scheduling, etc.) to financial analysis programs (stock trading, portfolio optimization, etc) and much more.
In these 16 chapters is where you will learn to use all that "stuff." And not only use it, but get creative with it. Mr. Albright has done a brilliant job at not only walking through the code step-by-step, but also imparting to the reader the all important "why component." After spending some time with this book, you will undoubtedly be a better technical, and equally important, creative programmer.
Tells you just what you need to know.......2004-11-11
This book is excellent for the person who simply wants to expand their ability to use Excel without becoming a VBA expert. Most books on VBA seem to be written for computer professionals who, for example, seem to want to know about every data type that can be handled before learning anything else. Most of us would rather just learn how to do the things we need to do. This book uses this much more useful route (for ordinary folks)and tells us how to do the basic kind of stuff that we need to do (and that isn't at all obvious how to do): Key topics are accessing data in a range of a worksheet, outputting data to a range, writing a function, etc. etc. It only tells you what you need to know and it explains it all clearly. I had banged my head against a wall before finding this book and it answered all my questions and dissipated all my frustrations. I've recommended it to many of my friends.
Excellent.......2004-09-22
Many Excel VBA books are a bunch of clever examples that you won't be able to apply to anything. This is the only book I have found with good examples about how to move around a spreadsheet using VBA. For some reason this is left out of most books.
Excellent Book. More then satisfied !!!.......2004-07-02
Absolutely agree with Mr.Weiqin Xie. I took this book from corporative library with intention to get help for my first degree completion project in Industrial management, where I really needed to increase my productivity in processing a lot of data,
and just can't bring it back extending my holding over and over again. I have already ordered it and waiting for delivery. I not only successfully completed the project but started to develop useful utilities in my job and decision support application for my investments needs and all of this owing to just few first chapters.
Customer Reviews:
Keeping it Simple.......2005-08-11
The layout of the book is simple, straightforward, and easy to follow. The editors included lots of "white space" which a book of this nature requires ... it keeps you from feeling overwhelmed. The interactive nature of the exercises and the explanations and diagrams are nicely organized. The book itself is very light and easy to carry around. Overall, I found it to be very accessible, and I would recommend it to others as a great resource.
Buy only if you already know statistics.......2000-03-04
I had hoped this book would explain the statistical techniques themselves before jumping into how to use Excel, which is all it really does. If you already know statistics (which I did not) and don't know Excel (which I did) this will help. If the reverse is true, keep looking.
First-class piece of work........1999-05-07
From a reviewer: I teach mathematics/statistics in the Education dept at Liverpool John Moores University, England. I have been asked by the publication 'Teaching Statistics' to review your recent book on Statistics with Excel.
I would like to congratulate you on this first class piece of work. I have felt for some time that the profession is too hung up with the usefulness of dedicated stats packages. Too often I believe, statistics departments believe that the costlier the package, then the better it is. Untrue!
Not as good as I hoped it would be........1999-01-12
I read this book, hoping to recommend it to my stat students. The exercises and examples were easy to follow, _but_ there was not enough explanation of the examples that were given.
For example, rather than just show how to do an analysis of probability, I wished for more of the "nuts and bolts" of the analysis.
I was disappointed. Even though the price of this book is relatively low, I would not recommend this to beginning students of statistics. The front section on using Excel seemed OK, but I didn't pay attention to it, as it was not needed for my classes.
Average customer rating:
- Textbook
- Best Math text I have read
- Excellent beginner and expert book for Applied Statistics
- Great book
|
Applied Statistics (with Microsoft Excel and CD-ROM)
Gerald Keller
Manufacturer: Duxbury Press
ProductGroup: Book
Binding: Hardcover
 Decision-Making & Problem Solving
| Management & Leadership
| Business & Investing
| Subjects
| Books
Office
| Certification Central
| Computers & Internet
| Subjects
| Books
General
| Certification Central
| Computers & Internet
| Subjects
| Books
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Science
| Subjects
| Books
General
| Mathematics
| Science
| Subjects
| Books
Probability & Statistics
| Applied
| Mathematics
| Science
| Subjects
| Books
Statistics
| Applied
| Mathematics
| Professional Science
| Professional & Technical
| Subjects
| Books
Software
| Information Systems
| Computer Science & Information Systems
| New & Used Textbooks
| Stores
| Books
Statistics
| Mathematics
| Sciences
| New & Used Textbooks
| Stores
| Books
General
| Mathematics
| Sciences
| New & Used Textbooks
| Stores
| Books
General
| Business & Finance
| New & Used Textbooks
| Stores
| Books
General
| Economics
| Business & Finance
| New & Used Textbooks
| Stores
| Books
Quantitative Business
| Business & Finance
| New & Used Textbooks
| Stores
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Business & Investing
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Professional
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Science
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
Quality Control, Seventh Edition
-
Total Quality Management (3rd Edition)
-
Practical Experiment Designs : for Engineers and Scientists, 3rd Edition
-
Principles of Quality Costs: Principles, Implementation, and Use
-
App Stats W/Ms Excel Ssm
ASIN: 0534371124 |
Book Description
Gerald Keller's new APPLIED STATISTICS WITH MICROSOFT® EXCEL integrates Excel into the general introductory statistics course. Keller, the co-author of the market-leading STATISTICS FOR MANAGEMENT AND ECONOMICS, Fifth Edition, incorporates his proven three-step problem-solving process throughout this book. The first step, "Identify," is the work a statistician does before the calculations are performed, which entails organizing the experiment, gathering the data, and deciding which statistical techniques to employ. The second step, "Compute," is the computation with Excel. In this step, Keller shows the manual calculation for the simplest of techniques only. For example, he describes how to calculate the sample mean, variance, and standard deviation, how to compute the z-interval estimate of, and the z-test of. The third step, "Interpret," is the interpretation of the computer output, which requires an understanding of statistical concepts.
Customer Reviews:
Textbook.......2007-09-06
I really just had to take the class to finish my masters. The book explains the theories behind the formulas. Having an instructor was very help to understand it all.
Best Math text I have read.......2007-07-10
I have a large library of math texts from many years in school and I have never read one that was so much fun. This book is really interesting and practical. Finally a statistics book that does more than scare the wit out of somebody. I would highly recommend that more professors choose this book for their students.
Excellent beginner and expert book for Applied Statistics.......2007-02-11
I have used this book in my classroom for the last 3 years and found it very illustrative and simple for students to comprehend statistics. It covers theory with practical examples and therefore keeps it 'real' for students. I have used other books in the past, but students found them theoretical and 'brain show-offs' by authors who really did not care for student comprehensions unless they were math majors. This book is far different and even beginner students can easily relate to the hundreds of practical examples that the author provides.
The Excel examples are easy to follow and my science students usually pick up many practical models from these examples. The regression covered at the beginning level in Chapter 3 is fully covered in multiple regressions in Chapters 17 &18 in a way that makes it easy to teach...
Of the 40-60 stats books I have in my office, this is by far my favorite....
Dr. Bjarne Berg
Assistant Professor Lenoir-Rhyne College
School of Math and Computer Science
Great book.......2005-09-28
Incredibly useful book, easy to use. Contains all the Excel information you will even need in a basic statistics class.
Book Description
Learn how to develop models for classification, prediction, and customer segmentation with the help of Data Mining for Business Intelligence
In today's world, businesses are becoming more capable of accessing their ideal consumers, and an understanding of data mining contributes to this success. Data Mining for Business Intelligence, which was developed from a course taught at the Massachusetts Institute of Technology's Sloan School of Management, and the University of Maryland's Smith School of Business, uses real data and actual cases to illustrate the applicability of data mining intelligence to the development of successful business models.
Featuring XLMiner, the Microsoft Office Excel add-in, this book allows readers to follow along and implement algorithms at their own speed, with a minimal learning curve. In addition, students and practitioners of data mining techniques are presented with hands-on, business-oriented applications. An abundant amount of exercises and examples are provided to motivate learning and understanding.
Data Mining for Business Intelligence:
* Provides both a theoretical and practical understanding of the key methods of classification, prediction, reduction, exploration, and affinity analysis
* Features a business decision-making context for these key methods
* Illustrates the application and interpretation of these methods using real business cases and data
This book helps readers understand the beneficial relationship that can be established between data mining and smart business practices, and is an excellent learning tool for creating valuable strategies and making wiser business decisions.
Customer Reviews:
An Excellent Introduction, Works with Excel.......2007-03-19
Data mining is the extraction of useful information from large amounts of data. Perhaps the best example of this is Amazon. If you go to Amazon to look at a book, you'll find such tidbits of information as a section on the page headlined 'Customers who bought this item also bought' and another 'What do customers ultimately buy after viewing this item?'
That's datamining, dozens or hundreds, or thousands of people looked at the page about this item. Then they went on to take these other actions. Among all the data that Amazon has collected they mine their database and pull out information to fill in these blocks.
This book, intended for MBA level students gives an excellent introduction to data mining. It further includes access to an Excel add-in called XLMiner that is specifically set up to allow the student to use Excel to learn how data mining is done.
The one thing I would ask the authors to do in their next edition is to provide a brief review of the commercially available data mining software products that are available. If not all of the software, perhaps just the top half dozen or so. In real life we aren't going to use Excel for data mining, our data resides in a database somewhere.
Condensed Discussion of DataMining.......2007-02-10
This book discusses some of the techniques used
in Data Mining.
It goes into Data Exploration as well as Evaluating
Classification and Predictive Performance.
Some of the more advanced techniques such as
Neural Nets and Cluster Analysis are
also discussed.
To learn more about database design and relational data modeling visit
[...]
From the authors:.......2007-01-27
This book got its start as notes for a data mining class that one of us (Nitin Patel) was teaching at MIT, and was completed while another of us (Galit Shmueli) was teaching a similar course at Maryland. Both courses were part of an MBA program. We found that, while there are a lot of books on data mining, there were none that actually gave business students the skills and tools to implement data mining algorithms. So we set ourselves the task of writing a book that (1) provides real data sets with a business decision-making context and a hands-on orientation , (2) provides a theoretical and practical understanding of the key data mining methods of classification, prediction, data reduction and exploration at a level that is appropriate and useful for MBA's, and (3) bundles a powerful version of a commercial data mining tool that works in Excel (XLMiner). For this reason, we think our book will be appropriate not just for students, but also for business analysts with a quantitative orientation, on, indeed, anyone who wants to learn data mining via self-study. Have we succeeded? You be the judge! - P. Bruce (for G. Shmueli and N. Patel)
Book Description
This popular best-selling book shows students and professionals how to do data analysis with Microsoft Excel. DATA ANALYSIS WITH MICROSOFT EXCEL teaches students and professionals the fundamental concepts of statistics and how to use Microsoft Excel to solve the kind of data-intensive problems that arise in business and elsewhere. Even students with no previous experience using spreadsheets will find that this text's step-by-step approach, extensive tutorials, and examples make it easy to learn how to use Excel for analyzing data. A CD-ROM is included with every new text that contains the StatPlus add-ins for Microsoft Excel and data sets for exercises.
Customer Reviews:
Worth it for the Disk.......2007-04-11
I have just recieved this Book, and have yet to delve into the text, but a brief review of the functionality provided on the the CD proves the purchase is worth it. Box Plots, Stem and leaf diagrams, Dtat point labeling and Scatterplot matrix alone is worth the price of the book
Good resource.......2006-12-22
I had this book for an undergraduate web-based distance learning course.
It provided good explanations, both of the excel function, and what was going on mathematically.
Very easy to find information.
StatPlus is a good addin. The interactive elements on distributions was also very helpful.
Very thorough text for both beginning and intermediate level users of Excel.
Outstanding, practical resource.......2005-02-02
Each of us on our data analysis team were given this book and have used the StatPlus add-ins to create control charts for various processes that we report on, with great success. The add-ins will work in Office Excel 2003 as well. Our company has seen substantially increased productivity and success as a result of the analyses that we are able to do with this book.
No Support Whatsoever.......2004-08-04
I have to say this book really does an okay job providing ways to use Excel for data analysis. But if you have ANY problems with their Add-Ins not working, the support people will just tell you it's an Excel problem...duh! Buy this book if you trust their Add-Ins will work on your computer. But if you encounter problems that you can't solve via the Microsoft help function, don't expect any help from the support that's promised in the back of the book. They'll just tell you to have your instructor figure it out.
A review by a statistics class (XP edition).......2003-10-18
I use this book as the main text book for the first half of a class in statistics and research methods for students from a wide variety of social science and humanities backgrounds, with little formal statistics or mathematics background.
I surveyed my students with 5 questions about the book, with responses on a Likert scale (1=strongly disagree, 3=neutral, 5=strongly aggree. 17 students responded, which is a small enough sample size to caution applicability of results. The mean value of each response appears after the questions I asked.
1.The book was, overall, helpful in explaining statistical concepts. (Mean=2.73). Students would have appreciated more explanation and examples.
2.The book helped me to analyze data. (Mean=2.3)
3.The StatPlus AddIn was, overall, helpful in analyzing data. (Mean=3.76)
4.The StatPlus AddIn worked well on my computer. (Mean=3.7)
5.Overall, I would recommend this book to next year's class. (Mean=3.05)
Thus, overall, weighting each question equally, my students gave the book 3.12 stars.
As a professor, I give the book 4 stars. The organization of the book chapters fit well in an overview course, with one chapter assinged per week. The StatPlus AddIn is worth the cost of the book itself, as it expands the statistical capabilities of Excel without students needing to purchase additional software. There are a wide range of problems and example data sets which come with the book, applicable to a wide range of disciplines. A significant number of students had computer difficulties installing and running the StatPlus AddIn, so I would recommend to the company a support web page with FAQs, at the least.
Students with little preparation in mathematics or statiscs who need a good step-by-step guide to data analysis will find this book helpful, especially if they do the excercises at the end of the chapters. (The publishers should make the answers available to everyone, not just us instructors -- for those working on their own who want to check their work). However, students with some preparation in statistics or mathematics may be better served with a more advanced text.
Book Description
Not only classroom tested, this book has truly been classroom driven. David Gerbing has been teaching this material in his own classes for over 3 years and revising it to better address difficult topics and areas of student confusion. This Excel driven text combines the presentation of content, the illustration of concepts, and multiple opportunities for application throughout the body of each chapter; the author does not wait until the end of the chapter to provide exercises which reinforce the material. He relies heavily on visual examples (line graphs, tables, histograms, screen dumps from Excel, ect.) to explain and support the theoretical material being discussed. The integration of content and exercises allows for more regular practice of statistical principles, ensuring a higher level of student mastery.
Customer Reviews:
Reminded me of my days at Yale............2004-07-12
Before I conceded the bar I went through profound mathematics courses through "Yale's Professor Challenge Program." Dr. Gerbing and his book have brought me back to brilliant years in the statistics classroom; this book brought me up to speed on the innovative computer technology that is premeditated for statistics. I was astounded how thorough this masterpiece is such auxiliary. By extreme, the book went more in depth than the professors at Yale. I would definitely advise this book; it will be sitting on my bookcase in the oval office very shortly.
Much better than expected.......2002-08-16
I bought this book to refresh my memory of the statistics class I took in college and also to master how to use the ubiquitous Excel program for statistical analysis. I was not willing to try any other statistical analysis softwares.
This book exceeded my expectations in both regards. It explains key concepts very well, backed by real-life examples to illustrate their practical aplications using Excel. I have had an easier and more enjoyable time both reviewing my statistics and learning Excel.
Statistics for the rest of us.......2001-06-10
This book accomplishes a great deal - it moves the reader from basic, descriptive statistics to inferential statistics quickly and logically. Each chapter is organized so you can repreat the steps using Excel functions, the Excel Data Analysis Add-in, or using traditional notation. The data are included on a disk, so you don't have to re-key. Also included are Dr. Gerbing's own templates, which include important tools that the Redmond Raiders left out.
I was fortunate enough to have had a course with Dr. Gerbing; I know that he has spent the last five or so years refining his teaching methods, so MBA students can learn AND apply statistics to their business lives. This book is truly a great accomlishment and a contribution to business people who want to use regression analysis - or just have a better understanding of the components that make for solid market research. In an age where we all spend thousands on research studies, it is more than a good idea to know what questions to ask of the syndicated research we're offered, or how to set up the framework for a proprietary study. As a marketing professional, I have found this text very useful. Now - if you can get Gerbing to market the powerpoint slides ...
Book Description
As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet.
Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues.
Aimed primarily at experienced Excel users, the book doesn't spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following:
- Statistics
- Pivot tables
- Workload forecasting
- Modeling
- Measuring quality
- Monitoring complex systems
- Queuing
- Optimizing
- Importing data
If you feel as though you're getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them.
Customer Reviews:
Very Disappointed........2006-12-29
We bought this book back in mid January 2006.
It's been a year since the published date on
January 1, 2006, where are ALL the EXCEL data?
The XL_Applications.zip posted on 28-Aug-2006
on O'Reilly website consists of about 1/3 of
ALL the data/examples in the book.
The book has 12 chapters; however, not a single
chapter is provided with complete EXCEL data/
examples. What XL_Applications.zip contains
are some selected data/examples from chapter 3
to 8. Again, NOT a single chapter is provided
with ALL the EXCEL data/examples used in that
chapter.
I won't recommend this book until O'Reilly takes
"actions" to provide the readers with ALL the
EXCEL data/examples used in this book.
For reading a data analysis book w/o ALL the
data/examples to run it ourselves in EXCEL is
NOT useful at all.
You may wonder, how about type those data in?
No way, because most (if not all) of the data/
examples are very long and can only be shown
"partially" in the figures/screen shots!
Great Book, but where's the data?.......2006-08-05
Overall this is a good book, but it would be much nicer if they provided Excel worksheets with the data used in the book's examples. Some sample code is provided for dowload on Oreilly's website, but this does not include example data. Nonetheless, the book is worth looking at.
VERY VERY HIGHLY RECOMMENDED!!.......2006-06-19
Are you an experienced Excel user? If you are, then this book is for you! Author Gerald Knight, has done an outstanding job of writing a practical guide that shows you how to solve real-world business problems by taking Excel's data analysis features to the max.
Knight, begins by covering averages, trends, correlation, distributions and array formulas. Then, the author examines pivot table basics and ways to modify data to make it work better with pivot tables. Next, he covers the application development process, worksheet organization, and forecasting techniques. The author continues by exploring regression, problem definition, analysis, model construction, and interpretation of results. He also works with statistical process control, X and Y charts, and application design. Knight, then examines data requirements, statistical techniques and logic, application design, and organization. Then, he shows you how to apply formatting, VBA, and logic in an application that measures worker performance in a queuing operation. The author continues the discussion of queuing with another application by focusing on the status of the queue. He also explains how to use Goal Seek and Solver for various kinds of problems. Knight next covers importing from text files, databases, and XML. Then, he examines common problems with dates, numeric information, dealing with data in report form, and equivalence problems. Finally, he covers display design, color combination, dealing with complexity, and visual consideration.
This most excellent book keys directly on the needs of business users. More importantly, this book addresses the growing Excel data analysis market head-on.
An outstanding set of connections between Excel and standard business use.......2006-05-02
Gerald Knight's Analyzing Business Data With Excel provides an outstanding set of connections between Excel and standard business use. Plenty of 'how to' computer books focus on the fundamentals of learning Excel without applying these lessons to basic business data analysis: Analyzing Business Data With Excel solves this in using real- world business problems as examples. From pivot tables and charts to statistical analysis choices and applications which can be easily updated, no business user should be without Analyzing Business Data With Excel.
Exactly what I was looking for!!.......2006-03-30
As a strategy analyst I'm always looking for concise ways to present data and make it automated and professional-looking without lots of code that none of my clients can use.
I agree with the previous reviewer, other books come at Excel and similar applications with a feature by feature breakdown so that in usage YOU have to work backwards to figure out how to apply software features to your problem.
This book is organized by business problem and then proceeds to breakdown how your problem applies to the software solution. There is very useful code in some of the models, but nothing horribly difficult to implement.
Excellent addition to my reference library. I've truly never seen a business data analysis book as well put together as this and I've been searching for years. You will not be disappointed.
Book Description
This new edition provides a brief introduction to business statistics that balances a conceptual understanding of statistics with the real-world application of statistical methodology. The latest version of Microsoft Excel is integrated throughout the text, showing step-by-step instructions and screen captures to enhance learning. The authors have been writing market-leading business statistics textbooks for over 20 years. This new edition contains the same learning features that have made ASW products best-sellers for years; features such as the problem-scenario approach, and real-world examples that introduce statistical techniques.
Customer Reviews:
SUPER.......2007-06-08
This book had it all. Buy it for a class or for your own eductation.
Books:
- Design for Six Sigma : A Roadmap for Product Development
- Design for Six Sigma : A Roadmap for Product Development
- Design for Six Sigma : A Roadmap for Product Development
- Design for Six Sigma for Green Belts and Champions: Applications for Service Operations--Foundations, Tools, DMADV, Cases, and Certification (Six Sigma)
- Design Management: Managing Design Strategy, Process and Implementation (Ava Academia)
- Design of Experiments for Process Improvement and Quality Assurance (Engineers in Business Series)
- Essential Managers: Project Management (Essential Managers Series)
- Essentials of Statistics for Business and Economics (with CD-ROM and InfoTrac )
- Evaluating Practice: Guidelines for the Accountable Professional (5th Edition)
- Factory Physics Second Edition
Books Index
Books Home
Recommended Books
- The Address Directory of Celebrities in Entertainment, Sports, Business & Politics, Second Editi
- Encyclopedia of Herbal Medicine: The Definitive Home Reference Guide to 550 Key Herbs with all their
- The Shocking Miss Pilgrim: A Writer in Early Hollywood
- Welcome to the Fallen Paradise
- Blue Ocean Strategy: How to Create Uncontested Market Space and Make Competition Irrelevant
- Heartbreaker
- Climbing Mount Kilimanjaro
- Social Security: The Inside Story : An Expert Explains Your Rights and Benefits
- Thoughts of Chairman Buffett: Thirty Years of Unconventional Wisdom from the Sage of Omaha
- A Wicked Deed
Strategy and the Business Landscape (2nd Edition)
Managerial Economics & Business Strategy + Data Disk
The Articulate Executive: Learn to Look, Act, and Sound Like a Leader
Financial Accounting: An Introduction to Concepts, Methods and Uses
Guide to Managerial Communication (7th Edition) (Guide to Series in Business Communication)
