589689.xyz

Lynda - Excel Data Analysis Forecasting

  • 收录时间:2018-03-03 03:33:11
  • 文件大小:810MB
  • 下载次数:204
  • 最近下载:2021-01-20 20:56:47
  • 磁力链接:

文件列表

  1. 06 Forecasting with Multiple Regressions/0607 Validating a multiple-regression equation using the TREND function.mp4 44MB
  2. 06 Forecasting with Multiple Regressions/0604 Finding the multiple-regression equation and testing for significance.mp4 43MB
  3. 06 Forecasting with Multiple Regressions/0602 Preparing data for multiple regression.mp4 42MB
  4. 03 Using a Trendline for Forecasting/0305 Exploring autocorrelation.mp4 32MB
  5. 03 Using a Trendline for Forecasting/0304 Computing standard error of the regression and outliers.mp4 30MB
  6. 06 Forecasting with Multiple Regressions/0601 What is multiple regression.mp4 28MB
  7. 04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0402 Creating an exponential trend curve.mp4 26MB
  8. 06 Forecasting with Multiple Regressions/0605 How good is the fit of the trendline.mp4 26MB
  9. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0203 Computing the mean absolute percentage error (MAPE).mp4 26MB
  10. 04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0401 When does a linear trend fail.mp4 25MB
  11. 05 Seasonality and the Ratio-to-Moving-Average Method/0506 Forecasting sales.mp4 23MB
  12. 06 Forecasting with Multiple Regressions/0610 Solution Regression analysis of Amazon.com revenue.mp4 23MB
  13. 03 Using a Trendline for Forecasting/0303 Interpreting the R-squared value.mp4 22MB
  14. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0201 Exploring why some forecasts are better than others.mp4 21MB
  15. 05 Seasonality and the Ratio-to-Moving-Average Method/0501 What is a seasonal index.mp4 21MB
  16. 06 Forecasting with Multiple Regressions/0606 Making forecasts from a multiple-regression equation.mp4 21MB
  17. 06 Forecasting with Multiple Regressions/0608 Interpreting regression coefficients.mp4 21MB
  18. 05 Seasonality and the Ratio-to-Moving-Average Method/0504 Calculating seasonal indices.mp4 20MB
  19. 05 Seasonality and the Ratio-to-Moving-Average Method/0503 Computing the centered moving average.mp4 19MB
  20. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0202 Computing the mean absolute deviation (MAD).mp4 18MB
  21. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0206 Advanced forecast bias Determining significance.mp4 18MB
  22. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0205 Computing forecast bias.mp4 16MB
  23. 05 Seasonality and the Ratio-to-Moving-Average Method/0507 Forecasting if the series trend is changing.mp4 15MB
  24. 01 Visually Displaying Your Time-Series Data/0107 Creating a moving average chart.mp4 14MB
  25. 03 Using a Trendline for Forecasting/0301 Fitting a linear trend curve.mp4 14MB
  26. 03 Using a Trendline for Forecasting/0307 Solution Create a trendline to analyze R squared and outliers.mp4 14MB
  27. 04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0403 Computing compound annual growth rate (CAGR).mp4 13MB
  28. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0204 Calculating the sum of squared errors (SSE).mp4 12MB
  29. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0208 Solution Compute MAD, MAPE, and SSE for an NFL game.mp4 12MB
  30. 07 Conclusion/0701 Next steps.mp4 12MB
  31. 01 Visually Displaying Your Time-Series Data/0105 Understanding seasonality in a time series.mp4 12MB
  32. 06 Forecasting with Multiple Regressions/0603 Running a multiple linear regression.mp4 12MB
  33. 01 Visually Displaying Your Time-Series Data/0103 Understanding level in a time series.mp4 11MB
  34. 05 Seasonality and the Ratio-to-Moving-Average Method/0505 Estimating a series trend.mp4 10MB
  35. 03 Using a Trendline for Forecasting/0302 Interpreting the trendline.mp4 9MB
  36. 05 Seasonality and the Ratio-to-Moving-Average Method/0502 Introducing the ratio-to-moving-average method.mp4 8MB
  37. 01 Visually Displaying Your Time-Series Data/0102 Plotting a time series.mp4 8MB
  38. 05 Seasonality and the Ratio-to-Moving-Average Method/0509 Solution Predicting future quarterly sales.mp4 8MB
  39. 01 Visually Displaying Your Time-Series Data/0106 Understanding noise in a time series.mp4 7MB
  40. 01 Visually Displaying Your Time-Series Data/0104 Understanding trend in a time series.mp4 7MB
  41. 01 Visually Displaying Your Time-Series Data/0109 Solution Analyze time-series data for airline miles.mp4 6MB
  42. 04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0405 Solution Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4 6MB
  43. 01 Visually Displaying Your Time-Series Data/0101 What is time-series data.mp4 6MB
  44. 00 Introduction/0001 Welcome.mp4 4MB
  45. 00 Introduction/0004 Using the exercise files.mp4 3MB
  46. 00 Introduction/0003 What you should know before watching this course.mp4 3MB
  47. 06 Forecasting with Multiple Regressions/0609 Challenge Regression analysis of Amazon.com revenue.mp4 3MB
  48. 00 Introduction/0002 Who is this course for.mp4 3MB
  49. 00 Introduction/0005 Using the challenges.mp4 2MB
  50. 04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)/0404 Challenge Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4 2MB
  51. 02 How Good Are Your Forecasts Errors, Accuracy, and Bias/0207 Challenge Compute MAD, MAPE, and SSE for an NFL game.mp4 2MB
  52. 03 Using a Trendline for Forecasting/0306 Challenge Create a trendline to analyze R squared and outliers.mp4 2MB
  53. 05 Seasonality and the Ratio-to-Moving-Average Method/0508 Challenge Predicting future quarterly sales.mp4 2MB
  54. 01 Visually Displaying Your Time-Series Data/0108 Challenge Analyze time-series data for airline miles.mp4 1MB
  55. Exercise Files/Chapter1/01_01/Timeseriesexamples.xlsx 36KB
  56. Exercise Files/Chapter2/02_08/02_08_solution.xlsx 30KB
  57. Exercise Files/Chapter3/03_04/Standarderror_start.xlsx 27KB
  58. Exercise Files/Chapter6/06_04/Regeq_final.xlsx 27KB
  59. Exercise Files/Chapter6/06_08/Interpretingcoefficients_start.xlsx 26KB
  60. Exercise Files/Chapter6/06_08/Interpretingcoefficients_final.xlsx 26KB
  61. Exercise Files/Chapter6/06_04/Regeq_start.xlsx 25KB
  62. Exercise Files/Chapter6/06_07/Validation_final.xlsx 25KB
  63. Exercise Files/Chapter6/06_06/Forecast_final.xlsx 24KB
  64. Exercise Files/Chapter3/03_04/Standarderror_final.xlsx 24KB
  65. Exercise Files/Chapter6/06_05/Fit_final.xlsx 23KB
  66. Exercise Files/Chapter1/01_04/trend_final.xlsx 23KB
  67. Exercise Files/Chapter6/06_06/Forecast_start.xlsx 23KB
  68. Exercise Files/Chapter1/01_04/trend_start.xlsx 23KB
  69. Exercise Files/Chapter4/04_02/Expo_final.xlsx 23KB
  70. Exercise Files/Chapter1/01_03/level_final.xlsx 23KB
  71. Exercise Files/Chapter4/04_03/CAGR_final.xlsx 22KB
  72. Exercise Files/Chapter4/04_01/Lineartrendfails_final.xlsx 22KB
  73. Exercise Files/Chapter6/06_02/Preparing_final.xlsx 22KB
  74. Exercise Files/Chapter4/04_03/CAGR_start.xlsx 22KB
  75. Exercise Files/Chapter6/06_03/Running_final.xlsx 22KB
  76. Exercise Files/Chapter6/06_07/Validation_start.xlsx 22KB
  77. Exercise Files/Chapter3/03_03/Rsquare_final.xlsx 22KB
  78. Exercise Files/Chapter6/06_05/Fit_start.xlsx 22KB
  79. Exercise Files/Chapter3/03_05/Autocorrelation_final.xlsx 19KB
  80. Exercise Files/Chapter1/01_06/Noise_start.xlsx 19KB
  81. Exercise Files/Chapter6/06_03/Running_start.xlsx 18KB
  82. Exercise Files/Chapter3/03_05/Autocorrelation_start.xlsx 18KB
  83. Exercise Files/Chapter3/03_07/NFLsolution.xlsx 18KB
  84. Exercise Files/Chapter5/05_04/Indices_final.xlsx 18KB
  85. Exercise Files/Chapter5/05_06/Forecastingahead_final.xlsx 17KB
  86. Exercise Files/Chapter5/05_07/Trendchanging_final.xlsx 17KB
  87. Exercise Files/Chapter5/05_04/Indices_start.xlsx 17KB
  88. Exercise Files/Chapter5/05_03/CMA_final.xlsx 17KB
  89. Exercise Files/Chapter5/05_05/Trend_final.xlsx 17KB
  90. Exercise Files/Chapter1/01_07/Movingaverage_final.xlsx 17KB
  91. Exercise Files/Chapter5/05_06/Forecastingahead_start.xlsx 17KB
  92. Exercise Files/Chapter1/01_07/Movingaverage_start.xlsx 17KB
  93. Exercise Files/Chapter5/05_02/Ratioma_start.xlsx 17KB
  94. Exercise Files/Chapter5/05_03/CMA_start.xlsx 17KB
  95. Exercise Files/Chapter1/01_05/Seasonality_final.xlsx 17KB
  96. Exercise Files/Chapter4/04_02/Expo_start.xlsx 17KB
  97. Exercise Files/Chapter1/01_09/01_09_solution.xlsx 17KB
  98. Exercise Files/Chapter4/04_01/Lineartrendfails_start.xlsx 17KB
  99. Exercise Files/Chapter5/05_09/Solution.xlsx 17KB
  100. Exercise Files/Chapter5/05_07/Trendchanging_start.xlsx 16KB
  101. Exercise Files/Chapter5/05_05/Trend_start.xlsx 16KB
  102. Exercise Files/Chapter6/06_02/Preparing_start.xlsx 16KB
  103. Exercise Files/Chapter3/03_03/Rsquare_start.xlsx 16KB
  104. Exercise Files/Chapter1/01_02/yankees_final.xlsx 15KB
  105. Exercise Files/Chapter1/01_03/level_start.xlsx 15KB
  106. Exercise Files/Chapter4/04_05/CAGRsolution.xlsx 15KB
  107. Exercise Files/Chapter3/03_02/Interpret_final.xlsx 15KB
  108. Exercise Files/Chapter3/03_02/Interpret_start.xlsx 14KB
  109. Exercise Files/Chapter3/03_01/Trendline_final.xlsx 14KB
  110. Exercise Files/Chapter2/02_07/02_07_Challenge.xlsx 13KB
  111. Exercise Files/Chapter6/06_10/Solution.xlsx 12KB
  112. Exercise Files/Chapter1/01_05/Seasonality_start.xlsx 11KB
  113. Exercise Files/Chapter1/01_08/01_08_Challenge.xlsx 10KB
  114. Exercise Files/Chapter2/02_03/MAPE_final.xlsx 10KB
  115. Exercise Files/Chapter2/02_06/AdvancedBias_final.xlsx 10KB
  116. Exercise Files/Chapter1/01_02/yankees_start.xlsx 10KB
  117. Exercise Files/Chapter2/02_06/AdvancedBias_start.xlsx 10KB
  118. Exercise Files/Chapter5/05_01/Seasonal_Index_final.xlsx 10KB
  119. Exercise Files/Chapter5/05_08/Challenge.xlsx 9KB
  120. Exercise Files/Chapter2/02_01/Accuracybias_final.xlsx 9KB
  121. Exercise Files/Chapter2/02_05/Bias_final.xlsx 9KB
  122. Exercise Files/Chapter2/02_04/SSE_final.xlsx 9KB
  123. Exercise Files/Chapter5/05_01/Seasonal_Index_start.xlsx 9KB
  124. Exercise Files/Chapter4/04_04/CAGRchallenge.xlsx 9KB
  125. Exercise Files/Chapter6/06_09/Challenge.xlsx 9KB
  126. Exercise Files/Chapter2/02_02/MAD_final.xlsx 9KB
  127. Exercise Files/Chapter6/06_01/MultRegressionExamples_final.xlsx 9KB
  128. Exercise Files/Chapter2/02_03/MAPE_start.xlsx 9KB
  129. Exercise Files/Chapter2/02_05/Bias_start.xlsx 9KB
  130. Exercise Files/Chapter2/02_01/Accuracybias_start.xlsx 9KB
  131. Exercise Files/Chapter3/03_01/Trendline_start.xlsx 9KB
  132. Exercise Files/Chapter3/03_06/03_06_challenge.xlsx 8KB
  133. Exercise Files/Chapter6/06_01/MultRegressionExamples_start.xlsx 8KB
  134. Exercise Files/Chapter2/02_04/SSE_start.xlsx 8KB
  135. Exercise Files/Chapter2/02_02/MAD_start.xlsx 8KB