Learning Excel: Data Analysis/ with Curt Frye.

Format:

Video

Author/Creator:

Frye, Curt, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Physical Description:

1 online resource

Place of Publication:

Carpenteria, CA: linkedin.com, 2022.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

Unlock the power of your organization's data. Learn how to perform data analysis in Microsoft Excel.

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; calculating the covariance and correlation between data sets; and calculating probabilities, combinations, and permutations. 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.

Participant:

Presenter: Curt Frye

Notes:

9/20/2022

Access Restriction:

Restricted for use by site license.