Determine the correlation between space and inventory with sales Create a boxplo

Question

Determine the correlation between space and inventory with sales

Create a boxplot of sales in each region and determine if there is a statistical difference between sales in any two of the regions (use 95% confidence level)

Test the hypothesis that Margin Percentage (Margin divided by Sales) is greater in the East region than the South

Store Space-Sqft Region Average Inventory Total Sales Margin 376063 50758951 812296 4230 East 2 3576 North 338339 6191604 2290893 3 3860 East 323626 4142413 1532693 4 2995 West 276610 4287455 514495 5 4335 West 249242 2666889 1066756 6 3784 South 287348 3045889 822390 7 3986 North 368888 4758655 2093808 8 3243 West 387473 5385875 592446 9 2125 North 343510 5427458 2496631 10 2825 South 300619 4689656 703448 11 4283 South 229831 3079735 923921 12 2446 West 229738 4342048 1128933 13 2421 East 322458 3772759 1169555 14 2463 West 3089068 4789004 2298722 3910 East 15 373175 4216878 1518076

Explanation / Answer

A) Correlations:

b) P-value for comparison between east & south sales is 0.14>0.05 we cant reject H0; so no significnat differnce between these 2.

excel formula:

we used 2 sample t-test.

SpacesSgft Average Inventor, Total Sales Margin SpacesSgft 1 Average Inventor, -0.2209337 1 Total Sales -0.4411318 0.72262568 1 Margin -0.3086135 0.42254071 0.47523669 1

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.