Technology plays an essential 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: 1. Show all information for only customers who live in the North region. 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. 3. Show all information for customers who have at least 4 household members. 4. Show all information for customers who (a) have spent less than $20 or (b) more than $100. 5. Show all information for all customers highlighting those customers who have spent more than $100. 6. Provide a two-dimensional table that counts the number of customers by the categories of REGION and RENT VS. OWN. 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. 8. Provide a three-dimensional table that counts the number of customers by the categories of REGION, RENT VS. OWN, and NUM HOUSEHOLD. First, read the attached Extended Learning Module D: Decision Analysis with Spreadsheet Software document. Then, create the requested worksheet summaries listed above. You will need to use Microsoft Excel to complete this assignment. Microsoft Excel is available at no cost to Regent students via the Office 365 application listed in the Course Resources section of our Blackboard course. The attached XLMD_Customer.xlsx data file should be used to complete the assignment. Once you have completed each request, please submit one Excel document, including 8 worksheets illustrating each exercise.
BUSN 420 Major Project Grading Rubric
Basic Filter Possible Points Actual Points
Show all information for only customers who live in the North region.
5
Show all information for only customers who (a) live in the North region, (b) own their homes, and (c) have only one household member.
10
Comments: 15
Custom Filter Possible Points Actual Points
Show all information for customers who have at least 4 household members.
10
Show all information for customers who (a) have spent less than $20 or (b) more than $100.
15
Comments: 25
Conditional Formatting Possible Points Actual Points
Show all information for all customers highlighting those customers who have spent more than $100.
10
Comments: 10
Pivot Tables Possible Points Actual Points
Provide a two-dimensional table that counts the number of customers by the categories of REGION and RENT vs. OWN.
15
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.
15
Provide a three-dimensional table that counts the number of customers by the categories of REGION, RENT vs. OWN, and NUM HOUSEHOLD.
20
Comments: 50
Late Deductions
Total Score 100
Overall Comments
For this short paper activity, you will learn about the three delays model, which explains…
Topic : Hospital adult medical surgical collaboration area a. Current Menu Analysis (5 points/5%) Analyze…
As a sales manager, you will use statistical methods to support actionable business decisions for Pastas R Us,…
Read the business intelligence articles: Getting to Know the World of Business Intelligence Business intelligence…
The behaviors of a population can put it at risk for specific health conditions. Studies…