Essays24.com - Term Papers and Free Essays
Search

Pelican Stores Case Study

Essay by   •  June 24, 2015  •  Coursework  •  854 Words (4 Pages)  •  1,992 Views

Essay Preview: Pelican Stores Case Study

Report this essay
Page 1 of 4

Problem 25 on page 31

[pic 1]

  1. How many variables are in the data set?

There are five variables in the data set (i.e. Exchange, Ticker Symbol, Market Cap, Price/Earnings Ratio, and Gross Profit Margin)

  1. Which of the variables are categorical and which are quantitative?

Categorical

Quantitative

Exchange

Market Cap

Ticker Symbol

Price/Earnings Ratio

Gross Profit Margin

  1. For the Exchange variable, show the frequency and the percent frequency for AMEX, NYSE, and OTC.  Construct a bar graph similar to Figure 1.5 for the Exchange variable.  

Exchange

Frequency

Percent Frequency

AMEX

5

20%

NYSE

3

12%

OTC

17

68%

Total

25

[pic 2]

  1. Show the frequency distribution for the Gross Profit Margin using the five intervals: 0-14.9, 15-29.9, 30-44.9, 45-59.9, and 60-74.9.  Construct a histogram similar to Figure 1.6.

Gross Profit Margin

Frequency

 0.0 – 14.9

2

15.0 – 29.9

6

30.0 – 44.9

8

45.0 – 59.9

6

60.0 – 74.9

3

[pic 3]

  1. What is the average price/earnings ratio?

The sum of P/E ratio for all 25 companies = 505.4
The average of the P/E ratio = (505.4/25) = 20.22

[pic 4]

Pelican Stores – Case Study 1

To help Pelican analyze their sales for Promotional Customers vs. Regular Customers, it would help to see frequency distribution.

Items Sold

Frequency

Relative Frequency

Percent Frequency

Regular

56

0.173913043

17.39

Promotional

266

0.826086957

82.61

Net Sales

Frequency

Relative Frequency

Percent Frequency

Regular

1859.75

0.239656961

24%

Promotional

5900.3

0.760343039

76%

[pic 5]

[pic 6]

Cross-tabulation of Items Sold, Net Sales and Customer Type:

Sum of Net Sales

Column Labels

Row Labels

1-4

5-8

9-12

13-17

Grand Total

Promotional

$2,805.49

$1,820.32

$846.19

$428.30

$5,900.30

Regular

$1,556.00

$303.75

$1,859.75

Grand Total

$4,361.49

$2,124.07

$846.19

$428.30

$7,760.05

Relative Frequency

Percentage Frequency

Promotional Sales

0.760343039

76%

Regular Sales

0.239656961

24%

Items Sold

Relative Frequency

Percentage Frequency

1-4

0.562044059

56%

5-8

0.273718597

27%

9-12

0.1090444

11%

13-17

0.055192943

6%

Row Percentages for each customer type

1-4

5-8

9-12

13-17

Promotional

48%

31%

14%

7%

100%

Regular

84%

16%

100%

...

...

Download as:   txt (6.5 Kb)   pdf (353.1 Kb)   docx (153.7 Kb)  
Continue for 3 more pages »
Only available on Essays24.com
Citation Generator

(2015, 06). Pelican Stores Case Study. Essays24.com. Retrieved 06, 2015, from https://www.essays24.com/essay/Pelican-Stores-Case-Study/62539.html

"Pelican Stores Case Study" Essays24.com. 06 2015. 2015. 06 2015 <https://www.essays24.com/essay/Pelican-Stores-Case-Study/62539.html>.

"Pelican Stores Case Study." Essays24.com. Essays24.com, 06 2015. Web. 06 2015. <https://www.essays24.com/essay/Pelican-Stores-Case-Study/62539.html>.

"Pelican Stores Case Study." Essays24.com. 06, 2015. Accessed 06, 2015. https://www.essays24.com/essay/Pelican-Stores-Case-Study/62539.html.