Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 1CP

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

Most of the variables shown in Table 3.9 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

Chapter 3, Problem 1CP, Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating

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 methods of descriptive statistics presented in this chapter to summarize the data and comment on your findings. At a minimum, your report should include the following:

  1. 1. Descriptive statistics on net sales and descriptive statistics on net sales by various classifications of customers.
  2. 2. Descriptive statistics concerning the relationship between age and net sales.
Blurred answer
Students have asked these similar questions
Businesses such as General Mills, Kellogg's, and Betty Crocker regularly use coupons to build brand allegiance and stimulate sales. Marketers believe that the users of paper coupons are different from the users of e-coupons accessed through the Internet. One survey recorded the age of each person who redeemed a coupon along with the type of coupon (either paper or electronic). The sample of 24 traditional paper-coupon clippers had a mean age of 41.2 with a standard deviation of 4.8. The sample of 35 e-coupon users had a mean age of 32.5 years with a standard deviation of 11.2. Assume the population standard deviations are not the same. Using a significance level of 0.05, test the hypothesis of no difference in the mean ages of the two groups of coupon clients. Hint: For the calculations, assume e-coupon as the first sample. a. What are the null and alternate hypotheses? O Ho: He-coupon = Htraditional Hi Me-coupon # Mtraditional %3D O Ho: He-coupon + Htraditional Hhi He-coupon =…
Businesses such as general mills, Kellogg's, and Betty Crocker regularly use coupons to build brand allegiance and stimulate sales. Marketers believe that the users of paper coupons are different from the users of e-coupons accessed through the internet. One survey recorded the age of each person who redeemed a coupon along with the type of coupon (either paper of electronic). The sample of 24 traditional paper-coupon clippers had a mean age of 62.0 with a standard deviation of 20.0. The sample of 35 e-coupon users had a mean age of 41.8 years with a standard deviation of 4.8. Assume the population standard deviations are not the same. Using a significance level of .02, test the hypothesis of no difference in mean ages of two groups of coupon clients. a. Compute the test statistic. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) b. Compute the p-value. Note: P-value calculators are available through online search. (Round your answer to 4…
The New York Times reported that Apple has unveiled a new iPad marketed specifically to school districts for use by students (The New York Times website). The -inch iPads will have faster processors and a cheaper price point in an effort to take market share away from Google Chromebooks in public school districts. Suppose that the following data represent the percentages of students currently using Apple iPads for a sample of  U.S. public school districts. Click on the datafile logo to reference the data. 15 22 12 21 26 18 42 29 64 20 15 22 18 24 27 24 26 19 a. Compute the mean and median percentage of students currently using Apple iPads. Mean   (to  decimals) Median   (to the nearest whole number) b. Compute the first and third quartiles for these data. First quartile   (to  decimals) Third quartile   (to  decimals) c. Compute the range and interquartile range for these data. Range   (to the nearest whole number) Interquartile range   (to  decimals) d.…

Chapter 3 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 3.1 - Prob. 11ECh. 3.1 - The Big Bang Theory, a situation comedy...Ch. 3.1 - Automobile Fuel Efficiencies. In automobile...Ch. 3.1 - The data contained in the DATAfile named...Ch. 3.1 - 15. Martinez Auto Supplies has retail stores...Ch. 3.1 - 16. The grade point average for college students...Ch. 3.1 - 17. The following table shows the total return and...Ch. 3.1 - 18. Based on a survey of master’s programs in...Ch. 3.1 - Annual revenue for Corning Supplies grew by 5.5%...Ch. 3.1 - Suppose that at the beginning of Year 1 you...Ch. 3.1 - Prob. 21ECh. 3.1 - Prob. 22ECh. 3.2 - 23. Consider a sample with data values of 10, 20,...Ch. 3.2 - Prob. 24ECh. 3.2 - Consider a sample with data values of 27, 25, 20,...Ch. 3.2 - Price of Unleaded Gasoline. Data collected by the...Ch. 3.2 - Round-Trip Flight Prices. The following table...Ch. 3.2 - The Australian Open is the first of the four...Ch. 3.2 - Air Quality Index. The Los Angeles Times regularly...Ch. 3.2 - Prob. 30ECh. 3.2 - The results of Accounting Principals’ latest...Ch. 3.2 - Advertising Spend by Companies. Advertising Age...Ch. 3.2 - Scores turned in by an amateur golfer at the...Ch. 3.2 - Consistency of Running Times. The following times...Ch. 3.3 - 35. Consider a sample with data values of 10, 20,...Ch. 3.3 - 36. Consider a sample with a mean of 500 and a...Ch. 3.3 - 37. Consider a sample with a mean of 30 and a...Ch. 3.3 - 38. Suppose the data have a bell-shaped...Ch. 3.3 - 39. The results of a national survey showed that...Ch. 3.3 - 40. The energy information Administration reported...Ch. 3.3 - 41. The Graduate Management Admission Test (GMAT)...Ch. 3.3 - 42. Many families in California are using backyard...Ch. 3.3 - According to a Los Angeles Times study of more...Ch. 3.3 - NCAA Basketball Game Scores. A sample of 10 NCAA...Ch. 3.3 - The Wall Street Journal reported that Walmart...Ch. 3.4 - Consider a sample with data values of 27, 25, 20,...Ch. 3.4 - Prob. 47ECh. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples Half-Marathon Times. Naples, Florida, hosts...Ch. 3.4 - Pharmaceutical Company Sales. Annual sales, in...Ch. 3.4 - Cell Phone Companies Customer Satisfaction....Ch. 3.4 - Most Admired Companies. Fortune magazine’s list of...Ch. 3.4 - Prob. 54ECh. 3.5 - Five observations taken for two variables...Ch. 3.5 - Prob. 56ECh. 3.5 - The DATAfile TwoStocks contains adjusted monthly...Ch. 3.5 - Driving Speed and Fuel Efficiency. A department of...Ch. 3.5 - Smoke Detector Use and Death Rates. Over the past...Ch. 3.5 - Stock Market Indexes Comparison. The Russell 1000...Ch. 3.5 - Best Private Colleges. A random sample of 30...Ch. 3 - Americans Dining Out. Americans tend to dine out...Ch. 3 - NCAA Football Coaches Salaries. A 2017 USA Today...Ch. 3 - Physician Office Waiting Times. The average...Ch. 3 - Worker Productivity and Insomnia. U.S. companies...Ch. 3 - A study of smartphone users shows that 68% of...Ch. 3 - Work Commuting Methods. Public transportation and...Ch. 3 - Household Incomes. The following data represent a...Ch. 3 - Restaurant Chains’ Sales per Store. The data...Ch. 3 - Prob. 70SECh. 3 - NFL Teams Worth. In 2014, the 32 teams in the...Ch. 3 - MLB Team Winning Percentages. Does a major league...Ch. 3 - 73. The days to maturity for a sample of five...Ch. 3 - 74. Automobiles traveling on a road with a posted...Ch. 3 - Annual Returns for Panama Railroad Company Stock....Ch. 3 - Pelican Stores, a division of National Clothing,...Ch. 3 - The motion picture industry is a competitive...Ch. 3 - The pursuit of a higher education degree in...Ch. 3 - Although millions of elephants once roamed across...
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License