Analyze data from an advertising image

Assignment Help Marketing Management
Reference no: EM131029562

Individual Assignment: Analyze an A/B Test

Introduction - For this assignment, you are to analyze data from an advertising image "pretest" conducted on Amazon Mechanical Turk (mturk.com).

Overview - Dulcet, a relatively new perfume brand wanted to know which image to use for a new campaign. The firm decided to test five different advertising images (listed below) to assess how consumer sentiment and get a sense of what might be more versus less effective. Many fragrances tend to promote feelings of confidence and sexiness, and Dulcet is no exception, however, the brand manager for Dulcet is unsure how far to push the envelope and is debating using more wholesome images versus more risqué images in the campaign. You have been tasked to help advise the brand manager with this decision.

Below are ad images from the pretest.Additionally, you will receive an Excel data file with responses from the "pretest" along with a copy of the questionnaire (Word doc). You will use these files to answer questions and develop insights. You will turn in responses to questions in this Word doc and the Excel file (showing the analyses and calculations reported in your responses in this document). You do not need to submit the questionnaire file, as this document will be unchanged.

Step 1: Research Design

Discuss whether a "pretest" was the best approach for the problem. Indicate whether you feel Dulcet was correct in selecting a "pretest" or if a "live" A/B test would have been more effective and provide support for this selection.

Step 2: Data Cleaning

Dulcet is interested in the opinions of women for this campaign. The A/B testing asked explicitly for women participants, however, some men completed the study. You need to eliminate the men from the data set prior to analysis.List the ResponseIDs below for the records you deleted from the data set prior to analysis.

You will also need to perform a calculation to transform height and weight into inches and then to calculate BMI. You should eliminate (replace with a ".") any height/weight responses that are outside of normal expected ranges (you must define this).

Write a short summary of what responses were affected and in what way (using ResponseID) to index any changes or adjustments you made.

Step 3: Descriptive Statistics

Using the cleaned data set, provide the mean value for each item in the tables below.

For BMI (table 2), you will need to calculate this separately. It is not provided for you in the data.

Table 1

AD/DV

ADRATE

ATTRCTV

SEXY

CLASSY

UNREAL

RECOG.

AD 1

 

 

 

 

 

 

AD 2

 

 

 

 

 

 

AD 3

 

 

 

 

 

 

AD 4

 

 

 

 

 

 

AD 5

 

 

 

 

 

 

Table 2

VARIABLE

MEAN

MEDIAN

MIN

MAX

AGE

 

 

 

 

GENDER

 

 

 

 

HEIGHT

 

 

 

 

WEIGHT

 

 

 

 

BMI

 

 

 

 

Step 4: Deeper Analysis

Dulcet is primarily targeted toward younger, single women. Define an age range you feel is appropriate, and then test each ad according to how single versus not single women respond. (Note: you will need to recode the data to perform this analysis). List the total number of observations (respondents) for each ad in the column "N" in the table.

Single

AD/DV

N

ADRATE

ATTRCTV

SEXY

CLASSY

UNREAL

RECOG.

AD 1

 

 

 

 

 

 

 

AD 2

 

 

 

 

 

 

 

AD 3

 

 

 

 

 

 

 

AD 4

 

 

 

 

 

 

 

AD 5

 

 

 

 

 

 

 

Not Single

 

N

ADRATE

ATTRCTV

SEXY

CLASSY

UNREAL

RECOG.

AD 1

 

 

 

 

 

 

 

AD 2

 

 

 

 

 

 

 

AD 3

 

 

 

 

 

 

 

AD 4

 

 

 

 

 

 

 

AD 5

 

 

 

 

 

 

 

Step 5: Recommendation

Make a recommendation on which ad Dulcet should use for it's target market and explain why. I would like for you to base your answer on the data (not your personal opinion). However, you do not need to conduct any statistical tests. It is fine to say Ad X was rated the highest in dimension A, or Ad Y was highly rated among dimensions A and B, or Ad Z had the best combined score along some metric you define. That said, I will award up to 5 bonus points for answers that appropriately uses statistical analyses as supporting evidence. Additionally, I will award up to 5 bonus points for additional analyses and investigations above and beyond what is asked specifically. That is, if you conduct additional analyses or deeper analyses and discuss those results in your recommendation, you can earn additional points.

Deliverables

You should turn in answers to the items outlined in Steps 1 - 4 above. You can answer within the text of this document. My text is blue. Your text should be in black to help distinguish responses from instructions.You will turn in both a copy of this document with your responses and the Excel data file showing the calculations supporting your answers above.

Attachment:- Assignment.rar

Reference no: EM131029562

Questions Cloud

Explain roles of goldmans partner both as owner and employee : Explain the roles of Goldman's partners, both as owners and as employees, in forming and managing its internal environment. Which models of organizational effectiveness are evident in Goldman's approach to management?
Determine at what times temperature within allowable limits : The temperature should never exceed 105°F. Use the find function to find the index numbers of the temperatures that exceed the maximum allowable temperature. Use the length function with the results from part (a) to determine how many times the ..
Analysing structural members in civil engineering : Name two methods used in analysing structural members in civil engineering
Define the term stocky wall : Define the term stocky wall Define the term simple bearing.
Analyze data from an advertising image : Introduction - For this assignment, you are to analyze data from an advertising image "pretest" conducted on Amazon Mechanical Turk
The unit weight using phase diagram : A certain soil has the following properties; the Specific gravity is 2.7, the porosity is 41.9% and moisture content is 21.3, find the degree saturation and the unit weight using phase diagram
Find the parametric equation for the line segment pq : Find the parametric equation for the line R normal to this plane.
Determine moment of force about point a and about point b : A rectangular shelf is attached to a wall by two brackets 12 inches apart at points A and B , as shown in Figure P10.17 . A wire with a 10-lbf weight attached to it is hanging from the edge of the shelf at point C . Determine the moment of force a..
State two properties of fluids : State two properties of fluids define the term orthogonal ratio define the term slenderness ratio

Reviews

Write a Review

 

Marketing Management Questions & Answers

  Scientific management and strategic management

Explain the similarities and differences between Scientific Management and Strategic Management. Explain whether Strategic Management could have been developed without Scientific Management as its predecessor.

  You must choose between two sales recruits one has scored

you must choose between two sales recruits. one has scored very high in terms of the quality of his interview but not

  A strategic management plan is vital for the company

you have held conversations with precision parts leaders and obtained the following information which you want to use

  Working to develop a coherent link of argument

While your report presented information on this topic, your research essay must explore this issue in greater detail, working to develop a coherent link of argument or discussion in a compelling essay founded upon a clear thesis.

  Explain liability and tort of negligence

Explain Liability and Tort of Negligence and fully discuss and provide examples and laws or other relevant information to support

  Final project marketing plan

Final project marketing plan.

  Explain how can the marketing mix be used to effectively

Explain how can the marketing mix be used to effectively differentiate and position your product or service?

  Explain marketing for dell studio 15 series laptop

Explain Marketing for Dell Studio 15 series laptop- Identify the ideal target market and Estimate the size of the market and estimated penetration percentage

  Difference between interest rate risk and default risk

What is the difference between interest rate risk and default risk? How do combinations of terms in ARMs affect the allocation of risk between borrowers and lenders? Is this a suitable way to allocate risk

  Describe five qualities a marketing manager should posses

Describe five qualities a marketing manager should posses

  What are external marketing environment factors

What are external marketing environment factors

  Targeting and positioning of the brand

Did the company do anything that reflected the targeting and positioning of the brand in the delivery of the coupon?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd