Regression
What visuals do we use to assess and explore the analysis
scatterplats and correlation
The single most important distribution in statistics
the normal distribution
What is the function or character used to lock cell references?
f4 or $
The hypothesis that the analysis evaluates
Ha or alternative hypothesis
What is more subject to errors
Long-term forecasts
What is the linear regressoin equation
y = a + bx
What does a 95% confidence interval mean?
We are 95% confident that the intervals that we calculated will contain the population parameter.
What are the commands that can be used to select a large amount of data?
ctrl + shift + (Arrow key)
What is mutually exclusive
the null and alternate hypothesis
Seasonal trend vs Cyclical trend
wave-like pattern describing a long-term trend (cyclical)
What always increases as we add variables to our model
R-squared
What kind of distribution is used to obtain multiples for mean intervals, and the standard normal distribution for proportion intervals
t-distribution
How can you code variables with categories?
If statement of VLOOKUP
The LOS test is determined by what error probability
Type 1 error
What are the three things that we can used to measure the accuracy of regression models
MAE, RMSE, MAPE
In logistic regression, what unit are our Exp(coef) in
odd units
point estimate +/- multiple *SE
is the form of what
a confidence interval
What formula do we use to add the product of at least two ranges?
=sumproduct
If the p-value is small?
reject the null
What exponential smoothing forecast is appropriate for a series with seasonality and a possible trend
Winter's Method
When calculating probabilities, what do we have to make sure is in the denominator, of our e
a negative
The three emperical rules
1. 68% of data falls within one standard deviation of the mean
2. 95% of the data falls within two standard deviations of the mean
3. 99% of data falls within three standard deviations of the mean
What is the one type of table that can be helpful in many situations?
Pivot Table
We calculate this test statistic for what type of hypothesis test
𝑡=(𝑥̄−𝜇)/(𝑠/𝑛)𝑡=(𝑥̄−𝜇)/(𝑠/𝑛√)
mean
When larger smoothing constants produce less smoothing and forecasts track the actual series more closely, what can we be forecasting
random noise