Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

MAJOR PROJECT

Attached Files:

  • BUSN 420 Major Project Assignment Instructions.docx (12.76 KB)
  • Extended Learning Module D.pdf (3.159 MB)
  • XLMD_Customer.xlsx (27.678 KB)
  • BUSN 420 Major Project Grading Rubric.xlsx (13.135 KB)

Technology plays an important role in supporting decision making. This minor 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 in order 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.

 

<h5 >

"Get 15%discount on your first 3 orderswith us"
Use the following coupon
"FIRST15"

testimonials icon
This assessment is an individual assignment. You are required to review a minimum of 10 research articles on a specific topic of choice. You can...
testimonials icon
 It is quite common for leaders and executive coaches to educate and influence constituents on topics that have relevance for good performance and...
testimonials icon
Choose one (1) of the three (3) reading selections from the list of topic choices below. The focus is on brief but important primary source materia...
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
Follow the Instructions 700-800 words Do...
testimonials icon
 Assignment 1: Innovation and Change: Strategic Consideration in PR Communication AbroadIn this module, you read about and...
testimonials icon
Review the simulation: You are a Supreme Court Justice Deciding on a Free Speech Case. Read Appendix B: Briefing and Analyzing Cases in...
testimonials icon
  · Recognizing the importance of security policies· Understanding the various policies and the rationale for them.· Know...
testimonials icon
Executive SummaryDuring the past three years under the leadership of Shikhar Ghosh, the Appex Corporation (Appex) has undergone a number of significa...
testimonials icon
Professor instructions: Review your eulogy, then based on that, visualize yourself at age 45. As you plan for retirement, identify three t...
testimonials icon
  Personal Savings StrategiesPart I:  Identify all the lazy dollars in your financial life. Identify source, am...
testimonials icon
Portrait of A manDescriptionThis art piece is an oil on wood Panel about 30 x 26 cm. The portrait is the work...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65