walmartpsp

Admin’s Target

By:

Ammara Farooq

Grayson Ricafort

Esmeralda Ramirez

Josiah Orozco

Alyssa Becerra

Denisse Ramos Talavera

Descriptive Statistics

The Average Shipping cost to ship a product on truck is 28.758, while on air it is 8.571.

This will let the company know that shipping through truck is more expensive. Shipment through air is far more reliable as noted in the pie chart. This is a possibility to decrease spending and increase revenue.

Average Shipping: 14.7908

Mean Shipping Cost:

6.18

Average Product Base Margin:

0.4918

Mean Product Base Margin:

0.5

Total Averages

median target PSP$5.79
average target PSP$7.22
median walmart PSP$5.79
average walmart PSP$7.14
The Average Discount percent of all Products5

Comparing Target and Walmart Sales Prices

Both companies almost have the same prices.

Olay Regenerist Moisturizer, Hellmann’s Real Mayonnaise, and Folgers Classic Roast are the only ones with slight price differences.

4

Product sale price

Wal-Mart Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 6.97 2.0 1.77 2.97 4.97 2.25 5.79 3.96 11.27 27.47 6.98 8.96 7.47 Target Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 9.49 2.04 1.99 4.49 4.99 2.29 5.79 4.99 11.39 22.99 6.99 8.99 7.49

Products

Prices

Positive Correlation

2011 prices vs. Present prices

There is a perfect positive correlation

Correlation Coefficient r= 0.9885946 which is near 1, which makes the correlation almost the same.

Correlation bewteen walmart prices and walmart 2011 prices

Wal-Mart Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 6.97 2.0 1.77 2.97 4.97 2.25 5.79 3.96 11.27 27.47 6.98 8.96 7.47 Wal-Mart (2011) Folgers Classic Roast Hamburger Helper Frenchs Mustard Hellmanns Real Mayonnaise Kraft Miracle Whip Pringles Listerine Cool Mint Pantene Color Reserve Volume Shampoo Aveeno Active Naturals Daily Mositurizing Lotion Olay Regenerist Moisturizer Fancy Feast Wet Cat Food Gourmet Entree Nice n Easy Haircolor Cover Girl Lash Blast Volume Mascara 9.47 2.67 2.17 3.97 4.37 1.67 4.99 4.96 11.27 32.97 7.48 7.78 7.47

Products

Prices

Product Correlation

Sales vs. Discounts

There is NO apparent correlation between product Sales and the Discount.

r= 0.0742363, which is near 0, meaning that there is no correlation.244.57 124.56 905.08 716.8399999999999 10123.02 228.41 146.69 394.27 261.54 196.85 93.54 2781.82 4965.7595 7.000000000000001 1.0 5.0 8.0 4.0 8.0 1.0 0.0 9.0 3.0 4.0 7.000000000000001 7.000000000000001

Product sales

Discount

Relative Frequency

There is NO association between Ship Mode and Product Container.

About eduhawks

Check Also

what is the heat of combustion of ethane, c2h6, in kilojoules per mole of ethane?

(Another) Physics Homework Help? The two blocks in the figure are sliding down the incline. …