TorBT - Torrents and Magnet Links Search Engine
Lynda - Excel Data Analysis Forecasting
- Date: 2026-03-18
- Size: 810 MB
- Files: 135
File Name
Size
00 Introduction/0001 Welcome.mp4
4.3 MB
00 Introduction/0002 Who is this course for.mp4
2.7 MB
00 Introduction/0003 What you should know before watching this course.mp4
3.1 MB
00 Introduction/0004 Using the exercise files.mp4
3.4 MB
00 Introduction/0005 Using the challenges.mp4
2.5 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.8 MB
01 Visually Displaying Your Time-Series Data/0103 Understanding level in a time series.mp4
11 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 MB
01 Visually Displaying Your Time-Series Data/0106 Understanding noise in a time series.mp4
7.4 MB
01 Visually Displaying Your Time-Series Data/0107 Creating a moving average chart.mp4
14 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
21 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0202 Computing the mean absolute deviation (MAD).mp4
18 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0203 Computing the mean absolute percentage error (MAPE).mp4
26 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0204 Calculating the sum of squared errors (SSE).mp4
12 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0205 Computing forecast bias.mp4
16 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0206 Advanced forecast bias Determining significance.mp4
18 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0207 Challenge Compute MAD, MAPE, and SSE for an NFL game.mp4
1.7 MB
02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0208 Solution Compute MAD, MAPE, and SSE for an NFL game.mp4
12 MB
03 Using a Trendline for Forecasting/0301 Fitting a linear trend curve.mp4
14 MB
03 Using a Trendline for Forecasting/0302 Interpreting the trendline.mp4
8.7 MB
03 Using a Trendline for Forecasting/0303 Interpreting the R-squared value.mp4
22 MB
03 Using a Trendline for Forecasting/0304 Computing standard error of the regression and outliers.mp4
30 MB
03 Using a Trendline for Forecasting/0305 Exploring autocorrelation.mp4
32 MB
03 Using a Trendline for Forecasting/0306 Challenge Create a trendline to analyze R squared and outliers.mp4
1.6 MB
03 Using a Trendline for Forecasting/0307 Solution Create a trendline to analyze R squared and outliers.mp4
14 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0401 When does a linear trend fail.mp4
25 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0402 Creating an exponential trend curve.mp4
26 MB
04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0403 Computing compound annual growth rate (CAGR).mp4
13 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.8 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
21 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0502 Introducing the ratio-to-moving-average method.mp4
8.1 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0503 Computing the centered moving average.mp4
19 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0504 Calculating seasonal indices.mp4
20 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
24 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0507 Forecasting if the series trend is changing.mp4
15 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0508 Challenge Predicting future quarterly sales.mp4
1.6 MB
05 Seasonality and the Ratio-to-Moving-Average Method/0509 Solution Predicting future quarterly sales.mp4
7.7 MB
06 Forecasting with Multiple Regressions/0601 What is multiple regression.mp4
28 MB
06 Forecasting with Multiple Regressions/0602 Preparing data for multiple regression.mp4
42 MB
06 Forecasting with Multiple Regressions/0603 Running a multiple linear regression.mp4
12 MB
06 Forecasting with Multiple Regressions/0604 Finding the multiple-regression equation and testing for significance.mp4
43 MB
06 Forecasting with Multiple Regressions/0605 How good is the fit of the trendline.mp4
26 MB
06 Forecasting with Multiple Regressions/0606 Making forecasts from a multiple-regression equation.mp4
21 MB
06 Forecasting with Multiple Regressions/0607 Validating a multiple-regression equation using the TREND function.mp4
44 MB
06 Forecasting with Multiple Regressions/0608 Interpreting regression coefficients.mp4
20 MB
06 Forecasting with Multiple Regressions/0609 Challenge Regression analysis of Amazon.com revenue.mp4
3.1 MB
06 Forecasting with Multiple Regressions/0610 Solution Regression analysis of Amazon.com revenue.mp4
23 MB
07 Conclusion/0701 Next steps.mp4
12 MB
Exercise Files/Chapter1/01_01/Timeseriesexamples.xlsx
36 kB
Exercise Files/Chapter1/01_02/yankees_final.xlsx
15 kB
Exercise Files/Chapter1/01_02/yankees_start.xlsx
10 kB
Exercise Files/Chapter1/01_03/level_final.xlsx
23 kB
Exercise Files/Chapter1/01_03/level_start.xlsx
15 kB
Exercise Files/Chapter1/01_04/trend_final.xlsx
23 kB
Exercise Files/Chapter1/01_04/trend_start.xlsx
23 kB
Exercise Files/Chapter1/01_05/Seasonality_final.xlsx
17 kB
Exercise Files/Chapter1/01_05/Seasonality_start.xlsx
11 kB
Exercise Files/Chapter1/01_06/Noise_start.xlsx
19 kB
Exercise Files/Chapter1/01_07/Movingaverage_final.xlsx
17 kB
Exercise Files/Chapter1/01_07/Movingaverage_start.xlsx
17 kB
Exercise Files/Chapter1/01_08/01_08_Challenge.xlsx
10 kB
Exercise Files/Chapter1/01_09/01_09_solution.xlsx
17 kB
Exercise Files/Chapter2/02_01/Accuracybias_final.xlsx
9.2 kB
Exercise Files/Chapter2/02_01/Accuracybias_start.xlsx
8.5 kB
Exercise Files/Chapter2/02_02/MAD_final.xlsx
8.9 kB
Exercise Files/Chapter2/02_02/MAD_start.xlsx
8.4 kB
Exercise Files/Chapter2/02_03/MAPE_final.xlsx
10 kB
Exercise Files/Chapter2/02_03/MAPE_start.xlsx
8.6 kB
Exercise Files/Chapter2/02_04/SSE_final.xlsx
9.1 kB
Exercise Files/Chapter2/02_04/SSE_start.xlsx
8.4 kB
Exercise Files/Chapter2/02_05/Bias_final.xlsx
9.1 kB
Exercise Files/Chapter2/02_05/Bias_start.xlsx
8.6 kB
Exercise Files/Chapter2/02_06/AdvancedBias_final.xlsx
10 kB
Exercise Files/Chapter2/02_06/AdvancedBias_start.xlsx
10 kB
Exercise Files/Chapter2/02_07/02_07_Challenge.xlsx
12 kB
Exercise Files/Chapter2/02_08/02_08_solution.xlsx
30 kB
Exercise Files/Chapter3/03_01/Trendline_final.xlsx
14 kB
Exercise Files/Chapter3/03_01/Trendline_start.xlsx
8.5 kB
Exercise Files/Chapter3/03_02/Interpret_final.xlsx
15 kB
Exercise Files/Chapter3/03_02/Interpret_start.xlsx
14 kB
Exercise Files/Chapter3/03_03/Rsquare_final.xlsx
22 kB
Exercise Files/Chapter3/03_03/Rsquare_start.xlsx
16 kB
Exercise Files/Chapter3/03_04/Standarderror_final.xlsx
24 kB
Exercise Files/Chapter3/03_04/Standarderror_start.xlsx
27 kB
Exercise Files/Chapter3/03_05/Autocorrelation_final.xlsx
19 kB
Exercise Files/Chapter3/03_05/Autocorrelation_start.xlsx
18 kB
Exercise Files/Chapter3/03_06/03_06_challenge.xlsx
8.5 kB
Exercise Files/Chapter3/03_07/NFLsolution.xlsx
18 kB
Exercise Files/Chapter4/04_01/Lineartrendfails_final.xlsx
22 kB
Exercise Files/Chapter4/04_01/Lineartrendfails_start.xlsx
17 kB
Exercise Files/Chapter4/04_02/Expo_final.xlsx
23 kB
Exercise Files/Chapter4/04_02/Expo_start.xlsx
17 kB
Exercise Files/Chapter4/04_03/CAGR_final.xlsx
22 kB
Exercise Files/Chapter4/04_03/CAGR_start.xlsx
22 kB
Exercise Files/Chapter4/04_04/CAGRchallenge.xlsx
8.9 kB
Exercise Files/Chapter4/04_05/CAGRsolution.xlsx
15 kB
Exercise Files/Chapter5/05_01/Seasonal_Index_final.xlsx
9.5 kB
Exercise Files/Chapter5/05_01/Seasonal_Index_start.xlsx
9.0 kB
Exercise Files/Chapter5/05_02/Ratioma_start.xlsx
17 kB
Exercise Files/Chapter5/05_03/CMA_final.xlsx
17 kB
Exercise Files/Chapter5/05_03/CMA_start.xlsx
17 kB
Exercise Files/Chapter5/05_04/Indices_final.xlsx
18 kB
Exercise Files/Chapter5/05_04/Indices_start.xlsx
17 kB
Exercise Files/Chapter5/05_05/Trend_final.xlsx
17 kB
Exercise Files/Chapter5/05_05/Trend_start.xlsx
16 kB
Exercise Files/Chapter5/05_06/Forecastingahead_final.xlsx
17 kB
Exercise Files/Chapter5/05_06/Forecastingahead_start.xlsx
17 kB
Exercise Files/Chapter5/05_07/Trendchanging_final.xlsx
17 kB
Exercise Files/Chapter5/05_07/Trendchanging_start.xlsx
16 kB
Exercise Files/Chapter5/05_08/Challenge.xlsx
9.2 kB
Exercise Files/Chapter5/05_09/Solution.xlsx
17 kB
Exercise Files/Chapter6/06_01/MultRegressionExamples_final.xlsx
8.9 kB
Exercise Files/Chapter6/06_01/MultRegressionExamples_start.xlsx
8.5 kB
Exercise Files/Chapter6/06_02/Preparing_final.xlsx
22 kB
Exercise Files/Chapter6/06_02/Preparing_start.xlsx
16 kB
Exercise Files/Chapter6/06_03/Running_final.xlsx
22 kB
Exercise Files/Chapter6/06_03/Running_start.xlsx
18 kB
Exercise Files/Chapter6/06_04/Regeq_final.xlsx
27 kB
Exercise Files/Chapter6/06_04/Regeq_start.xlsx
25 kB
Exercise Files/Chapter6/06_05/Fit_final.xlsx
23 kB
Exercise Files/Chapter6/06_05/Fit_start.xlsx
22 kB
Exercise Files/Chapter6/06_06/Forecast_final.xlsx
24 kB
Exercise Files/Chapter6/06_06/Forecast_start.xlsx
23 kB
Exercise Files/Chapter6/06_07/Validation_final.xlsx
25 kB
Exercise Files/Chapter6/06_07/Validation_start.xlsx
22 kB
Exercise Files/Chapter6/06_08/Interpretingcoefficients_final.xlsx
26 kB
Exercise Files/Chapter6/06_08/Interpretingcoefficients_start.xlsx
26 kB
Exercise Files/Chapter6/06_09/Challenge.xlsx
8.9 kB
Exercise Files/Chapter6/06_10/Solution.xlsx
12 kB