HBX Core Formulas and Excel Funtions - Business Analytics Questions and Answers (100% Correct Answers) Already Graded A+

Coefficient of Variation [ Ans: ] Standard Deviation÷Mean Z Value [ Ans: ] z=(x−µ)÷σ µ [ Ans: ] Population Mean σ [ Ans: ] Population Standard Deviation x¯¯ [ Ans: ] Sample Mean s [ Ans: ] Sample Standard Deviation One standard deviation in a normal distribution [ Ans: ] P( μ−σ≤x≤μ+σ)≈68% Two (1.96) standard deviations in a normal distribution [ Ans: ] P(μ−2σ≤x≤μ+2σ)≈95% Three standard deviations in a normal distribution [ Ans: ] P(μ−3σ≤x≤μ+3σ)≈99.7% Upper and lower bounds of a confidence interval [ Ans: ] x¯±z(s÷√n) Single variable linear regression [ Ans: ] y^=a+bx y^ [ Ans: ] The expected value of y, the dependent variable, for a given value of x x [ Ans: ] The independent variable, the variable we are using to help us predict or better understand the dependent variable a [ Ans: ] The y-intercept, the point at which the regression line intersects the vertical axis. This is the value of y^ when the independent variable, x, is set equal to 0 b [ Ans: ] The slope, the average change in the dependent variable y as the independent variable x increases by one R² [ Ans: ] Variation explained by the regression line÷Total variation=Regression Sum of Squares÷Total Sum of Squares R² for single variable linear regression [ Ans: ] Square of the correlation coefficient The true relationship between 2 variables [ Ans: ] y=α+β x+ε Multiple Linear Regression [ Ans: ] y^=a+b₁x₁+b₂x₂+...+b₀x₀ Excel - Creating a regression model using dummy variables [ Ans: ] =IF(logical_test,[value_if_true],[value_if_false]) Excel - find the average [ Ans: ] =AVERAGE(number 1, [number 2], ...) Excel - find the median [ Ans: ] =MEDIAN(number 1, [number 2], ...) Excel - find the mode [ Ans: ] =MODE.SNGL(number 1, [number 2], ...) Excel - find the conditional mean [ Ans: ] =AVERAGEIF(range, criteria, [average_range]) Excel - find the nth percentile of value [ Ans: ] =PERCENTILE.INC(array, k) Excel - find the variation [ Ans: ] =VAR.S(number 1, [number 2], ...) Excel - find the standard deviation [ Ans: ] =STDEV.S(number 1, [number 2], ...) Excel - find the correlation coefficient [ Ans: ] =CORREL(array 1, array 2) Excel - generate random values for sample selection [ Ans: ] =RAND() Excel - find the cumulative probability (the probability of being less than a specified value on a normal curve) [ Ans: ] =NORM.DIST(x, mean, standard_dev, cumulative) Excel - find the cumulative probability of a normal curve [ Ans: ] =NORM.S.DIST(z, cumulative) Excel - find the inverse of the cumulative probability for a normal curve; calculate a given percentile [ Ans: ] =NORM.INV(probability, mean, standard_dev) Excel -find the marg