A(n) ____________ refers to a model input that can be controlled ...

[altibaby]

A(n) ____________ refers to a model input that can be controlled in a spreadsheet model.
 a. decision variable b. outlier
  c. parameter d. dummy variable

Question 2

Platinum Gym has 10,000 gyms members out of which 1500 memberships included Unlimited Fitness Training and use of the tanning salon, and out of which 750 included Unlimited Hydromassage. If the Fitness Training are considered A, the use of the tanning salon are considered B, and the Hydromassage are considered C, then the associate rule for these sales become, If A and B are purchased, then C is also purchased. Given total transactions for C is 3000 . Calculate the lift for this rule.

[Briannahope]

Answer to Question 1

a
RATIONALE: A model input the decision maker can control is referred to as a decision variable.

Answer to Question 2

1.67
RATIONALE: Total memberships = 10,
Packages of A and B = 1,500
Packages of A, B, and C = 750

The association rule, If A and B are purchased, then C is also purchased has a support of 750 out of 1500 sales. The confidence level = Total support/Total memberships = 750/1,500 = 50.

The total number of transactions for C is given as 3000 . Benchmark confidence is the number of transactions that include the consequent divided by the total number of transactions. Therefore the benchmark confidence level = 3,000/10,000 = 30. The lift is calculated as confidence / benchmark confidence = 50 / 30 = 1.67.

[altibaby]

Thank you

[Briannahope]

Happy to help you