create a 12 slide ppt on Topic 5-Product Prices Key Research Question: What is the typical market price of a product, and how do prices differ across competing brands? Select one product category only, such as smartphones, laptops, headphones, running shoes, cosmetics or household appliances. Preferably collect 30 or more observations. Record product/model, brand and price. Calculate Mean, Median and Mode where meaningful. Prepare a frequency distribution and visualisation. Discuss typical price and most frequent price/range. Explain implications for pricing, positioning and competition. 2. Important Guidelines for Students Preferably use at least 30 observations; larger datasets are encouraged. Use real data wherever possible: credible secondary data, public datasets, company/industry data or student-collected survey data. If primary data are used, clearly state the sample and method of data collection. Do not turn the presentation into a theoretical explanation of Mean, Median and Mode. Follow: Business Problem → Data Statistical Analysis → Interpretation → Business Conclusion. Interpret every numerical result; do not merely display calculations. Use Microsoft Excel for data organisation, calculations, frequency tables and graphs. Give every graph a clear title, labelled axes and a brief interpretation. Graphs should be selected according to the nature of the data. 3. Questions Students Should Be Prepared to Answer 1. Where did you obtain the data? 2. Why did you select this dataset? 3. How many observations are there? 4. What variables have you considered? 5. How did you classify the data? 6. Why did you choose this particular graph? 7. What does the frequency distribution show? 8. What is the arithmetic mean? 9. What is the median? 10. What is the mode? 11. Why are the three values different? 12. Which measure is most representative, and why? 13. What does your result mean for a business? < QAM103_Business_Statisti ... Interpretation→ Business Conclusion. Interpret every numerical result; do not merely display calculations. Use Microsoft Excel for data organisation, calculations, frequency tables and graphs. Give every graph a clear title, labelled axes and a brief interpretation. Graphs should be selected according to the nature of the data. 3. Questions Students Should Be Prepared to Answer 1. Where did you obtain the data? 2. Why did you select this dataset? 3. How many observations are there? 4. What variables have you considered? 5. How did you classify the data? 6. Why did you choose this particular graph? 7. What does the frequency distribution show? 8. What is the arithmetic mean? 9. What is the median? 10. What is the mode? 11. Why are the three values different? 12. Which measure is most representative, and why? 13. What does your result mean for a business? 14. What decision could a manager make based on your findings? And the product should be fragrance And use ₹ for currency Indian
create a 12 slide ppt on Topic 5-Product Prices
Key Research Question: What is the typical market price of a product, and how do prices differ across competing brands?
Select one product category only, such as smartphones, laptops, headphones, running shoes, cosmetics or household appliances.
Preferably collect 30 or more observations.
Record product/model, brand and price.
Calculate Mean, Median and Mode where meaningful.
Prepare a frequency distribution and visualisation.
Discuss typical price and most frequent price/range.
Explain implications for pricing, positioning and competition.
2. Important Guidelines for Students
Preferably use at least 30 observations; larger datasets are encouraged.
Use real data wherever possible: credible secondary data, public datasets, company/industry data or student-collected survey data.
If primary data are used, clearly state the sample and method of data collection.
Do not turn the presentation into a theoretical explanation of Mean, Median and Mode.
Follow: Business Problem → Data Statistical Analysis → Interpretation → Business Conclusion.
Interpret every numerical result; do not merely display calculations.
Use Microsoft Excel for data organisation, calculations, frequency tables and graphs.
Give every graph a clear title, labelled axes and a brief interpretation.
Graphs should be selected according to the nature of the data.
3. Questions Students Should Be Prepared to Answer
1. Where did you obtain the data?
2. Why did you select this dataset?
3. How many observations are there?
4. What variables have you considered?
5. How did you classify the data?
6. Why did you choose this particular graph?
7. What does the frequency distribution show?
8. What is the arithmetic mean?
9. What is the median?
10. What is the mode?
11. Why are the three values different?
12. Which measure is most representative, and why?
13. What does your result mean for a business?
<
QAM103_Business_Statisti
...
Interpretation→
Business Conclusion.
Interpret every numerical result; do not merely display calculations.
Use Microsoft Excel for data organisation, calculations, frequency tables and graphs.
Give every graph a clear title, labelled axes and a brief interpretation.
Graphs should be selected according to the nature of the data.
3. Questions Students Should Be Prepared to Answer
1. Where did you obtain the data?
2. Why did you select this dataset?
3. How many observations are there?
4. What variables have you considered?
5. How did you classify the data?
6. Why did you choose this particular graph?
7. What does the frequency distribution show?
8. What is the arithmetic mean?
9. What is the median?
10. What is the mode?
11. Why are the three values different?
12. Which measure is most representative, and why?
13. What does your result mean for a business?
14. What decision could a manager make based on your findings?
And the product should be fragrance
And use ₹ for currency Indian
Created using ChatSlide
This project explores the fragrance market in India by analysing a dataset of over 30 perfumes from various brands. It begins with defining typical fragrance prices and comparing key attributes such as model, brand, size, and price. Statistical analysis follows, calculating mean, median, and mode, while creating price bands and frequency tables. Visual evidence is presented through histograms and brand comparison charts. Finally, the project interprets the findings to explain price ranges,...