More Predictive Analytics: Microsoft Excel
Language: English
Published by Que Publishing, 2015
- Softcover
- Used

Seller: Gulf Coast Books, Cypress, TX, U.S.A.Gulf Coast Books
AbeBooks seller since June 27, 2017
Condition: Used - Fair
£ 15.65
Quantity: 1 available
Add to basketSeller Inventory # 0789756145-4-37281153
- Title
- More Predictive Analytics: Microsoft Excel
- Author
- Carlberg, Conrad
- Publisher
- Que Publishing
- Publication year
- 2015
- Condition
- Fair
- Binding
- paperback
- Language
- English
- ISBN 10
- 0789756145
- ISBN 13
- 9780789756145
- Item weight
- 15 ounces
- Dimensions
- 7x0x9
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
"Synopsis" may belong to another edition of this title.
Gulf Coast Books
Cypress, TX, U.S.A.
AbeBooks seller since June 27, 2017
Shipping rates within U.S.A.
| Item | 4 to 8 business days | 2 to 6 business days |
|---|---|---|
| First item | £ 0.00 | £ 0.73 |
Payment methods
Specialty
all genres, all categoriesSeller's business information
Gulf Coast Books, LLC
3092 LAKEVIEW RD
Memphis, TN U.S.A. 38116
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Gulf Coast Books, Houston, Texas, U.S.A., without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.