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

Encino dental studio amir jamsheed dds - 2 reply 150 words each one citation and references - Sealed off zhang ailing themes - BUS 310 Week 3 Quiz - Tvb anniversary awards 2012 - The company has its camera and drone assembly facilities in - Module 11 Discussion - Self-Assessment and Reflection A&P - Types of hazards in caregiving - Sticks and stones and such like - Kfc ppt - Celf 5 core language subtests 9 21 - Nottingham trent foundation year - Emergency generator solas requirements - Ross corporation reported the following - Describe the process for tracking and evaluating training effectiveness - Victoria university law degree - When was texas readmitted to the union - Mis case study with question and answers - My cousin vinny law questions - Basin of attraction matlab - Silver nitrate and ammonia exposed to light - Five mission competencies gcu - It's the economy stupid fallacy - Topic 6 DQ 2 - A bowling ball traveling with constant speed hits the pins - Use the above adjusted trial balance - Reflect on and improve own professional practice - Buchan caves reserve campground - What does 0.2 fte mean - Essay - Discussion - Cardiac muscle diagram labeled - Forest hill group practice - How to write reflection 1 for english sba - Elysian multizone fitted electric blanket - Baloney - Spelling words grade 5 - 8 7 7 7 ielts score meaning - Assessment 1 - 550 sender's policy prohibits this message quarantine - Features editor irish times - Informatics - Right and wrong basic readings in ethics christina hoff sommers - Word modules 1 3 sam capstone project - Problem 7 2a accounting - Nrs 490 scholarly activity summary - Interpersonal Communication Principles - Enhanced synthesis paper - Download the cloud security alliance csa cloud controls matrix spreadsheet - Cloud Computing - Obstacles to implementing standardized terminologies within ehrs - 【(+97•15-2•730-•5642) Abortion Pills in Dubai|Abu Dhabi|Alain|Sharjah|RAK city|(Surgical Abortion in UAE)-mifepristone200mg & Misoprostol 200mcg Available in Dubai|Abu Dhabi-ipills in Dubai & Cost of Cytotec in Dubai| Abu Dhabi. - APA Citation Tutorial - Describe how packet loss can occur at output ports - A1 size paper in cm - What is an annotated outline sample - Factory manager's salary manufacturing overhead - Diabetic - What is a random assignment in psychology - Todaiji temple ap art history - Edld 5345 week 2 assignment - When did khufu rule - Ponytail palm freeze damage - Batman parody i stabbed you first - What makes water so special - C4 Due in 24 hours - Sikiliza kwa wahenga lyrics meaning - Engr 45 lb #4 - Commbank home loan upfront costs - Poems by gwendolyn brooks and emily dickinson - Films that gained notoriety due to the internet - Describe the major threats in doing business in global markets - Find the error in the following pseudocode - BA 4010 MODULE 1 Questions - Define and Reflect on conflict - Iboard allied american university - Order of magnitude biology - Operational Excellence - Child development theories chart - Summerland credit union term deposit interest rates - Strict two phase locking - Policy Analysis Group Assignment - Colorbond shale grey exterior - Google search appliance ebay - The 4 e's of marketing - Albaik recruitment - Radioactive dating lab answer key - Tutorial 4 case problem 1 sky dust stories - How to cultivate pineapple in sri lanka - Brave new world exposition - The last mountain movie questions - APA paper on Artificial intelligence - Bits pilani masters in computer science - 5 1 midway company performance summary powerpoint - Key success factors under armour - Assgnmet - The fortune cookie chronicles sparknotes - Thomas adams school wem - Sun ancon chi machine - To maximize profit a pure monopolist must