The movie Moneyball made predictive analytics famous: Now you can apply the same techniques to help your business win. You don’t need multimillion-dollar software: All the tools you need are available in Microsoft Excel, and all the knowledge and skills are right here, in this book!

Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real-world problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, showing how to gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS.

You’ll get an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA code―much of it open-source―to streamline several of this book’s most complex techniques.

Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself.

• Learn both the “how” and “why” of using data to make better tactical decisions

• Choose the right analytics technique for each problem

• Use Excel to capture live real-time data from diverse sources, including third-party websites

• Use logistic regression to predict behaviors such as “will buy” versus “won’t buy”

• Distinguish random data bounces from real, fundamental changes

• Forecast time series with smoothing and regression

• Construct more accurate predictions by using Solver to find maximum likelihood estimates

• Manage huge numbers of variables and enormous datasets with principal components analysis and Varimax factor rotation

• Apply ARIMA (Box-Jenkins) techniques to build better forecasts and understand their meaning

About the Author

Counting conservatively, this is Conrad Carlberg’s eleventh book about quantitative analysis using Microsoft Excel, which he still regards with a mix of awe and exasperation. A look back at the “About the Author” paragraph in Carlberg’s first book, published in 1995, shows that the only word that remains accurate is “He.” Scary.

"About this title" may belong to another edition of this title.

Store Description

Thank you for visiting our profile. We are a home-based business have been selling books online since 2004 and joined AbeBooks in 2008. Feel free to e-mail us at BasementSeller101@gmail.com. We would be happy to assist you.

Visit Seller's Storefront

Seller's business information

Basement Seller 101
OH, U.S.A.

Sale & Shipping Terms

Terms of Sale

We guarantee the condition of every book as it's described on the Abebooks web sites. If you're dissatisfied with your purchase (Incorrect Book/Not as Described/Damaged) or if the order hasn't arrived, you're eligible for a refund within 30 days of the estimated delivery date. If you've changed your mind about a book that you've ordered, please use the Ask bookseller a question link to contact us and we'll respond within 2 business days.

Shipping Terms

Orders usually ship within 2 business days. Expected shipping times for "Standard" orders is 4 to 14 business days and for "Expedited" orders is 3 to 5 business days. We do accept international orders, although shipment times may vary, usually from 3 to 6 weeks.

If you have any questions about our shipment times and policies, if you need a book faster, or if you would like to check the status of your order, please e-mail us.

Please note that we ship all "Standard" items via US Postal Service Media Mail and all "Expedited" items via US Postal Service Priority Mail. Our international orders go via USPS First Class or Priority International Mail. If you would like us to ship an item via another carrier, please e-mail us and we will try to accommodate you.

We can overnight books domestically and send books expedited internationally for an additional charge.

The majority of our packages are shipped using Stamps.com NetStamps, a non-trackable method. Please note that all items ordered via the "Expedited" shipping method are automatically shipped with Delivery Confirmation. If you would like your item shipped with Delivery Confirmation, please e-mail us before making your purchase.

We ship orders every day, Monday through Friday, (excluding Postal Service holidays) usually by 12PM. If you need to cancel or make changes to an order, please do so as soon as possible -- many requests we get regarding orders are not fulfilled because we find, pack, and ship the book before the buyer contacts us. If you receive a confirmation e-mail from us, it means your order has been shipped and we can no longer make changes to it.

Please note that the majority of our orders ship out within 24 hours, many shipping out the same day they are ordered. Since we usually ship around 12PM, most orders received Friday after 10AM will not go out until Monday. In some cases, we will make a trip on Saturday to get more orders out.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	5 to 14 business days	2 to 6 business days
First item	US$ 5.00	US$ 10.00

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.