Wiley chapter 8

Question 1

Which is the best tool when the desired result is know, but not the input value for a single variable will achiever that result?

Answer 1

Goal Seek

Question 2

An analysis prepared to support a predetermined belief is an example of

Answer 2

confirmation bias

Question 3

An anomaly is

Answer 3

an observation that deviates from what is normal or expected

Question 4

When examining the relationship between two variables, if one variable increases as the other variable decreases the relationship is

Answer 4

a negative correlation

Question 5

In a regression model prepared to predict revenue, which of the following is the correct interpretation of an adjusted R-squared of 0.85?

Answer 5

The independent variables in the model can explain 85% of the change in revenue

Question 6

A spreadsheet model that allows evaluating how changes to values and assumptions affect an outcome is called a

Answer 6

what-if analysis

Question 7

Determining if the analysis makes senses is associated with….

Answer 7

Data Analysis Interpretation

Question 8

An appropriate analysis to use to determine how many times an event has occurred would be

Answer 8

a frequency distribution

Question 9

Which of the following analysis can predict a future outcome?

Answer 9

Linear Regression

Question 10

If the objective is to use historical data to identify patterns, which is the best analysis to use?

Answer 10

Trend analysis