data analysis
Faridak3
UNIT01INTROPIVOTTABLESPROJECT.xlsxDATASET
| 1.DATASET | 2. FUNCTIONS | |||||||||||
| Month | Sales | Level of Satisfacton | Nationality | Conditions? | Functions | |||||||
| 01 - January | 217.24 $ | satisfied | ESP | (No conditions) | SUM | COUNT | AVERAGE | MAX | MIN | |||
| 01 - January | 178.66 $ | neutral | FRA | (1 condition) | SUMIF | COUNTIF | AVERAGEIF | MAXIFS | MINIFS | |||
| 01 - January | 188.36 $ | satisfied | DNK | (1 condition) | SUMIF | COUNTIF | AVERAGEIF | MAXIFS | MINIFS | |||
| 01 - January | 294.31 $ | satisfied | FRA | (2 or more conditions) | SUMIFS | COUNTIFS | AVERAGEIFS | MAXIFS | MINIFS | |||
| 01 - January | 498.73 $ | neutral | KSA | |||||||||
| 01 - January | 253.14 $ | satisfied | USA | |||||||||
| 01 - January | 230.83 $ | neutral | ESP | 3. EXERCISE 1 | ||||||||
| 01 - January | 498.73 $ | satisfied | GBR | Criteria | Customers | Sales | Sales per customer | |||||
| 01 - January | 202.51 $ | satisfied | ESP | 01 - January | ||||||||
| 01 - January | 188.36 $ | satisfied | GBR | 02 - February | ||||||||
| 01 - January | 252.82 $ | dissatisfied | DNK | 03 - March | ||||||||
| 01 - January | 358.34 $ | satisfied | IRL | 04 - April | ||||||||
| 02 - February | 460.61 $ | satisfied | IRL | 5-May | ||||||||
| 02 - February | 425.21 $ | dissatisfied | POL | 06 - June | ||||||||
| 02 - February | 223.32 $ | satisfied | ITA | 07 - July | ||||||||
| 02 - February | 253.14 $ | dissatisfied | DEU | 08 - August | ||||||||
| 02 - February | 184.66 $ | dissatisfied | DEU | 09 - September | ||||||||
| 02 - February | 398.98 $ | neutral | POL | 10 - October | ||||||||
| 02 - February | 178.66 $ | satisfied | USA | 11 - November | ||||||||
| 02 - February | 223.32 $ | neutral | ITA | 12 - December | ||||||||
| 02 - February | 460.61 $ | satisfied | IRL | TOTAL | ||||||||
| 02 - February | 425.21 $ | dissatisfied | POL | |||||||||
| 02 - February | 223.32 $ | satisfied | ITA | Find the month with the highest average sales per customer | ||||||||
| 02 - February | 253.14 $ | dissatisfied | DEU | |||||||||
| 02 - February | 184.66 $ | dissatisfied | DEU | 3. EXERCISE 2 | ||||||||
| 02 - February | 398.98 $ | neutral | POL | Criteria | Customers | Sales | Sales per customer | |||||
| 02 - February | 178.66 $ | satisfied | USA | Satisfied | ||||||||
| 02 - February | 223.32 $ | neutral | ITA | Neutral | ||||||||
| 02 - February | 460.61 $ | satisfied | IRL | Dissatisfied | ||||||||
| 02 - February | 425.21 $ | dissatisfied | POL | TOTAL | ||||||||
| 02 - February | 223.32 $ | satisfied | ITA | |||||||||
| 02 - February | 253.14 $ | dissatisfied | DEU | What is the percentage of Satisfied Customers? | ||||||||
| 02 - February | 184.66 $ | dissatisfied | DEU | |||||||||
| 02 - February | 398.98 $ | neutral | POL | 3. EXERCISE 3 | ||||||||
| 02 - February | 178.66 $ | satisfied | USA | Criteria 1 | Criteria 2 | Customers | Sales | Sales per customer | ||||
| 02 - February | 223.32 $ | neutral | ITA | Satisfied | ||||||||
| 02 - February | 460.61 $ | satisfied | IRL | Neutral | ||||||||
| 02 - February | 425.21 $ | dissatisfied | POL | Dissatisfied | ||||||||
| 02 - February | 223.32 $ | satisfied | ITA | TOTAL | ||||||||
| 02 - February | 253.14 $ | dissatisfied | DEU | |||||||||
| 02 - February | 184.66 $ | dissatisfied | DEU | What percentage of French customers are Satisfied? | ||||||||
| 02 - February | 398.98 $ | neutral | POL | |||||||||
| 02 - February | 178.66 $ | satisfied | USA | |||||||||
| 02 - February | 223.32 $ | neutral | ITA | |||||||||
| 03 - March | 294.31 $ | dissatisfied | ESP | |||||||||
| 03 - March | 294.31 $ | neutral | DEU | |||||||||
| 03 - March | 498.73 $ | dissatisfied | ITA | |||||||||
| 03 - March | 271.55 $ | satisfied | FRA | |||||||||
| 03 - March | 340.17 $ | satisfied | IRL | |||||||||
| 03 - March | 217.24 $ | satisfied | GBR | |||||||||
| 03 - March | 294.79 $ | neutral | GBR | |||||||||
| 03 - March | 229.34 $ | neutral | IRL | |||||||||
| 03 - March | 498.73 $ | satisfied | ITA | |||||||||
| 03 - March | 339.44 $ | neutral | GBR | |||||||||
| 03 - March | 294.31 $ | dissatisfied | ESP | |||||||||
| 03 - March | 294.31 $ | neutral | DEU | |||||||||
| 03 - March | 498.73 $ | dissatisfied | ITA | |||||||||
| 03 - March | 271.55 $ | satisfied | FRA | |||||||||
| 03 - March | 340.17 $ | satisfied | IRL | |||||||||
| 03 - March | 217.24 $ | satisfied | GBR | |||||||||
| 03 - March | 294.79 $ | neutral | GBR | |||||||||
| 03 - March | 229.34 $ | neutral | IRL | |||||||||
| 03 - March | 498.73 $ | satisfied | ITA | |||||||||
| 03 - March | 339.44 $ | neutral | GBR | |||||||||
| 03 - March | 294.31 $ | dissatisfied | ESP | |||||||||
| 03 - March | 294.31 $ | neutral | DEU | |||||||||
| 03 - March | 498.73 $ | dissatisfied | ITA | |||||||||
| 03 - March | 358.34 $ | neutral | DEU | |||||||||
| 03 - March | 498.73 $ | neutral | KSA | |||||||||
| 03 - March | 253.14 $ | satisfied | USA | |||||||||
| 03 - March | 230.83 $ | neutral | ESP | |||||||||
| 03 - March | 498.73 $ | satisfied | GBR | |||||||||
| 03 - March | 202.51 $ | satisfied | ESP | |||||||||
| 03 - March | 188.36 $ | satisfied | GBR | |||||||||
| 03 - March | 252.82 $ | dissatisfied | DNK | |||||||||
| 03 - March | 358.34 $ | satisfied | IRL | |||||||||
| 03 - March | 498.73 $ | dissatisfied | ITA | |||||||||
| 03 - March | 271.55 $ | satisfied | FRA | |||||||||
| 03 - March | 340.17 $ | satisfied | IRL | |||||||||
| 03 - March | 217.24 $ | satisfied | GBR | |||||||||
| 03 - March | 294.79 $ | neutral | GBR | |||||||||
| 03 - March | 229.34 $ | neutral | IRL | |||||||||
| 03 - March | 498.73 $ | satisfied | ITA | |||||||||
| 03 - March | 339.44 $ | neutral | GBR | |||||||||
| 04 - April | 447.88 $ | satisfied | DNK | |||||||||
| 04 - April | 489.04 $ | satisfied | DEU | |||||||||
| 04 - April | 395.04 $ | neutral | FRA | |||||||||
| 04 - April | 223.32 $ | neutral | KSA | |||||||||
| 04 - April | 223.32 $ | satisfied | ESP | |||||||||
| 04 - April | 272.13 $ | dissatisfied | KSA | |||||||||
| 04 - April | 156.89 $ | dissatisfied | DEU | |||||||||
| 04 - April | 395.04 $ | neutral | FRA | |||||||||
| 04 - April | 223.32 $ | dissatisfied | KSA | |||||||||
| 04 - April | 447.88 $ | satisfied | DNK | |||||||||
| 04 - April | 489.04 $ | satisfied | DEU | |||||||||
| 04 - April | 395.04 $ | neutral | FRA | |||||||||
| 04 - April | 223.32 $ | neutral | KSA | |||||||||
| 04 - April | 223.32 $ | satisfied | ESP | |||||||||
| 04 - April | 358.34 $ | neutral | DEU | |||||||||
| 04 - April | 498.73 $ | neutral | KSA | |||||||||
| 04 - April | 253.14 $ | satisfied | USA | |||||||||
| 04 - April | 230.83 $ | neutral | ESP | |||||||||
| 04 - April | 498.73 $ | satisfied | GBR | |||||||||
| 04 - April | 202.51 $ | satisfied | ESP | |||||||||
| 04 - April | 188.36 $ | satisfied | GBR | |||||||||
| 04 - April | 252.82 $ | dissatisfied | DNK | |||||||||
| 04 - April | 358.34 $ | satisfied | IRL | |||||||||
| 04 - April | 272.13 $ | dissatisfied | KSA | |||||||||
| 04 - April | 156.89 $ | dissatisfied | DEU | |||||||||
| 04 - April | 395.04 $ | neutral | FRA | |||||||||
| 04 - April | 223.32 $ | dissatisfied | KSA | |||||||||
| 04 - April | 447.88 $ | satisfied | DNK | |||||||||
| 04 - April | 489.04 $ | satisfied | DEU | |||||||||
| 04 - April | 395.04 $ | neutral | FRA | |||||||||
| 04 - April | 223.32 $ | neutral | KSA | |||||||||
| 04 - April | 223.32 $ | satisfied | ESP | |||||||||
| 04 - April | 178.66 $ | neutral | FRA | |||||||||
| 04 - April | 188.36 $ | satisfied | DNK | |||||||||
| 04 - April | 294.31 $ | satisfied | FRA | |||||||||
| 04 - April | 316.03 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 358.34 $ | neutral | DEU | |||||||||
| 05 - Mayo | 498.73 $ | neutral | KSA | |||||||||
| 05 - Mayo | 253.14 $ | satisfied | USA | |||||||||
| 05 - Mayo | 230.83 $ | neutral | ESP | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 202.51 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 188.36 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 252.82 $ | dissatisfied | DNK | |||||||||
| 05 - Mayo | 358.34 $ | satisfied | IRL | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | KSA | |||||||||
| 05 - Mayo | 460.61 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 425.21 $ | neutral | GBR | |||||||||
| 05 - Mayo | 358.34 $ | neutral | DEU | |||||||||
| 05 - Mayo | 498.73 $ | neutral | KSA | |||||||||
| 05 - Mayo | 253.14 $ | satisfied | USA | |||||||||
| 05 - Mayo | 230.83 $ | neutral | ESP | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 202.51 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 188.36 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 252.82 $ | dissatisfied | DNK | |||||||||
| 05 - Mayo | 358.34 $ | satisfied | IRL | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | KSA | |||||||||
| 05 - Mayo | 460.61 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 425.21 $ | neutral | GBR | |||||||||
| 05 - Mayo | 358.34 $ | neutral | DEU | |||||||||
| 05 - Mayo | 498.73 $ | neutral | KSA | |||||||||
| 05 - Mayo | 253.14 $ | satisfied | USA | |||||||||
| 05 - Mayo | 230.83 $ | neutral | ESP | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 202.51 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 188.36 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 252.82 $ | dissatisfied | DNK | |||||||||
| 05 - Mayo | 358.34 $ | satisfied | IRL | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | KSA | |||||||||
| 05 - Mayo | 460.61 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 425.21 $ | neutral | GBR | |||||||||
| 05 - Mayo | 358.34 $ | neutral | DEU | |||||||||
| 05 - Mayo | 498.73 $ | neutral | KSA | |||||||||
| 05 - Mayo | 253.14 $ | satisfied | USA | |||||||||
| 05 - Mayo | 230.83 $ | neutral | ESP | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 202.51 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 188.36 $ | satisfied | GBR | |||||||||
| 05 - Mayo | 252.82 $ | dissatisfied | DNK | |||||||||
| 05 - Mayo | 358.34 $ | satisfied | IRL | |||||||||
| 05 - Mayo | 498.73 $ | satisfied | KSA | |||||||||
| 05 - Mayo | 460.61 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 425.21 $ | neutral | GBR | |||||||||
| 05 - Mayo | 245.14 $ | satisfied | USA | |||||||||
| 05 - Mayo | 460.61 $ | dissatisfied | ITA | |||||||||
| 05 - Mayo | 368.49 $ | dissatisfied | KSA | |||||||||
| 05 - Mayo | 235.45 $ | dissatisfied | USA | |||||||||
| 05 - Mayo | 391.24 $ | neutral | DEU | |||||||||
| 05 - Mayo | 398.98 $ | dissatisfied | FRA | |||||||||
| 05 - Mayo | 178.66 $ | neutral | FRA | |||||||||
| 05 - Mayo | 188.36 $ | satisfied | DNK | |||||||||
| 05 - Mayo | 294.31 $ | satisfied | FRA | |||||||||
| 05 - Mayo | 316.03 $ | satisfied | ESP | |||||||||
| 05 - Mayo | 294.79 $ | neutral | FRA | |||||||||
| 05 - Mayo | 188.36 $ | satisfied | DEU | |||||||||
| 06 - June | 294.79 $ | neutral | FRA | |||||||||
| 06 - June | 188.36 $ | satisfied | DEU | |||||||||
| 06 - June | 217.24 $ | satisfied | ESP | |||||||||
| 06 - June | 178.66 $ | neutral | FRA | |||||||||
| 06 - June | 188.36 $ | satisfied | DNK | |||||||||
| 06 - June | 294.31 $ | satisfied | FRA | |||||||||
| 06 - June | 202.51 $ | dissatisfied | KSA | |||||||||
| 06 - June | 272.13 $ | satisfied | ESP | |||||||||
| 06 - June | 358.34 $ | neutral | DEU | |||||||||
| 06 - June | 498.73 $ | neutral | KSA | |||||||||
| 06 - June | 253.14 $ | satisfied | USA | |||||||||
| 06 - June | 230.83 $ | neutral | ESP | |||||||||
| 06 - June | 498.73 $ | satisfied | GBR | |||||||||
| 06 - June | 202.51 $ | satisfied | ESP | |||||||||
| 06 - June | 188.36 $ | satisfied | GBR | |||||||||
| 06 - June | 252.82 $ | dissatisfied | DNK | |||||||||
| 06 - June | 358.34 $ | satisfied | IRL | |||||||||
| 06 - June | 156.89 $ | neutral | FRA | |||||||||
| 06 - June | 202.51 $ | dissatisfied | KSA | |||||||||
| 06 - June | 272.13 $ | satisfied | ESP | |||||||||
| 06 - June | 142.93 $ | satisfied | GBR | |||||||||
| 06 - June | 230.83 $ | neutral | IRL | |||||||||
| 06 - June | 358.31 $ | neutral | DEU | |||||||||
| 06 - June | 235.45 $ | neutral | DEU | |||||||||
| 06 - June | 230.83 $ | neutral | IRL | |||||||||
| 06 - June | 358.31 $ | neutral | DEU | |||||||||
| 06 - June | 253.14 $ | satisfied | ESP | |||||||||
| 06 - June | 235.45 $ | satisfied | DEU | |||||||||
| 06 - June | 368.49 $ | neutral | IRL | |||||||||
| 06 - June | 156.89 $ | neutral | FRA | |||||||||
| 06 - June | 202.51 $ | dissatisfied | KSA | |||||||||
| 06 - June | 272.13 $ | satisfied | ESP | |||||||||
| 06 - June | 142.93 $ | satisfied | GBR | |||||||||
| 06 - June | 230.83 $ | neutral | IRL | |||||||||
| 06 - June | 358.31 $ | neutral | DEU | |||||||||
| 06 - June | 235.45 $ | neutral | DEU | |||||||||
| 06 - June | 230.83 $ | neutral | IRL | |||||||||
| 06 - June | 358.34 $ | neutral | DEU | |||||||||
| 06 - June | 498.73 $ | neutral | KSA | |||||||||
| 06 - June | 253.14 $ | satisfied | USA | |||||||||
| 06 - June | 230.83 $ | neutral | ESP | |||||||||
| 06 - June | 498.73 $ | satisfied | GBR | |||||||||
| 06 - June | 202.51 $ | satisfied | ESP | |||||||||
| 06 - June | 188.36 $ | satisfied | GBR | |||||||||
| 06 - June | 252.82 $ | dissatisfied | DNK | |||||||||
| 06 - June | 178.66 $ | neutral | FRA | |||||||||
| 06 - June | 188.36 $ | satisfied | DNK | |||||||||
| 06 - June | 294.31 $ | satisfied | FRA | |||||||||
| 07 - July | 316.03 $ | satisfied | ESP | |||||||||
| 07 - July | 294.79 $ | neutral | FRA | |||||||||
| 07 - July | 188.36 $ | satisfied | DEU | |||||||||
| 07 - July | 217.24 $ | satisfied | ESP | |||||||||
| 07 - July | 178.66 $ | neutral | FRA | |||||||||
| 07 - July | 188.36 $ | satisfied | DNK | |||||||||
| 07 - July | 294.31 $ | satisfied | FRA | |||||||||
| 07 - July | 316.42 $ | satisfied | DEU | |||||||||
| 07 - July | 271.55 $ | satisfied | USA | |||||||||
| 07 - July | 271.55 $ | dissatisfied | FRA | |||||||||
| 07 - July | 235.45 $ | satisfied | DEU | |||||||||
| 07 - July | 271.55 $ | neutral | USA | |||||||||
| 07 - July | 447.93 $ | dissatisfied | ITA | |||||||||
| 07 - July | 358.34 $ | neutral | DEU | |||||||||
| 07 - July | 498.73 $ | neutral | KSA | |||||||||
| 07 - July | 253.14 $ | satisfied | USA | |||||||||
| 07 - July | 230.83 $ | neutral | ESP | |||||||||
| 07 - July | 498.73 $ | satisfied | GBR | |||||||||
| 07 - July | 202.51 $ | satisfied | ESP | |||||||||
| 07 - July | 188.36 $ | satisfied | GBR | |||||||||
| 07 - July | 252.82 $ | dissatisfied | DNK | |||||||||
| 07 - July | 358.34 $ | satisfied | IRL | |||||||||
| 07 - July | 235.45 $ | satisfied | DEU | |||||||||
| 07 - July | 271.55 $ | neutral | USA | |||||||||
| 07 - July | 447.93 $ | dissatisfied | ITA | |||||||||
| 07 - July | 279.15 $ | neutral | FRA | |||||||||
| 07 - July | 447.88 $ | neutral | KSA | |||||||||
| 07 - July | 425.21 $ | neutral | FRA | |||||||||
| 07 - July | 279.15 $ | satisfied | GBR | |||||||||
| 07 - July | 447.88 $ | dissatisfied | DEU | |||||||||
| 07 - July | 245.14 $ | satisfied | ESP | |||||||||
| 07 - July | 316.42 $ | satisfied | DEU | |||||||||
| 07 - July | 358.34 $ | neutral | DEU | |||||||||
| 07 - July | 498.73 $ | neutral | KSA | |||||||||
| 07 - July | 253.14 $ | satisfied | USA | |||||||||
| 07 - July | 230.83 $ | neutral | ESP | |||||||||
| 07 - July | 498.73 $ | satisfied | GBR | |||||||||
| 07 - July | 202.51 $ | satisfied | ESP | |||||||||
| 07 - July | 188.36 $ | satisfied | GBR | |||||||||
| 07 - July | 252.82 $ | dissatisfied | DNK | |||||||||
| 07 - July | 358.34 $ | satisfied | IRL | |||||||||
| 07 - July | 447.88 $ | dissatisfied | DEU | |||||||||
| 07 - July | 245.14 $ | satisfied | ESP | |||||||||
| 07 - July | 316.42 $ | satisfied | DEU | |||||||||
| 07 - July | 178.66 $ | neutral | FRA | |||||||||
| 07 - July | 188.36 $ | satisfied | DNK | |||||||||
| 07 - July | 294.31 $ | satisfied | FRA | |||||||||
| 07 - July | 316.03 $ | satisfied | ESP | |||||||||
| 08 - August | 294.79 $ | neutral | FRA | |||||||||
| 08 - August | 188.36 $ | satisfied | DEU | |||||||||
| 08 - August | 217.24 $ | satisfied | ESP | |||||||||
| 08 - August | 178.66 $ | neutral | FRA | |||||||||
| 08 - August | 188.36 $ | satisfied | DNK | |||||||||
| 08 - August | 294.31 $ | satisfied | FRA | |||||||||
| 08 - August | 288.53 $ | dissatisfied | ESP | |||||||||
| 08 - August | 279.15 $ | neutral | DEU | |||||||||
| 08 - August | 196.11 $ | dissatisfied | USA | |||||||||
| 08 - August | 178.66 $ | satisfied | ITA | |||||||||
| 08 - August | 286.65 $ | neutral | ESP | |||||||||
| 08 - August | 272.13 $ | satisfied | USA | |||||||||
| 08 - August | 398.98 $ | satisfied | GBR | |||||||||
| 08 - August | 245.14 $ | neutral | ITA | |||||||||
| 08 - August | 288.53 $ | dissatisfied | ESP | |||||||||
| 08 - August | 288.53 $ | satisfied | FRA | |||||||||
| 08 - August | 316.42 $ | neutral | ESP | |||||||||
| 08 - August | 288.53 $ | neutral | DEU | |||||||||
| 08 - August | 339.44 $ | satisfied | FRA | |||||||||
| 08 - August | 425.21 $ | satisfied | IRL | |||||||||
| 08 - August | 316.42 $ | neutral | DEU | |||||||||
| 08 - August | 288.53 $ | dissatisfied | ESP | |||||||||
| 08 - August | 279.15 $ | neutral | DEU | |||||||||
| 08 - August | 196.11 $ | dissatisfied | USA | |||||||||
| 08 - August | 178.66 $ | satisfied | ITA | |||||||||
| 08 - August | 286.65 $ | neutral | ESP | |||||||||
| 08 - August | 272.13 $ | satisfied | USA | |||||||||
| 08 - August | 398.98 $ | satisfied | GBR | |||||||||
| 08 - August | 245.14 $ | neutral | ITA | |||||||||
| 08 - August | 288.53 $ | dissatisfied | ESP | |||||||||
| 08 - August | 288.53 $ | satisfied | FRA | |||||||||
| 08 - August | 316.42 $ | neutral | ESP | |||||||||
| 08 - August | 288.53 $ | neutral | DEU | |||||||||
| 08 - August | 339.44 $ | satisfied | FRA | |||||||||
| 08 - August | 425.21 $ | satisfied | IRL | |||||||||
| 08 - August | 316.42 $ | neutral | DEU | |||||||||
| 08 - August | 178.66 $ | neutral | FRA | |||||||||
| 08 - August | 188.36 $ | satisfied | DNK | |||||||||
| 08 - August | 294.31 $ | satisfied | FRA | |||||||||
| 08 - August | 316.03 $ | satisfied | ESP | |||||||||
| 08 - August | 294.79 $ | neutral | FRA | |||||||||
| 08 - August | 188.36 $ | satisfied | DEU | |||||||||
| 08 - August | 217.24 $ | satisfied | ESP | |||||||||
| 08 - August | 178.66 $ | neutral | FRA | |||||||||
| 08 - August | 188.36 $ | satisfied | DNK | |||||||||
| 08 - August | 294.31 $ | satisfied | FRA | |||||||||
| 08 - August | 252.82 $ | dissatisfied | DNK | |||||||||
| 08 - August | 358.34 $ | satisfied | IRL | |||||||||
| 08 - August | 339.44 $ | satisfied | FRA | |||||||||
| 08 - August | 425.21 $ | satisfied | IRL | |||||||||
| 08 - August | 316.42 $ | neutral | DEU | |||||||||
| 08 - August | 288.53 $ | dissatisfied | ESP | |||||||||
| 08 - August | 279.15 $ | neutral | DEU | |||||||||
| 08 - August | 196.11 $ | dissatisfied | USA | |||||||||
| 08 - August | 178.66 $ | satisfied | ITA | |||||||||
| 08 - August | 286.65 $ | neutral | ESP | |||||||||
| 08 - August | 272.13 $ | satisfied | USA | |||||||||
| 08 - August | 398.98 $ | satisfied | GBR | |||||||||
| 08 - August | 245.14 $ | neutral | ITA | |||||||||
| 08 - August | 288.53 $ | dissatisfied | ESP | |||||||||
| 08 - August | 288.53 $ | neutral | DEU | |||||||||
| 08 - August | 339.44 $ | satisfied | FRA | |||||||||
| 08 - August | 425.21 $ | satisfied | IRL | |||||||||
| 08 - August | 316.42 $ | neutral | DEU | |||||||||
| 08 - August | 288.53 $ | dissatisfied | ESP | |||||||||
| 08 - August | 279.15 $ | neutral | DEU | |||||||||
| 09 - September | 493.80 $ | neutral | ITA | |||||||||
| 09 - September | 623.41 $ | satisfied | KSA | |||||||||
| 09 - September | 339.44 $ | dissatisfied | DEU | |||||||||
| 09 - September | 460.61 $ | dissatisfied | USA | |||||||||
| 09 - September | 623.41 $ | satisfied | GBR | |||||||||
| 09 - September | 623.41 $ | satisfied | DNK | |||||||||
| 09 - September | 358.34 $ | neutral | DEU | |||||||||
| 09 - September | 498.73 $ | neutral | KSA | |||||||||
| 09 - September | 253.14 $ | satisfied | USA | |||||||||
| 09 - September | 230.83 $ | neutral | ESP | |||||||||
| 09 - September | 498.73 $ | satisfied | GBR | |||||||||
| 09 - September | 202.51 $ | satisfied | ESP | |||||||||
| 09 - September | 188.36 $ | satisfied | GBR | |||||||||
| 09 - September | 252.82 $ | dissatisfied | DNK | |||||||||
| 09 - September | 358.34 $ | satisfied | IRL | |||||||||
| 09 - September | 623.41 $ | satisfied | DNK | |||||||||
| 09 - September | 339.44 $ | satisfied | USA | |||||||||
| 09 - September | 294.31 $ | neutral | GBR | |||||||||
| 09 - September | 368.49 $ | satisfied | ITA | |||||||||
| 09 - September | 294.79 $ | neutral | DEU | |||||||||
| 09 - September | 493.80 $ | neutral | ITA | |||||||||
| 09 - September | 623.41 $ | satisfied | KSA | |||||||||
| 09 - September | 339.44 $ | dissatisfied | DEU | |||||||||
| 09 - September | 460.61 $ | dissatisfied | USA | |||||||||
| 09 - September | 623.41 $ | satisfied | GBR | |||||||||
| 09 - September | 623.41 $ | satisfied | DNK | |||||||||
| 09 - September | 339.44 $ | satisfied | USA | |||||||||
| 09 - September | 294.31 $ | neutral | GBR | |||||||||
| 09 - September | 368.49 $ | satisfied | ITA | |||||||||
| 09 - September | 294.79 $ | neutral | DEU | |||||||||
| 09 - September | 493.80 $ | neutral | ITA | |||||||||
| 09 - September | 623.41 $ | satisfied | KSA | |||||||||
| 09 - September | 339.44 $ | dissatisfied | DEU | |||||||||
| 09 - September | 460.61 $ | dissatisfied | USA | |||||||||
| 09 - September | 623.41 $ | satisfied | GBR | |||||||||
| 09 - September | 623.41 $ | satisfied | DNK | |||||||||
| 09 - September | 178.66 $ | neutral | FRA | |||||||||
| 09 - September | 188.36 $ | satisfied | DNK | |||||||||
| 09 - September | 294.31 $ | satisfied | FRA | |||||||||
| 09 - September | 316.03 $ | satisfied | ESP | |||||||||
| 10 - October | 294.79 $ | neutral | FRA | |||||||||
| 10 - October | 188.36 $ | satisfied | DEU | |||||||||
| 10 - October | 217.24 $ | satisfied | ESP | |||||||||
| 10 - October | 178.66 $ | neutral | FRA | |||||||||
| 10 - October | 188.36 $ | satisfied | DNK | |||||||||
| 10 - October | 294.31 $ | satisfied | FRA | |||||||||
| 10 - October | 312.99 $ | satisfied | FRA | |||||||||
| 10 - October | 202.51 $ | satisfied | DEU | |||||||||
| 10 - October | 230.83 $ | neutral | GBR | |||||||||
| 10 - October | 447.88 $ | dissatisfied | FRA | |||||||||
| 10 - October | 279.15 $ | neutral | IRL | |||||||||
| 10 - October | 358.34 $ | neutral | DEU | |||||||||
| 10 - October | 498.73 $ | neutral | KSA | |||||||||
| 10 - October | 253.14 $ | satisfied | USA | |||||||||
| 10 - October | 230.83 $ | neutral | ESP | |||||||||
| 10 - October | 498.73 $ | satisfied | GBR | |||||||||
| 10 - October | 202.51 $ | satisfied | ESP | |||||||||
| 10 - October | 188.36 $ | satisfied | GBR | |||||||||
| 10 - October | 252.82 $ | dissatisfied | DNK | |||||||||
| 10 - October | 358.34 $ | satisfied | IRL | |||||||||
| 10 - October | 447.88 $ | dissatisfied | FRA | |||||||||
| 10 - October | 460.61 $ | dissatisfied | USA | |||||||||
| 10 - October | 623.41 $ | satisfied | GBR | |||||||||
| 10 - October | 623.41 $ | satisfied | DNK | |||||||||
| 10 - October | 339.44 $ | satisfied | USA | |||||||||
| 10 - October | 294.31 $ | neutral | GBR | |||||||||
| 10 - October | 368.49 $ | satisfied | ITA | |||||||||
| 10 - October | 294.79 $ | neutral | DEU | |||||||||
| 10 - October | 312.99 $ | satisfied | FRA | |||||||||
| 10 - October | 202.51 $ | satisfied | DEU | |||||||||
| 10 - October | 230.83 $ | neutral | GBR | |||||||||
| 10 - October | 447.88 $ | dissatisfied | FRA | |||||||||
| 10 - October | 279.15 $ | neutral | IRL | |||||||||
| 10 - October | 340.17 $ | neutral | ESP | |||||||||
| 10 - October | 230.83 $ | satisfied | GBR | |||||||||
| 10 - October | 358.31 $ | neutral | FRA | |||||||||
| 10 - October | 340.17 $ | satisfied | DEU | |||||||||
| 10 - October | 358.31 $ | satisfied | DEU | |||||||||
| 10 - October | 286.65 $ | neutral | IRL | |||||||||
| 10 - October | 312.99 $ | satisfied | FRA | |||||||||
| 10 - October | 202.51 $ | satisfied | DEU | |||||||||
| 10 - October | 230.83 $ | neutral | GBR | |||||||||
| 10 - October | 447.88 $ | dissatisfied | FRA | |||||||||
| 10 - October | 279.15 $ | neutral | IRL | |||||||||
| 11 - November | 196.11 $ | neutral | KSA | |||||||||
| 11 - November | 286.67 $ | satisfied | USA | |||||||||
| 11 - November | 286.65 $ | satisfied | DEU | |||||||||
| 11 - November | 184.66 $ | neutral | USA | |||||||||
| 11 - November | 184.66 $ | dissatisfied | DEU | |||||||||
| 11 - November | 460.61 $ | dissatisfied | USA | |||||||||
| 11 - November | 623.41 $ | satisfied | GBR | |||||||||
| 11 - November | 623.41 $ | satisfied | DNK | |||||||||
| 11 - November | 339.44 $ | satisfied | USA | |||||||||
| 11 - November | 178.66 $ | neutral | FRA | |||||||||
| 11 - November | 188.36 $ | satisfied | DNK | |||||||||
| 11 - November | 294.31 $ | satisfied | FRA | |||||||||
| 11 - November | 316.03 $ | satisfied | ESP | |||||||||
| 11 - November | 294.79 $ | neutral | FRA | |||||||||
| 11 - November | 188.36 $ | satisfied | DEU | |||||||||
| 11 - November | 217.24 $ | satisfied | ESP | |||||||||
| 11 - November | 178.66 $ | neutral | FRA | |||||||||
| 11 - November | 188.36 $ | satisfied | DNK | |||||||||
| 11 - November | 294.31 $ | satisfied | FRA | |||||||||
| 11 - November | 184.66 $ | neutral | USA | |||||||||
| 11 - November | 184.66 $ | dissatisfied | DEU | |||||||||
| 11 - November | 217.24 $ | satisfied | DEU | |||||||||
| 11 - November | 147.73 $ | dissatisfied | ESP | |||||||||
| 11 - November | 316.42 $ | neutral | DEU | |||||||||
| 11 - November | 196.11 $ | neutral | KSA | |||||||||
| 11 - November | 286.67 $ | satisfied | USA | |||||||||
| 11 - November | 286.65 $ | satisfied | DEU | |||||||||
| 11 - November | 460.61 $ | dissatisfied | USA | |||||||||
| 11 - November | 623.41 $ | satisfied | GBR | |||||||||
| 11 - November | 623.41 $ | satisfied | DNK | |||||||||
| 11 - November | 339.44 $ | satisfied | USA | |||||||||
| 11 - November | 294.31 $ | neutral | GBR | |||||||||
| 11 - November | 368.49 $ | satisfied | ITA | |||||||||
| 11 - November | 294.79 $ | neutral | DEU | |||||||||
| 11 - November | 184.66 $ | dissatisfied | DEU | |||||||||
| 11 - November | 217.24 $ | satisfied | DEU | |||||||||
| 11 - November | 147.73 $ | dissatisfied | ESP | |||||||||
| 11 - November | 316.42 $ | neutral | DEU | |||||||||
| 12 - December | 316.03 $ | satisfied | ESP | |||||||||
| 12 - December | 294.79 $ | dissatisfied | FRA | |||||||||
| 12 - December | 188.36 $ | satisfied | DEU | |||||||||
| 12 - December | 217.24 $ | satisfied | ESP | |||||||||
| 12 - December | 178.66 $ | neutral | FRA | |||||||||
| 12 - December | 188.36 $ | dissatisfied | DNK | |||||||||
| 12 - December | 294.31 $ | satisfied | FRA | |||||||||
| 12 - December | 316.03 $ | satisfied | ESP | |||||||||
| 12 - December | 294.79 $ | neutral | FRA | |||||||||
| 12 - December | 188.36 $ | satisfied | DEU | |||||||||
| 12 - December | 217.24 $ | satisfied | ESP | |||||||||
| 12 - December | 178.66 $ | neutral | FRA | |||||||||
| 12 - December | 188.36 $ | satisfied | DNK | |||||||||
| 12 - December | 294.31 $ | satisfied | FRA | |||||||||
| 12 - December | 316.03 $ | satisfied | ESP | |||||||||
| 12 - December | 294.79 $ | neutral | FRA | |||||||||
| 12 - December | 188.36 $ | satisfied | DEU | |||||||||
| 12 - December | 460.61 $ | dissatisfied | USA | |||||||||
| 12 - December | 623.41 $ | satisfied | GBR | |||||||||
| 12 - December | 623.41 $ | satisfied | DNK | |||||||||
| 12 - December | 339.44 $ | dissatisfied | USA | |||||||||
| 12 - December | 294.31 $ | neutral | GBR | |||||||||
| 12 - December | 368.49 $ | satisfied | ITA | |||||||||
| 12 - December | 294.79 $ | neutral | DEU | |||||||||
| 12 - December | 217.24 $ | dissatisfied | ESP | |||||||||
| 12 - December | 178.66 $ | neutral | FRA | |||||||||
| 12 - December | 188.36 $ | satisfied | DNK | |||||||||
| 12 - December | 294.31 $ | dissatisfied | FRA | |||||||||
| 12 - December | 316.03 $ | satisfied | ESP | |||||||||
| 12 - December | 294.79 $ | neutral | FRA | |||||||||
| 12 - December | 188.36 $ | satisfied | DEU | |||||||||
| 12 - December | 217.24 $ | satisfied | ESP | |||||||||
| 12 - December | 178.66 $ | neutral | FRA | |||||||||
| 12 - December | 188.36 $ | satisfied | DNK | |||||||||
| 12 - December | 294.31 $ | satisfied | FRA |
_x000D_&1#&"Aptos"&10&K000000 INTERNAL - RESTRICTED
PIVOT TABLES
| PIVOT TABLES |
| PT1: NATIONALITY (CUSTOMERS) |
| PT2: NATIONALITY (SALES) |
| PT3: MONTH (CUSTOMERS) |
| PT4: MONTH (SALES) |
| PT5: NATIONALITY & MONTH (CUSTOMERS) |
| PT6: NATIONALITY & MONTH (SALES) |
| PT7: LEVEL OF SATISFACTION & NATIONALITY & MONTH (SALES) |
| PT7: LEVEL OF SATISFACTION & NATIONALITY (FILTER) & MONTH (SALES) |
EXERCISE 3
| EXERCISE 3 | ||||||||||||||
| Order no. | Date | Driver's name | Item | Number of items | Transport | Destination | Criteria | Result | ||||||
| 100001 | 2/1/13 | John May | TV | 25 | truck 4 | Boston | countif | |||||||
| 100002 | 2/1/13 | Peter White | washing machine | 30 | truck 3 | NY | number of orders in Boston : | |||||||
| 100003 | 2/2/13 | Carl Nowak | washing machine | 15 | truck 3 | Philadelphia | number of microwave orders : | |||||||
| 100004 | 2/3/13 | Peter White | TV | 32 | truck 4 | NY | number of journeys with truck 3: | |||||||
| 100005 | 2/3/13 | George Ramsay | refrigerator | 25 | truck 3 | Boston | number of Peter White journeys: | |||||||
| 100006 | 2/3/13 | Carl Nowak | washing machine | 18 | truck 1 | Baltimore | how many times are no. of items less than 20: | |||||||
| 100007 | 2/3/13 | John May | refrigerator | 15 | truck 2 | Philadelphia | ||||||||
| 100008 | 2/4/13 | Carl Nowak | refrigerator | 25 | truck 3 | Baltimore | sumif | |||||||
| 100009 | 2/4/13 | Peter White | TV | 30 | truck 1 | Pittsburgh | sum of refrigerator items: | |||||||
| 100010 | 2/4/13 | George Ramsay | refrigerator | 15 | truck 2 | NY | sum of washing machine items: | |||||||
| 100011 | 2/4/13 | Mertl Pavel | microwave | 25 | truck 3 | Philadelphia | sum of items transported by truck 4: | |||||||
| 100012 | 2/4/13 | John May | washing machine | 14 | truck 4 | NY | sum of items transported by trucks: | |||||||
| 100013 | 2/5/13 | John May | washing machine | 25 | airplane | Baltimore | ||||||||
| 100014 | 2/5/13 | Carl Nowak | TV | 30 | truck 4 | Philadelphia | ||||||||
| 100015 | 2/5/13 | George Ramsay | microwave | 15 | truck 3 | Boston | Criteria 1 | Criteria 2 | Result | |||||
| 100016 | 2/5/13 | Peter White | TV | 15 | truck 1 | Pittsburgh | countifs | |||||||
| 100017 | 2/6/13 | John May | microwave | 25 | truck 1 | NY | number of microvawe orders in Boston : | |||||||
| 100018 | 2/7/13 | John May | TV | 30 | truck 4 | Philadelphia | number of Peter White journeys with truck 1: | |||||||
| 100019 | 2/8/13 | George Ramsay | washing machine | 13 | truck 3 | Baltimore | number of orders in Boston after 3/2/2013: | |||||||
| 100020 | 2/8/13 | Peter White | refrigerator | 25 | truck 2 | Philadelphia | number of orders between 03/02/2013 and 06/02/2013: | |||||||
| 100021 | 2/8/13 | Carl Nowak | microwave | 30 | truck 1 | Pittsburgh | ||||||||
| 100022 | 2/8/13 | Peter White | washing machine | 15 | airplane | NY | sumifs | |||||||
| 100023 | 2/8/13 | John May | microwave | 25 | truck 4 | Boston | number of microwaves transported to NY: | |||||||
| 100024 | 2/9/13 | George Ramsay | washing machine | 34 | truck 3 | Baltimore | items transported to Pittsburgh by truck 1: | |||||||
| items ordered between 03/02/2013 and 03/02/2013: | ||||||||||||||
| items transported to NY, Baltimore and Philadelphia: |
_x000D_&1#&"Aptos"&10&K000000 INTERNAL - RESTRICTED
