Skip to content
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
Course Catalog
About
Contact Us
Home
All Programs
Computers
Data Science
Data Analytics
Discovering Advanced Data-Analysis Tools
Discovering Advanced Data-Analysis Tools
Curriculum
5 Sections
37 Lessons
10 Weeks
Expand all sections
Collapse all sections
Dealing with Data Models
8
1.1
Understanding Excel Data Models
1.2
Quiz for Understanding Excel Data Models
6 Questions
1.3
Managing a Data Model with Power Pivot
1.4
Quiz for Managing a Data Model with Power Pivot
5 Questions
1.5
Transforming Data
1.6
Quiz for Transforming Data
5 Questions
1.7
Creating a PivotTable or PivotChart from Your Data Model
1.8
Quiz for Creating a PivotTable or PivotChart from Your Data Model
6 Questions
Tracking Trends and Making Forecasts
22
2.1
Plotting a Best-Fit Trend Line
2.2
Quiz for Plotting a Best-Fit Trend Line
5 Questions
2.3
Calculating Best-Fit Values
2.4
Quiz for Calculating Best-Fit Values
7 Questions
2.5
Plotting Forecasted Values
2.6
Quiz for Plotting Forecasted Values
6 Questions
2.7
Extending a Linear Trend
2.8
Quiz for Extending a Linear Trend
6 Questions
2.9
Calculating Forecasted Linear Values
2.10
Quiz for Calculating Forecasted Linear Values
7 Questions
2.11
Plotting an Exponential Trend Line
2.12
Quiz for Plotting an Exponential Trend Line
6 Questions
2.13
Calculating Exponential Trend Values
2.14
Quiz for Calculating Exponential Trend Values
7 Questions
2.15
Plotting a Logarithmic Trend Line
2.16
Quiz for Plotting a Logarithmic Trend Line
6 Questions
2.17
Plotting a Power Trend Line
2.18
Quiz for Plotting a Power Trend Line
7 Questions
2.19
Plotting a Polynomial Trend Line
2.20
Quiz for Plotting a Polynomial Trend Line
5 Questions
2.21
Creating a Forecast Sheet
2.22
Quiz for Creating a Forecast Sheet
6 Questions
Analyzing Data Using Statistics
16
3.1
Counting Things
3.2
Quiz for Counting Things
7 Questions
3.3
Averaging Things
3.4
Quiz for Averaging Things
6 Questions
3.5
Finding the Rank
3.6
Quiz for Finding the Rank
6 Questions
3.7
Determining the Nth Largest or Smallest Value
3.8
Quiz for Determining the Nth Largest or Smallest Value
5 Questions
3.9
Creating a Grouped Frequency Distribution
3.10
Quiz for Creating a Grouped Frequency Distribution
5 Questions
3.11
Calculating the Variance
3.12
Quiz for Calculating the Variance
5 Questions
3.13
Calculating the Standard Deviation
3.14
Quiz for Calculating the Standard Deviation
6 Questions
3.15
Finding the Correlation
3.16
Quiz for Finding the Correlation
6 Questions
Analyzing Data Using Descriptive Statistics
12
4.1
Loading the Analysis ToolPak
4.2
Quiz for Loading the Analysis ToolPak
6 Questions
4.3
Generating Descriptive Statistics
4.4
Quiz for Generating Descriptive Statistics
7 Questions
4.5
Calculating a Moving Average
4.6
Quiz for Calculating a Moving Average
5 Questions
4.7
Determining Rank and Percentile
4.8
Quiz for Determining Rank and Percentile
7 Questions
4.9
Generating Random Numbers
4.10
Quiz for Generating Random Numbers
6 Questions
4.11
Creating a Frequency Distribution
4.12
Quiz for Creating a Frequency Distribution
5 Questions
Analyzing Data Using Inferential Statistics
16
5.1
Sampling Data
5.2
Quiz for Sampling Data
5 Questions
5.3
Using the t-Test Tools
5.4
Quiz for Using the t-Test Tools
7 Questions
5.5
Performing a z-Test
5.6
Quiz for Performing a z-Test
6 Questions
5.7
Determining the Regression
5.8
Quiz for Determining the Regression
5 Questions
5.9
Calculating the Correlation
5.10
Quiz for Calculating the Correlation
6 Questions
5.11
Calculating the Covariance
5.12
Quiz for Calculating the Covariance
6 Questions
5.13
Using the Anova Tools
5.14
Quiz for Using the Anova Tools
5 Questions
5.15
Performing an f-Test
5.16
Quiz for Performing an f-Test
6 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Your Journey Starts Here
Course Catalog
About
Contact Us
Login/Sign Up
Modal title
Main Content
