More predictive analytics: Microsoft Excel

Book Cover
Average Rating
Publisher:
Que,
Pub. Date:
[2016]
Language:
English
Description

Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers!

 

In More Predictive Analytics, Microsoft Excel® MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t have to write a line of code--all you need is Excel and this all-new, crystal-clear tutorial.

 

Carlberg goes beyond his highly-praised Predictive Analytics, introducing proven methods for creating more specific, actionable forecasts. You’ll learn how to predict what customers will spend on a given product next year… project how many patients your hospital will admit next quarter… tease out the effects of seasonality (or patterns that recur over a day, year, or any other period)… distinguish real trends from mere “noise.”

 

Drawing on more than 20 years of experience, Carlberg helps you master powerful techniques such as autocorrelation, differencing, Holt-Winters, backcasting, polynomial regression, exponential smoothing, and multiplicative modeling.

 

Step by step, you’ll learn how to make the most of built-in Excel tools to gain far deeper insights from your data. To help you get better results faster, Carlberg provides downloadable Excel workbooks you can easily adapt for your own projects.

 

If you’re ready to make better forecasts for better decision-making, you’re ready for More Predictive Analytics.

  • Discover when and how to use smoothing instead of regression
  • Test your data for trends and seasonality
  • Compare sets of observations with the autocorrelation function
  • Analyze trended time series with Excel’s Solver and Analysis ToolPak
  • Use Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future
  • Initialize your forecasts with a solid baseline
  • Improve your initial forecasts with backcasting and optimization
  • Fully reflect simple or complex seasonal patterns in your forecasts
  • Account for sudden, unexpected changes in trends, from fads to new viral infections
  • Use range names to control complex forecasting models more easily
  • Compare additive and multiplicative models, and use the right model for each task
More Details
ISBN:
9780789756145
Also in This Series
More Like This
Reviews from GoodReads
Loading GoodReads Reviews.
Staff View

Grouping Information

Grouped Work IDeb3cdf96-1402-504f-c8e3-5a7444eceed0
Grouping Titlemore predictive analytics microsoft excel
Grouping Authorcarlberg conrad george
Grouping Categorybook
Last Grouping Update2019-09-20 04:48:43AM
Last Indexed2019-10-17 04:47:16AM

Solr Details

accelerated_reader_interest_level
accelerated_reader_point_value0
accelerated_reader_reading_level0
authorCarlberg, Conrad George,
author_displayCarlberg, Conrad George
available_at_arlingtonCentral
collection_arlingtonAdult Nonfiction
detailed_location_arlingtonCentral Adult Nonfiction
display_description
format_arlingtonBook
format_category_arlingtonBooks
ideb3cdf96-1402-504f-c8e3-5a7444eceed0
isbn9780789756145
item_details
Bib IdItem IdShelf LocCall NumFormatFormat CategoryNum CopiesIs Order ItemIs eContenteContent SourceeContent FileeContent URLsubformatDetailed StatusLast CheckinLocationSub-location
ils:.b19055109.i20571355Central Adult Nonfiction303.49 CARLB1falsefalseOn ShelfSep 19, 2019can
itype_arlingtonPaperback
last_indexed2019-10-17T08:47:16.382Z
lexile_score-1
literary_formNon Fiction
literary_form_fullNon Fiction
local_callnumber_arlington303.49 CARLB
owning_library_arlingtonArlington Public Library
Aurora Hills
Central
Cherrydale
Columbia Pike
Connection Crystal City
Detention Center
Glencarlyn
Local History
Plaza
Shirlington
Westover
owning_location_arlingtonCentral
primary_isbn9780789756145
publishDate2016
record_details
Bib IdFormatFormat CategoryEditionLanguagePublisherPublication DatePhysical Description
ils:.b19055109BookBooksEnglishQue, [2016]vi, 252 pages : illustrations ; 23 cm.
recordtypegrouped_work
scoping_details_arlington
Bib IdItem IdGrouped StatusStatusLocally OwnedAvailableHoldableBookableIn Library Use OnlyLibrary OwnedHoldable PTypesBookable PTypesLocal Url
ils:.b19055109.i20571355On ShelfOn Shelffalsetruetruefalsefalsetrue9999
subject_facetForecasting
Microsoft Excel (Computer file)
Statistics
title_displayMore predictive analytics : Microsoft Excel
title_fullMore predictive analytics : Microsoft Excel / Conrad Carlberg
title_shortMore predictive analytics
title_subMicrosoft Excel