| Lynda - Excel Data Analysis Forecasting/00 Introduction/0001 Welcome.mp4 |
4.3 MB |
| Lynda - Excel Data Analysis Forecasting/00 Introduction/0002 Who is this course for.mp4 |
2.7 MB |
| Lynda - Excel Data Analysis Forecasting/00 Introduction/0003 What you should know before watching this course.mp4 |
3.1 MB |
| Lynda - Excel Data Analysis Forecasting/00 Introduction/0004 Using the exercise files.mp4 |
3.4 MB |
| Lynda - Excel Data Analysis Forecasting/00 Introduction/0005 Using the challenges.mp4 |
2.5 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0101 What is time-series data.mp4 |
5.6 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0102 Plotting a time series.mp4 |
7.8 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0103 Understanding level in a time series.mp4 |
11.1 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0104 Understanding trend in a time series.mp4 |
6.6 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0105 Understanding seasonality in a time series.mp4 |
12 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0106 Understanding noise in a time series.mp4 |
7.4 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0107 Creating a moving average chart.mp4 |
14.3 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0108 Challenge Analyze time-series data for airline miles.mp4 |
1.4 MB |
| Lynda - Excel Data Analysis Forecasting/01 Visually Displaying Your Time-Series Data/0109 Solution Analyze time-series data for airline miles.mp4 |
6.4 MB |
| Lynda - Excel Data Analysis Forecasting/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0201 Exploring why some forecasts are better than others.mp4 |
21 MB |
| Lynda - Excel Data Analysis Forecasting/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0202 Computing the mean absolute deviation (MAD).mp4 |
18.2 MB |
| Lynda - Excel Data Analysis Forecasting/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0203 Computing the mean absolute percentage error (MAPE).mp4 |
25.7 MB |
| Lynda - Excel Data Analysis Forecasting/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0204 Calculating the sum of squared errors (SSE).mp4 |
12.5 MB |
| Lynda - Excel Data Analysis Forecasting/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0205 Computing forecast bias.mp4 |
15.9 MB |
| Lynda - Excel Data Analysis Forecasting/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0206 Advanced forecast bias Determining significance.mp4 |
17.8 MB |
| Lynda - Excel Data Analysis Forecasting/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 |
| Lynda - Excel Data Analysis Forecasting/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0208 Solution Compute MAD, MAPE, and SSE for an NFL game.mp4 |
12.3 MB |
| Lynda - Excel Data Analysis Forecasting/03 Using a Trendline for Forecasting/0301 Fitting a linear trend curve.mp4 |
14.1 MB |
| Lynda - Excel Data Analysis Forecasting/03 Using a Trendline for Forecasting/0302 Interpreting the trendline.mp4 |
8.7 MB |
| Lynda - Excel Data Analysis Forecasting/03 Using a Trendline for Forecasting/0303 Interpreting the R-squared value.mp4 |
22.1 MB |
| Lynda - Excel Data Analysis Forecasting/03 Using a Trendline for Forecasting/0304 Computing standard error of the regression and outliers.mp4 |
29.9 MB |
| Lynda - Excel Data Analysis Forecasting/03 Using a Trendline for Forecasting/0305 Exploring autocorrelation.mp4 |
31.9 MB |
| Lynda - Excel Data Analysis Forecasting/03 Using a Trendline for Forecasting/0306 Challenge Create a trendline to analyze R squared and outliers.mp4 |
1.6 MB |
| Lynda - Excel Data Analysis Forecasting/03 Using a Trendline for Forecasting/0307 Solution Create a trendline to analyze R squared and outliers.mp4 |
13.7 MB |
| Lynda - Excel Data Analysis Forecasting/04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0401 When does a linear trend fail.mp4 |
25.4 MB |
| Lynda - Excel Data Analysis Forecasting/04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0402 Creating an exponential trend curve.mp4 |
26.3 MB |
| Lynda - Excel Data Analysis Forecasting/04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0403 Computing compound annual growth rate (CAGR).mp4 |
13 MB |
| Lynda - Excel Data Analysis Forecasting/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 |
| Lynda - Excel Data Analysis Forecasting/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 |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0501 What is a seasonal index.mp4 |
20.9 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0502 Introducing the ratio-to-moving-average method.mp4 |
8.1 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0503 Computing the centered moving average.mp4 |
19.1 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0504 Calculating seasonal indices.mp4 |
20.2 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0505 Estimating a series trend.mp4 |
9.7 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0506 Forecasting sales.mp4 |
23.5 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0507 Forecasting if the series trend is changing.mp4 |
14.7 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0508 Challenge Predicting future quarterly sales.mp4 |
1.6 MB |
| Lynda - Excel Data Analysis Forecasting/05 Seasonality and the Ratio-to-Moving-Average Method/0509 Solution Predicting future quarterly sales.mp4 |
7.7 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0601 What is multiple regression.mp4 |
28.5 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0602 Preparing data for multiple regression.mp4 |
42 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0603 Running a multiple linear regression.mp4 |
11.8 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0604 Finding the multiple-regression equation and testing for significance.mp4 |
42.8 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0605 How good is the fit of the trendline.mp4 |
26.3 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0606 Making forecasts from a multiple-regression equation.mp4 |
20.7 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0607 Validating a multiple-regression equation using the TREND function.mp4 |
44 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0608 Interpreting regression coefficients.mp4 |
20.5 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0609 Challenge Regression analysis of Amazon.com revenue.mp4 |
3.1 MB |
| Lynda - Excel Data Analysis Forecasting/06 Forecasting with Multiple Regressions/0610 Solution Regression analysis of Amazon.com revenue.mp4 |
22.6 MB |
| Lynda - Excel Data Analysis Forecasting/07 Conclusion/0701 Next steps.mp4 |
12.3 MB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_01/Timeseriesexamples.xlsx |
36 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_02/yankees_final.xlsx |
15 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_02/yankees_start.xlsx |
10 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_03/level_final.xlsx |
23 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_03/level_start.xlsx |
15 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_04/trend_final.xlsx |
23 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_04/trend_start.xlsx |
23 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_05/Seasonality_final.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_05/Seasonality_start.xlsx |
11 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_06/Noise_start.xlsx |
19 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_07/Movingaverage_final.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_07/Movingaverage_start.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_08/01_08_Challenge.xlsx |
10 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter1/01_09/01_09_solution.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_01/Accuracybias_final.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_01/Accuracybias_start.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_02/MAD_final.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_02/MAD_start.xlsx |
8 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_03/MAPE_final.xlsx |
10 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_03/MAPE_start.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_04/SSE_final.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_04/SSE_start.xlsx |
8 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_05/Bias_final.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_05/Bias_start.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_06/AdvancedBias_final.xlsx |
10 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_06/AdvancedBias_start.xlsx |
10 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_07/02_07_Challenge.xlsx |
13 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter2/02_08/02_08_solution.xlsx |
30 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_01/Trendline_final.xlsx |
14 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_01/Trendline_start.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_02/Interpret_final.xlsx |
15 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_02/Interpret_start.xlsx |
14 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_03/Rsquare_final.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_03/Rsquare_start.xlsx |
16 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_04/Standarderror_final.xlsx |
24 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_04/Standarderror_start.xlsx |
27 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_05/Autocorrelation_final.xlsx |
19 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_05/Autocorrelation_start.xlsx |
18 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_06/03_06_challenge.xlsx |
8 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter3/03_07/NFLsolution.xlsx |
18 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_01/Lineartrendfails_final.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_01/Lineartrendfails_start.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_02/Expo_final.xlsx |
23 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_02/Expo_start.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_03/CAGR_final.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_03/CAGR_start.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_04/CAGRchallenge.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter4/04_05/CAGRsolution.xlsx |
15 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_01/Seasonal_Index_final.xlsx |
10 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_01/Seasonal_Index_start.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_02/Ratioma_start.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_03/CMA_final.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_03/CMA_start.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_04/Indices_final.xlsx |
18 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_04/Indices_start.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_05/Trend_final.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_05/Trend_start.xlsx |
16 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_06/Forecastingahead_final.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_06/Forecastingahead_start.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_07/Trendchanging_final.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_07/Trendchanging_start.xlsx |
16 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_08/Challenge.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter5/05_09/Solution.xlsx |
17 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_01/MultRegressionExamples_final.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_01/MultRegressionExamples_start.xlsx |
8 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_02/Preparing_final.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_02/Preparing_start.xlsx |
16 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_03/Running_final.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_03/Running_start.xlsx |
18 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_04/Regeq_final.xlsx |
27 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_04/Regeq_start.xlsx |
25 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_05/Fit_final.xlsx |
23 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_05/Fit_start.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_06/Forecast_final.xlsx |
24 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_06/Forecast_start.xlsx |
23 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_07/Validation_final.xlsx |
25 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_07/Validation_start.xlsx |
22 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_08/Interpretingcoefficients_final.xlsx |
26 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_08/Interpretingcoefficients_start.xlsx |
26 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_09/Challenge.xlsx |
9 KB |
| Lynda - Excel Data Analysis Forecasting/Exercise Files/Chapter6/06_10/Solution.xlsx |
12 KB |
Magnet link
