HBX Core Formulas and Excel Funtions - Business Analytics Questions And Answers|Latest Update

HBX Core Formulas and Excel Funtions -
Business Analytics Questions And
Answers|Latest Update



Multiple Linear Regression y^=a+b₁x₁+b₂x₂+...+b₀x₀



Excel - Creating a regression model using dummy variables
=IF(logical_test,[value_if_true],[value_if_false])




Excel - find the average =AVERAGE(number 1, [number 2], ...)




Excel - find the median =MEDIAN(number 1, [number 2], ...)




Excel - find the mode =MODE.SNGL(number 1, [number 2], ...)




Excel - find the conditional mean =AVERAGEIF(range, criteria, [average_range])




Excel - find the nth percentile of value =PERCENTILE.INC(array, k)




Excel - find the variation =VAR.S(number 1, [number 2], ...)

, HBX Core Formulas and Excel Funtions -
Business Analytics Questions And
Answers|Latest Update

Excel - find the standard deviation =STDEV.S(number 1, [number 2], ...)




Excel - find the correlation coefficient =CORREL(array 1, array 2)




Excel - generate random values for sample selection =RAND()



Excel - find the cumulative probability (the probability of being less than a specified value on a
normal curve) =NORM.DIST(x, mean, standard_dev, cumulative)




Excel - find the cumulative probability of a normal curve =NORM.S.DIST(z, cumulative)



Excel - find the inverse of the cumulative probability for a normal curve; calculate a given
percentile =NORM.INV(probability, mean, standard_dev)



Excel -find the margin of error for a large sample in order to build a confidence interval
=CONFIDENCE.NORM(alpha, standard_dev, size)




Excel - find the margin or error for a small sample size =CONFIDENCE.T(alpha,
standard_dev, size)