Download link
File List
-
00 Introduction/0001 Welcome.mp4 4.26 MB
00 Introduction/0002 Who is this course for.mp4 2.75 MB
00 Introduction/0003 What you should know before watching this course.mp4 3.15 MB
00 Introduction/0004 Using the exercise files.mp4 3.37 MB
00 Introduction/0005 Using the challenges.mp4 2.49 MB
01 Visually Displaying Your Time-Series Data/0101 What is time-series data.mp4 5.6 MB
01 Visually Displaying Your Time-Series Data/0102 Plotting a time series.mp4 7.83 MB
01 Visually Displaying Your Time-Series Data/0103 Understanding level in a time series.mp4 11.15 MB
01 Visually Displaying Your Time-Series Data/0104 Understanding trend in a time series.mp4 6.6 MB
01 Visually Displaying Your Time-Series Data/0105 Understanding seasonality in a time series.mp4 12.01 MB
01 Visually Displaying Your Time-Series Data/0106 Understanding noise in a time series.mp4 7.39 MB
01 Visually Displaying Your Time-Series Data/0107 Creating a moving average chart.mp4 14.27 MB
01 Visually Displaying Your Time-Series Data/0108 Challenge Analyze time-series data for airline miles.mp4 1.4 MB
01 Visually Displaying Your Time-Series Data/0109 Solution Analyze time-series data for airline miles.mp4 6.4 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0201 Exploring why some forecasts are better than others.mp4 20.97 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0202 Computing the mean absolute deviation (MAD).mp4 18.17 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0203 Computing the mean absolute percentage error (MAPE).mp4 25.7 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0204 Calculating the sum of squared errors (SSE).mp4 12.46 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0205 Computing forecast bias.mp4 15.85 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0206 Advanced forecast bias Determining significance.mp4 17.83 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0207 Challenge Compute MAD, MAPE, and SSE for an NFL game.mp4 1.72 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0208 Solution Compute MAD, MAPE, and SSE for an NFL game.mp4 12.29 MB
03 Using a Trendline for Forecasting/0301 Fitting a linear trend curve.mp4 14.07 MB
03 Using a Trendline for Forecasting/0302 Interpreting the trendline.mp4 8.72 MB
03 Using a Trendline for Forecasting/0303 Interpreting the R-squared value.mp4 22.05 MB
03 Using a Trendline for Forecasting/0304 Computing standard error of the regression and outliers.mp4 29.92 MB
03 Using a Trendline for Forecasting/0305 Exploring autocorrelation.mp4 31.92 MB
03 Using a Trendline for Forecasting/0306 Challenge Create a trendline to analyze R squared and outliers.mp4 1.64 MB
03 Using a Trendline for Forecasting/0307 Solution Create a trendline to analyze R squared and outliers.mp4 13.73 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0401 When does a linear trend fail.mp4 25.37 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0402 Creating an exponential trend curve.mp4 26.34 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0403 Computing compound annual growth rate (CAGR).mp4 13.03 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0404 Challenge Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4 1.75 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0405 Solution Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4 6.3 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0501 What is a seasonal index.mp4 20.94 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0502 Introducing the ratio-to-moving-average method.mp4 8.11 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0503 Computing the centered moving average.mp4 19.15 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0504 Calculating seasonal indices.mp4 20.19 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0505 Estimating a series trend.mp4 9.7 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0506 Forecasting sales.mp4 23.49 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0507 Forecasting if the series trend is changing.mp4 14.65 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0508 Challenge Predicting future quarterly sales.mp4 1.58 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0509 Solution Predicting future quarterly sales.mp4 7.75 MB
06 Forecasting with Multiple Regressions/0601 What is multiple regression.mp4 28.46 MB
06 Forecasting with Multiple Regressions/0602 Preparing data for multiple regression.mp4 42.04 MB
06 Forecasting with Multiple Regressions/0603 Running a multiple linear regression.mp4 11.78 MB
06 Forecasting with Multiple Regressions/0604 Finding the multiple-regression equation and testing for significance.mp4 42.79 MB
06 Forecasting with Multiple Regressions/0605 How good is the fit of the trendline.mp4 26.31 MB
06 Forecasting with Multiple Regressions/0606 Making forecasts from a multiple-regression equation.mp4 20.74 MB
06 Forecasting with Multiple Regressions/0607 Validating a multiple-regression equation using the TREND function.mp4 44.01 MB
06 Forecasting with Multiple Regressions/0608 Interpreting regression coefficients.mp4 20.51 MB
06 Forecasting with Multiple Regressions/0609 Challenge Regression analysis of Amazon.com revenue.mp4 3.11 MB
06 Forecasting with Multiple Regressions/0610 Solution Regression analysis of Amazon.com revenue.mp4 22.55 MB
07 Conclusion/0701 Next steps.mp4 12.28 MB
Exercise Files/Chapter1/01_01/Timeseriesexamples.xlsx 36.04 KB
Exercise Files/Chapter1/01_02/yankees_final.xlsx 15.22 KB
Exercise Files/Chapter1/01_02/yankees_start.xlsx 10.26 KB
Exercise Files/Chapter1/01_03/level_final.xlsx 22.84 KB
Exercise Files/Chapter1/01_03/level_start.xlsx 15.14 KB
Exercise Files/Chapter1/01_04/trend_final.xlsx 23.12 KB
Exercise Files/Chapter1/01_04/trend_start.xlsx 23.04 KB
Exercise Files/Chapter1/01_05/Seasonality_final.xlsx 17.16 KB
Exercise Files/Chapter1/01_05/Seasonality_start.xlsx 11.35 KB
Exercise Files/Chapter1/01_06/Noise_start.xlsx 18.99 KB
Exercise Files/Chapter1/01_07/Movingaverage_final.xlsx 17.25 KB
Exercise Files/Chapter1/01_07/Movingaverage_start.xlsx 17.19 KB
Exercise Files/Chapter1/01_08/01_08_Challenge.xlsx 10.43 KB
Exercise Files/Chapter1/01_09/01_09_solution.xlsx 16.93 KB
Exercise Files/Chapter2/02_01/Accuracybias_final.xlsx 9.19 KB
Exercise Files/Chapter2/02_01/Accuracybias_start.xlsx 8.53 KB
Exercise Files/Chapter2/02_02/MAD_final.xlsx 8.91 KB
Exercise Files/Chapter2/02_02/MAD_start.xlsx 8.38 KB
Exercise Files/Chapter2/02_03/MAPE_final.xlsx 10.39 KB
Exercise Files/Chapter2/02_03/MAPE_start.xlsx 8.65 KB
Exercise Files/Chapter2/02_04/SSE_final.xlsx 9.05 KB
Exercise Files/Chapter2/02_04/SSE_start.xlsx 8.43 KB
Exercise Files/Chapter2/02_05/Bias_final.xlsx 9.12 KB
Exercise Files/Chapter2/02_05/Bias_start.xlsx 8.57 KB
Exercise Files/Chapter2/02_06/AdvancedBias_final.xlsx 10.37 KB
Exercise Files/Chapter2/02_06/AdvancedBias_start.xlsx 10.23 KB
Exercise Files/Chapter2/02_07/02_07_Challenge.xlsx 12.54 KB
Exercise Files/Chapter2/02_08/02_08_solution.xlsx 30.16 KB
Exercise Files/Chapter3/03_01/Trendline_final.xlsx 13.66 KB
Exercise Files/Chapter3/03_01/Trendline_start.xlsx 8.51 KB
Exercise Files/Chapter3/03_02/Interpret_final.xlsx 14.78 KB
Exercise Files/Chapter3/03_02/Interpret_start.xlsx 14.04 KB
Exercise Files/Chapter3/03_03/Rsquare_final.xlsx 21.77 KB
Exercise Files/Chapter3/03_03/Rsquare_start.xlsx 15.79 KB
Exercise Files/Chapter3/03_04/Standarderror_final.xlsx 23.85 KB
Exercise Files/Chapter3/03_04/Standarderror_start.xlsx 27.38 KB
Exercise Files/Chapter3/03_05/Autocorrelation_final.xlsx 19.05 KB
Exercise Files/Chapter3/03_05/Autocorrelation_start.xlsx 18.04 KB
Exercise Files/Chapter3/03_06/03_06_challenge.xlsx 8.49 KB
Exercise Files/Chapter3/03_07/NFLsolution.xlsx 17.93 KB
Exercise Files/Chapter4/04_01/Lineartrendfails_final.xlsx 22.11 KB
Exercise Files/Chapter4/04_01/Lineartrendfails_start.xlsx 16.93 KB
Exercise Files/Chapter4/04_02/Expo_final.xlsx 22.92 KB
Exercise Files/Chapter4/04_02/Expo_start.xlsx 17.11 KB
Exercise Files/Chapter4/04_03/CAGR_final.xlsx 22.35 KB
Exercise Files/Chapter4/04_03/CAGR_start.xlsx 21.95 KB
Exercise Files/Chapter4/04_04/CAGRchallenge.xlsx 8.93 KB
Exercise Files/Chapter4/04_05/CAGRsolution.xlsx 15.01 KB
Exercise Files/Chapter5/05_01/Seasonal_Index_final.xlsx 9.55 KB
Exercise Files/Chapter5/05_01/Seasonal_Index_start.xlsx 8.99 KB
Exercise Files/Chapter5/05_02/Ratioma_start.xlsx 17.18 KB
Exercise Files/Chapter5/05_03/CMA_final.xlsx 17.34 KB
Exercise Files/Chapter5/05_03/CMA_start.xlsx 17.18 KB
Exercise Files/Chapter5/05_04/Indices_final.xlsx 17.54 KB
Exercise Files/Chapter5/05_04/Indices_start.xlsx 17.36 KB
Exercise Files/Chapter5/05_05/Trend_final.xlsx 17.33 KB
Exercise Files/Chapter5/05_05/Trend_start.xlsx 16.37 KB
Exercise Files/Chapter5/05_06/Forecastingahead_final.xlsx 17.43 KB
Exercise Files/Chapter5/05_06/Forecastingahead_start.xlsx 17.22 KB
Exercise Files/Chapter5/05_07/Trendchanging_final.xlsx 17.4 KB
Exercise Files/Chapter5/05_07/Trendchanging_start.xlsx 16.5 KB
Exercise Files/Chapter5/05_08/Challenge.xlsx 9.21 KB
Exercise Files/Chapter5/05_09/Solution.xlsx 16.56 KB
Exercise Files/Chapter6/06_01/MultRegressionExamples_final.xlsx 8.89 KB
Exercise Files/Chapter6/06_01/MultRegressionExamples_start.xlsx 8.47 KB
Exercise Files/Chapter6/06_02/Preparing_final.xlsx 22.03 KB
Exercise Files/Chapter6/06_02/Preparing_start.xlsx 15.88 KB
Exercise Files/Chapter6/06_03/Running_final.xlsx 21.88 KB
Exercise Files/Chapter6/06_03/Running_start.xlsx 18.1 KB
Exercise Files/Chapter6/06_04/Regeq_final.xlsx 26.76 KB
Exercise Files/Chapter6/06_04/Regeq_start.xlsx 25.2 KB
Exercise Files/Chapter6/06_05/Fit_final.xlsx 23.17 KB
Exercise Files/Chapter6/06_05/Fit_start.xlsx 21.6 KB
Exercise Files/Chapter6/06_06/Forecast_final.xlsx 24.42 KB
Exercise Files/Chapter6/06_06/Forecast_start.xlsx 23.12 KB
Exercise Files/Chapter6/06_07/Validation_final.xlsx 24.95 KB
Exercise Files/Chapter6/06_07/Validation_start.xlsx 21.8 KB
Exercise Files/Chapter6/06_08/Interpretingcoefficients_final.xlsx 25.7 KB
Exercise Files/Chapter6/06_08/Interpretingcoefficients_start.xlsx 26.37 KB
Exercise Files/Chapter6/06_09/Challenge.xlsx 8.93 KB
Exercise Files/Chapter6/06_10/Solution.xlsx 12.49 KB
Download Info
-
Tips
“Lynda - Excel Data Analysis Forecasting” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.