VR SCHOOL
ONLINE
Nexus Home
Course Catalog
Meta-Campus
Status
Enter The Nexus
Home
Courses
Part 3: Discovering Advanced Data-Analysis Tools
Curriculum
5 Sections
37 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 9: Dealing with Data Models
4
1.1
Understanding Excel Data Models
10 mins
1.2
Managing a Data Model with Power Pivot
10 mins
1.3
Transforming Data
10 mins
1.4
Creating a PivotTable or PivotChart from Your Data Model
10 mins
Chapter 10: Tracking Trends and Making Forecasts
11
2.1
Plotting a Best-Fit Trend Line
10 mins
2.2
Calculating Best-Fit Values
10 mins
2.3
Plotting Forecasted Values
10 mins
2.4
Extending a Linear Trend
10 mins
2.5
Calculating Forecasted Linear Values
10 mins
2.6
Plotting an Exponential Trend Line
10 mins
2.7
Calculating Exponential Trend Values
10 mins
2.8
Plotting a Logarithmic Trend Line
10 mins
2.9
Plotting a Power Trend Line
10 mins
2.10
Plotting a Polynomial Trend Line
10 mins
2.11
Creating a Forecast Sheet
10 mins
Chapter 11: Analyzing Data Using Statistics
8
3.1
Counting Things
10 mins
3.2
Averaging Things
10 mins
3.3
Finding the Rank
10 mins
3.4
Determining the Nth Largest or Smallest Value
10 mins
3.5
Creating a Grouped Frequency Distribution
10 mins
3.6
Calculating the Variance
10 mins
3.7
Calculating the Standard Deviation
10 mins
3.8
Finding the Correlation
10 mins
Chapter 12: Analyzing Data Using Descriptive Statistics
6
4.1
Loading the Analysis ToolPak
10 mins
4.2
Generating Descriptive Statistics
10 mins
4.3
Calculating a Moving Average
10 mins
4.4
Determining Rank and Percentile
10 mins
4.5
Generating Random Numbers
10 mins
4.6
Creating a Frequency Distribution
10 mins
Chapter 13: Analyzing Data Using Inferential Statistics
8
5.1
Sampling Data
10 mins
5.2
Using the t-Test Tools
10 mins
5.3
Performing a z-Test
10 mins
5.4
Determining the Regression
10 mins
5.5
Calculating the Correlation
10 mins
5.6
Calculating the Covariance
10 mins
5.7
Using the Anova Tools
10 mins
5.8
Performing an f-Test
10 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content