Lynda Excel Data Analysis Forecasting | E3CCEF2F6BBB7C6A02CAF1EC227030879E5B8715

Lynda Excel Data Analysis Forecasting

Name	Lynda - Excel Data Analysis Forecasting	DOWNLOAD Copy Link
Total Size	849.3 MB
Total Files	135
Hash	E3CCEF2F6BBB7C6A02CAF1EC227030879E5B8715

/00 Introduction/
0001 Welcome.mp4	4.5 MB
0002 Who is this course for.mp4	2.9 MB
0003 What you should know before watching this course.mp4	3.3 MB
0004 Using the exercise files.mp4	3.5 MB
0005 Using the challenges.mp4	2.6 MB
/01 Visually Displaying Your Time-Series Data/
0101 What is time-series data.mp4	5.9 MB
0102 Plotting a time series.mp4	8.2 MB
0103 Understanding level in a time series.mp4	11.7 MB
0104 Understanding trend in a time series.mp4	6.9 MB
0105 Understanding seasonality in a time series.mp4	12.6 MB
0106 Understanding noise in a time series.mp4	7.8 MB
0107 Creating a moving average chart.mp4	15.0 MB
0108 Challenge Analyze time-series data for airline miles.mp4	1.5 MB
0109 Solution Analyze time-series data for airline miles.mp4	6.7 MB
/02 How Good Are Your Forecasts Errors, Accuracy, and Bias/
0201 Exploring why some forecasts are better than others.mp4	22.0 MB
0202 Computing the mean absolute deviation (MAD).mp4	19.0 MB
0203 Computing the mean absolute percentage error (MAPE).mp4	27.0 MB
0204 Calculating the sum of squared errors (SSE).mp4	13.1 MB
0205 Computing forecast bias.mp4	16.6 MB
0206 Advanced forecast bias Determining significance.mp4	18.7 MB
0207 Challenge Compute MAD, MAPE, and SSE for an NFL game.mp4	1.8 MB
0208 Solution Compute MAD, MAPE, and SSE for an NFL game.mp4	12.9 MB
/03 Using a Trendline for Forecasting/
0301 Fitting a linear trend curve.mp4	14.8 MB
0302 Interpreting the trendline.mp4	9.1 MB
0303 Interpreting the R-squared value.mp4	23.1 MB
0304 Computing standard error of the regression and outliers.mp4	31.4 MB
0305 Exploring autocorrelation.mp4	33.5 MB
0306 Challenge Create a trendline to analyze R squared and outliers.mp4	1.7 MB
0307 Solution Create a trendline to analyze R squared and outliers.mp4	14.4 MB
/04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/
0401 When does a linear trend fail.mp4	26.6 MB
0402 Creating an exponential trend curve.mp4	27.6 MB
0403 Computing compound annual growth rate (CAGR).mp4	13.7 MB
0404 Challenge Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4	1.8 MB
0405 Solution Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4	6.6 MB
/05 Seasonality and the Ratio-to-Moving-Average Method/
0501 What is a seasonal index.mp4	22.0 MB
0502 Introducing the ratio-to-moving-average method.mp4	8.5 MB
0503 Computing the centered moving average.mp4	20.1 MB
0504 Calculating seasonal indices.mp4	21.2 MB
0505 Estimating a series trend.mp4	10.2 MB
0506 Forecasting sales.mp4	24.6 MB
0507 Forecasting if the series trend is changing.mp4	15.4 MB
0508 Challenge Predicting future quarterly sales.mp4	1.7 MB
0509 Solution Predicting future quarterly sales.mp4	8.1 MB
/06 Forecasting with Multiple Regressions/
0601 What is multiple regression.mp4	29.8 MB
0602 Preparing data for multiple regression.mp4	44.1 MB
0603 Running a multiple linear regression.mp4	12.3 MB
0604 Finding the multiple-regression equation and testing for significance.mp4	44.9 MB
0605 How good is the fit of the trendline.mp4	27.6 MB
0606 Making forecasts from a multiple-regression equation.mp4	21.7 MB
0607 Validating a multiple-regression equation using the TREND function.mp4	46.2 MB
0608 Interpreting regression coefficients.mp4	21.5 MB
0609 Challenge Regression analysis of Amazon.com revenue.mp4	3.3 MB
0610 Solution Regression analysis of Amazon.com revenue.mp4	23.7 MB
/07 Conclusion/
0701 Next steps.mp4	12.9 MB
/Exercise Files/Chapter1/01_01/
Timeseriesexamples.xlsx	36.9 KB
/Exercise Files/Chapter1/01_02/
yankees_final.xlsx	15.6 KB
yankees_start.xlsx	10.5 KB
/Exercise Files/Chapter1/01_03/
level_final.xlsx	23.4 KB
level_start.xlsx	15.5 KB
/Exercise Files/Chapter1/01_04/
trend_final.xlsx	23.7 KB
trend_start.xlsx	23.6 KB
/Exercise Files/Chapter1/01_05/
Seasonality_final.xlsx	17.6 KB
Seasonality_start.xlsx	11.6 KB
/Exercise Files/Chapter1/01_06/
Noise_start.xlsx	19.4 KB
/Exercise Files/Chapter1/01_07/
Movingaverage_final.xlsx	17.7 KB
Movingaverage_start.xlsx	17.6 KB
/Exercise Files/Chapter1/01_08/
01_08_Challenge.xlsx	10.7 KB
/Exercise Files/Chapter1/01_09/
01_09_solution.xlsx	17.3 KB
/Exercise Files/Chapter2/02_01/
Accuracybias_final.xlsx	9.4 KB
Accuracybias_start.xlsx	8.7 KB
/Exercise Files/Chapter2/02_02/
MAD_final.xlsx	9.1 KB
MAD_start.xlsx	8.6 KB
/Exercise Files/Chapter2/02_03/
MAPE_final.xlsx	10.6 KB
MAPE_start.xlsx	8.9 KB
/Exercise Files/Chapter2/02_04/
SSE_final.xlsx	9.3 KB
SSE_start.xlsx	8.6 KB
/Exercise Files/Chapter2/02_05/
Bias_final.xlsx	9.3 KB
Bias_start.xlsx	8.8 KB
/Exercise Files/Chapter2/02_06/
AdvancedBias_final.xlsx	10.6 KB
AdvancedBias_start.xlsx	10.5 KB
/Exercise Files/Chapter2/02_07/
02_07_Challenge.xlsx	12.8 KB
/Exercise Files/Chapter2/02_08/
02_08_solution.xlsx	30.9 KB
/Exercise Files/Chapter3/03_01/
Trendline_final.xlsx	14.0 KB
Trendline_start.xlsx	8.7 KB
/Exercise Files/Chapter3/03_02/
Interpret_final.xlsx	15.1 KB
Interpret_start.xlsx	14.4 KB
/Exercise Files/Chapter3/03_03/
Rsquare_final.xlsx	22.3 KB
Rsquare_start.xlsx	16.2 KB
/Exercise Files/Chapter3/03_04/
Standarderror_final.xlsx	24.4 KB
Standarderror_start.xlsx	28.0 KB
/Exercise Files/Chapter3/03_05/
Autocorrelation_final.xlsx	19.5 KB
Autocorrelation_start.xlsx	18.5 KB
/Exercise Files/Chapter3/03_06/
03_06_challenge.xlsx	8.7 KB
/Exercise Files/Chapter3/03_07/
NFLsolution.xlsx	18.4 KB
/Exercise Files/Chapter4/04_01/
Lineartrendfails_final.xlsx	22.6 KB
Lineartrendfails_start.xlsx	17.3 KB
/Exercise Files/Chapter4/04_02/
Expo_final.xlsx	23.5 KB
Expo_start.xlsx	17.5 KB
/Exercise Files/Chapter4/04_03/
CAGR_final.xlsx	22.9 KB
CAGR_start.xlsx	22.5 KB
/Exercise Files/Chapter4/04_04/
CAGRchallenge.xlsx	9.1 KB
/Exercise Files/Chapter4/04_05/
CAGRsolution.xlsx	15.4 KB
/Exercise Files/Chapter5/05_01/
Seasonal_Index_final.xlsx	9.8 KB
Seasonal_Index_start.xlsx	9.2 KB
/Exercise Files/Chapter5/05_02/
Ratioma_start.xlsx	17.6 KB
/Exercise Files/Chapter5/05_03/
CMA_final.xlsx	17.8 KB
CMA_start.xlsx	17.6 KB
/Exercise Files/Chapter5/05_04/
Indices_final.xlsx	18.0 KB
Indices_start.xlsx	17.8 KB
/Exercise Files/Chapter5/05_05/
Trend_final.xlsx	17.7 KB
Trend_start.xlsx	16.8 KB
/Exercise Files/Chapter5/05_06/
Forecastingahead_final.xlsx	17.8 KB
Forecastingahead_start.xlsx	17.6 KB
/Exercise Files/Chapter5/05_07/
Trendchanging_final.xlsx	17.8 KB
Trendchanging_start.xlsx	16.9 KB
/Exercise Files/Chapter5/05_08/
Challenge.xlsx	9.4 KB
/Exercise Files/Chapter5/05_09/
Solution.xlsx	17.0 KB
/Exercise Files/Chapter6/06_01/
MultRegressionExamples_final.xlsx	9.1 KB
MultRegressionExamples_start.xlsx	8.7 KB
/Exercise Files/Chapter6/06_02/
Preparing_final.xlsx	22.6 KB
Preparing_start.xlsx	16.3 KB
/Exercise Files/Chapter6/06_03/
Running_final.xlsx	22.4 KB
Running_start.xlsx	18.5 KB
/Exercise Files/Chapter6/06_04/
Regeq_final.xlsx	27.4 KB
Regeq_start.xlsx	25.8 KB
/Exercise Files/Chapter6/06_05/
Fit_final.xlsx	23.7 KB
Fit_start.xlsx	22.1 KB
/Exercise Files/Chapter6/06_06/
Forecast_final.xlsx	25.0 KB
Forecast_start.xlsx	23.7 KB
/Exercise Files/Chapter6/06_07/
Validation_final.xlsx	25.6 KB
Validation_start.xlsx	22.3 KB
/Exercise Files/Chapter6/06_08/
Interpretingcoefficients_final.xlsx	26.3 KB
Interpretingcoefficients_start.xlsx	27.0 KB
/Exercise Files/Chapter6/06_09/
Challenge.xlsx	9.1 KB
/Exercise Files/Chapter6/06_10/
Solution.xlsx	12.8 KB
Total files 135