Lab Exercise: Basic Data AnalyticsBased on the data sets involving OMT posted in UNIEC Virtual, you are going to develop pivot tablesduring the lab sessions. In the last lab session, the lab test may start. Questions will be asked atrandom based on any of the data sets used during your training. Those who do not get the chance todo it during that time will have to arrange a specific time with the instructor. Answer multiplequestions and even experiment with the data to learn new things about it.

ANSWER THESE QUESTIONS USING YOUR PIVOT TABLE

Where do most of our customers come from? The answer might tell managers where to spendmore marketing resources, or to initiate new marketing efforts.

Where are the average purchases higher? The answer might tell managers where to focusmarketing and sales resources or pitch different messages to different regions

What form of payment is the most common? The answer could be used to emphasize in advertisingthe most preferred means of payment.

Are there any times of day when purchases are mostcommon? Do people buy products while at work (likely during the day) or at home (likely in theevening)?