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 problem 1 solution

20/12/2020 Client: saad24vbs Deadline: 10 Days

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

Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Helping Hand
University Coursework Help
Top Essay Tutor
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$140 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$142 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

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

How does gladwell define high risk activism - What is a provider sponsored organization - Pros and cons of utopian society - Darla's cosmetics has annual credit - Chuck e cheese profit margin - Com assigmet 2 record - Hush lash studio mackay - Enthalpy of combustion of h2o - PsycPORT Article Responses essay - Tinks chainsaws and mowers - Jetfire heater j33 price - Systemverilog assertions examples with answers - Leeds beckett my hub - Jane addams why women should vote - Marketing management - Interviews and Interrogations CRJ-573 - Civic car park geelong - Of these four words, which one is most likely to have a negative flavor or connotation? - Deliverable 3 Kingston - Stoichiometry of a precipitation reaction lab report - Centre of pressure experiment discussion - 2 dimensional design projects - According to zinn what is his main purpose for writing - Project 7 - Cori close ucla salary - SCIENCE Discussion(NO PLAGIARISM, A++ WORK, QUALITY, On time) - Defiance data recorder rumors of utopia - Did arnold schwarzenegger cheat - DQ8 - 35 hannemann drive whyalla - 4 1/6 as an improper fraction - Diving board torque physics problem - Mr bean pushes woman's face - Huckleberry finn chapter 13 summary - Fan dampers and vanes - Paper - 500 word essay on macbeth - Medical practice problem - Under ifrs an entity should initially recognize inventory when - Australian catholic social justice - E1.A - What i am grateful for - All even numbers between 9 and 25 - Character Traits - Le chatelier's principle lab answers - A luxury cell phone maker has a high fixed cost - Xlitemprod pearsoncmg answers - A man with muscle dysmorphobia is most likely to: - How to defer unisa - Cultural Diversity - Energy systems response to acute exercise - Tertiary student concession card nsw - Silver and gold have i none meaning - John q movie character analysis - Biophysical interactions which lead to diverse ecosystems and their functioning - Writter - Math 533 project part b - How many grams in a tenth - Oxford university essay writing guide - Accounting - Ati video case study levels of prevention - Walden NURS6003 Week 4 Quiz Part 1 - Object line definition engineering - Where is the coriolis effect the largest - Coca cola profit margin 2017 - Sbi net banking saral - Ways to separate solutions - Why our screens make us less happy summary - Mens Rea and Actus Reus - Mod4Option1 - Policy Response 4 - What is an arrangement in which the supplier maintains title to the inventory until it is used? - Walker and avant concept analysis steps - The morning brew coffee shop sells regular - Trial of Socrates - Lymphatic capillaries are present in ________. - Hitotsu futatsu mittsu yottsu itsutsu muttsu - First cirque du soleil show 1984 - Bankwest children's savings account - Australian standards for tiling - 9 barriers of communication - Balmoral gardens red suite - Cycle ergometer test results - An electric motor worksheet answers - On january majestic mantles leased a lathe - Swot analysis for management consulting - Proficient Academic Writers From Academic Era - Birch - 1 jeannine court mount martha - Soap note for strep throat - Journal of inequalities in pure and applied mathematics - BUS 629 Final Assignment - Comprehensive international business plan - Persuasion discussion questions - Answer the following questions - Second order digital low pass filter - Which of the following is not a subfield of anthropology - Discussion - Case study on mortgage banking with solution - Assessment Process to Establish Eligibility