Two Variable Data Tables

Create Variable Data Table

Formula for Calculating Total Profit

Formulas for Column Variables

Create Row Variables

Add Outline Fill

Row Input Cell explained

Formatting the Data Table

Number Formatting

Summary

Introduction to Data set and our goal which is to create a Frequency Distribution and Histogram

Create formula for calculating Revenue when we have transactional records with product name, units and revenue discount and a separate table with product prices. The formula uses VLOOKUP and the ROUND function to calculate price times units times one minus the discount rate.

How to determine the class limits (upper and lower limit for counting revenue amounts) and the interval between the upper and lower limit. We use the MIN, MAX and COUNT functions. We also create a formula for range and a formula to determine the number of classes ( 2^k greater than n ). We finally determine the lower limit of the first class and the increment for all classes.

How to use FREQUENCY Array Function for counting between an upper and lower limit with the goal of creating a Frequency Distribution. This is an Array Function that requires the special key stroke: Ctrl + Shift + Enter.

Formula for Relative Frequency or Percent Frequency

Formulas for Cumulative Frequency

Formula for Percent Cumulative Frequency

Combination Chart for a Histogram to show Frequency and Line Chart to show Percent Cumulative Frequency. Two Chart examples that show many important charting tricks to create a chart that articulates an accurate and effective massage, including Custom Number Formatting to show “nothing”.

Prime Implicant and Essential Prime Implicant

Binary Equivalent

Min Terms with 2 Ones

Matched Pairs

Important Note

Check for Matched Pairs

Prime Implicit Table

Given Min Terms

K Map

Conclusion

Introduction

What is Raw Data?

What is Data?

Data Types and Default Alignment in Excel

What is Proper Data Set?

Terms for Proper Data sets. We will see parallel terms for Databasing and Analytics.

In Excel a Proper Data set may or may not have a Primary Key (List of Unique Elements)

Variables and Variation

Population & Sample

Quantitative and Categorical Data

Cross Sectional and Time Series data

Intro to Geometric Mean

Formula for Growth Rate or % Change

Arithmetic Mean is the incorrect calculation for Growth Rates

Geometric Mean Formula 1 when you have End Amount (PV Amount) and End Amount (FV Amount) and the number of compounding periods.

Geometric Mean Formula 2 when you have End Amount (PV Amount) and End Amount (FV Amount) and the number of compounding periods. RRI Function. New in Excel 2013.

Geometric Mean Formula 1 when you have a column of growth rates or % changes. GEOMEAN function and an Array Calculation. Remember, for Array Formulas you must enter the formula into the cell with the special keystroke: Ctrl + Shift + Enter.

Geometric Mean Formula 2 when you have a column of growth rates or % changes.

Formula 1: Prove that our calculations are correct by calculating The End Amount (FV Amount). Formula: Beg*(1+GeoMean)^TotalPeriods or PV*(1+GeoMean)^TotalPeriods

Formula 2: Prove that our calculations are correct by calculating The End Amount (FV Amount). Formula: =FV(GeoMean,TotalPeriods,,-PV)

Conclusion