Reference no: EM133218018
Question: There are four rules for credit rating and each customer may qualify for no rule or more than one rule:
Rule 1: Extend customer credit if there is no past due payment.
Rule 2: Extend customer credit if there is a maximum of one past due payment and credit score is at least 600.
Rule 3: Extend customer credit if there is a maximum of one past due payment and credit score is at least 700, or: The maximum risk rating is "2".
Rule 4: Extend customer credit if there is a maximum of two past-due payments, credit score is 720 or greater, Risk rating factor is 3 or lower, Total of purchases for the past 3 years is at least $200,000, and the customer has plans to expand the business.
Enter formulas/functions for rules 1-4 in columns I, J, K, and L respectively. These formulas will demonstrate if the customer credit is approved based on each rule.
Use conditional formatting to show different background colors for the rules outcomes (TRUE and FALSE).
In column "Credit Line" enter a function/formula to show the credit line for customers:
Customer qualifies for no rule: 0
Customer qualifies for one rule: $40,000
Customer qualifies for two rules: $60,000
Customer qualifies for three rules: $80,000
Customer qualifies for all rules: $100,000
Use 3-arrows conditional formatting on customer credit lines
|
Prediction made using regular multiple regression
: Summarize your results any way you like, but please don't give us the raw coefficients from 90 variables. c. Using the results from
|
|
Add a new field to the revenue query
: displays Profit when the value of the Net field is greater than zero and Loss when it is less than or equal to zero. Need this function drawn up for Microsoft A
|
|
Compute the checksum as tcp/ip does
: See if you can compute the checksum as TCP/IP does. Run the applet, using any message. Select a data packet, but don't select the last packet because it might
|
|
What would be an obvious way to decrease the overhead
: How many characters in total (and to your best estimate) would be sent in all packets necessary to move it from node 0 to node 1?
|
|
Four rules for credit rating and each customer
: Enter formulas/functions for rules 1-4 in columns I, J, K, and L respectively. These formulas will demonstrate if the customer credit is approved based on each
|
|
Evaluate various platforms for characteristics
: Evaluate various platforms for characteristics, advantages, and weaknesses for hosting a web-based software application. Consider the following in your
|
|
Provide an overview of your data
: Provide an overview of your data, business/organization, and use case Analyze the data and give reasoning of why you think it is useful to the business
|
|
Draw a deterministic and non-deterministic finite automate
: Draw a deterministic and non-deterministic finite automate which accept AA and BB at the end of a string containing A, B in it, e.g., ABABABAA but not AAABBBABA
|
|
Design an algorithm that outputs the time-stamps
: Design an algorithm that outputs the time-stamps in the correct order and uses only a constant amount of storage, i.e., the memory used should be independent
|