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

Predict my future bra size quiz - Managing operations across the supply chain answer key - 91 lanita road ferny grove - Client consultation form template word - Swinburne senior secondary college staff - Importance of company secretary ppt - 1917 churchill dr union nj - Block method vs point by point - The spleen poem analysis - Statistic questions - Pro eating disorder tumblr - How to make boost juice mango tango crush - Is point of service a gatekeeper or open access - Regional events acceleration fund - Investment corporation of bangladesh branches - Printable list of agatha christie books - Www veltechuniv edu in fee payment - Discussion post - CLOUD COM WEEK 3 DQ - Mass effect 3 petra nebula - Organizational needs assessment template - Rancho solano preparatory school case - Gai waterhouse tip sheet - Sydney chinese sda church - PDF Textbook - Zenger folkman 16 competencies - Density of carbon tetrachloride - Wearable computers change how we work - Pyramid of giza diorama - Ds al fine definition - Krayzie bone clash of the titans reaction - Automotive engineers refer to the time rate of change - Mr jones science class - CPSC 355 Assignment 3 - Similarities between virtue theory utilitarianism and deontological ethics - Sea company reports the following information regarding its production cost - Parton v milk board - CIS 275 - Master of translation and interpreting mq - Benefits of autocad electrical - Evaluation Planning - One page - An air filled capacitor consists of two parallel - Health Promotion in Nursing Care - National intelligence priorities framework list - 1.09 macbeth plot analysis quiz - Is light potential energy - Thomson flight tom 814 - Slumdog millionaire part 3 - Managing Dynamic Environment - A group of words having a subject and a verb - Specific heat capacity of copper sulfate - Shadow health cardiovascular assessment answers - 704b old calder highway - Global Health Topic Discussion - Business Valuation - Strategies of teamwork ppt - Mexican food recipes pdf - Canon macro lens for dental photography - What is 2.4 in a fraction - Vcat vic gov au renting notice - Form 27 corrective services - Application for consent orders kit - Mod 7 - They say i say blue collar brilliance - What is a passing grade at saint leo university - Beer mechanics of materials 6th solutions chapter 3 - Clearing paths to the past by kevin coyne - V curve synchronous motor - Physics formula sheet hsc - Hist Blog - Kickers size chart cm - Snowfall the avalanche at tunnel creek summary - United colors of benetton ads - Rotary to reciprocating motion mechanism - Wzzm13 on your sidelines scores - Math Questions due at 10:00pm - CCM-3 - NEED IN 7 HOURS or LESS (NO EXCEPTION) - Everyday series evangelism earley and wheeler - Expressive techniques for vocals - Eight dimensions of organizational capacity for change - Intended for brilliant answers ONLY - 978 1337272896 - Ib chemistry bonding questions - Bobbie harro cycle of socialization - Thrift shop vocals only - Cisco 1941 end of life - Alfa romeo usp - "American (Wild?) West of the 1800s" - Main rules of badminton - Fierce conversations discussion questions - Assignment 2 part b your marketing plan - World Civilization before 1650. - Gram positive bacteria stain colors - World religions vocabulary worksheet - Team in training logo - Nursing Statistics - Psychology Essay - How to create a pcx file