Sentry Page Protection
Exercise (6-10)
cont...
Task 3
Tom also wants to find out, on average, how long the majority of the computer will start experiencing problems.
Create a new variable called PERIOD that classifies the period where the computers start experience problems:
The classification should be based on the date of purchase and date of repair requested.
Example
Date of Purchase: 01JAN2013
Date of Repair: 01APR2014
Since there are about 15 months between the date of purchase and date of repair, the period should be classified as "Between 1-2 year".
Please note that the date of purchase contains some incomplete date, as most customers didn't remember the exact date when they made the purchase.
You should assume middle of the month if the day of purchase is missing.
E.g.
FEB2013 --> 15FEB2013
You should also assume middle of the year if the month of purchase is missing.
E.g.
2013 --> 30JUN2013
cont...
Task 3
Tom also wants to find out, on average, how long the majority of the computer will start experiencing problems.
Create a new variable called PERIOD that classifies the period where the computers start experience problems:
- < 1 year
- Between 1-2 year
- Between 2-3 year
- >3 year
The classification should be based on the date of purchase and date of repair requested.
Example
Date of Purchase: 01JAN2013
Date of Repair: 01APR2014
Since there are about 15 months between the date of purchase and date of repair, the period should be classified as "Between 1-2 year".
Please note that the date of purchase contains some incomplete date, as most customers didn't remember the exact date when they made the purchase.
You should assume middle of the month if the day of purchase is missing.
E.g.
FEB2013 --> 15FEB2013
You should also assume middle of the year if the month of purchase is missing.
E.g.
2013 --> 30JUN2013