Download Excel Data Analysis: Forecasting [2014, ENG] Torrent

Torrent Contents Size: 809.98 MB

Excel Data Analysis: Forecasting [2014, ENG]

00 Introduction

0001 Welcome.mp4	MP4	4.26 MB
0002 Who is this course for.mp4	MP4	2.75 MB
0003 What you should know before watching this course.mp4	MP4	3.15 MB
0004 Using the exercise files.mp4	MP4	3.37 MB
0005 Using the challenges.mp4	MP4	2.49 MB

01 Visually Displaying Your Time-Series Data

0101 What is time-series data.mp4	MP4	5.6 MB
0102 Plotting a time series.mp4	MP4	7.83 MB
0103 Understanding level in a time series.mp4	MP4	11.15 MB
0104 Understanding trend in a time series.mp4	MP4	6.6 MB
0105 Understanding seasonality in a time series.mp4	MP4	12.01 MB
0106 Understanding noise in a time series.mp4	MP4	7.39 MB
0107 Creating a moving average chart.mp4	MP4	14.27 MB
0108 Challenge Analyze time-series data for airline miles.mp4	MP4	1.4 MB
0109 Solution Analyze time-series data for airline miles.mp4	MP4	6.4 MB

02 How Good Are Your Forecasts Errors, Accuracy, and Bias

0201 Exploring why some forecasts are better than others.mp4	MP4	20.97 MB
0202 Computing the mean absolute deviation (MAD).mp4	MP4	18.17 MB
0203 Computing the mean absolute percentage error (MAPE).mp4	MP4	25.7 MB
0204 Calculating the sum of squared errors (SSE).mp4	MP4	12.46 MB
0205 Computing forecast bias.mp4	MP4	15.85 MB
0206 Advanced forecast bias Determining significance.mp4	MP4	17.83 MB
0207 Challenge Compute MAD, MAPE, and SSE for an NFL game.mp4	MP4	1.72 MB
0208 Solution Compute MAD, MAPE, and SSE for an NFL game.mp4	MP4	12.29 MB

03 Using a Trendline for Forecasting

0301 Fitting a linear trend curve.mp4	MP4	14.07 MB
0302 Interpreting the trendline.mp4	MP4	8.72 MB
0303 Interpreting the R-squared value.mp4	MP4	22.05 MB
0304 Computing standard error of the regression and outliers.mp4	MP4	29.92 MB
0305 Exploring autocorrelation.mp4	MP4	31.92 MB
0306 Challenge Create a trendline to analyze R squared and outliers.mp4	MP4	1.64 MB
0307 Solution Create a trendline to analyze R squared and outliers.mp4	MP4	13.73 MB

04 Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)

0401 When does a linear trend fail.mp4	MP4	25.37 MB
0402 Creating an exponential trend curve.mp4	MP4	26.34 MB
0403 Computing compound annual growth rate (CAGR).mp4	MP4	13.03 MB
0404 Challenge Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4	MP4	1.75 MB
0405 Solution Fit an exponential growth curve, estimate CAGR, and forecast revenue.mp4	MP4	6.3 MB

05 Seasonality and the Ratio-to-Moving-Average Method

0501 What is a seasonal index.mp4	MP4	20.94 MB
0502 Introducing the ratio-to-moving-average method.mp4	MP4	8.11 MB
0503 Computing the centered moving average.mp4	MP4	19.15 MB
0504 Calculating seasonal indices.mp4	MP4	20.19 MB
0505 Estimating a series trend.mp4	MP4	9.7 MB
0506 Forecasting sales.mp4	MP4	23.49 MB
0507 Forecasting if the series trend is changing.mp4	MP4	14.65 MB
0508 Challenge Predicting future quarterly sales.mp4	MP4	1.58 MB
0509 Solution Predicting future quarterly sales.mp4	MP4	7.75 MB

06 Forecasting with Multiple Regressions

0601 What is multiple regression.mp4	MP4	28.46 MB
0602 Preparing data for multiple regression.mp4	MP4	42.04 MB
0603 Running a multiple linear regression.mp4	MP4	11.78 MB
0604 Finding the multiple-regression equation and testing for significance.mp4	MP4	42.79 MB
0605 How good is the fit of the trendline.mp4	MP4	26.31 MB
0606 Making forecasts from a multiple-regression equation.mp4	MP4	20.74 MB
0607 Validating a multiple-regression equation using the TREND function.mp4	MP4	44.01 MB
0608 Interpreting regression coefficients.mp4	MP4	20.51 MB
0609 Challenge Regression analysis of Amazon.com revenue.mp4	MP4	3.11 MB
0610 Solution Regression analysis of Amazon.com revenue.mp4	MP4	22.55 MB

07 Conclusion

0701 Next steps.mp4

MP4

12.28 MB

Exercise Files

Chapter1

01_01

Timeseriesexamples.xlsx

XLSX

36.04 KB

01_02

	yankees_final.xlsx	XLSX	15.22 KB
	yankees_start.xlsx	XLSX	10.26 KB

01_03

	level_final.xlsx	XLSX	22.84 KB
	level_start.xlsx	XLSX	15.14 KB

01_04

	trend_final.xlsx	XLSX	23.12 KB
	trend_start.xlsx	XLSX	23.04 KB

01_05

	Seasonality_final.xlsx	XLSX	17.16 KB
	Seasonality_start.xlsx	XLSX	11.35 KB

01_06

Noise_start.xlsx

XLSX

18.99 KB

01_07

	Movingaverage_final.xlsx	XLSX	17.25 KB
	Movingaverage_start.xlsx	XLSX	17.19 KB

01_08

01_08_Challenge.xlsx

XLSX

10.43 KB

01_09

01_09_solution.xlsx

XLSX

16.93 KB

Chapter2

02_01

	Accuracybias_final.xlsx	XLSX	9.19 KB
	Accuracybias_start.xlsx	XLSX	8.53 KB

02_02

	MAD_final.xlsx	XLSX	8.91 KB
	MAD_start.xlsx	XLSX	8.38 KB

02_03

	MAPE_final.xlsx	XLSX	10.39 KB
	MAPE_start.xlsx	XLSX	8.65 KB

02_04

	SSE_final.xlsx	XLSX	9.05 KB
	SSE_start.xlsx	XLSX	8.43 KB

02_05

	Bias_final.xlsx	XLSX	9.12 KB
	Bias_start.xlsx	XLSX	8.57 KB

02_06

	AdvancedBias_final.xlsx	XLSX	10.37 KB
	AdvancedBias_start.xlsx	XLSX	10.23 KB

02_07

02_07_Challenge.xlsx

XLSX

12.54 KB

02_08

02_08_solution.xlsx

XLSX

30.16 KB

Chapter3

03_01

	Trendline_final.xlsx	XLSX	13.66 KB
	Trendline_start.xlsx	XLSX	8.51 KB

03_02

	Interpret_final.xlsx	XLSX	14.78 KB
	Interpret_start.xlsx	XLSX	14.04 KB

03_03

	Rsquare_final.xlsx	XLSX	21.77 KB
	Rsquare_start.xlsx	XLSX	15.79 KB

03_04

	Standarderror_final.xlsx	XLSX	23.85 KB
	Standarderror_start.xlsx	XLSX	27.38 KB

03_05

	Autocorrelation_final.xlsx	XLSX	19.05 KB
	Autocorrelation_start.xlsx	XLSX	18.04 KB

03_06

03_06_challenge.xlsx

XLSX

8.49 KB

03_07

NFLsolution.xlsx

XLSX

17.93 KB

Chapter4

04_01

	Lineartrendfails_final.xlsx	XLSX	22.11 KB
	Lineartrendfails_start.xlsx	XLSX	16.93 KB

04_02

	Expo_final.xlsx	XLSX	22.92 KB
	Expo_start.xlsx	XLSX	17.11 KB

04_03

	CAGR_final.xlsx	XLSX	22.35 KB
	CAGR_start.xlsx	XLSX	21.95 KB

04_04

CAGRchallenge.xlsx

XLSX

8.93 KB

04_05

CAGRsolution.xlsx

XLSX

15.01 KB

Chapter5

05_01

	Seasonal_Index_final.xlsx	XLSX	9.55 KB
	Seasonal_Index_start.xlsx	XLSX	8.99 KB

05_02

Ratioma_start.xlsx

XLSX

17.18 KB

05_03

	CMA_final.xlsx	XLSX	17.34 KB
	CMA_start.xlsx	XLSX	17.18 KB

05_04

	Indices_final.xlsx	XLSX	17.54 KB
	Indices_start.xlsx	XLSX	17.36 KB

05_05

	Trend_final.xlsx	XLSX	17.33 KB
	Trend_start.xlsx	XLSX	16.37 KB

05_06

	Forecastingahead_final.xlsx	XLSX	17.43 KB
	Forecastingahead_start.xlsx	XLSX	17.22 KB

05_07

	Trendchanging_final.xlsx	XLSX	17.4 KB
	Trendchanging_start.xlsx	XLSX	16.5 KB

05_08

Challenge.xlsx

XLSX

9.21 KB

05_09

Solution.xlsx

XLSX

16.56 KB

Chapter6

06_01

	MultRegressionExamples_final.xlsx	XLSX	8.89 KB
	MultRegressionExamples_start.xlsx	XLSX	8.47 KB

06_02

	Preparing_final.xlsx	XLSX	22.03 KB
	Preparing_start.xlsx	XLSX	15.88 KB

06_03

	Running_final.xlsx	XLSX	21.88 KB
	Running_start.xlsx	XLSX	18.1 KB

06_04

	Regeq_final.xlsx	XLSX	26.76 KB
	Regeq_start.xlsx	XLSX	25.2 KB

06_05

	Fit_final.xlsx	XLSX	23.17 KB
	Fit_start.xlsx	XLSX	21.6 KB

06_06

	Forecast_final.xlsx	XLSX	24.42 KB
	Forecast_start.xlsx	XLSX	23.12 KB

06_07

	Validation_final.xlsx	XLSX	24.95 KB
	Validation_start.xlsx	XLSX	21.8 KB

06_08

	Interpretingcoefficients_final.xlsx	XLSX	25.7 KB
	Interpretingcoefficients_start.xlsx	XLSX	26.37 KB

06_09

Challenge.xlsx

XLSX

8.93 KB

06_10

Solution.xlsx

XLSX

12.49 KB

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by freecoursewb in Other Posted in Other 10 2.1 GB 1 month ago freecoursewb	Size 2.1 GB	Files 50	Age 1 month ago	Seeds 10	Leechs 7	Source
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by freecoursewb in Other Posted in Other 9 2.6 GB 3 months ago freecoursewb	Size 2.6 GB	Files 71	Age 3 months ago	Seeds 9	Leechs 5	Source
Complete Guide to Next Gen Excel Formulas for Data Analysts by Microsoft Press Posted by freecoursewb in Other Posted in Other 4 823.2 MB 3 months ago freecoursewb	Size 823.2 MB	Files 142	Age 3 months ago	Seeds 4	Leechs 2	Source
Udemy - Microsoft Excel Data Analysis with Chart and Graph Posted by freecoursewb in Other Posted in Other 8 1.6 GB 6 months ago freecoursewb	Size 1.6 GB	Files 26	Age 6 months ago	Seeds 8	Leechs 3	Source
Udemy - Excel Data Analysis for Professionals and Analysts Posted by freecoursewb in Other Posted in Other 6 1.3 GB 6 months ago freecoursewb	Size 1.3 GB	Files 24	Age 6 months ago	Seeds 6	Leechs 1	Source

Excel Data Analysis: Forecasting [2014, ENG]

Torrent Contents Size: 809.98 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags