BMG323/03: Academic Session 2024 January 2024 Semester Assignment 2, WOU, Malaysia

School

Wawasan Open University (WOU)

*We aren't endorsed by this school

Assignment Type

Subject

Date

19/02/2024

January 2024 Semester
Assignment 2

BMG 323/03
2024/T1

Question 1
Using market basket analysis, construct a combination of two purchased items into an appropriate table or matrix. Record the following:
(i) Frequency
(ii) Support
(iii) Confidence
(iv) Lift

Which of the following 3 combinations would you prioritize? Justify the reason.

Question 2

A business analyst has been tasked to study the relationship of telemarketing effectiveness. It has been hypothesized the conversion of effective sales is proportion to the number of calls. A time series study over 1 month has been conducted to evaluate the median sales and the number of calls made per day. Table 2 illustrates the result. The business analyst is required to perform a few data visualizations and use appropriate data analytics to justify the result.

a) Based on the table above, visualize the overall relationship through a Scatter Diagram Comment on the scatter diagram.
b) Describe the use of regression model in analytics modelling. Name 3 basic assumptions.
c) Using manual computation, derive a simple linear relationship. Comment on the regression model
d) Now, repeat the process with automated solution (through MS Excel)

Question 3

a) Based on the scenario above of the sales calls and the number of units sold, you will determine the confidence interval of 95% for any 25 sales call.
A new agent by the name of Jorge has just joined and made 25 calls. Determine the estimated amount of sales call.

b) In addition, it has been hypothesized that the number of experience (months) impacts on the predicted units sold.

Based on this model, remodel the relationship as Multiple regression. Use MS Excel to solve it.

Get Help By Expert

Empower your academic journey with our specialized services – the go-to destination for an online assignment helper and a trusted dissertation writing service. Malaysian students, navigating the complexities of BMG323/03 Business Analytics assignment just got easier!Simply pay our experts for tailored assistance and watch your academic challenges fade away. Say goodbye to stress and hello to success as our team provides reliable support customized to your needs.

UP TO 15 % DISCOUNT

Instant Paper Writing Services by Native Malaysia Writers

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now
Convincing Features
Plagiarism Free Report
On-Time Delivery
Native Writers
A+ Quality
100% Confidential
24*7 Online Assistance