Need help? We are here

# An excel workbook of statistical analysis has already been created

An excel workbook of statistical analysis has already been created from a dataset. Answering the following questions based on the analysis conducted. Write down your observation and interpretation

Background:

The dataset records the sales revenue and its marketing spending on each marketing channel from January 2013 to December 2014. The dataset has 105 rows and 16 columns.

Explanation of some columns:

Holiday: 1 means holiday, 0 means non-holiday.

PROMOTION: the scale of promotion

SP: ad spending or cost that used in each marketing channel, e.g. TV, email, paid search, online display, product search.

IMP: the total number of exposures that the ad is viewed by a visitor, or displayed on a web page in each marketing channel.

Assignment

1. What’s the correlation between each ‘IMP'(impression) and ‘SP’.

2. How’s the trend of sales over the months?

3. According to visualization between each ‘IMP’ and ‘SP’. How’s the trend of each ‘IMP’ and ‘SP’?

4. Check the segmentation of ‘AVERAGE_PRICE’ and ‘MEDIA_SPEND_of_competitor’ for ‘Holiday’. Does ‘MEDIA_SPEND_of_competitor’ have an impact on ‘AVERAGE_PRICE’?

5. Check the segmentation of ‘Sales’ on each ‘PROMOTION’. Does ‘PROMOTION’ boost ‘Sales’?

6. Check the coefficient for ‘IMP’ and ‘SP’ linear regression model. Summarize the output of the linear regression model, e.g. p-value, r square. What are the indications from these values?

7. What is the marketing mix modeling method? ROI (Return of Investment) of each marketing channel is calculated from this method. How do you interpret contributions to the sales for each marketing channel based on each ROI?

Requirement:

Must include an introduction and conclusion about relationships between business knowledge, statistical modeling method, and how important data visualization skills are used, such as analyzing the sales data from an online store.

3 pages

At least 3 references. The cover page and reference page/s are not included in the above-stated page requirement.

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Security awareness training is often the first view a typical

Security awareness training is often the first view a typical user has into information security. It’s often required for all new hires. Think of

### In this course learners are introduced to business statistics and the need for quantitative analysis in business basic procedures in

In this course, learners are introduced to business statistics and the need for quantitative analysis in business, basic procedures in problem-solving, and the sources and

Q1: A) Describe your topic of your article from RES 7011.  B) After reviewing McGregor (2018), particularly tables 8.2 and 8.3, and using Goodson exercise

### 1. Within the Discussion Board area, write 600–800 words on

1. Within the Discussion Board area, write 600–800 words on each that respond to the following questions with your thoughts, ideas, and comments. This

### Developing an Investigation Plan Scenario Read the case to completethis assignment. A child was playing in a local park with

Developing an Investigation PlanScenarioRead the case to completethis assignment.A child was playing in a local park with his brother. A car pulled up as they

### Choose one of the following questions for your discussion: 1)

Choose one of the following questions for your discussion: 1) Should offenders who have had a history of victimization be treated differently by the

### 250 words book: Applied Human Behavior in the Social Environment

250 words book: Applied Human Behavior in the Social Environment  Chapter 14, “Family Influences on Human Behavior.”       This chapter provides a description of the five

### Support your response with evidence and references from outside resources.

Week 6 Assignment: http://cdnfiles.laureate.net/2dett4d/Walden/NURS/6521/05/mm/decision_trees/week_07/index.html By Day 7 of Week 8 Write a 1- to 2-page summary paper that addresses the following: Briefly summarize the

### Reflect on the teaching principles and practices discussed during the

Reflect on the teaching principles and practices discussed during the course. What did you learn about teaching that you did not know prior to

### Step 1: Innovations in Biology and Technology – Finding Information

Step 1: Innovations in Biology and Technology – Finding Information Sources and Outline (1%)  Choose one of the provided topics (see list below, a-e).  Search

*****PLEASE, PLEASE, PLEASE read the INSTRUCTIONS*****OBJECTIVEIdentify social entrepreneurs in the entertainment industry.Examine the role of social entrepreneurs and the benefits provided to society.What is a

### 1. Research paper: The scalability and efficacy of existing analytics techniques being applied to bigdata must be empirically

1. Research paper:The scalability and efficacy of existing analytics techniques being applied to bigdata must be empirically examined.Your paper should meet the following requirements:• Be

New questions

### Discern leadership approaches that facilitate achievement of health outcomes through interprofessional collaborative practice within micro-, meso-, and macro-level systems.

Reflect upon the learning that you have accomplished throughout the previous weeks, and assess your achievement of each of the five course outcomes. CO 1:

### In 200-250 words, respond to the following: Should the     physician allow Mike to continue making decisions that seem to him     to be irrational and harmful to James, or would that mean a     disrespect of a patient's autonomy?

ASSIGNMENT 1 In addition to the topic study materials, use the chart you completed   and questions you answered in the Topic 3 about “Case Study:

### The purposes of this assignment you will identify a problem or concern in your community, organization, etc. that has the capacity to be legislated.

As you have discovered through this course, nurses are influential members of the community and the political system. Therefore, for the purposes of this assignment

### Identify      the sample population. Analyze and critique the study to identify if sampling      method reflects ethical principles including consent, conditions of the      participants, study approved by IRB,

1. Prepare for Final Paper Topic: Ethical Conduct of Research (Outcomes 1,6): 20 hours Select a healthcare related research study. Identify      the sample population. Analyze and critique

### Write a brief description of the situation you experienced and explain how incorporating or not incorporating patient preferences and values impacted the outcome of their treatment plan.

ASSIGNMENT 1 Write a brief description of the situation you experienced and explain how incorporating or not incorporating patient preferences and values impacted the outcome