Data Analysis - Quiz 3

What-if analysis in Excel allows users to explore different outcomes by changing which elements?

• Formulas themselves
• Input variables
• Formatting styles
• Data ranges

In scenario analysis, what are independent variables?

• Variables affected by the model
• Variables derived from dependent values
• Inputs determined outside the model
• Random factors

Which of the following best describes a dependent variable?

• An input to the model
• A variable calculated from inputs
• A constant in the formula
• A fixed number

A company wants to test what their taxes would be if income changes — this is an example of:

• Regression analysis
• Scenario analysis
• Forecasting
• Goal seek

Sensitivity analysis differs from scenario analysis because it:

• Focuses on one specific scenario
• Uses a range of input values
• Is used only for dependent variables
• Does not use Excel

In a sensitivity table, which type of variables are typically labeled on the axes?

• Dependent variables
• Independent variables
• Random values
• Constant parameters

When supply and demand are equal, the price shown in a sensitivity table represents:

• A shortage
• An equilibrium
• A maximum value
• A dependent variable error

If demand is high and supply is low, what happens to price in a sensitivity table?

• It decreases
• It stays constant
• It increases
• It becomes undefined

How do you calculate growth rate?

• Divide start by end value
• Subtract end from start
• Divide the difference by the start value
• Multiply start by end

If sales grew from 50 million to 70 million, the growth rate is:

• 20%
• 30%
• 40%
• 50%