![Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card](https://www.bartleby.com/isbn_cover_images/9781337589383/9781337589383_smallCoverImage.jpg)
Concept explainers
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.
Most of the variables shown in Table 2.19 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.
Managerial Report
Use the tabular and graphical methods of
- 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.
![Check Mark](/static/check-mark.png)
Trending nowThis is a popular solution!
![Blurred answer](/static/blurred-answer.jpg)
Chapter 2 Solutions
Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
- Question 2: When John started his first job, his first end-of-year salary was $82,500. In the following years, he received salary raises as shown in the following table. Fill the Table: Fill the following table showing his end-of-year salary for each year. I have already provided the end-of-year salaries for the first three years. Calculate the end-of-year salaries for the remaining years using Excel. (If you Excel answer for the top 3 cells is not the same as the one in the following table, your formula / approach is incorrect) (2 points) Geometric Mean of Salary Raises: Calculate the geometric mean of the salary raises using the percentage figures provided in the second column named “% Raise”. (The geometric mean for this calculation should be nearly identical to the arithmetic mean. If your answer deviates significantly from the mean, it's likely incorrect. 2 points) Starting salary % Raise Raise Salary after raise 75000 10% 7500 82500 82500 4% 3300…arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward
- 310015 K Question 9, 5.2.28-T Part 1 of 4 HW Score: 85.96%, 49 of 57 points Points: 1 Save of 6 Based on a poll, among adults who regret getting tattoos, 28% say that they were too young when they got their tattoos. Assume that six adults who regret getting tattoos are randomly selected, and find the indicated probability. Complete parts (a) through (d) below. a. Find the probability that none of the selected adults say that they were too young to get tattoos. 0.0520 (Round to four decimal places as needed.) Clear all Final check Feb 7 12:47 US Oarrow_forwardhow could the bar graph have been organized differently to make it easier to compare opinion changes within political partiesarrow_forwardDraw a picture of a normal distribution with mean 70 and standard deviation 5.arrow_forward
- What do you guess are the standard deviations of the two distributions in the previous example problem?arrow_forwardPlease answer the questionsarrow_forward30. An individual who has automobile insurance from a certain company is randomly selected. Let Y be the num- ber of moving violations for which the individual was cited during the last 3 years. The pmf of Y isy | 1 2 4 8 16p(y) | .05 .10 .35 .40 .10 a.Compute E(Y).b. Suppose an individual with Y violations incurs a surcharge of $100Y^2. Calculate the expected amount of the surcharge.arrow_forward
- 24. An insurance company offers its policyholders a num- ber of different premium payment options. For a ran- domly selected policyholder, let X = the number of months between successive payments. The cdf of X is as follows: F(x)=0.00 : x < 10.30 : 1≤x<30.40 : 3≤ x < 40.45 : 4≤ x <60.60 : 6≤ x < 121.00 : 12≤ x a. What is the pmf of X?b. Using just the cdf, compute P(3≤ X ≤6) and P(4≤ X).arrow_forward59. At a certain gas station, 40% of the customers use regular gas (A1), 35% use plus gas (A2), and 25% use premium (A3). Of those customers using regular gas, only 30% fill their tanks (event B). Of those customers using plus, 60% fill their tanks, whereas of those using premium, 50% fill their tanks.a. What is the probability that the next customer will request plus gas and fill the tank (A2 B)?b. What is the probability that the next customer fills the tank?c. If the next customer fills the tank, what is the probability that regular gas is requested? Plus? Premium?arrow_forward38. Possible values of X, the number of components in a system submitted for repair that must be replaced, are 1, 2, 3, and 4 with corresponding probabilities .15, .35, .35, and .15, respectively. a. Calculate E(X) and then E(5 - X).b. Would the repair facility be better off charging a flat fee of $75 or else the amount $[150/(5 - X)]? [Note: It is not generally true that E(c/Y) = c/E(Y).]arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)