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 solution

14/10/2021 Client: muhammad11 Deadline: 2 Day

Business Analytics

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 1/8

home / study / math / statistics and probability / statistics and probability solutions manuals / statistics for business & economics / 12th edition / chapter 2 / problem 1cp

Statistics for Business & Economics (12th Edition) See this solution in the app

Problem

Pelican Stores

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 during one day while the promotion was running are contained in the file named PelicanStores. Table 2.19 shows a portion of the data set. 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.

TABLE 2.19 DATAFOR ASAMPLE OF 100 CREDIT CARD PURCHASES AT PELICAN STORES

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

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

Managerial Report

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.

Step-by-step solution

My Textbook Solutions

Statistics for Business &... 12th Edition

Statistics for Business... 11th Edition

Statistics fo Business... 10th Edition

View all solutions

Post a question Answers from our experts for your tough homework questions

Enter question

Continue to post 20 questions remaining

Statistics Chegg tutors who can help right now

Daniel NYIT College of Os… 466

Dakota University of Wisco… 148

Chetana Lady Brabourne Co… 621

Find me a tutor

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

https://www.chegg.com/
https://www.chegg.com/study
https://www.chegg.com/homework-help/math
https://www.chegg.com/homework-help/math-statistics-and-probability-s31
https://www.chegg.com/homework-help/statistics-and-probability-solutions-manual-sm2-31
https://www.chegg.com/homework-help/statistics-for-business-economics-solutions-manual-sm3-514581
https://www.chegg.com/homework-help/statistics-for-business-economics-12th-edition-solutions-9781133274537
https://www.chegg.com/homework-help/statistics-for-business-economics-12th-edition-chapter-2-solutions-9781133274537
https://www.chegg.com/homework-help/statistics-for-business-economics-12th-edition-solutions-9781133274537
https://www.chegg.com/homework-help/statistics-for-business-and-economics-11th-edition-solutions-9788131517055
https://www.chegg.com/homework-help/statistics-for-business-and-economics-with-cd-rom-10th-edition-solutions-9780324360684
https://www.chegg.com/study/tbs
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice
3/2/2020 Solved: Pelican StoresPelican Stores, a division of National Cl... | Chegg.com

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 2/8

1)

Consider the case of Pelican stores which is a division of National Clothing. A promotional discount coupon is given to customers. Data of 100 customers was collected. Part of the data is shown below:

The percentage frequency distribution of key variables in Excel is obtained as follows:

STEP 1: Select all the cells of key variable.

STEP 2: Click Insert PivotTable Pivot Table.

STEP 3: Table range is already selected. Select Existing worksheet. Enter any random cell K1. The screenshot is shown below:

Comment

STEP 4: Click ok. In right hand pane, tick “Type of customer”. Drag “Type of customer” to “Row Labels” and “Values”. The screenshot is shown below:

Step 1 of 11

Step 2 of 11

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

javascript:;
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice
3/2/2020 Solved: Pelican StoresPelican Stores, a division of National Cl... | Chegg.com

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 3/8

Comment

STEP 5: Frequency distribution is obtained as follows:

For data with numeric value Items, right click on pivot table and select “Group by”.

Comments (1)

In the pop up, enter data as follows:

Frequency distribution for Items and Method of Payment is obtained as follows:

Step 3 of 11

Step 4 of 11

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

javascript:;
javascript:;
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice
3/2/2020 Solved: Pelican StoresPelican Stores, a division of National Cl... | Chegg.com

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 4/8

For the above output for the given data, observe that 70% users are Promotional users. Also 85% customers buy 1-5 items. Also as many as 70% customers use Propriety card.

Comment

2)

Bar chart of Method of payments is obtained as follows:

STEP 1: Click Insert Charts Columns in Excel.

STEP 2: Select First Column chart.

STEP 3: In the displayed blank chart, right click and click ‘select data’.

STEP 4: In Chart Data Range, enter frequency distribution table for ‘Method of Payments’.

STEP 5: Bar chart showing the number of customer purchases attributable to the method of payment is obtained as follows:

Step 5 of 11

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

javascript:;
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice
3/2/2020 Solved: Pelican StoresPelican Stores, a division of National Cl... | Chegg.com

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 5/8

Comment

3)

A cross tabulation between Type of customers and net sales is obtained as follows:

STEP 1: Click Insert Pivot Table Pivot table.

STEP 2: In the pop-up window enter columns B1:D101. Click Existing worksheet. Enter preferred location. Click OK. Screenshot is shown below:

Comment

Comment

STEP 3: In the left pane tick ‘Type of customers’ and ‘Net Sales’. Drag “Net sales” to “column Labels”, and “Values”. Drag “Type of customers” to Row labels.

Step 6 of 11

Step 7 of 11

Step 8 of 11

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

javascript:;
javascript:;
javascript:;
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice
3/2/2020 Solved: Pelican StoresPelican Stores, a division of National Cl... | Chegg.com

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 6/8

Comment

STEP 4: Hover Mouse over columns. Right click and click ‘Group’. In the popup, enter values as shown in the below screenshot. Click ok in the below screenshot.

STEP 5: Result cross tabulation is obtained as shown below:

The cross tabulation gives the data of sales under each category. Sales of Regular customers is lesser than sales of Promotional customers. Highest sales are done by promotional customers in the category 50 to 100 dollars.

Comment

4)

Scatter plot showing relation between net sales and customer age is shown below:

STEP 1: Click Insert Charts XY scatter. Select first option and click ok.

STEP 2: In the empty chart right click and click ‘Select Data’.

STEP 3: In the pop-up window enter H1:H101.

Step 9 of 11

Step 10 of 11

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

javascript:;
javascript:;
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice
3/2/2020 Solved: Pelican StoresPelican Stores, a division of National Cl... | Chegg.com

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 7/8

Recommended solutions for you in Chapter 2

Was this solution helpful?

Comment

STEP 4: Click Edit. In the pop up window, enter data range as shown below:

STEP 5: Click ok.

The Scatter plot of the relationship between the net sales and customer age is obtained as follows:

Comment

Step 11 of 11

3 0

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

javascript:;
javascript:;
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice
3/2/2020 Solved: Pelican StoresPelican Stores, a division of National Cl... | Chegg.com

https://www.chegg.com/homework-help/statistics-for-business-and-economics-12th-edition-chapter-2-problem-1CP-solution-9781133274537 8/8

Chapter 2, Problem 17E

A doctor’s office staff studied the waiting times for patients who arrive at the office with a request for emergency service....

See solution

Chapter 2, Problem 43E

The Northwest regional manager of an outdoor equipment retailer conducted a study to determine how managers at three store...

See solution

ABOUT CHEGG

LEGAL & POLICIES

CHEGG PRODUCTS AND SERVICES

CHEGG NETWORK

CUSTOMER SERVICE

© 2003-2020 Chegg Inc. All rights reserved.

1 Bookmark Show all steps:Chapter 2, Problem 1CP ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

https://www.chegg.com/homework-help/doctor-s-office-staff-studied-waiting-times-patients-arrive-o-chapter-2-problem-17e-solution-9781133274537-exc
https://www.chegg.com/homework-help/northwest-regional-manager-outdoor-equipment-retailer-conduct-chapter-2-problem-43e-solution-9781133274537-exc
http://www.paypal.com/
http://www.bbb.org/sanjose/business-reviews/books-textbooks-new-and-used/cheggcom-in-santa-clara-ca-238456
https://www.chegg.com/study
https://www.chegg.com/study/tbs
https://www.chegg.com/study/qa
https://www.chegg.com/study-pack
https://www.chegg.com/study/v2/practice

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:

Top Academic Tutor
Study Master
Engineering Help
Assignment Hut
Engineering Mentor
Ideas & Innovations
Writer Writer Name Offer Chat
Top Academic Tutor

ONLINE

Top Academic Tutor

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$43 Chat With Writer
Study Master

ONLINE

Study Master

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

$27 Chat With Writer
Engineering Help

ONLINE

Engineering Help

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.

$33 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

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.

$22 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$16 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$43 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

Propane is obtained from propene by which method - Harry potter dracula fanfiction - What is a value scale in art - West chester dpa - What role does creativity play in the bat poet - Strategy and games dutta pdf - Anth journal - Nordic genetic resource center - Chapter Readings Reflections Journal - Chapter 10 and 11 - All summer in a day worksheet pdf - Calculate equivalent annual cost - Marketing communication mix of coca cola - Lección 4 estructura 4.2 practicar verbos - Victoria climbie injuries photos - Psyc305 unit 3 individual project - Need in 1 hour - Brc food safety culture - Analytical research - 1993 landcare $1 coin value - Jumping gum pumping gum song lyrics - Juegan ustedes al baloncesto en la universidad - Royal arch chapter room layout - Current issues and enduring questions 10th edition ebook - The things they carried setting importance - Organizations with adhocracy cultures are described as - Two shuffleboard disks of equal mass one orange - Discussion (AG) - Prisoner 819 real name - International Business- Essay - Tom's auto service case study - Gf - HN 522 Unit 9 Discussion - When scheduling production of products what are the key factors to consider - Computer literacy course outline - Assignment 9/22/2020 - Essay - The importance of being earnest act 1 questions - Autem plc analyzer pro 6 - Newham council resident permit - Finance Personal Planning - Leadership and conflict management ppt - Buses to roehampton university - 5 MOST CONTAGIOUS DISEASE - Playstation network london gb pos authorisation - Case study - English - Audi a4 convertible roof fuse - Healthcare Strategies - Google docs unable to convert document - Wk4 DQ1 Discussion Question: CLO 1, CLO 3, CLO 5 - Bio-anth - BHA415 Module 4 Case - Which of the following statements concerning leases is true - The green witch your complete guide pdf - Operational Planning - 8 Page work - Bond j has a coupon rate of 3 percent - WK4 Assignment-Quantitative Research Critique - Discussion - Run lola run jump cuts - Gea westfalia separator models - Business ethics: case study 5 - Isa 230 audit documentation acca - What is a personal creed - Finance Exam / Need it within 10 hours / Complete in a Word document - Product design at regal marine case study answers - Pick one topic below compare and contrast. - Economics problem set 1 answers - Where are contingent liabilities recorded - Deliverable 6 - Using Business Visuals - What is bavarian sausage inc s operating cash flow - End of day checklist - The other wes moore mla citation - Critical Thinking Oral Answer - Ancestor doll school project - How can we bridge the differences that divide us - Steve caples a real estate appraiser - Defense mechanisms worksheet answers - Organ leader and decision making - Deborah brandt sponsors of literacy - Python - The lion's bride gwen harwood analysis - Article writing - Hopes and fears workshop - Homework - Nonpf competencies for fnp graduates - WEBAssignment - Summary - Case studiePYSC 430 Module/ - What internet business model would be appropriate - Effect of roughness on frictional force - Gen 103 week 1 assignment - Focal length of convex lens graph - Conclusion of the little match girl - Cert 2 electrotechnology adelaide - A can of bull case study - Maso company recorded journal entries - Cisco unified ccx administration - Commonwealth bank old statements - Humn 8660