Excel Question

You are supposed to develop a case study for a real time business application (any domain of your choice), using secondary data from any reliable source (Specify the source of data) and address the following requirements initiated as part of your Business Statistics course.

Hint for Case Study formulation: Title Abstract of case Introduction …………. Conclusion Minimum 3 questions Reference section Appendix for data, or other information Case Discussion and answers for the questions to be at the end (Need to use statistical analysis methods right from central tendency, dispersion, probability (if relevant), and hypothesis testing for discussing your case)

1. Formulate a frequency distribution table using MS-Excel and show graphical representation of the data in any form.

2. Assess characteristics of the data collected for study using measures of central tendency. Justify with your interpretation of result, the best measure of central tendency.

3. Analyse dispersion or variability pattern of the data set using a measure of dispersion and infer your analysis.

4. Analyse problem of the case with hypothesis testing and infer your results