4. Question 4 Which of the following list the correct steps to use to lookup a value based on a horizontal lookup value and a vertical lookup value? 1 / 1 point …
1. Question 1 Index Match allows you to complete which of the following functions? 1 / 1 point Measure profitability Ability to look vertically as well as horizontally with the same…
5. Question 5 How do we interpret the Y-intercept of our linear regression? 1 / 1 point A measure of the average dispersion of values in a dataset around the average value….
2. Question 2 What statistical method do we use to quantify the relationship between changes in the independent variable and changes in the dependent variable? 1 / 1 point R-Squared Covariance…
6. Question 6 You’ve completed a linear regression model using in-store sales data to store visits data. You observe a strong, positive correlation between the independent variable and the dependent…
3. Question 3 What do we use as a measurement of the average dispersion of values in a dataset around the average value? 1 / 1 point b Multicollinearity Standard deviation…
4. Question 4 How should we interpret a correlation coefficient of 1? 1 / 1 point No strong correlation between the two variables For every 1-unit increase in one variable, we…
1. Question 1 You are asked to predict total store sales based on the number of visitors to the store. You are provided a data set containing sales and store…
3. Question 3 In Exercise 5, what is the total headcount for Buffalo shift 2 employees? 1 point 11 279 519
2. Question 2 Once you have completed Exercise 3, what is the correct formula in cell K197? 1 point =SUMIFS(Head_Count,Office_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186) =COUNTIFS(Head_Count,Location_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186) =SUMIFS(Head_Count,Location_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186)
