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 As 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 Bs 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)