Solution Manual for Essentials of Modern Business Statistics with Microsoft Excel 7th Edition by Anderson
Solutions to
Case Problems
Chapter 2
Descriptive Statistics: Tabular and Graphical Displays
Case Problem 1: Pelican Stores
- Solution Manual for Essentials of Modern Business Statistics There were 70 Promotional customers and 30 Regular customers Percent frequency distributions for many of the variables are given.
| No. of Items | Percent Frequency |
| 1 | 29 |
| 2 | 27 |
| 3 | 10 |
| 4 | 10 |
| 5 | 9 |
| 6 | 7 |
| 7 or more | 8 |
| Total: | 100 |
| Net Sales | Percent Frequency |
| 0.00 – 24.99 | 9 |
| 25.00 – 49.99 | 30 |
| 50.00 – 74.99 | 25 |
| 75.00 – 99.99 | 10 |
| 100.00 – 124.99 | 12 |
| 125.00 – 149.99 | 4 |
| 150.00 – 174.99 | 3 |
| 175.00 – 199.99 | 3 |
| 200 or more | 4 |
| Total: | 100 |
| Method of Payment | Percent Frequency |
| American Express | 2 |
| Discover | 4 |
| MasterCard | 14 |
| Proprietary Card | 70 |
| Visa | 10 |
| Total: | 100 |
| Gender | Percent Frequency |
| Female | 93 |
| Male | 7 |
| Total: | 100 |
| Martial Status | Percent Frequency |
| Married | 84 |
| Single | 16 |
| Total: | 100 |
| Age | Percent Frequency |
| 20 – 29 | 10 |
| 30 – 39 | 30 |
| 40 – 49 | 33 |
| 50 – 59 | 16 |
| 60 – 69 | 7 |
| 70 – 79 | 4 |
| Total: | 100 |
Solution Manual for Essentials of Modern Business Statistics These percent frequency distributions provide a profile of Pelican’s customers. Many observations are possible, including:
- A large majority of the customers use National Clothing’s proprietary credit card
- The percent frequency distribution of net sales shows that 61% of the customers spent $50 or more.
- Customers are distributed across all adult age groups.
- The overwhelming majority of customers are female.
- Most of the customers are married.
