Chat with us, powered by LiveChat Technology plays an important role in supporting decision-making.? This major project will focus on supporting decision-making by exploring some of th - EssayAbode

Technology plays an important role in supporting decision-making.? This major project will focus on supporting decision-making by exploring some of th

 

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:

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 Download 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.  The attached XLMD_Customer.xlsx Download XLMD_Customer.xlsxdata file should be used to complete each exercise.

Once you have completed each request, please submit one Excel document, including 8 worksheets illustrating each exercise.

XLMD_Customer

<

Related Tags

AcademicAPAAssignmentBusinessCapstoneCollegeConclusionCourseDayDiscussionDouble SpacedEssayEnglishFinanceGeneralGraduateHistoryInformationJustifyLiteratureManagementMarketMastersMathMinimumMLANursingOrganizationalOutlinePagesPaperPresentationQuestionsQuestionnaireReferenceResponseResponseSchoolSubjectSlidesSourcesStudentSupportTimes New RomanTitleTopicsWordWriteWriting

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 7
88 West Own 1 50K-100K $ 85 5
89 East Own 2 50K-100K $ 59 7
90 North Rent 3 100K+ $ 84 9
91 North Own 2 100K+ $ 144 10
92 West Rent 3 100K+ $ 26 1
93 South Rent 7 25K-50K $ 31 1
94 East Own 6 50K-100K $ 19 1
95 South Rent 5 50K-100K $ 30 1
96 West Rent 4 100K+ $ 29 11
97 West Rent 5 10K-25K $ 25 2
98 West Rent 6 100K+ $ 24 6
99 East Rent 3 25K-50K $ 36 5
100 North Own 4 50K-100K $ 29 7
101