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.  

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

850 words Book: Social Policy and Social Programs Read Chapter

850 words  Book: Social Policy and Social Programs  Read Chapter 2, “An Overview of Social Policy Analysis: A Critical Value Approach,” pages 29–39 Assignment Overview According to Chambers and Bonk (2013), social policies and programs are meant to serve categories or groups of people rather than individuals. Social workers must

Criteria for answers: 1) Direct reference to the chapter’s laws/regulations

  Criteria for answers: 1) Direct reference to the chapter’s laws/regulations (Employment Laws, Case Law, Statutes)  2) Direct reference to the chapter’s concepts (discrimination, ethics, social responsibility)  3) Quotes from the text.  4) Personal opinions based on an analysis of the above. 5) Each answer should be a paragraph (or

Create a two-page document that evaluates the impact of application

Create a two-page document that evaluates the impact of application portfolio management.  Identify benefits that an organization can find using this methodology.   Your submission must have a title and reference page that does not count towards your one-page minimum.  Use at least two scholarly resources, do not use Wikipedia

In an effort to reduce the high costs of health

In an effort to reduce the high costs of health care, health care executives, physicians, and clinical staff establish guidelines to minimize the rates of readmissions for patients. While certain medical conditions may require that patients are readmitted into health care organizations, for less urgent or extensive medical conditions, ensuring

For this week’s journal: Read/watch two of the resources linked

  For this week’s journal: Read/watch two of the resources linked near the bottom of this week’s Moodle section (I encourage you to choose two that are from different categories), and answer the following in a Word document uploaded to this assignment:  The Far Right and Far Left Agree on

250 words with at least one reference suggest one way

250 words with at least one reference suggest one way in which sports are a microcosm of society. Justify your  position and relate it to your background. Consider integrating  sociological concepts and theories of society into your initial  response. Use specific examples from the reading and other resources to  support

Assignment #3 Problem #1 Farm Fresh Produce Co. sells produce

  Assignment #3 Problem #1 Farm Fresh Produce Co. sells produce wholesale to local groceries on account. The accounts receivable department had the following information on December 31, 2009: Total Credit sales $400,000.00 Balance of allowance for doubtful accounts ($950.00) Bad debt as a percentage of credit sales 0.50% Days

Methadone has a more than 30-year history of use in

 Methadone has a more than 30-year history of use in the treatment of opioid addiction. By blocking cravings and withdrawal symptoms without making people high, it reduces illicit drug use. Many individuals on methadone maintenance are able to live successful and productive lives. However, some oppose methadone treatment, arguing that

Wellness Education Program

 Develop a 5–7-page paper for a wellness education program for a specific population. Integrate aspects of culture, CAM and spirituality, and linguistics into the program. Explain how to market the program to the population, and explain the ethical, legal, and economic factors that can affect the health of the population.

Discuss the underlying assumptions and potential ramifications of having proxy

Discuss  the underlying assumptions and potential ramifications of having proxy subjective health status or evaluation measures for children or those unable to speak for themselves. 450 words. APA 7th edition. 2 references within 5 years. WITH THIS ASSIGNMENT TWO (2) DIFFERENT DISCUSSION POST REPLIES ARE ALSO REQUESTED. 200 WORDS WITH

MUST BE APA FORMAT , WITH AT LEAST 5 SCHOLARLY

MUST BE APA FORMAT , WITH AT LEAST 5 SCHOLARLY SOURCES (PLEASE MAKE SURE YOU USE THE CHAPTER ATTACHED AS YOUR MAIN SOURCE) For this Discussion, interact in a free-flowing discussion of the  biblical and constitutional parameters for the particular policy focus  being discussed this module. In other words, you

Step-3 of McCollum’s Model of Mental Health Education is “Goal

   Step-3 of McCollum’s Model of Mental Health Education is “Goal Setting” to identify short-term or long-term goals for changes in knowledge, beliefs, attitudes, and behaviors.  Module 4 provided several theories, models, and constructs for stress and coping.  For this assignment, you are asked to apply stress and coping theory to

After completing your assigned readings for this week, answer one

  After completing your assigned readings for this week, answer one of the following questions from chapter 175 in your Hospital Medicine textbook. 1.        What types of biopsies can aid in the diagnostic workup of cancer? 2.        How is the cancer stage determined? 3.        What are the goals of therapy in the neoadjuvant,

Promoting Evidence-Based Practice In recent years, the implementation of evidence-based

Promoting Evidence-Based Practice In recent years, the implementation of evidence-based practice has been identified as a priority across nearly every nursing specialty (Prevost & Ford, 2020). In addition, nurses are increasingly accepted as essential members and often as leaders, of the interdisciplinary health-care teams. To effectively participate and lead a

Discussion #10: The Struggle for Civil Rights Throughout the 1950s

Discussion #10: The Struggle for Civil Rights Throughout the 1950s African Americans in northern cities grew increasingly active in opposing discrimination and in protesting white resistance to black progress in housing, education, and employment. Martin Luther King and others embarked on a campaign of nonviolent resistance and demonstrations, which spread