Skip to content
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Login
Sign Up
Login
Sign Up
Login
Sign Up
Home
All Programs
Computers
Data Science
Data Analytics
Discovering Advanced Data-Analysis Tools
Discovering Advanced Data-Analysis Tools
Curriculum
5 Sections
37 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 9: Dealing with Data Models
8
1.1
Understanding Excel Data Models
1.1
Quiz for Understanding Excel Data Models
6 Questions
1.2
Managing a Data Model with Power Pivot
1.2
Quiz for Managing a Data Model with Power Pivot
5 Questions
1.3
Transforming Data
1.3
Quiz for Transforming Data
5 Questions
1.4
Creating a PivotTable or PivotChart from Your Data Model
1.4
Quiz for Creating a PivotTable or PivotChart from Your Data Model
6 Questions
Chapter 10: Tracking Trends and Making Forecasts
22
2.1
Plotting a Best-Fit Trend Line
2.1
Quiz for Plotting a Best-Fit Trend Line
5 Questions
2.2
Calculating Best-Fit Values
2.2
Quiz for Calculating Best-Fit Values
7 Questions
2.3
Plotting Forecasted Values
2.3
Quiz for Plotting Forecasted Values
6 Questions
2.4
Extending a Linear Trend
2.4
Quiz for Extending a Linear Trend
6 Questions
2.5
Calculating Forecasted Linear Values
2.5
Quiz for Calculating Forecasted Linear Values
7 Questions
2.6
Plotting an Exponential Trend Line
2.6
Quiz for Plotting an Exponential Trend Line
6 Questions
2.7
Calculating Exponential Trend Values
2.7
Quiz for Calculating Exponential Trend Values
7 Questions
2.8
Plotting a Logarithmic Trend Line
2.8
Quiz for Plotting a Logarithmic Trend Line
6 Questions
2.9
Plotting a Power Trend Line
2.9
Quiz for Plotting a Power Trend Line
7 Questions
2.10
Plotting a Polynomial Trend Line
2.10
Quiz for Plotting a Polynomial Trend Line
5 Questions
2.11
Creating a Forecast Sheet
2.11
Quiz for Creating a Forecast Sheet
6 Questions
Chapter 11: Analyzing Data Using Statistics
16
3.1
Counting Things
3.1
Quiz for Counting Things
7 Questions
3.2
Averaging Things
3.2
Quiz for Averaging Things
6 Questions
3.3
Finding the Rank
3.3
Quiz for Finding the Rank
6 Questions
3.4
Determining the Nth Largest or Smallest Value
3.4
Quiz for Determining the Nth Largest or Smallest Value
5 Questions
3.5
Creating a Grouped Frequency Distribution
3.5
Quiz for Creating a Grouped Frequency Distribution
5 Questions
3.6
Calculating the Variance
3.6
Quiz for Calculating the Variance
5 Questions
3.7
Calculating the Standard Deviation
3.7
Quiz for Calculating the Standard Deviation
6 Questions
3.8
Finding the Correlation
3.8
Quiz for Finding the Correlation
6 Questions
Chapter 12: Analyzing Data Using Descriptive Statistics
12
4.1
Loading the Analysis ToolPak
4.1
Quiz for Loading the Analysis ToolPak
6 Questions
4.2
Generating Descriptive Statistics
4.2
Quiz for Generating Descriptive Statistics
7 Questions
4.3
Calculating a Moving Average
4.3
Quiz for Calculating a Moving Average
5 Questions
4.4
Determining Rank and Percentile
4.4
Quiz for Determining Rank and Percentile
7 Questions
4.5
Generating Random Numbers
4.5
Quiz for Generating Random Numbers
6 Questions
4.6
Creating a Frequency Distribution
4.6
Quiz for Creating a Frequency Distribution
5 Questions
Chapter 13: Analyzing Data Using Inferential Statistics
16
5.1
Sampling Data
5.1
Quiz for Sampling Data
5 Questions
5.2
Using the t-Test Tools
5.2
Quiz for Using the t-Test Tools
7 Questions
5.3
Performing a z-Test
5.3
Quiz for Performing a z-Test
6 Questions
5.4
Determining the Regression
5.4
Quiz for Determining the Regression
5 Questions
5.5
Calculating the Correlation
5.5
Quiz for Calculating the Correlation
6 Questions
5.6
Calculating the Covariance
5.6
Quiz for Calculating the Covariance
6 Questions
5.7
Using the Anova Tools
5.7
Quiz for Using the Anova Tools
5 Questions
5.8
Performing an f-Test
5.8
Quiz for Performing an f-Test
6 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Login
or
Sign Up
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Cybersecurity
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Linkedin
Instagram
Modal title
Main Content
