BUSINESS ANALYTICS RESEARCH PROJECT ( USE THE EXCEL FILE TO GET YOUR ANSWERS)

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% in" rel="nofollow">interval estimates for each of the above. Show the confidence in" rel="nofollow">intervals graphically and in" rel="nofollow">interpret your results. (7 marks) 8. Provide poin" rel="nofollow">int and 95% confidence in" rel="nofollow">interval estimates for the weight of tuna cans, show it graphically and in" rel="nofollow">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 in" rel="nofollow">involved in" rel="nofollow">in hypothesis testin" rel="nofollow">ing. ( 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 in" rel="nofollow">involved in" rel="nofollow">in hypothesis testin" rel="nofollow">ing. (8 marks)