Linear Regression and Linear Programming Models

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 optimization model in Excel to determine the number of each type of media to use such that the number of audiences reached is maximized.

c) Perform what-if analysis for the optimization model.

d) Explain the best option and trade-offs that must be made to increase the number of audiences reached. Use the Sensitivity Report to facilitate your analysis.

Order any type of Service We Provide

We are the best assignment service that can satisfy student’s demands in different scientific fields. We perform tasks of any kind. Our specialists provide diverse custom assignment writing services to students from all over the world every day. You can contact us for assistance with:

• Essays of any type (application, scholarship, argumentative, personal, informative, persuasive, compare and contrast, narrative, analytical, cause and effect, critical, process, descriptive, expository essays);
• Homework,
• Assignments,
• Reviews of all types (for a book, an article, or a film),
• Reports,
• Annotated bibliography,
• Projects,
• Thesis,
• Term papers,
• Presentations,
• Lab works,
• Research papers,
• Speeches,
• Critical thinking,
• Capstone projects;
• Business plan;
• Coursework’s;
• Dissertations.

The list is far from complete!

Representatives of our student assignment service are connoisseurs of the peculiarities of presentation in regards to academics. Your college assignment will never turn out an untoward surprise! Whether you need research for high school, an undergraduate program, or a Master’s or Doctoral degree, you will get exactly what you are looking for to sound smart and well-informed.

If you are pressed for time, request our experts!

We are your academic saver. It is a perfect solution for people who need academic help but has no professionals nearby to provide it. Just redirect your home tasks to us and forget about any educational issues. With us, you will get 100% plagiarism-free content delivered on time by an experienced specialist in a particular field.

Main Advantages of Collaboration with Us

When you order professional assignments here, you will get:

Original custom papers. We value your academic reputation. Just as well, we value the years of thorough work on our reputation for reliability and never compromise the originality of delivered papers. We will never endanger both. Every custom assignment is written from zero – the only possible first stage of work on the order is research. We apply the latest plagiary checking tools on the final stage, so plagiarism has no chance to emerge in your college assignment writing.

Control over the order completion. To make the process of collaboration comfortable and efficient, we offer our clients to choose the writer themselves taking into account all the requirements and the budget. For you to save nerves, having entrusted your fateful task to some qualified “stranger”, we enable communication with the assigned writer in the process of order completion.

Affordable assistance. We are eager to contribute to the academic achievements of students in need of help with college assignments. We are eager to help you start investing in your career growth today. That is why our service is so affordable. We don’t charge to pay for the latest marketing tricks or advertisements – we choose the best experts in the labor market who write great custom papers in any area, level of complexity, and time frame. Our client’s grateful feedback is a top advertising trick.

On-time delivery. The quality of a paper is only valued when it is delivered within the determined time frame – you will get your custom assignment writing service in time and have a couple of days to revise it and ask for changes in case they are needed. And you will still have time to learn the material.

Protection. We value your trust and take all measures needed to keep your private and banking details safe. We offer only well-tested payment methods. Due to the system of encryption and protected servers, no third party can have access to your data.

Custom support 24/7. We do our best to make the process of collaboration comfortable for the customer. Our “write my assignment” help is always here for you to provide a solution to your problems, give you a prompt answer to any question, and offer clarification as to any issue related to the services. Feel free to contact us anytime!

If you feel that your dissatisfaction with student life is growing every day and you just feel exhausted, don’t hesitate to change the situation for the better today. Order your first assignment from reliable custom assignment services today to evaluate the advantages.

Having seen the difference once, you won’t want to go back to your previous lifestyle. You deserve to find fulfilment in other spheres of your life, have hobbies, spend time with close people but continue making progress. It is possible when you have a professional helper. Don’t put off your life for someday after graduation!

Order your paper now!