I’m writing a business report for my predictive and prescriptive analytics module and I need help with doing the linear regression and linear programming models. Please download the excel file and follow the steps outlined below. I would really appreciate it if you could attach the completed models (updated excel file) and explain step by step how you achieved this (separate word doc). All explanations and answers will be used to help me learn.
1. Predictive Analytics Task
To help a company improve their brand recognition and optimise the impact of their social media posts, the company would like to know which characteristics of the post impacts the social media activity the most (See Excel Dataset: Social Media Metrics).
a) Develop a linear regression model in R for each of the social media metric of your choice (minimum 3).
b) Identify the post characteristics that are relevant in predicting the performance of the social media metrics
c) Provide further analysis to show how each relevant feature influenced the performance of the social media metrics
2. Prescriptive Analytics Task
To attract more customers, the company had identified four advertisement media to advertise their products (See Excel Dataset: Advertising Media). To ensure a balanced use of advertisement media, TV advertisement must not exceed 50% of the total number of advertisements, flyer and radio must not exceed 10% of the total number of advertisements. In addition, there should be at least 10 online advertisements. The advertising budget is £190,000.
a) Apply prescriptive analytics to recommend the best possible option. State any assumptions that you have made.
b) Develop and solve a linear optimisation model in Excel to determine the number of each type of media to use such that the number of audiences reached is maximised.
c) Perform what-if analysis for the optimisation model.
d) Explain the best option and trade-offs that must be made to increase the numbers of audience reached. Use the Sensitivity Report to facilitate your analysis.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more