Question: I HAVE AN EXCEL SHEET FOR THE DATA. THE DATA IS GIVEN BELOW. GENDER PACK PRICE CART MADE 1 1 13.00 1 1 1 1
I HAVE AN EXCEL SHEET FOR THE DATA.
THE DATA IS GIVEN BELOW.
| GENDER | PACK | PRICE | CART | MADE |
| 1 | 1 | 13.00 | 1 | 1 |
| 1 | 1 | 10.50 | 1 | 2 |
| 1 | 1 | 12.00 | 1 | 1 |
| 1 | 1 | 12.00 | 1 | 1 |
| 1 | 1 | 6.80 | 1 | 2 |
| 1 | 1 | 7.00 | 1 | 2 |
| 1 | 1 | 3.50 | 1 | 3 |
| 1 | 1 | 13.60 | 1 | 1 |
| 1 | 1 | 12.50 | 1 | 2 |
| 1 | 1 | 13.50 | 1 | 1 |
| 1 | 1 | 13.00 | 1 | 1 |
| 1 | 1 | 15.00 | 2 | 1 |
| 1 | 1 | 16.00 | 2 | 1 |
| 1 | 1 | 12.00 | 2 | 2 |
| 1 | 1 | 14.00 | 2 | 1 |
| 1 | 1 | 15.00 | 2 | 1 |
| 1 | 1 | 10.00 | 2 | 2 |
| 1 | 1 | 10.00 | 2 | 2 |
| 1 | 1 | 6.50 | 2 | 2 |
| 1 | 1 | 10.00 | 2 | 2 |
| 1 | 1 | 3.50 | 2 | 3 |
| 1 | 1 | 4.00 | 2 | 3 |
| 1 | 1 | 8.00 | 2 | 2 |
| 1 | 1 | 9.00 | 2 | 2 |
| 1 | 1 | 12.90 | 2 | 2 |
| 1 | 1 | 9.80 | 3 | 2 |
| 1 | 1 | 12.00 | 3 | 2 |
| 1 | 1 | 8.00 | 3 | 3 |
| 1 | 1 | 12.00 | 3 | 1 |
| 1 | 1 | 11.00 | 3 | 2 |
| 1 | 1 | 10.50 | 3 | 2 |
| 1 | 1 | 9.00 | 3 | 2 |
| 1 | 1 | 8.50 | 3 | 2 |
| 1 | 1 | 7.00 | 3 | 2 |
| 1 | 2 | 2.30 | 1 | 3 |
| 1 | 2 | 8.00 | 1 | 2 |
| 1 | 2 | 1.90 | 1 | 3 |
| 2 | 2 | 1.20 | 1 | 3 |
| 2 | 2 | 6.50 | 1 | 3 |
| 2 | 2 | 6.00 | 1 | 2 |
| 1 | 2 | 3.50 | 2 | 3 |
| 1 | 2 | 2.50 | 2 | 3 |
| 1 | 2 | 7.00 | 2 | 2 |
| 1 | 2 | 2.50 | 2 | 3 |
| 1 | 2 | 1.30 | 2 | 3 |
| 1 | 2 | 1.10 | 2 | 3 |
| 1 | 2 | 2.30 | 2 | 3 |
| 1 | 2 | 4.50 | 2 | 3 |
| 1 | 2 | 2.00 | 2 | 3 |
| 1 | 2 | 3.00 | 2 | 3 |
| 1 | 2 | 3.00 | 2 | 3 |
| 2 | 2 | 3.50 | 2 | 3 |
| 2 | 2 | 2.90 | 2 | 3 |
| 2 | 2 | 6.80 | 2 | 2 |
| 2 | 2 | 7.90 | 2 | 3 |
| 2 | 2 | 8.90 | 2 | 2 |
| 2 | 2 | 3.00 | 2 | 3 |
| 2 | 2 | 2.00 | 2 | 3 |
| 2 | 2 | 8.00 | 2 | 2 |
| 2 | 2 | 6.00 | 2 | 3 |
| 1 | 2 | 2.50 | 3 | 3 |
| 1 | 2 | 2.00 | 3 | 3 |
| 1 | 2 | 6.00 | 3 | 3 |
| 1 | 2 | 6.50 | 3 | 3 |
| 1 | 2 | 3.50 | 3 | 3 |
| 1 | 2 | 2.60 | 3 | 3 |
| 2 | 2 | 9.50 | 3 | 2 |
| 2 | 2 | 9.00 | 3 | 2 |
| 1 | 2 | 1.90 | 1 | 3 |
| 1 | 2 | 2.10 | 1 | 3 |
| 1 | 2 | 2.00 | 1 | 3 |
| 1 | 2 | 3.50 | 1 | 3 |
| 1 | 2 | 3.50 | 1 | 3 |
| 1 | 3 | 3.00 | 1 | 3 |
| 1 | 3 | 2.90 | 1 | 3 |
| 1 | 3 | 2.30 | 1 | 3 |
| 2 | 3 | 1.50 | 1 | 3 |
| 2 | 3 | 3.50 | 1 | 3 |
| 1 | 3 | 3.20 | 2 | 3 |
| 1 | 3 | 2.20 | 2 | 3 |
| 1 | 3 | 1.90 | 2 | 3 |
| 2 | 3 | 9.00 | 2 | 3 |
| 1 | 3 | 1.90 | 1 | 3 |
A market leading Australian manufacturer of sanitary products is keen to develop new products so that the company can expand into Asian markets. Its Research and Development department has prepared a proposal to work on a new product line of razor blades. Assume you work as a data analyst for this company and you have been asked to investigate the market for shaving products. You have been asked to study the characteristics of currently available razor blades so the company will be in a better position to price its proposed new product. You have collected data for 83 products on the market. The data is in the excel file, named 'Razors'. Column 1: GENDER 1 for Female product and 2 for Male product Column 2: PACK Number of blades in a packet, 1 for 5-pack and 2 for 10-pack Column 3: PRICE Price of the product in Australian dollars for a packet Column 4: CART Number of cartridge blades, 1 for twin, 2 for 3-blade and 3 for 5-blade Column 5: MADE 1 made in France, 2 made in USA, 3 other countries QUESTIONS 1. Calculate descriptive statistics and visually present data for the prices of male and female products. What conclusions can you draw from your analysis by commenting on the location, shape and variability of those distributions. 2. Calculate descriptive statistics and visually present data prices for twin, 3-blade and 5- blade cartridges. What conclusions can you draw from your analysis by commenting on the location, shape and variability of those distributions. 3. Calculate descriptive statistics and visually present data for different countries. What conclusions can you draw from your analysis by commenting on the location, shape and variability of those distributions.
Step by Step Solution
3.50 Rating (163 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help