Order Description
Report Format: BUSINESS ANALYTICS

� PLEASE ANSWER ALL THE QUESTIONS USING THE EXCEL SAMPLE THAT I ATTACHED
� USE MAXIMUM 400 WORDS NOT INCLUDING THE GRAPHS, DIAGRAMS AND TABLES !!
� PLEASE ADD ALL THE TABLES DIAGRAMS NEEDED
� PLEASE USE ALL THE FORMALAS AND SHOW ALL THE WORKING OUTS!!
� MAKE SURE YOU GIVE YOUR ANSWERS BASED ON THE EXCEL FILE I ATTACHED AND PLEASE INCLUDE ALL THE DIAGRAMS, GRAPHS, TABLES NEEDED ANS MAK SURE YOU USE THE RIGHT FORMULAS AND READ THE QUESTIONS CAREFULLY!
� PLEASE USE THE Z TABLE AND T TABLE AND ALL THE TABLES YOU NEED TO FIND THE ANSWERS AND SHOW ALL THE WORKING OUTS!!

Section C: Advance scenarios (30 marks)
7. Suppose, you randomly selected a customer. How likely is it that the customer will purchase
i. brand A
ii. brand B
Provide 95% interval estimates for each of the above. Show the confidence intervals graphically and interpret your results. (7 marks)
8. Provide point and 95% confidence interval estimates for the weight of tuna cans, show it graphically and interpret your results. (7 marks)
ANSWER:
9. Suppose brand A�s producer claimed that the average weight of their products is 100gm. Test validity of this claim at 5% level of significance. Clearly show steps involved in hypothesis testing. ( 8 marks)
HO: �= 100
HA: � ? 100
? IS KNOWN
T=
�-�
S?N
10) Suppose brand B�s producer claimed that less than 20% of their cans are under-filled. Test validity of this claim at 5% level of significance. Clearly show steps involved in hypothesis testing. (8 marks)