BUSINESS ANALYTICS RESEARCH PROJECT

BUSINESS ANALYTICS RESEARCH PROJECT

—
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)

Report Format: BUSINESS ANALYTICS

• PLEASE ANSWER ALL THE QUESTIONS USING THE EXCEL SAMPLE THAT I ATTACHED
• USE MAXIMUM 400 WORDS NOT INCLUDNG 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)

Instructions on How to Select a random Sample for your Assignment

In order to select a random sample for your assignment, go to the Survey Data Sheet and follow the following steps

Step 1: Select the data from Cells A2 to J647 in the “Survey Data” worksheet

Step 2: Go to Data>Sort and select Sort by “Random Number”

Make sure the “My data has headers” option located on the top right is checked before you click OK

This step will randomly change the order of the reponses. This is simple random sampling procedure you practiced in workshop 1

Step 3: Select the first 100 obseravtion as your sample

Make sure you copy your selected sample into a new spreadsheet.

To do this, select cells B1 toJ102,

Press Ctrl+C (this command will copy the selected data)

Press Ctrl+N (this command will open a new spreadsheet file)

Press Ctrl+V (this command will paste your selected sample in the new spreadsheet)

Make sure you save the new spreadsheet.

Note: Please make sure you save your data file as everytime you repeat steps 1 to 3 above you will obtain a different sample.

*You will have to submit this sample with your assignment so that your calculations are double checked.

* If you are doing this assignnent in a group, only one student should select a sample as the above process will result in a different sample

every time you follow steps 1 to 3.

Need help with selecting a sample?

See your tutor. See LMS for details of consultation hour.

Make Sure you Submit the following information with your random Sample

Tutorial Time:
Tutor Name:

Group Members Details
Student NO Student Name
Group Member 1 18471993 Christian Doneski

Group Member 2 18910487 Selin Onal
Group Member 3 18095395 Mohammed Merhi