Download Excel Data Analysis: Forecasting RAR file from Ryushare, Nitroflare, Uploadable, Rapidgator, Storagon...
Excel Data Analysis: Forecasting MP4 | Video: 720p | Duration: 3:07:01 | English | Subtitles: VTT | 506.5 MB
Professor Wayne Winston has taught advanced forecasting techniques to Fortune 500 companies for more than twenty years. In this course, he shows how to use Excel's data-analysis tools-including charts, formulas, and functions-to create accurate and insightful forecasts. Learn how to display time-series data visually; make sure your forecasts are accurate, by computing for errors and bias; use trendlines to identify trends and outlier data; model growth; account for seasonality; and identify unknown variables, with multiple regression analysis. A series of practice challenges along the way helps you test your skills and compare your work to Wayne's solutions.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
Topics include: Descriptionting and displaying time-series dataCreating a moving average chartAccounting for errors and biasUsing and interpreting trendlinesModeling exponential growthCalculating compound annual growth rate (CAGR)Analyzing the impact of seasonalityIntroducing the ratio-to-moving-average methodForecasting with multiple regression