Home - wikitekkee

Welcome to wikitekkee.com. “In my experience, more than 99% of the companies I worked for have used Excel.“–Thomas Subia. We have analyzed more than 900 companies’ job advertisements and found that 100% of the employers prefer candidates who have basic and advanced knowledge in Excel. We have been learning and teaching MS Excel for more than 15 years. We will be sharing our knowledge for your better understanding of Excel. Your comments and feedbacks are our most valuable assets.

Advertisements

Excel for Beginners

This section is for absolute beginners, and even expert users may find something unique in this section.

14 New Excel Functions 2022

On March 16, 2022, Microsoft announced 14 new Excel functions.

Text Functions:

TEXTBEFORE	To return a string of text that occurs before a given substring in that string.
TEXTAFTER	To return a string of text that occurs after a substring in a string.
TEXTSPLIT	To split text strings by using column and row delimiters.

Array Stacking Functions:

VSTACK	To append data to the first blank cell at the bottom of a range.
HSTACK	To append data of the array argument in a column-wise fashion.

Functions for Selecting and Array:

CHOOSECOLS	It returns the specified columns from an array.
CHOOSEROWS	It returns an array that contains just the rows specified.
DROP	It excludes a specified number of contiguous rows or columns from start or end.
TAKE	It returns a specified number of contiguous rows or columns from the start or end.
EXPAND	It expands or pads an array to specified row and column.

Array Shaping Functions:

WRAPROWS	It wraps the provided vector by rows after a specified number of elements.
WRAPCOLS	It wraps the provided vector by columns after a specified number of elements.
TOCOL	It returns a column vector containing all the items in the source array.
TOROW	It returns a row vector that contains all the items in the source array.

Most Popular

Advertisements

SUM	The SUM function adds its arguments
SUMIF	It adds the cells in a range that meet a specific criteria
LOOKUP	This function looks up values in a vector or array
VLOOKUP	VLOOKUP function looks in the first column of an array and moves across the row to return the value of a cell
MATCH	MATCH function looks up values in a reference or array
CHOOSE	This function chooses a value from a list of values
DATE	The DATE function returns the serial number of a particular date
DAYS	The DAYS function returns the number of days between two dates
FIND	FIND function is used to find one text value within another.
INDEX	INDEX function uses an index to choose a value from a reference or array
COUNT	The COUNT function counts how many numbers are in the list of arguments
COUNTIF	The COUNTIF function counts the number of cells within a range that meet a given criteria
CONCAT	CONAT function, a replacement of CONCATENCATE, combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or Ignore Empty arguments.
IF	IF function specifies a logical test to perform
MAX	The MAX Function returns the maximum value in a list of arguments
MIN	The MIN function returns the minimum value in a list of arguments

Logical Functions

AND | FALSE | IF | IFERROR | IFNA | IFS | NOT | OR | SWITCH | TRUE | XOR

AND	Generates TRUE if all the arguments are TRUE
FALSE	Returns the logical value FALSE
IF	State logical test to perform
IFERROR	User specified value is returned if a formula evaluates an error; otherwise returns the results of expression.
IFNA	User specified value is generated if the expression resolves to #N/A; otherwise returns the result of the expression.
IFS	If one or more conditions are met, IFS returns a value that corresponds to the first TRUE condition.
NOT	It is used to reverse the logic of its argument.
OR	Generates TRUE if any argument is TRUE.
SWITCH	Evaluates multiple values and returns the first matching result.
TRUE	Returns the logical value TRUE based on a condition.
XOR	Test logical arguments and returns FALSE if all the arguments are TRUE/FALSE

Text Function

ASC	Changes full-width (double-byte) English letters to half-width (single-byte)
ARRAYTOTEXT	Generates an array of text from user specified range
BATHTEXT	Using baht currency format, it converts number to text.
CHAR	Generates character specified by code number.
CLEAN	Eliminates all nonprintable characters from text.
CODE	Generates numeric code for the first character in a text string.
CONCAT–1 2 3	Combines text from multiple sources.
CONCATENATE	Joins several text items into one. CONCAT is the updated version of CONCATENATE.
BDCS	Converts half-width English letters to full-width characters.
DOLLAR	Using dollar ($) currency format, it converts number to text.
EXACT	Helps to check whether two text values are identical.
FIND, FINDB	To find one text value within another.
FIXED	Formats a number as text with a fixed number decimals.
LEFT, LEFTB	To return the leftmost characters in a text string.
LEN,LENB	To generate the number of characters in a text string.
LOWER	Converts text to lowercase.
MID, MIDB	To generate specific number of characters from text at the position users specify.
NUMBERVALUE	To convert text to number.
PROPER	To capitalize the first letter of each word.
REPLACE, REPLACEB	To replace characters with different text.
REPT	To repeat text a given number of times.
RIGHT, RIGHTB	To return rightmost characters from a text value.
SEARCH, SEARCHB	To find one text value within another.
SUBSTITUTE	To substitute text with a new text.
T Function	To converts arguments to text.
TEXT	It converts numbers to text after formatting.
TEXTJOIN	Combines text from multiple ranges.
TRIM	To remove spaces between text.
UNICHAR	To generate Unicode characters.
UNICODE	To generate number corresponding to first character of the text.
UPPER	To convert text to uppercase.
VALUE	To convert text argument to number.
VALUETOTEXT	To generate text from specified value.

Date & Time Functions

DATE	Generates the sequential serial numbers that represents a specific date.
DATEDIF	To calculate the number of days, months, or years between two dates.
DATEVALUE	To convert a date in the form of text to serial number.
DAY	To convert to the number of day from a date.
DAYS	To find the number of days between two dates.
DAYS360	Returns number of days between two dates based on 360 days.
EDATE	To generate date before or after a date.
EOMONTH	To generate the last day of month before or after a specified month.
HOUR	To convert a serial number to an hour(s).
ISOWEEKNUM	ISO week number of the year for a given date.
MINUTE	To convert a serial number to minute.
MONTH	To convert a serial number to a month.
NETWORKDAYS	To generate number of whole workdays between two dates.
NETWORKDAYS.INTL	Using parameters to indicate which and how many days are weekend days, it returns the number of whole workdays between two dates.
NOW	To generate the serial number of current date and time.
SECOND	To convert a serial number to second.
TIME	To generate the serial number of a specific date.
TIMEVALUE	To convert a text format time to serial number.
TODAY	To generate today’s date.
WEEKDAY	To convert a serial number to a day of the week.
WEEKNUM	Number of week in w year.
WORKDAY	To calculate the serial number of the date before or after a particular workday.
YEAR	To convert a serial number into a year.
YEARFRAC	To generate fraction of the year between two dates.

Information Functions

CELL	To know the content, formatting, and location of a cell.
ERROR.TYPE	Generates a number corresponding to the type of error.
INFO	Generates information about current operating environment.
ISBLANK	Populates TRUE if the cell is blank.
ISERR	If the value in any cell is an error type except #N/A, TRUE.
ISERROR	If the value in any cell is an error type, it generates TRUE.
ISEVEN	To know whether the number of even.
ISFORMULA	To know whether a cell contains formula.
ISLOGICAL	To know whether a value is logical.
ISNA	To know whether a value is #N/A error value.
ISNONTEXT	To know whether a value is not a text.
ISNUMBER	To know whether a value is a number.
ISODD	To know whether the number is odd.
ISREF	It generates TRUE if the value is a reference.
ISTEXT	To know whether a value is text.
N function	Generates a value converted to a number.
NA Function	Generates the error value #N/A.
SHEET	To know the number of sheets of the referenced sheet.
SHEETS	To know the number of sheets in a reference.
TYPE	To know the data type.

Math & Trigonometry Functions

ABS	Generates the absolute value of a number
ACOS	Generates the arccosine of a number
ACOSH	Generates the inverse hyperbolic cosine of a number
ACOT	Generates the arccotangent of a number
ACOTH	Generates the hyperbolic arccotangent of a number
AGGREGATE	Generates an aggregate in a list or database
ARABIC	Converts a Roman number to Arabic, as a number
ASIN	Generates the arcsine of a number
ASINH	Generates the inverse hyperbolic sine of a number
ATAN	Generates the arctangent of a number
ATAN2	Generates the arctangent from x- and y-coordinates
ATANH	Generates the inverse hyperbolic tangent of a number
BASE	Converts a number into a text representation with the given radix (base)
CEILING	Rounds a number to the nearest integer or to the nearest multiple of another number
CEILING.MATH	Rounds a number up, to the nearest integer or to the nearest multiple of another number
CEILING.PRECISE	Regardless of the sign of number, it rounds a number the nearest integer or to the nearest multiple of significance.
COMBIN	Generates the number of combinations for a given number of objects
COMBINA	Generates the number of combinations with repetitions for a given number of items
COS	Generates the cosine of a number
COSH	Generates the hyperbolic cosine of a number
COT	Generates the cotangent of an angle
COTH	Generates the hyperbolic cotangent of a number
CSC	Generates the cosecant of an angle
CSCH	Generates the hyperbolic cosecant of an angle
DECIMAL	Converts a text representation of a number in a given base into a decimal number
DEGREES	Converts radians to degrees
EVEN	Rounds a number up to the nearest even integer
EXP	Generates e raised to the power of a given number
FACT	Generates the factorial of a number
FACTDOUBLE	Generates the double factorial of a number
FLOOR	Rounds a number down, toward zero
FLOOR.MATH	Rounds a number down, to the nearest integer or to the nearest multiple of significance
FLOOR.PRECISE	Regardless of sign, it rounds a number down to the nearest integer or to the nearest multiple of significance.
GCD	Generates the greatest common divisor
INT	Rounds a number down to the nearest integer
ISO.CEILING	Generates a number that is rounded up to the nearest integer or to the nearest multiple of significance
LCM	Generates the least common multiple
LET	Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
LN	Generates the natural logarithm of a number
LOG	Generates the logarithm of a number to a specified base
LOG10	Generates the base-10 logarithm of a number
MDETERM	Generates the matrix determinant of an array
MINVERSE	Generates the matrix inverse of an array
MMULT	Generates the matrix product of two arrays
MOD	Generates the remainder from division
MROUND	Generates a number rounded to the desired multiple
MULTINOMIAL	Generates the multinomial of a set of numbers
MUNIT	Generates the unit matrix or the specified dimension
ODD	Rounds a number up to the nearest odd integer
PI	Generates the value of pi
POWER	Generates the result of a number raised to a power
PRODUCT	Multiplies its arguments
QUOTIENT	Generates the integer portion of a division
RADIANS	Converts degrees to radians
RAND	Generates a random number between 0 and 1
RANDARRAY	Generates an array of random numbers between 0 and 1.
RANDBETWEEN	Generates a random number between the numbers you specify
ROMAN	Converts an Arabic numeral to Roman, as text
ROUND	Rounds a number to a specified number of digits
ROUNDDOWN	Rounds a number down, toward zero
ROUNDUP	Rounds a number up, away from zero
SEC	Generates the secant of an angle
SECH	Generates the hyperbolic secant of an angle
SERIESSUM	Generates the sum of a power series based on the formula
SEQUENCE	Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
SIGN	Generates the sign of a number
SIN	Generates the sine of the given angle
SINH	Generates the hyperbolic sine of a number
SQRT	Generates a positive square root
SQRTPI	Generates the square root of (number * pi)
SUBTOTAL	Generates a subtotal in a list or database
SUM	Adds its arguments
SUMIF	Adds the cells specified by a given criteria
SUMIFS	Adds the cells in a range that meet multiple criteria
SUMPRODUCT	Generates the sum of the products of corresponding array components
SUMSQ	Generates the sum of the squares of the arguments
SUMX2MY2	Generates the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2	Generates the sum of the sum of squares of corresponding values in two arrays
SUMXMY2	Generates the sum of squares of differences of corresponding values in two arrays
TAN	Generates the tangent of a number
TANH	Generates the hyperbolic tangent of a number
TRUNC	Truncates a number to an integer

Statistical Functions

Advertisements

AVEDEV	Generates the average of the absolute deviations of data points from their mean
AVERAGE	Generates the average of its arguments
AVERAGEA	Generates the average of its arguments, including numbers, text, and logical values
AVERAGEIF	Generates the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS	Generates the average (arithmetic mean) of all cells that meet multiple criteria
BETA.DIST	Generates the beta cumulative distribution function
BETA.INV	Generates the inverse of the cumulative distribution function for a specified beta distribution
BINOM.DIST	Generates the individual term binomial distribution probability
BINOM.DIST.RANGE	Generates the probability of a trial result using a binomial distribution
BINOM.INV	Generates the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CHISQ.DIST	Generates the cumulative beta probability density function
CHISQ.DIST.RT	Generates the one-tailed probability of the chi-squared distribution
CHISQ.INV	Generates the cumulative beta probability density function
CHISQ.INV.RT	Generates the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.TEST	Generates the test for independence
CONFIDENCE.NORM	Generates the confidence interval for a population mean
CONFIDENCE.T	Generates the confidence interval for a population mean, using a Student’s t distribution
CORREL	Generates the correlation coefficient between two data sets
COUNT	Counts how many numbers are in the list of arguments
COUNTA	Counts how many values are in the list of arguments
COUNTBLANK	Counts the number of blank cells within a range
COUNTIF	Counts the number of cells within a range that meet the given criteria
COUNTIFS	Counts the number of cells within a range that meet multiple criteria
COVARIANCE.P	Generates covariance, the average of the products of paired deviations
COVARIANCE.S	Generates the sample covariance, the average of the products deviations for each data point pair in two data sets
DEVSQ	Generates the sum of squares of deviations
EXPON.DIST	Generates the exponential distribution
F.DIST	Generates the F probability distribution
F.DIST.RT	Generates the F probability distribution
F.INV	Generates the inverse of the F probability distribution
F.INV.RT	Generates the inverse of the F probability distribution
F.TEST	Generates the result of an F-test
FISHER	Generates the Fisher transformation
FISHERINV	Generates the inverse of the Fisher transformation
FORECAST	Generates a value along a linear trend
FORECAST.ETS	Generates a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm
FORECAST.ETS.CONFINT	Generates a confidence interval for the forecast value at the specified target date
FORECAST.ETS.SEASONALITY	Generates the length of the repetitive pattern Excel detects for the specified time series
FORECAST.ETS.STAT	Generates a statistical value as a result of time series forecasting
FORECAST.LINEAR	Generates a future value based on existing values
FREQUENCY	Generates a frequency distribution as a vertical array
GAMMA	Generates the Gamma function value
GAMMA.DIST	Generates the gamma distribution
GAMMA.INV	Generates the inverse of the gamma cumulative distribution
GAMMALN	Generates the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISE	Generates the natural logarithm of the gamma function, Γ(x)
GAUSS	Generates 0.5 less than the standard normal cumulative distribution
GEOMEAN	Generates the geometric mean
GROWTH	Generates values along an exponential trend
HARMEAN	Generates the harmonic mean
HYPGEOM.DIST	Generates the hypergeometric distribution
INTERCEPT	Generates the intercept of the linear regression line
KURT	Generates the kurtosis of a data set
LARGE	Generates the k-th largest value in a data set
LINEST	Generates the parameters of a linear trend
LOGEST	Generates the parameters of an exponential trend
LOGNORM.DIST	Generates the cumulative lognormal distribution
LOGNORM.INV	Generates the inverse of the lognormal cumulative distribution
MAX	Generates the maximum value in a list of arguments
MAXA	Generates the maximum value in a list of arguments, including numbers, text, and logical values
MAXIFS	Generates the maximum value among cells specified by a given set of conditions or criteria
MEDIAN	Generates the median of the given numbers
MIN	Generates the minimum value in a list of arguments
MINA	Generates the smallest value in a list of arguments, including numbers, text, and logical values
MINIFS	Generates the minimum value among cells specified by a given set of conditions or criteria.
MODE.MULT	Generates a vertical array of the most frequently occurring, or repetitive values in an array or range of data
MODE.SNGL	Generates the most common value in a data set
NEGBINOM.DIST	Generates the negative binomial distribution
NORM.DIST	Generates the normal cumulative distribution
NORM.INV	Generates the inverse of the normal cumulative distribution
NORM.S.DIST	Generates the standard normal cumulative distribution
NORM.S.INV	Generates the inverse of the standard normal cumulative distribution
PEARSON	Generates the Pearson product moment correlation coefficient
PERCENTILE.EXC	Generates the k-th percentile of values in a range, where k is in the range 0..1, exclusive
PERCENTILE.INC	Generates the k-th percentile of values in a range
PERCENTRANK.EXC	Generates the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
PERCENTRANK.INC	Generates the percentage rank of a value in a data set
PERMUT	Generates the number of permutations for a given number of objects
PERMUTATIONA	Generates the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI	Generates the value of the density function for a standard normal distribution
POISSON.DIST	Generates the Poisson distribution
PROB	Generates the probability that values in a range are between two limits
QUARTILE.EXC	Generates the quartile of the data set, based on percentile values from 0..1, exclusive
QUARTILE.INC	Generates the quartile of a data set
RANK.AVG	Generates the rank of a number in a list of numbers
RANK.EQ	Generates the rank of a number in a list of numbers
RSQ	Generates the square of the Pearson product moment correlation coefficient
SKEW	Generates the skewness of a distribution
SKEW.P	Generates the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
SLOPE	Generates the slope of the linear regression line
SMALL	Generates the k-th smallest value in a data set
STANDARDIZE	Generates a normalized value
STDEV.P	Calculates standard deviation based on the entire population
STDEV.S	Estimates standard deviation based on a sample
STDEVA	Estimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPA	Calculates standard deviation based on the entire population, including numbers, text, and logical values
STEYX	Generates the standard error of the predicted y-value for each x in the regression
T.DIST	Generates the Percentage Points (probability) for the Student t-distribution
T.DIST.2T	Generates the Percentage Points (probability) for the Student t-distribution
T.DIST.RT	Generates the Student’s t-distribution
T.INV	Generates the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom
T.INV.2T	Generates the inverse of the Student’s t-distribution
T.TEST	Generates the probability associated with a Student’s t-test
TREND	Generates values along a linear trend
TRIMMEAN	Generates the mean of the interior of a data set
VAR.P	Calculates variance based on the entire population
VAR.S	Estimates variance based on a sample
VARA	Estimates variance based on a sample, including numbers, text, and logical values
VARPA	Calculates variance based on the entire population, including numbers, text, and logical values
WEIBULL.DIST	Generates the Weibull distribution
Z.TEST	Generates the one-tailed probability-value of a z-test

Data Analytics with Excel, Tableau, and MySQL Workbench

MS Excel | Tableau | MySQL Workbench |

MS Excel

Cell Reference Types
Naming of Range
IF and IFS Function-Questions, Answers, and Practice
SUM Function-Questions, Answers, and Practice
SUMIF Function-Questions, Answers, and Practice
SUMIFS Function-Questions, Answers, and Practice
COUNTIF, COUNIFS Function-Questions, Answers, and Practice
CHOOSE Function-Questions, Answers, and Practice
VLOOKUP, HLOOKUP, XLOOKUP-Questions, Answers, and Practice
INDEX/MACTH-Questions, Answers, and Practice
AVERAGE, AVERAGEIFS-Questions, Answers, and Practice
IFERROR and SWITCH Functions-Questions, Answers, and Practice
FILTER Function-Questions, Answers, and Practice
SORT, SORTBY Function-Questions, Answers, and Practice
UNIQUE Function-Questions, Answers, and Practice
Quick Analysis-Questions, Answers, and Practice
Excel SOLVER-Questions, Answers, and Practice
TEXT Functions:
- LEFT
- RIGHT
- MID
- TRIM
- LEN
- FIND
- SEARCH
- REPT
- CONCAT
- REPLACE
- SUBSTITUTE
- UPPER/LOWER/PROPER
- TEXTJOIN
- CLEAN
Advanced Dynamic Array-Questions, Answers, and Practice
Interactive Reports in Excel
Ben Ford’s Law

Tableau

Tableau for Students:
- Download Tableau and Installation.
Tableau Desktop Basic
- Connecting Tableau to a Data File
- Tableau User Interface
- Navigating Tableau
- Creating Calculating Field
- Adding Colors
- Adding Labels and Formatting
- Exporting Worksheet
Time Series, Aggregation, and Filters
- Working with Data Extract in Tableau
- Time Series Data
- Aggregation, Granularity, and Level
- Area Chart
- Filter and Quick Filter
Maps & Scatterplots:
- Relationship Vs Joins
- Joining Data
- Creating Maps
- Scatterplots
- Dashboard
- Interactive Dashboard
Joining Multiple Tables:
- Different types of joins
- Join with duplicates
- Joining on Multiple ID
- Joining Vs Blending
- Dual Axis Charts
- Relationship in Tableau
Advance Dashboard:
- Connecting Data
- Setting Geographical roles
- Creating Table Calculations
- Creating Bins and Distribution
- Leveraging Power of Parameters

MySQL Workbench

Getting Started with MySQL Workbench:
- Introduction to Installing MySQL and MySQL Workbench for Beginners
- Why Learn SQL From Scratch? The Ultimate MySQL Bootcamp is Worth It!
- History & SQL “Flavors” (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL)
- MySQL Installation Overview
- PC Download – Community Server + Workbench
- Connecting Workbench to the Server
- MySQL Workbench Interface
- Creating the Maven Movies Database
Creating Single Table & Analysis
- Introduction to Databases and SQL Querying
- Getting to Know the Database
- The “Big 6” Statements and Clauses of SQL Queries
- The SELECT Statement – Your SQL Querying Starts Here
- The FROM Clause – Tell the Server Which Table Your SQL Query Will Pull Data From
- SELECT * FROM
- The USE Statement
- Selecting Specific Columns
- SELECT DISTINCT
- The WHERE Clause
- Common WHERE Operators
- Combining WHERE & AND
- Combining WHERE & OR
- Combining WHERE & IN
- The LIKE Operator
- LIKE Wildcard Examples
- The GROUP BY Clause
- GROUP BY Example
- Multiple Dimension GROUP BY Clauses
- Grouping with Aggregate Functions
- The HAVING Clause
- HAVING Example
- The ORDER BY Clause
- ORDER BY Example
Analyzing Multiple Tables with Join:
- Introduction to SQL JOINs and Querying Multiple Tables
- Normalization & Cardinality
- Relationship Diagrams
- Multi-Table Querying
- Reviewing the Maven Movies Database
- Common JOIN Types
- INNER JOIN
- INNER JOIN Example
- LEFT JOIN
- LEFT JOIN Example
- RIGHT JOIN
- LEFT vs. INNER vs. RIGHT JOIN
- FULL OUTER JOIN
- PRO TIP: “Bridging” Unrelated Tables
- Multi-Condition Joins
- The UNION Operator
- UNION Example

Data Analytics with Excel

Fundamentals of Statistics:

Introduction to Business Statistics
- What is statistics?
- Difference between descriptive and inferential statistics
- Population Vs Sample with Examples
- Statistic Vs Parameter Examples
- Qualitative Vs Quantitative Variables
- Levels of Measurements: Nominal, Ordinal, Interval, and Ratio
Displaying Descriptive Statistics
- Descriptive Statistics in Excel and STATA
Calculating Descriptive Statistics
Measures of Central Tendency
Measures of Dispersion
Visualization of Data:
- Boxplot in Excel, STATA, and Python
- Stem and Leaf Plots
- Scatter Plots in Excel Multiple Series
- Relative Frequency Histogram
- Density Curves
- Pareto Diagram
- Pie Charts
Sampling and Sampling Distribution
Confidence Interval
Hypothesis Testing for a Single Population
Hypothesis Testing for Two Populations
Analysis of Variance (ANOVA) Procedure
- One-way ANOVA
- Two-way ANOVA
- Repeated Measures ANOVA
- ANCOVA
- Kruskal-Wallis Test
- Friedman Test
Chi-Square Test
Hypothesis Test for the Population Variance
Correlation
Simple Regression
- How to calculate regression coefficient in Excel and STATA
- How to interpret simple regression coefficients in Excel and STATA
- How to test significance of a regression slope
- Understanding the standard error of the regression
- How to calculate residual in Regression analysis with STATA
- Heteroscedasticity in regression
- Multicollinearity in regression
Multiple Regression and Modeling
Forecasting
Nonparametric Method
Statistical Methods for Quality Control
Decision Analysis