Provide a three-dimensional table that counts the number

Assignment Help Management Theories

Reference no: EM133828658

Case: Technology plays an important role in supporting decision-making. This major project will focus on supporting decision-making by exploring some of the features within Microsoft Excel including the basic filter, custom filter, conditional formatting, as well as pivot tables.

Let's assume that you work for a small business and have been asked to perform the following tasks to aid in various decisions:

Question 1. Show all information for only customers who live in the North region.

Question 2. Show all information for only customers who (a) live in the North region, (b) own their homes, and (c) have only one household member.

Question 3. Show all information for customers who have at least 4 household members. Complete your assignment now!

Question 4. Show all information for customers who (a) have spent less than $20 or (b) more than $100.

Question 5. Show all information for all customers highlighting those customers who have spent more than $100.

Question 6. Provide a two-dimensional table that counts the number of customers by the categories of REGION and RENT VS. OWN.

Question 7. Provide a two-dimensional table that both (a) counts the number of customers and (b) sums the TOTAL PURCHASES of customers by the categories of REGION and RENT VS. OWN.

Question 8. Provide a three-dimensional table that counts the number of customers by the categories of REGION, RENT VS. OWN, and NUM HOUSEHOLD.

Reference no: EM133828658

Questions Cloud

Identify one core issue that your coaching subject : Identify one core issue that your coaching subject has indicated an interest in changing. Explain briefly what the issue is and how they want to change

What stage of change is your coaching subject currently in : What stage of change is your coaching subject currently in? Note: The goal is to help them get to the next stage in the change process

Reflective assessment of your life coaching : Reflective assessment of your life coaching experience. This piece, though the last, is just as important as the actual coaching because it allows you

What is your definition of personal integrity : Becoming a Professional Life Coach: Lessons from the Institute for Life Coach Training and What is your definition of personal integrity? Be specific and detail

Provide a three-dimensional table that counts the number : Provide a two-dimensional table that both counts the number of customers and (b) sums the TOTAL PURCHASES of customers by the categories of REGION and RENT

Effective partnership strategies : Effective partnership strategies for Human Capital Management (HCM) can significantly impact a student's future development

Leadership identities-manager-adminstrator-leader : Is there a thin line between these three leadership identities. manager, adminstrator, leader, do they overlap.

How would have you resolved the issue using : How would have you resolved the issue using your leadership style - What is the issue in the video - What leadership styles or approaches did you see

What techniques and proven practices can you use : What techniques and proven practices can you use when motivating followers? Hello classmates and Dr. Angello Lamar, welcome to week four of our management

User Account

All Pages