Powerful Forecasting With MS Excel Joe Choong

ISBN:

Published:

Kindle Edition

301 pages


Description

Powerful Forecasting With MS Excel  by  Joe Choong

Powerful Forecasting With MS Excel by Joe Choong
| Kindle Edition | PDF, EPUB, FB2, DjVu, talking book, mp3, RTF | 301 pages | ISBN: | 7.70 Mb

Forecasting has become very important to all business enterprises and individual as well. This book provides readers with the tools to analyze their data, develop forecasting models and present the results in Excel.Step-by-step development of theMoreForecasting has become very important to all business enterprises and individual as well.

This book provides readers with the tools to analyze their data, develop forecasting models and present the results in Excel.Step-by-step development of the forecasting techniques are presented in a clear, simple and straightforward style. The essential text covers techniques that include but not limited to time series moving average, exponential smoothing, Box-Jenkins (ARIMA), Monte Carlo simulation, neural network, K Nearest Neighbors and so on.

And unlike other books of its kind that require either high-priced statistical software or Excel add-ins, this book does not require such software. It can be used both as a primary text and as a supplementary text. Apart from thatOnly minimal mathematic knowledge is requireLots of Excel spreadsheet examplesProvides a wide range of proven methodologiesIncludes both time series and causal modelsThis book is also ideal for a small business owner or someone who may not have the budget for expensive analytical tools such as SAS or SPSS.

If you are building your forecast based on time series analysis or independent variables, then this book will be perfect for you.The chapter includes:Chapter 1: Basic Forecasting MethodsMoving AverageExponential SmoothingHolts MethodHolts WintersChapter 2: ARIMA / Box JenkinsArima ModelingSubjective MethodObjective MethodChapter 3: Monte Carlo SimulationExample 1: Coin TossingExample 2: Sales ForecastingExample 3: Modeling Stock PricesChapter 4: K Nearest NeighborsExample 1: KNN for classificationExample 2: KNN for time series predictionExample 3: Cross Validation With MSEChapter 5: Neural Network With MS ExcelExample 1: Credit Approval ModelExample 2: Sales ForecastingExample 3: Predicting Stock Prices (DJIA)Example 4: Predicting Real Estate ValueExample 5: Classify Type Of FlowersThe objective of this book is to provide the reader with the tools to analyze data and produce forecasts in MS Excel.

Written in a simple, straightforward style, Powerful Forecasting With MS Excel presents basic statistical techniques using practical business examples to teach readers how to predict short, medium and long-term forecasts.Each chapter explores a specific forecasting topic and takes you forward into more advanced areas until you are able to understand powerful forecasting using Excel spreadsheet.Once you are comfortable with the practicalities of using the spreadsheet models then perhaps you can simply tailor one of the preexisting spreadsheets for your own use.

However, if you need to develop your own unique model then you will find that this book has the materials that you can reference to build one on your own. Assuming little prior knowledge, this informal text is a great companion for those who have not studied forecasting in depth before.

This book truly promotes self-study as readers are encouraged to tackle problems as they go along and can see fully worked examples to help their understanding. Both beginners and more advanced students will find material in this book relevant to their needs. The book you will read once, and refer to over and over again!



Enter the sum





Related Archive Books



Related Books


Comments

Comments for "Powerful Forecasting With MS Excel":


ddin.pl

©2009-2015 | DMCA | Contact us