Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Pelican stores case study answers

26/11/2021 Client: muhammad11 Deadline: 2 Day

Have to answer the questions using the excel data file.

I'm attaching excel data file(Data - Case - Week - 1 - PelicanStores).

have to answer all questions below.

========Question:

Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores.
Data collected for a sample of 100 in-store credit card transactions at Pelican Stores for one day while the promotion was running are contained in the file PelicanStores.

Table shows a portion of the data set (USE DATA AS POSTED). The Proprietary Card method of payment refers to charges made using a National Clothing charge card.

Customers who made a purchase using a discount coupon are referred to as promotional customers, and customers who made a purchase but did not use a discount coupon are referred to as regular customers.

Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make.

Of course, Pelican also hopes that the promotional customers will continue to shop at its stores.

Most of the variables shown in data attached are self-explanatory, but two of the variables require some clarification.

Items The total number of items purchased

Net Sales The total amount ($) charged to the credit card

Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

Write - Managerial Report - APA style
Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following:

1. Percent frequency distribution for key variables.

2. A bar chart or pie chart showing the number of customer purchases attributable to the method of payment.

3. A crosstabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences present.

4. A scatter diagram to explore the relationship between net sales and customer age.

&UnStack
&DataIndices
&DataCopy
&GraphData
&WorkArea
&Miscel_Area
Data
Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age
1 Regular 1 39.50 Discover Male Married 32
2 Promotional 1 102.40 Proprietary Card Female Married 36
3 Regular 1 22.50 Proprietary Card Female Married 32
4 Promotional 5 100.40 Proprietary Card Female Married 28
5 Regular 2 54.00 MasterCard Female Married 34
6 Regular 1 44.50 MasterCard Female Married 44
7 Promotional 2 78.00 Proprietary Card Female Married 30
8 Regular 1 22.50 Visa Female Married 40
9 Promotional 2 56.52 Proprietary Card Female Married 46
10 Regular 1 44.50 Proprietary Card Female Married 36
11 Regular 1 29.50 Proprietary Card Female Married 48
12 Promotional 1 31.60 Proprietary Card Female Married 40
13 Promotional 9 160.40 Visa Female Married 40
14 Promotional 2 64.50 Visa Female Married 46
15 Regular 1 49.50 Visa Male Single 24
16 Promotional 2 71.40 Proprietary Card Male Single 36
17 Promotional 3 94.00 Proprietary Card Female Single 22
18 Regular 3 54.50 Discover Female Married 40
19 Promotional 2 38.50 MasterCard Female Married 32
20 Promotional 6 44.80 Proprietary Card Female Married 56
21 Promotional 1 31.60 Proprietary Card Female Single 28
22 Promotional 4 70.82 Proprietary Card Female Married 38
23 Promotional 7 266.00 American Express Female Married 50
24 Regular 2 74.00 Proprietary Card Female Married 42
25 Promotional 2 39.50 Visa Male Married 48
26 Promotional 1 30.02 Proprietary Card Female Married 60
27 Regular 1 44.50 Proprietary Card Female Married 54
28 Promotional 5 192.80 Proprietary Card Female Single 42
29 Promotional 3 71.20 Proprietary Card Female Married 32
30 Promotional 1 18.00 Proprietary Card Female Married 70
31 Promotional 2 63.20 MasterCard Female Married 28
32 Regular 1 75.00 Proprietary Card Female Married 52
33 Promotional 3 63.20 Proprietary Card Female Married 44
34 Regular 1 40.00 Proprietary Card Female Married 34
35 Promotional 5 105.50 MasterCard Female Married 56
36 Regular 1 29.50 MasterCard Male Single 36
37 Regular 2 102.50 Visa Female Single 42
38 Promotional 6 117.50 Proprietary Card Female Married 50
39 Promotional 5 13.23 Proprietary Card Female Married 44
40 Regular 2 52.50 Proprietary Card Female Married 58
41 Promotional 13 198.80 Proprietary Card Female Married 42
42 Promotional 4 19.50 Visa Female Married 46
43 Regular 2 123.50 Proprietary Card Female Married 48
44 Promotional 1 62.40 Proprietary Card Female Married 54
45 Promotional 2 23.80 Proprietary Card Female Married 38
46 Promotional 2 39.60 Proprietary Card Female Married 60
47 Regular 1 25.00 MasterCard Female Married 46
48 Promotional 3 63.64 Proprietary Card Female Married 30
49 Promotional 1 14.82 Proprietary Card Female Married 32
50 Promotional 9 145.20 MasterCard Female Married 46
51 Promotional 6 176.62 Proprietary Card Female Married 38
52 Promotional 5 118.80 Proprietary Card Male Married 68
53 Regular 1 58.00 Discover Female Single 78
54 Regular 2 74.00 Visa Female Single 20
55 Regular 2 49.50 MasterCard Female Married 32
56 Promotional 3 141.60 Proprietary Card Female Married 38
57 Promotional 6 123.10 Proprietary Card Female Married 54
58 Promotional 2 80.40 Proprietary Card Female Married 48
59 Promotional 4 65.20 MasterCard Female Married 46
60 Promotional 4 113.00 Proprietary Card Female Single 50
61 Promotional 1 108.80 Proprietary Card Female Married 46
62 Promotional 3 59.91 Proprietary Card Female Single 30

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Assignment Solver
Coursework Helper
Top Academic Guru
Exam Attempter
Study Master
Essay & Assignment Help
Writer Writer Name Offer Chat
Assignment Solver

ONLINE

Assignment Solver

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$30 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$26 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$47 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$27 Chat With Writer
Study Master

ONLINE

Study Master

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$26 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$23 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Principles of guided missile design october sky - Acute response to exercise - Capsim simulation analysis report - Basin fixing kit wickes - How to prepare effective slides for proposal presentation - Assignment: “Separating the War From the Warrior” 6411-wk2 - Is social media a good forum for elected leaders - Fly spray for dogs woolworths - Hospitality management in perth - Dolch high frequency word list - National Labor Relations Act - Stickup kid documentary - I need 1200 words 12 answers the Questions - Method of joints and method of sections - Food cost percentage formula - Regulation of lactase gene worksheet answers - Ancient egypt hair and makeup - Rossendale pet crematorium and memorial gardens - PUblic Health - Describe how outsourcing can be used for risk transference - 380 pfc weight per m - Higher chemistry problem solving questions - Why is the gh spelling inconsistent with etymology - Does social media make us lonely essay - Finn kelly wealth enhancers - I NEED A TUTOR TO COMPLETE EXCELL PORTION FOR THIS ASSIGNMENT ASAP. PLEASE SEE ATTACHMENT FOR THE WORD PORTION - Unit 4 DB - Rock paper scissors lizard spock algorithm - Zinc and hydrochloric acid lab report - Milton keynes bus routes - Determination of the ka of a weak acid - Strategic Planning - Final Project: Briefing Project - Wilsons prom accommodation lighthouse - What do grievers look like in the maze runner book - Redox titration calculations questions - Tampa microwave satellite simulator - A credit sale of merchandise for $112.20 - Fundamental methods of mathematical economics 4th edition solutions - Briefly describe fasb iasb convergence process - Modern romeo and juliet - Recycling at work handy hints to employers reading answers - Inventory records for marvin company revealed the following - Chemical reaction word equations - 2 questions about Intersectionality, due before 9.26th noon, 1 page - Obsolete jobs of the past - What is a da capo aria - How to find sticky bit files in linux - What is sr2 in multiple regression - The book thief blurb - Http www wmfc org uploads generationaldifferenceschart pdf - Real estate law 9th edition aalberts pdf - Australian curriculum studies association - Ppc specialist job description - Organisational behavior - Assignment/Discussion: Water Resources Assessment and Management, Sustainability, Resource Management, Environmental Management - Light motif in a streetcar named desire - Artifact of human creative expression examples - Questions - Hard rock cafe forecasting case study - Mitel mivoice business brochure - Bsbmgt502 role play - National curriculum for pe 2008 - Bsbitu101a operate a personal computer assessment - Blackjack eyes and tambourine hips - Hey shepherds wakey wakey listen to the news - Inputs strategic plans target elements of change and outputs - Irs 28 rate gain worksheet - Technical Writing in Criminal Justice - Chapter 7 - Assimilate crossword clue 6 letters - Discussion: Strategies for Addressing Questions - Campbell soup annual report 2011 - Statement of Purpose - Art history research paper - Pretest posttest design example - Silver glitter toilet brush - Http www famousscientists org list - Escience lab 2 answers - On the job training record template - My homework lesson 1 factors and multiples page 489 - Series fed class a power amplifier - Angry white men org - Machine used to resurface ice for skating - Brilliant answers practical - Corpus callosum function while driving - R12000 in dollars - English - Scientific promotional items - Leather sector skill council - Assembly of god doctrine - How to take isotonix - Jill mccorkle her chee to heart - Gallup poll worksheet answers - Lennons circus gold coast - Case Assessment: Hopworks Urban Brewery - Pfannenberg asia pacific pte ltd - Exploring electric charges simulations answer key - M4 screw hole size - Comparison between taba and tyler model pdf - Standard deviation on casio fx-82au plus ii