Image and Motion Pictures

Only available on StudyMode
  • Download(s) : 58
  • Published : October 6, 2011
Open Document
Text Preview
Solutions to Case Problems
Chapter 2 Descriptive Statistics: Tabular and Graphical Presentations Case Problem 1: Pelican Stores
1. There were 70 Promotional customers and 30 Regular customers. Because there are 100 observations in the sample, the frequency and percent frequency distribution are the same. Percent frequency distributions for many of the variables are given. No. of Items 1 2 3 4 5 6 7 or more Total: Net Sales 0.00 - 24.99 25.00 - 49.99 50.00 - 74.99 75.00 - 99.99 100.00 - 124.99 125.00 - 149.99 150.00 - 174.99 175.00 - 199.99 200 or more Total: Method of Payment American Express Discover MasterCard Proprietary Card Visa Total: Percent Frequency 29 27 10 10 9 7 8 100 Percent Frequency 9 30 25 10 12 4 3 3 4 100 Percent Frequency 2 4 14 70 10 100

CP - 1

Chapter 2 Gender Female Male Total: Martial Status Married Single Total: Age 20 - 29 30 - 39 40 - 49 50 - 59 60 - 69 70 - 79 Total: Percent Frequency 93 7 100 Percent Frequency 84 16 100 Percent Frequency 10 30 33 16 7 4 100

Descriptive Statistics: Tabular and Graphical Presentations

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. • Over half of the customers purchase 1 or 2 items, but a few make numerous purchases. • 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. 2.

3.

A crosstabulation of type of customer versus net sales is shown.

CP - 2

Chapter 2

Descriptive Statistics: Tabular and Graphical Presentations

Net Sales 0- 25- 50- 75- 100- 125- 175- 200- 225- 250- 275- Total Customer 25 50 75 100 125 175 200 225 250 275 300 Promotional 7 17 17 8 9 3 2 3 1 2 1 70 Regular 2 13 8 2 3 1 1 30 Total 9 30 25 10 12 4 3 3 1 2 1 100 4. From the crosstabulation it appears that net sales are larger for promotional customers. A scatter diagram of net Sales vs. age is shown below. A trendline has been fitted to the data. From this, it appears that there is no relationship between net sales and age.

350.00 300.00 250.00 200.00 150.00 100.00 50.00 0.00 0 10 20 30 40 Age 50 60 70 80 90

Age is not a factor in determining net sales.

Case Problem 2: The Motion Picture Industry
This case provides the student with the opportunity to use tabular and graphical presentations to analyze data from the motion picture industry. Developing and interpreting frequency distributions, percent frequency distributions and scatter diagrams are emphasized. The interpretations and insights can be quite varied. We illustrate some below. Frequency Distribution and Percent Frequency Distribution The choice of the classes for frequency distributions or percent frequency distributions can be expected to vary. The frequency distributions we developed are as follows: Opening Gross Sales (Millions) $0 – 9.99 10 – 19.99 20 – 29.99 30 – 39.99 Frequency (or Percentage) 70 15 8 2

Net Sales

CP - 3

Chapter 2 40 50 60 70 80 90 100 – – – – – – – 49.99 59.99 69.99 79.99 89.99 99.99 109.99 Total

Descriptive Statistics: Tabular and Graphical Presentations 1 1 0 1 0 0 2 100 Frequency (or Percentage) 77 16 1 1 3 1 0 1 100 Frequency (or Percentage) 51 3 6 7 5 6 17 5 100

Total Gross Sales (Millions) $0 – 49.99 50 – 99.99 100 – 149.99 150 – 199.99 200 – 249.99 250 – 299.99 300 – 349.99 350 – 399.99 Total Number of Theaters 0 – 499 500 – 999 1000 – 1499 1500 – 1999 2000 – 2499 2500 – 2999 3000 – 3499 3500 – 3999 Total Number of Weeks in Top 60 0 – 4 5 – 9 10 – 14 15 – 19 20 – 24 25 – 29 Total

Frequency (or Percentage) 33 28 18 15 5 1 100

CP - 4

Chapter 2

Descriptive Statistics: Tabular and Graphical Presentations

Histograms The following histograms are based on the frequency distributions shown above....
tracking img