Premium Essay

Pelican Store

In:

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

Premium Essay

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

Free Essay

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 43...

Words: 614 - Pages: 3

Premium Essay

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 130-160 11 9 4 4 3 2 15 12 ...

Words: 591 - Pages: 3

Premium Essay

Grocery Inc

...INDIVIDUAL RESEARCH ASSIGNMENT 2 SCENARIO Grocery, Inc. is a retail grocery store chain based in Houston, Texas. Grocery has stores throughout Texas. Tom Green works as the produce manager for the store on Highway 290 in Cypress, Texas. Jeff Fresh, who turned 17 years old on June 5, 2008, begins working in June 2008 for Tom in the produce department at the beginning of the summer. ASSIGNMENT Using the scenario above, submit a 1,250-1,750 word paper with detailed answers to the following questions. QUESTION ONE Grocery contracted with Masterpiece Construction, Inc. to renovate the store in Cypress, Texas. Masterpiece was chosen by Grocery because of the superb workmanship it had displayed in prior projects for Grocery. After beginning the project, Masterpiece finds that it is unable to complete the renovation within the six-month time limit set out in its written contract with Grocery ostensibly due to a sudden increase in new contracts. Masterpiece subcontracts the remainder of the project to Build Them To Fall, LLC. Grocery was unaware of the subcontract and did not approve it. Grocery soon realized (due to the poor quality of work) that Build, not Masterpiece, was handling the renovation. Grocery files a lawsuit in the District Court of Harris County, Texas, petitioning the court for (1) an injunction against both Masterpiece and Build to stop on the project and (2) suing Masterpiece for breach of contract and specific performance. Masterpiece...

Words: 714 - Pages: 3

Premium Essay

Aldi

...After doing well in Germany, Netherlands, United States and Austria Aldi decided to enter the UK market in 1989. Nowadays Aldi is about to open its 500th store within the borders of the UK (BBC 2013). According to the Reuters (2013) Aldi has a 3.9% of market share within the UK where its competitors, that are called “big four” (Tesco, Asda, Sainsbury, Morrison), dominated the market with cumulative of 75.3% shares. PESTEL Analysis: Political factors: It is noted form (thinketc, 2008) that for employment regulations, the government inspires the retailers to offer a mix of job prospects from flexible, less-paid and locally-based works to highly-skilled and higher-paid, centrally-located jobs (Riboldi, 2013). Economical: One of the most significant factors on economy is great unemployment ranks that reduces the effective demand for goods, unfavourably upsetting the demand required to create such products (Riboldi, 2013). These economic aspects are mainly outside control of company but their special effects on the marketing mix and performance can be insightful (Gill, 2013). Social: Aldi have improved the amount of non-food substances presented for sale (Riboldi, 2013). Aldi is adjusting its product mix that is to accommodate improved demand for organic products (thinketc, 2008). Demographic variations such as aging population rise in female staffs and a drop in the home meal preparation means that UK sellers are also concentrating on added-value goods and services (Baymoh...

Words: 784 - Pages: 4

Premium Essay

Wal-Mart 2005

...start of 2005, Wal-Mart was up to nearly $260 billion in sales, managed over 5,000 stores in 10 different countries, and was an employer to over 1.5 million people worldwide- making it the largest supercenter, the largest company in the world. As of 1998, Wal-Mart began closing many of the original discount stores and opening supercenters in their place that provided “one-stop, round-the-clock family shopping,” with everyday low prices and convenient store hours. Supercenters doubled the size of the discount stores, employed over 200 and offered over 100,000 items (30,000 being grocery products). Some supercenters also consisted of specialty shops and others opened in urban areas as simply neighborhood markets offering limited drugs and groceries. Wal-Mart also continued to run the widely distributed warehouse clubs, SAM’S CLUBS, which directly competed with Costco and BJ’s Warehouse. By 2004, Wal-Mart maintained over 3,200 locations in the U.S., nearly 900 locations in the Americas (non U.S.), over 350 in Europe, and over 440 in Asia. Wal-Mart’s strategy began with the goal to provide customers with the goods they wanted when and where they wanted them. Wal-Mart then focused on developing cost structures that allowed it to offer low everyday pricing. This operational strength evolved from their strategic use of IT systems. These systems interchangeably shared information within stores, across stores, and with suppliers for forecasting, planning, replenishing and shipping applications...

Words: 1087 - Pages: 5

Premium Essay

3 Kinds of Supermarkets

...| | | | Applied Research Project | Introduction In this contemporary life, people cannot survive without supermarket which is interrelated to the whole thing of people’s lives, such as food and clothing line. A supermarket is a outward appearance of grocery store, a self-service store offering a wide variety of food and household merchandise and organized into departments. The supermarket characteristically comprises meat, fresh produce dairy, baked goods departments, along with shelf space reserved for canned and packaged goods as well as for various non-food items such as household cleaners, pharmacy products and pet supplies. Most supermarkets also sell a variety of other household products that are consumed regularly, like alcohol, medicine, clothes and some stores sell a much wider range of non-food products. A supermarket is larger in size and has a wider selection than a traditional grocery store also selling items typically found in a convenience store but is smaller and more limited in range of merchandise than a hypermarket or big-box store. In this paper we divided supermarkets of the worlds into three categories: * Convenience stores also called corner store, a small store that stocks a range of everyday items such as groceries, toiletries, alcoholic soft drinks and tobacco products. * Regional supermarket, a superstore which is bigger than 3000 square meters, contain routine weekly needs for most people can be satisfied in the case that adequate...

Words: 3433 - Pages: 14

Premium Essay

Superior Supermarkets

...Superior Supermarkets Everyday Low Pricing In: Business and Management Superior Supermarkets Everyday Low Pricing Superior Supermarkets (SS) is a division of Hall Consolidated, a privately owned wholesale and retail food distributor. Hall distributes food and related products to some 150 company-owned supermarket units and about 1,100 independent grocery stores in the U.S. through 12 wholesale distribution centers. Superior is the smallest of the three supermarket chains owned by Hall, with sales of $192.2 million in 2002. Sales of three Centralia stores were $14,326,700 in 2002. Randall Johnson, the District Manager for the Centralia stores, has recommended that they implement everyday low pricing (ELP) since Superior’s prices are higher than the competition at a time of growing price consciousness, and that the price differential could cause them to lose market share. Problem Statement Superior Supermarkets (SS) must decide whether o not to pursue an everyday low pricing (ELP) strategy at its three Centralia MO locations. Analysis Three viable alternatives have been found. Alternative #1 is to do nothing. Do not adopt ELP and keep the current promotional budget. If market share continues to decline, at the growth rate of -0.53% or greater, this alternative would be deemed unsuccessful. Conversely, if market share remains stagnant or improves, this strategy would prove to be prudent.    Alternative #2 is to implement a ‘limited ELP’ model. By marginally increasing the...

Words: 324 - Pages: 2

Free Essay

Bubble Tea

...TABLE OF CONTENTS Executive Summary ............................................................................................................................................... 1 The problem .............................................................................................................................................................. 2 Background ............................................................................................................................................................... 3 Research ..................................................................................................................................................................... 4 PMB................................................................................................................................................................ 4 Primary data survey .............................................................................................................................. 5 Industry overview .................................................................................................................................. 7 Costs ............................................................................................................................................................. 7 Revenues ..................................................................................................................................................... 8 The...

Words: 8741 - Pages: 35

Premium Essay

Outline of Apple

...things that seem to work well for apple: They have a diverse product line. They have opened jop oppunities. In africa and asia they have wear houses that produce parts of there products. They have also been known to hire musicians and historians. They also parner with the competition. Most noteable samsung and microsoft. they have achieved massive success. People wait year round for there keynotes and conferances. They have a dinimic business plan. They are allways trying new ideas. Apple stores: There are over 250 stores all over the woruld. Apple gives there customers that face to face interaction with an employee that can fix,setup and troubleshoot any of there products. Another reason why they are so successful is because there products just "work" together. In other wirds, if you plug an i phone into a mac it's easier to figure out how to import your music photos and oher media. I cloud is another reason why appple is so successful. They are a firm believer in having all your documents, music photos and even your settings in sync for transfering or setting up a new device. 2 products that have contributed to apple's success are the i phone and i pod. Steve jobs has said that he wanted the first i phone to be "An iPod, a phone, an internet mobile communicator," A brand that inspires innovation, engineering, user experience and design. Like any other Apple product; iPhone has set new standers on every front living up to and surpassing user expectation. This...

Words: 330 - Pages: 2

Premium Essay

Apple Communication

...security. That’s right, they are told not to speak to each other. This may be a necessary evil in the highly competitive world of computers and electronics but it can be detrimental to the work environment. Imagine the distrust within the company when only a few employees know what it is going on. Not to mention the fact that it elevates the risk of an employee selling the secret if he is the only one knowledgeable of it. Keeping the knowledge to a minimum also reduces the creativity within the company. There are less people thinking on how to make a product better and that means less brainstorming and creative ideas. Not only is this problem found at the corporate and administration levels, but also down to the very bottom at the Apple stores. Apple is a firm believer that the less people that know about the product, the less likely it is be leaked to the public or competitors. The sales people have no idea when a product is coming out until the last minute and are ill prepared for selling the item when it hits the shelves. Another problem with the lack of communication is in dealing with the customers. Remember the launch of the iPhone 4? Within hours, a design flaw was obvious to its millions of buyers. When the phone was held in such a way that the holder’s palm bridged the gap between the two metal antenna panels on the bottom left corner of the phone (as is generally...

Words: 948 - Pages: 4

Premium Essay

How to Jailbreak an Iphone

...Aug 14, 2013 * Email * Share * * If you own at least one iPhone, iPod, or iPad, then you've probably come across the curious act known as jailbreaking.  In geek terms, jailbreaking something is the process of exploiting a bug or system flaw on an iDevice to eliminate Apple-imposed restrictions and gain privileged access. In other words, you get access to resources that would be otherwise unavailable on your stock Apple product. Heck, jailbreaking even allows you to completely change the way your iDevice looks and functions and make it more like—dare we say it—an Android.   Obviously, the biggest tradeoff to any jailbreak method is that it voids your warranty from Apple, which means the company—and by extension, the store you bought your iDevice from—are no longer obliged to uphold any warranty claim, much less repair your hardware if it ends up being a very expensive paperweight.   It may also lead to performance issues, but this one's more of a consequence to pulling the trigger on apps, extensions, or themes too quickly without waiting for feedback first.   >>READ ALSO: How to turn your Windows laptop into a hotspot If all of this sounds compelling and reasonable to you, then you may want to stick around as we guide you through the process of liberating your iOS device from Apple's ironhanded constraints with the help of Evasi0n, our jailbreak software of choice. The latest version of Evasi0n is compatible with iPhone, iPod, and iPad models running...

Words: 535 - Pages: 3

Premium Essay

Ipad Market Plan

...Company Overview Val’s hand held iPad is a highly successful organization that aims to advance in technology. It will run on Apple’ The iPad features a camera, keyboard, and it has built in Wi-Fi. The iPad can shoot video, take photos and play music. Executive Summary of Market Plan In today’s society everything is going global and competitive business environment, the marketing plan of Apple’s iPad will develop a strong brand image from the initial stage. My market is a topic where an effective marketing strategy is develops to endure the global competitive market. The purpose of this new ipad will benefit everyone in the United States. This new ipad will have various apps that will be easy to function. Description of the Target Market This ipad will be sold to younger generation as well to the older generation. It will be used for business or personal use. You can create your own apps to whatever you need or want. It would not matter what kind of income you have it would be very affordable. Description of competitors The top two competitors would be Microsoft surface pro and Kindle fire Description of producr or service My product is a mini hand held ipad that will be voice activated like a iphone. It will have a app that you can create to your own life style. It will do whatever you want it to do. You will have a option to touch screen or use your voice. To run this ipad all you would have to do is go into a wifi once you get into a wifi account you can...

Words: 364 - Pages: 2

Premium Essay

Organic

...products have a growth rate of 5 times that of conventional packaged foods. -This information has led to some large chain grocers to even create their own brand of organic products. “Organic grocery products are ringing up sales growth of 15 percent a year, that is five times the growth rate of conventional packaged foods. Several major supermarket chains have begun offering their own brand of organic pasta, cookies and juice. Now, giant food processors and packagers of national brands are getting in on the organic action. Wal-Mart. the nation's largest retailer decided earlier this year to expand its organic offerings in the produce and grocery aisles across all its outlets and is doubling the number of organic items in 10 percent of its stores.” The reason why people don’t buy Organic product. -Some consumers don’t buy organic due to the higher price of the products. -Organic products can cost consumers 20%-100% more than the typical non-organic products. -It is expensive for traditional farms to be converted to organic farms. -Only 0.9% of farmland throughout the world is organic. -Organic farms produce less than traditional farms so there are less organic ingredients available to make these products. “America's appetite for organic food is so strong that supply just can't keep up with demand. Mainstream supermarkets, eyeing the success of organic retailers such as Whole Foods have rushed to meet demand. The Kroger Co., Safeway and SuperValu are among those...

Words: 293 - Pages: 2

Premium Essay

Est1 310-2-1

...profitable for the stakeholders, but also to present a positive image of social responsibility. Company Q has not demonstrated the behavior of care and concern for the community. Although Company Q has been successful in building a small grocery store chain in a large metropolitan city, if their position regarding social responsibility does not change it could prove to be detrimental to their business. The business practices that worked for Company Q in the beginning obviously did not factor in social responsibility and therefore will not sustain the company’s future growth. Company Q recently decided to close two stores in higher-crime areas of the city, reportedly because these stores were consistently losing money. Although loss revenue is certainly an area of concern, this decision did not take into consideration the negative impact the store closing would have in the community. More specifically, many residents of the community chose to shop at Company Q because the store was conveniently located in the community and these stores employ many of the local residents. The closing of these stores coupled with Company Q’s recent decision to start offering health-conscience and organic products in all of their remaining stores could raise an ethical question. Did Company Q overlook the need in the community for the purpose of a profit? Company Q has also exhibited poor judgment when asked by the local food bank for a donation of day old products. Company Q’s reasoning...

Words: 542 - Pages: 3