Все публикации

Simple Linear Regression with Data Analysis Toolpak

Chi Square Tests with PhStat

TWO_WAY ANOVA with parachute2 data

ONE-WAY ANOVA with parachute data

Data Analysis Toolpak for t tests (independent sample and paired sample)

PhStat proportion test and variance equality test

PhStat paired sample t test

PhStat independent sample t test with unsummarized values option

PhStat independent sample t test

t Test and Z Test for the proportion with PHStat

Z Test for the mean using PhStat

Sample size determination for the mean and the proportion

Confidence Intervals with PhStat

Generating random samples with Data Analysis Toolpak

Normal probability plot construction

Using normal probability distribution functions in Excel

Portfolio Expectation and Variance with PHStat

Poisson distribution probabilities

Binomial probabilities with the Binom.dist function

Calculating Expected Value and Variance from a discrete distribution

Counting Rules

Conditional Probabilities with Pivot Table

What if function in Excel, using Goal Seek to calculate monthly payment of a loan.

Absolute Referencing, Relative Referencing and Mixed Referencing in Excel