Question 17
Discounts are calculated as a percentage of the balance owed, rates vary depending on how large the balance is. The lookup table in S2:T5 details what percentage is applied, so for example balances from 300 to 11999.99 get a 5% discount. In column N calculate how much discount will be awarded for each customer if they are eligible. Include an Average calculation in the Total row for Discount Offered. What was the average Discount Offered?
1. Question 1 Think about all of the methods we have covered that allow us to model agents. Which of the following CAN be true? You may select more than…
8. Question 8 For which of the following business processes is a log function particularly useful in modeling the output? 1 point  A process that exhibits seasonality A process…
3. Question 3 Which of the following characterizes the strategic approach of a differentiated player? 1 / 1 point  Relies on broad market appeal  Produces a product customers are willing to…
7. Question 7 A regression is performed to determine the effect of the Experience of an employee (in years) on the Processing Time (PT) of a job. Is this a…
5. Question 5 In the ‘Creating Basic Charts in Excel’ video, which type of chart shows the relative contribution of unit sales from Ford car models? 1 point  Line…
6. Question 6 The Reform Bias takes the form of: S​elect all that apply. 1 / 1 point  No consideration for results and outcomes of change initiatives  Pressure to create reforms,…
