Overview
exam starting at 18:20 today You may bring to the exam 8 pages of notes, front and back, 8 1/2 by 11 inch, written or typed. No photocopies. So essentially 16 sides of paper. No books, no PPTs, no notes on computers or IPADS or other tablets or other electronic devices. Phone must be put away during the exam in pocket, bag or purse. You may not text or email or communicate with anyone in anyway during the exam. You may have on your laptops any EXCEL files that will help you do break even/NPV/merge purge/etc. You can bring a calculator, but not one on a phone or smartphone or on any other electronic device.
Be sure you know how to access Census data through the various sites we have gone over in class. Make sure you know how to use Claritas and have access to ChatGPT 4.0
What you should study (this may not be a complete lists but it is pretty comprehensive)
MLR, SLR, Correlation, Scatter plots and trendlines
Breakeven
NPV
Monetary value
Profitability
Census data
Claritas data
different kinds of variables
How to combine variables into what type of variables
Inactive customers vs. active customers
Cross tabbing
Gains charts
Entity relationships
Merge/purge
Sampling
Validation samples
RFM
Retention
Different kinds of data tables
Different kinds of lists.
Database maintenance rules
Updates to data tables and updates to customer records -- how to do this, what is it
Test variables
Nth name select
Basics of large language models, prompt engineering
Remember this is not a comprehensive list, but a guide as to what to study.