Pelican Store

In: Business and Management

Submitted By meezy06
Words 1050
Pages 5
Statistical Analysis of the net sales of Pelican Store
The following will examine the tables that were formulated based on the data given and state conclusions on what it represents. This data was collected from a sample of 100 customers that used a credit card at Pelican Stores one day during a discount-coupon promotion.
All of the tables are categorized in different groups representing the net sales of the Pelican Store. They show the mean, median, mode, standard deviation, variance, skewness, kurtosis, range and the 25th, 50th and 75th percentile. All of these statistical outputs each embody a particular meaning.

The first table that was constructed represented the frequencies of the net sales of the pelican store data and is simply a basic overview of sorts of the data. The mean here indicates that on average Pelican Stores customers spent over $77.
The standard deviation shows how close the rest of the individual data is from the averages and the closer they are, the more accurate the average is. The data has a standard deviation of $55.66 from the average spending which is reasonably low and it is safe to assume that the data is fairly accurate.
The percentiles show that 25% of customers spent $39.60, 50% spent $59.70 and 75% spent $101.90

The second table divides the net sales into gender groups. It shows that 93% of customers were female and the rest were male which is reasonable as this is a woman’s apparel store.
The females on average spent $79.18 whereas the males spent an average of $56.48
Female customers have a larger deviation than males of $56.89 from the average, as the males have a deviation of $30.40, which means the data on their average should be more accurate than the females.
FEMALE: 25% of female customers spent $39.80, 50% spent $62.40 and 75% spent $102.45
MALE: 25% of male customers spent $39.50, 50% spent 47.20 and 75%…...

Similar Documents

Pelican Stores

...————— 1/17/2013 2:23:03 PM ———————————————————— Results for: PELICANSTORES[1].MTW Descriptive Statistics: Net Sales Variable Maximum Net Sales 287.59 Variable Net Sales N* 0 Mean 77.60 SE Mean 5.57 StDev 55.66 Minimum 13.23 Q1 39.60 Median 59.71 Q3 101.90 Range 274.36 Descriptive Statistics: Net Sales Variable Median Net Sales 63.42 51.00 Variable Net Sales Type of Customer Promotional Regular Q3 109.39 74.25 Maximum 287.59 159.75 Range 274.36 137.25 Type of Customer Promotional Regular N* 0 0 Mean 84.29 61.99 SE Mean 7.35 6.40 StDev 61.46 35.07 Minimum 13.23 22.50 Q1 43.50 39.38 Descriptive Statistics: Net Sales Variable Net Sales Age 20 22 24 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 68 70 72 74 78 Age 20 22 24 28 30 32 34 36 N* 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Mean 52.8 81.5 49.500 90.6 117.5 42.57 51.17 68.9 99.9 67.3 99.5 38.91 66.4 77.7 165.5 181 73.2 75.2 52.500 34.81 48.4 98.4 18.000 159.75 45.220 58.000 SE Mean 21.2 12.5 * 19.9 29.6 6.44 5.80 12.7 26.9 31.8 26.4 5.86 13.1 19.2 50.3 106 11.7 30.4 * 4.79 19.0 20.4 * * * * StDev 30.0 17.7 * 44.5 83.8 18.21 10.05 31.1 60.1 63.5 69.8 15.51 39.4 47.1 87.1 150 33.0 42.9 * 6.77 32.9 28.8 * * * * Minimum 31.6 69.0 49.500 31.6 47.6 14.82 40.00 29.5 23.8 22.5 31.6 13.23 19.5 29.5 113.0 75.0 22.4 44.8 52.500 30.02 20.8 78.0 18.000 159.75 45.220 58.000 Q1 * * * 47.4 54.9 26.50 40.00 40.8 47.3 24.8 39.0 28.44 36.1 37.0 113.0 * 46.8 * * * 20.8 * * * * * Median 52.8 81.5 49.500 100.4 70.8......

Words: 614 - Pages: 3

Happiness Store

...Wegley ENG 102 18 January 2014 The Happiness Store: A Place to be Happy in Less Mundane Ways Gary Larson has brought laughter to many people by his popular long-running comic called The Far Side. In one of these cartoon series, the character names Crawley was told by his friends: “You cannot buy happiness”. However, “Mr. Crawley surmised that they just didn’t know where the store was” (Figure 1). Humorously, Mr. Crawley’s conclusion about the reason why his friends could never buy happiness may be comical and eccentric, but it conveys Larson’s message about a common and reflective argument in our life as he identifies people’s different aspects of happiness and ways to accomplish it. Is simply painted in black and white with captions at the bottom, the single rectangular panel makes it easier for the readers to recognize Larson’s typical painting style and his message throughout the comic. Looking at the panel, what impresses viewers at the first glance is the “Happiness” store with a remarkable, large signboard on the corner of a crowded street. On the pane of glass, there are several flyers for advertisement such as “Complete your life”. Besides, that store selling happiness is the place which Mr. Crawley’s friends – the characters in the comic did not know. Thus, they were unable to purchase happiness. The hilarious point is that “happiness” is an abstract, ungraspable definition; how come there is a store selling it? Nevertheless, according to Henri......

Words: 944 - Pages: 4

Pelican Stores

...Case Problem: Pelican Stores BUS-7900 Introduction to Quantitative Analysis Spring2 -2014 Dr. Carol Colston Ottawa University Abstract Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores located throughout the country. They ran a one-day promotion that offered discount coupons to its customers from the other National Clothing stores. They collected data from a sample of 100 customers’ in-store credit card transactions from that day. Management wanted to learn about the customer base and to evaluate the promotion involving the discount coupon. This report will examine the customer profiles that will include gender, marital status, net sales and age groups through the use of tabular and graphical descriptive statistics. In addition, the effectiveness of the promotional campaign will be evaluated by looking at key variables including methods of payment, types of customer and age groups as compared to net sales. Introduction Pelican Stores is a chain of women’s apparel stores located throughout the country and is a division of national Clothing. They ran a one-day sales promotion that offered discount coupons to its customers from the other National Clothing stores. They collected data from a sample of 100 customers’ in-store credit card transactions from that day. The management from Pelican Stores wanted assesses the effectiveness of its promotion by collecting data from the date of the sale. Since the promotion al coupons...

Words: 964 - Pages: 4

A Convenience Store

...opportunities for the Corporation. Why Convenient Stores alongside Fuelling Facilities ? With the emergence of organised retailing in the country and a growing demand from consumers for a superior shopping experience, Convenience Retailing has emerged as a key business area for petroleum companies given their wide retail presence, existing customer base and strategically located sites. Convenience need gaps have been felt in various fields and research has shown that the urban consumer today seeks convenience in shopping for their basic requirements so that their precious time is reserved for more fruitful pursuits. Petrol retail outlets provide the right framework for setting up convenience retail chains where the consumer has the opportunity of combining shopping with the fuelling occasion. Realising the importance of a greater understanding of consumers’ needs and consistent with its core objective of continuously adding value to it’s customers through innovative means, Bharat Petroleum has launched its convenience retailing initiative under the “In&Out” brand. Bharat Petroleum is the 2nd largest oil marketing company in the country with over 13000 Retail outlets spread across the length and breadth of the country. The In&Out chain of convenience stores is being set up in the urban markets at strategically located retail outlet sites with high customer footfalls. A convenience store, corner store, or corner shop, is a small store that stocks a range of......

Words: 1700 - Pages: 7

Candy Store

...Candy Store In this chart, there is an assumption that each of the 24 franchise stores will generate $570,000 in revenue each year. This projection is within 8% of Candy Andy’s revenue in 2013, however it is unreasonable to assume that this is accurate. The original Candy Andy store is located in a town with a summer population of 54,000 and a winter total of 9000. Each of the new franchises will be located in areas with varying populations, and the size will heavily influence the amount of demand generated for Candy Andy’s products. Therefore, this projection is not directly repeatable throughout each of the 24 franchises. This projection also assumes that sales will be consistent throughout three years. This is not a reasonable assumption, especially since it is highly unlikely that all 24 stores will be ready and open within the first year. This chart assumes that TURG has the necessary capital to build 24 franchise stores before day 1 of the first year following the deal. This is extremely unlikely, as building and implementing the new franchise stores will take a substantial amount of time and capital. When making her decision, Edith must consider how she would adjust her current marketing efforts if she declines the franchise offer. Her current marketing strategy involving AdMad costs $4500 per month. Her return on marketing investment is extremely low, since she has not noticed a significant change in Candy Andy’s sales. If Edith keeps her business, she......

Words: 2179 - Pages: 9

Store

...in Manila, Epifania de Jesus put up a small sari – sari store which is retailing goods and soft drinks. Eventually, their store became bigger with the help of her husband; and in 1998 they expanded the store from retailing to a wholesaler soft drinks store and named it “Funny Kids”. The store’s name came from the owner’s name and her five daughters. The business started its operation at Sampaloc, Manila in June 1998. In 2000, the store owner added alcoholic beverages to provide all beverage needs of the customers. Leveraging on the business as a high-level customer provider, they open up a mini-grocery in 2009. Now Funny Kids store is operating for twelve years, providing soft drinks and alcoholic beverages within the area of Sta. Mesa and Balic-Balic Manila. Customers usually order soft drinks and beers, including Coca Cola Products, Pepsi Products, ARC Cola’s, Cosmos, San Miguel Products and other beverages that customers demand. Customers are ordering from the store every other day, the store personnel distribute beverages to almost sixty to eighty stores within the said area. The store sold approximately ninety to one hundred cases of beverages on normal days and on peak days they sold almost two hundred cases of beverages while on off peak days they only sold eighty cases. At the end of the day, the store keeper checks their stocks if how many beverages are still available for delivery on the next day. The store keeper also checks the cash at hand with the receipts......

Words: 348 - Pages: 2

Store

...Charming Charlie In Barboursville W.V Huntington Mall ,Charming Charlie's is a store that came on the scene particularly faster than most independent jewelry stores. The store provides jewelry not seen around in the area and quit an abundance of it. The one things most people like about Charming Charlie, is the amount of jewelry and every color available to your liking. Also something that the store offers are shoes and purses not like most shoes and purses throughout the mall. When you walk into the store they have each piece of jewelry color coordinated and sectioned off in areas throughout the store. The store itself is one of the larger stores in the mall, it's very difficult not to notice when walking by, the colors are very vibrant with reds, yellows, blues and pinks all year around regardless of season. The music they play in the store is very contemporary but played in a lower sound than most stores not being too distracting. They display signs on the windows when they are having a sale of any type. The salespeople that work in the store wear their own style of clothing but jewelry from head to toe. One of the things I believe that would help Charming Charlie's is not so much the appearance of the store but the sale consultants of the establishment. One thing I notice was it took a few minutes, if not ten minutes to respond to me as I was looking through the store . When the sales consultant finally notices me they were placing items on the shelf and ask if I......

Words: 358 - Pages: 2

Case Pelican Study

...Final Analysis Descriptive analysis : Sales by gender: 97% of customers were female whereas 3% of customers were male. we can conclude Females represents the largest part of customers compare to Males. Moreover, female customers spend on an average $ 22,7 more than male customers. Sales by marital status : Married customers represents 76% of overall customers at Pelican stores. Also they tend to spend more than single customers. Sales by age: Around 80% are between 30 years old and 60 years old. Also, customers between 50 and 60 years old spend an average $30 more than customers of a different group age. Sales by discount and gender: Female represent the largest part of customers among promotional and regular customers. Also they tend to spend more money than male customers Sales by discount: Promotional customers bought an average of 3.8 items, while the Regular customers bought 1.8. It is clear that promotional customers purchase more items than regular customers. Moreover, Promotional customers spend more than Regular customers. They represent Stem and leaf plot : the stem and leaf plot shows that both Regular and Promotional customers, the most frequent amount of dollars spent is between $40 and $50. It also shows that customers with promotional coupons are more likely to spend more. Without promotional coupons the maximum amount spent was $ 160. With Promotional coupons, 7 customers spent more than $16. The maximum being $288. Outliers : We have found a 3......

Words: 515 - Pages: 3

Pelican Case Study

...Pelican Stores - Data c Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Promotional Items 1 5 2 2 1 9 2 2 3 2 6 1 4 7 2 1 5 3 1 2 3 5 6 5 13 4 Net Sales 102,40 100,40 78,00 56,52 31,60 160,40 64,50 71,40 94,00 38,50 44,80 31,60 70,82 266,00 39,50 30,02 192,80 71,20 18,00 63,20 63,20 105,50 117,50 13,23 198,80 19,50 Age 36 28 30 46 40 40 46 36 22 32 56 28 38 50 48 60 42 32 70 28 44 56 50 44 42 46 Gender Female Female Female Female Female Female Female Male Female Female Female Female Female Female Male Female Female Female Female Female Female Female Female Female Female Female Marital Status Z......

Words: 4726 - Pages: 19

Pelican Stores Case Study

...Names: Marielisa Mata Marlenne Ruiz Case Study 1 Pelican Stores 1. Percent Frequency distribution Count of Type of Customer Row Labels Total Promotional Regular Grand Total Count of Net Sales 70 30 100 Relative Freq. Percentage Freq. 0.7 70% 0.3 30% 1 100% 29 27 10 10 9 7 1 1 3 1 1 1 100 Relative Freq. Percentage Freq. 0.29 29% 0.27 27% 0.1 10% 0.1 10% 0.09 9% 0.07 7% 0.01 1%Count of Method of Payment 0.01 1% 0.03 3% 0.01 1% 0.01 1% 0.01 1% 1 100% 10 30 33 16 7 4 100 Relative Freq. Percentage Freq. 0.1 10% 0.3 30% 0.33 33% 0.16 16% 0.07 7% 0.04 4% 1 100% Count of Items Row Labels 1 2 3 4 5 6 7 8 9 10 13 17 Grand Total Total Count of Age Row Labels 20-29 30-39 40-49 50-59 60-69 70-80 Grand Total Total Number of Classes Largest data value Smallest data value Aprox. Class width 2. A bar chart or pie chart showing the number of customer purchases attributable to the method of payment. Payment Method Chart Payment Method Chart 80 70 Customer Purchases 60 50 40 30 20 10 0 American Express Discover MasterCard Proprietary Card Visa Payment Method 3. A crosstabulation of Type of customer versus Net sales . Comment Count of Type of Customer Row Labels Promotional Regular Grand Total Column Labels 10-40 40-70 17 9 26 21 12 33 70-100 100-130......

Words: 591 - Pages: 3

Store

...being said, The Lavish was launched to give people an opportunity to dress like those that inspired them. The Lavish provides consumers with reasonable prices so they can wear the same apparel as their favorite musical artists. Living Lavish is living free, we all have moments in our life where looking your best is important. We aren’t just your local fashion apparel store, we give confidence, and great ideas to those that shop with us” -ROB B. We respect you shopping with us; our job is to provide you with the best customer service. All of our products are 100% authentic and from the real retailers. We will also provide you with a receipt and confirmation number with your purchase. Any problem found with any of our products will result in an immediate refund and store credit. Our headquarters is located in FairFax CA, 3556 Fashion Ave near Huntington Beach and we have over 1,100 stores in 48 states in shopping malls, outlets and strip centers. By working directly with the market, we can react instantly to produce new trends and must-have styles that don’t exist anywhere else. Shoppers will find that our store is very modern and up to date with the newest trends of celebrities and todays culture. You can purchase the “look” of current pop and hip-hop artist’s at an affordable price. We’re young, fun and fresh. We’re energetic and playful. We believe in changing things up while staying true to yourself, and we’re passionate about giving you a voice; and the right to......

Words: 641 - Pages: 3

Apple Store

...Apple Store Introduction Apple store is defined as the chain of retail sores owned and operated by Apple Inc. the store sells computer software, iPod, phones apple watches and apple televisions. Additionally, it offers technical support and repair, free workshops for the public and youth, presentation theaters and training on apple products. According to Ron Jonson article Apple store are responsible for turning boring computer into playroom, (New York Times). Apple store Computation in technology is propelling every technology companies to develop stores that suit the needs of location and regulation authorizes. Apple store has taken a high notch by changing the landscape of consumers’ electronic retail. In Apple stores, customers can get all the help they need , they can make a Genius Bar reservation for any software repair and services on the hardware and they come with the security key that protect consumers device whenever it’s lost and keep track of the apple device. structural organization of Apple store allows the firm grow and continue innovating rapidly, the most significant structural organization of Apple store include; structural glass and staircase where each part of the structure is structurally linked to the rest and contribute to the global stiffness of the structure. The elements of the glass include; steps which are made from annealed lamination glass, stringers from the chemically toughed laminated glass, glass floor, glass beams and mezzanine......

Words: 338 - Pages: 2

Store and Non-Store Retailing

...Store and Non-store Retailing Store Retailing * Consists of the sale of goods or merchandise from a fixed location. * Specialty Stores - is a store, usually retail, that offers specific and specialized types of items. These stores focus on selling a particular brand, or a particular type of item. Specialty stores include: * Limited-line stores that offer a large assortment of a few related product lines. * Single-line stores that emphasize a single product. * Category killers which are large, low-priced limited-line retail chains that attempt to dominate a particular product category. * Convenience Stores – are retailers whose primary advantages to consumers are location convenience, close-in parking, and easy entry and exit. Non-store Retailing * It is the selling of goods and services outside the confines of a retail facility. * Catalogs and Direct Mail – the advantages of this type of non-store retailing for marketers are that consumers can be targeted effectively and reached in their homes or at work, and assortments of specialty merchandise can be presented with attractive pictures and in-depth descriptions of features and benefits. * Vending Machines – are a relatively limited method of retail merchandising, and most vending machine sales for beverages, food and candy. Vending machines are available for sales 24 hours a day, they can be placed in a variety of high-traffic locations, and marketers can charge higher prices. ...

Words: 361 - Pages: 2

Pelican Stor

...Introduction The purpose of this report is to show how the spending habits of customers changes when they are given coupons versus when they arrive at the store with no discounts to use. The key variable discussed in one graph includes the number of items that were bought with and without coupons or store promotions. It also shows the percent of items purchased with each payment method allowed at the store. This comparison helps the management to decide whether or not their promotional credit card is actually worthwhile and worth keeping around. Does this store credit card benefit the company to have? Are the coupons beneficial to the store owners? Abstract First, we will look at the key variables to be discussed in this section. One of the most important objects to determine is whether or not it is beneficial to The Pelican Store to have promotional items, such as coupons, given out. Type of Customer Items Bought % Bought Regular 88 0.27 27% Promotional 234 0.73 73% 322 100% This percent frequency distribution breaks down the type of customer along with the number and percentage of items bought. As you can see, a significant amount of sales are coming from the promotional customers. A whopping 73% of items sales came from promotional customers. Now, in this case, promotional customers are the customers that used a discount coupon to purchase the items. This shows how important it can be to offer promotions every once in a while for your customers. Coupons......

Words: 1122 - Pages: 5

Pelican Pharmaceutical

...Executive summary (DRAFT); This report provides an analyses, evaluation and recommendation on behalf of Pelican Pharmaceuticals Limited (PPL) on feasibility of the launching of a new product for the treatment of constipation for the Australian and New Zealand market. The methods used on this evaluation include discounted cash flow analysis, where an investment is valued by discounting its future cash flows. Also, net present value, which is considered to provide the most accurate evaluation of this investment as it precisely, determines the increase in value of shareholders capital by evaluating the profitability of the project. Finally internal rate of return, which is an important method of analyse in percentage. Furthermore, the project should be accepted if the IRR of an investment exceeds its required return. Along with the base calculation, the report is taking into consideration few different calculations, where Miguel and Freddy believe that sales could be 10% higher and also Anna’s opinion, where sales could be overestimate by 5%. Moreover, the report also includes calculations where contract manufacturing sales are not included in the base case, best case at 10% and worst case where Anna defends an overestimation of 5%. The results presented by the sales analysis take into consideration the following assumptions and considerations: 1) Base case with and without contract manufacturing with another companies, an optimistic approach (best scenario)......

Words: 468 - Pages: 2