1. Calculate at least 2 measures of central tendency and at least 2 measures of variation for
2. your Continuous Variable sample data. Explain the results and meaning of these measures in your report. Include a summary of the data in your report using a graph or table. Use Excel for this task.
3. Describe what is a Discrete Probability Distribution. Identify/develop a Discrete Random Variable in your dataset. Use an appropriate Discrete Probability Distribution you have learnt in class to illustrate how you could apply these technique to solve your business problems.
4. Inferential Statistics
5. a.You may want to include some theoretical background to the Normal (and Sampling)
6. Distribution. Topics could include:
7. What is the Normal Distribution?
8. Why is the Normal Distribution used in Sampling Distributions?
9. What is the basis for Inferential Statistics?
10. b.You should include:
11. An explanation of your continuous random variable and sampling work
12. An explanation of what a Confidence Interval / Hypothesis Test is;
13. An interpretation of your Confidence Interval/ Hypothesis Test results;
14. c. Either do 3c.i OR 3c.ii
15. i. Calculate and interpret a confidence interval estimate of an appropriate
16. Continuous Random Variable from your dataset. Choose 95% confidence level
17. for your interval. (OR)
18. ii. Set up and conduct a hypothesis test relevant to the continuous random variable.
19. Choose 5% significance level for your test. Identify what is your Type I and II
20. errors.
21. By using the Data Analysis function in Excel, show how Regression techniques can be
22. used to extrapolate or interpolate values for your dependent variable. Include the Regression Analysis Excel output and state your predictive model. Test one of the four assumptions.

90%v T View Zoom Insert Table Chart Text Shape Comment Collaborate Format Sort & Filter Instructions Food_Dairy CallCentre SportsMgt Music Retail CoffeeShop Butcher Tourism 5 Service Cancellation Note: Table 1 shows the number of calls in the sample hour per staff member plus the proportion of unresolved calls for that mem Table 1: Number of calls answered in sample hour Proportion Staff Id unresolved Mon Wed Thur Fri Sat Sun an C011 0 12 10 0.04 C012 10 0.1 024 0.2 CO27 10 C028 10 0. 1 0.1 C03 C031 0.08 0.0 |C032 C042 0.12 0.05 C049 0.01 C050 0.0. 0. 14 0.07 0.07 0.02 0.02 0.0 0.0 0.0 0.1 Nothing selected. 0.07 Select an object to format. DO19 |DO20 DO35 DO43 013 w . . 0.07 D22 329 0.08 0.04 0.01 0. 16 GO2 0.07 0. 18 G030 03 0. 15 G044 0.02 G16 G18 G37 0.08 G39 0.07 wowios 0. 1 0.08 G40 0.0 G45 0.01 G48 10 0.09 G7 Note: lable 2 shows the call duration for each of the 10 sample calls per staff member 2: Sample ple call duration (minutes) Staff Id