Microsoft Excel is an important tool for data analysis. It helps companies accurately assess situations and make better business decisions. This course helps you unlock the power of your organization’s data using the data analysis and visualization tools built into Excel. Author Curt Frye starts with the foundational concepts, including basic calculations such as mean, median, and standard deviation, and provides an introduction to the central limit theorem. He then shows how to visualize data, relationships, and future results with Excel’s histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating the covariance and correlation between data sets. Finally, he reviews the process of calculating Bayesian probabilities in Excel. Each chapter includes practical examples that show how to apply the techniques to real-world business problems.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
01 - The power of data analysis using Excel.en.srt
1 KB
01 - The power of data analysis using Excel.mp4
2.2 MB
02 - What you should know.en.srt
2.9 KB
02 - What you should know.mp4
2.6 MB
03 - Calculate mean and median values.en.srt
10.1 KB
03 - Calculate mean and median values.mp4
11.9 MB
04 - Measure maximums, minimums, and other data characteristics.en.srt
8.6 KB
04 - Measure maximums, minimums, and other data characteristics.mp4
11.4 MB
05 - Analyze data using variance and standard deviation.en.srt
10.5 KB
05 - Analyze data using variance and standard deviation.mp4
14.6 MB
06 - Introducing the central limit theorem.en.srt
6.4 KB
06 - Introducing the central limit theorem.mp4
5.7 MB
07 - Analyze a population using data samples.en.srt
6.5 KB
07 - Analyze a population using data samples.mp4
6.1 MB
08 - Identify and minimize sources of error.en.srt
3.9 KB
08 - Identify and minimize sources of error.mp4
2.8 MB
09 - Group data using histograms.en.srt
6 KB
09 - Group data using histograms.mp4
7.2 MB
10 - Identify relationships using XY scatter charts.en.srt
4.2 KB
10 - Identify relationships using XY scatter charts.mp4
4.3 MB
11 - Visualize data using logarithmic scales.en.srt
5.3 KB
11 - Visualize data using logarithmic scales.mp4
6.2 MB
12 - Add trendlines to charts.en.srt
6 KB
12 - Add trendlines to charts.mp4
6.4 MB
13 - Forecast future results.en.srt
8.4 KB
13 - Forecast future results.mp4
10.4 MB
14 - Calculate running averages.en.srt
7.9 KB
14 - Calculate running averages.mp4
9.2 MB
15 - Formulate a hypothesis.en.srt
4.8 KB
15 - Formulate a hypothesis.mp4
4.2 MB
16 - Interpret the results of your analysis.en.srt
3.3 KB
16 - Interpret the results of your analysis.mp4
2.9 MB
17 - Consider the limits of hypothesis testing.en.srt
2.3 KB
17 - Consider the limits of hypothesis testing.mp4
2 MB
18 - Use the normal distribution.en.srt
9.5 KB
18 - Use the normal distribution.mp4
12.7 MB
19 - Use the exponential distribution.en.srt
8.7 KB
19 - Use the exponential distribution.mp4
10.4 MB
20 - Use a uniform distribution.en.srt
9.6 KB
20 - Use a uniform distribution.mp4
12 MB
21 - Use the binomial distribution.en.srt
8.3 KB
21 - Use the binomial distribution.mp4
10.4 MB
22 - Use the Poisson distribution.en.srt
7 KB
22 - Use the Poisson distribution.mp4
7.9 MB
23 - Visualize what covariance means.en.srt
4.6 KB
23 - Visualize what covariance means.mp4
4.5 MB
24 - Calculate covariance between two columns of data.en.srt
6.7 KB
24 - Calculate covariance between two columns of data.mp4
8.2 MB
25 - Calculate covariance among multiple pairs of columns.en.srt
7.7 KB
25 - Calculate covariance among multiple pairs of columns.mp4
10.8 MB
26 - Visualize what correlation means.en.srt
8.1 KB
26 - Visualize what correlation means.mp4
7.7 MB
27 - Calculate correlation between two columns of data.en.srt
4.1 KB
27 - Calculate correlation between two columns of data.mp4
4.5 MB
28 - Calculate correlation among multiple pairs of columns.en.srt
7.1 KB
28 - Calculate correlation among multiple pairs of columns.mp4
9.6 MB
29 - Introduce Bayesian analysis.en.srt
4.2 KB
29 - Introduce Bayesian analysis.mp4
3.9 MB
30 - Analyze a sample problem Kahneman’s Cabs.en.srt
6.8 KB
30 - Analyze a sample problem Kahneman’s Cabs.mp4
6.8 MB
31 - Create a classification matrix.en.srt
6.1 KB
31 - Create a classification matrix.mp4
5.9 MB
32 - Calculate Bayesian probabilities in Excel.en.srt
9.4 KB
32 - Calculate Bayesian probabilities in Excel.mp4