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, includin

BUSN 420 Major Project Assignment Instructions

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

XLMD_Customer

CUST ID	REGION	RENT VS. OWN	NUM HOUSEHOLD	ANNUAL INCOME	TOTAL PURCHASES	NUM PURCHASES
1	North	Own	1	10K-25K	$ 38	1
2	South	Own	4	100K+	$ 30	4
3	North	Rent	3	25K-50K	$ 19	3
4	West	Own	5	25K-50K	$ 21	6
5	East	Own	6	50K-100K	$ 35	7
6	South	Own	2	10K-25K	$ 27	5
7	East	Own	3	100K+	$ 26	3
8	West	Rent	4	25K-50K	$ 25	6
9	North	Own	5	50K-100K	$ 30	8
10	West	Rent	7	25K-50K	$ 26	2
11	North	Own	1	50K-100K	$ 21	4
12	East	Own	2	100K+	$ 29	9
13	South	Own	5	10K-25K	$ 20	7
14	South	Own	4	25K-50K	$ 27	10
15	South	Rent	3	50K-100K	$ 19	2
16	West	Own	5	25K-50K	$ 19	6
17	North	Own	6	50K-100K	$ 129	5
18	East	Rent	2	10K-25K	$ 99	7
19	West	Own	3	25K-50K	$ 99	4
20	North	Rent	1	50K-100K	$ 119	3
21	East	Own	4	50K-100K	$ 149	2
22	South	Own	3	50K-100K	$ 165	8
23	West	Rent	5	25K-50K	$ 119	6
24	North	Rent	6	10K-25K	$ 129	7
25	East	Rent	7	100K+	$ 165	5
26	South	Own	3	10K-25K	$ 99	3
27	West	Rent	2	25K-50K	$ 155	6
28	North	Own	4	50K-100K	$ 115	8
29	East	Own	5	50K-100K	$ 129	1
30	South	Rent	4	50K-100K	$ 99	8
31	West	Own	2	25K-50K	$ 169	6
32	East	Rent	3	25K-50K	$ 40	4
33	East	Own	1	50K-100K	$ 36	7
34	North	Own	6	100K+	$ 45	3
35	North	Own	5	10K-25K	$ 29	1
36	West	Rent	4	100K+	$ 28	4
37	East	Rent	1	25K-50K	$ 46	1
38	South	Rent	5	50K-100K	$ 50	4
39	East	Rent	3	50K-100K	$ 22	6
40	West	Own	6	50K-100K	$ 20	9
41	North	Own	7	25K-50K	$ 19	3
42	East	Own	3	50K-100K	$ 31	1
43	South	Rent	2	50K-100K	$ 30	10
44	West	Rent	4	25K-50K	$ 18	3
45	East	Own	5	25K-50K	$ 31	7
46	South	Own	3	10K-25K	$ 35	6
47	West	Own	7	25K-50K	$ 28	5
48	East	Rent	3	100K+	$ 29	8
49	South	Rent	2	10K-25K	$ 35	6
50	North	Own	6	25K-50K	$ 30	4
51	South	Own	5	50K-100K	$ 38	7
52	West	Own	3	50K-100K	$ 20	3
53	North	Rent	1	25K-50K	$ 40	5
54	East	Rent	5	25K-50K	$ 30	4
55	South	Own	6	25K-50K	$ 40	8
56	West	Rent	3	10K-25K	$ 62	7
57	North	Rent	4	100K+	$ 22	9
58	East	Rent	5	100K+	$ 25	1
59	West	Rent	7	10K-25K	$ 27	4
60	East	Rent	2	25K-50K	$ 22	7
61	South	Own	3	25K-50K	$ 30	4
62	East	Own	1	25K-50K	$ 31	3
63	East	Own	4	50K-100K	$ 22	8
64	South	Rent	2	50K-100K	$ 25	9
65	West	Own	3	25K-50K	$ 24	3
66	East	Own	5	50K-100K	$ 36	2
67	North	Rent	4	50K-100K	$ 123	11
68	North	Rent	6	100K+	$ 19	2
69	North	Own	5	100K+	$ 23	6
70	South	Rent	7	100K+	$ 19	8
71	West	Rent	4	25K-50K	$ 25	6
72	West	Rent	5	50K-100K	$ 129	8
73	North	Own	3	50K-100K	$ 119	9
74	East	Own	6	100K+	$ 109	3
75	North	Own	5	10K-25K	$ 179	6
76	East	Rent	4	100K+	$ 145	5
77	South	Own	2	25K-50K	$ 119	7
78	North	Rent	3	50K-100K	$ 129	2
79	East	Own	4	10K-25K	$ 189	4
80	West	Own	6	50K-100K	$ 155	6
81	North	Rent	5	25K-50K	$ 78	4
82	East	Own	4	25K-50K	$ 61	5
83	South	Rent	3	25K-50K	$ 97	7
84	North	Rent	2	50K-100K	$ 63	2
85	West	Own	4	100K+	$ 39	3
86	East	Rent	6	50K-100K	$ 95	1
87	South	Rent	4	25K-50K	$ 86	Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. Prior to completing this assignment, review your prior research on the company you selected for research in this Weeks Environmental Scanning interactive assignment.?Also, watch the video How t The HR planning process should be aligned with the strategic process of the organization in general. It will show how HR will contribute to the achievement of goals and objectives the organizat Related Posts Uncategorized The selection of measures is an incredibly important aspect of program evaluation.? Discuss possible measures that could be used in your program evaluat Uncategorized Financial Analysis Purpose This analysis is an individual assignment where you will analyze your own company in terms of its financial position.? The easi Uncategorized GCU PHI413 Ethical and Spiritual Decision Making in Health Care All Discussions All Rights Reserved Terms and Conditions College pals.com Privacy Policy 2010-2018