Key demographic variables, Marketing Management

Assignment Help:

Managerial Decision I: Developing advertising strategies by understanding key demographic variables

To understand the demographics of your target audience, you obtain data on Facebook users in Australia, The US, and Japan.  Google Ad Planner generates statistics on key demographics such as Gender and Income. Taking a randomly selected sample of 2000 Facebook users from each country produced the data in the file AdPlanner.xlsx, available on the course resources website (Assignments folder).

You decide to use Descriptive Summaries to help understand the data and devise an advertising strategy for one of your best selling products, the oNetbook, by Orange Computers.

i.   Produce histograms in Excel for the demographic variables Gender and Income, for each country. For full marks, be sure to follow the formatting instructions for the histograms given below.

EXCEL Instructions:   For each country, you will need to create Bin columns for the histogram.  E.g. BinG, could contain the Bin numbers from 1 to 2 in steps of 1 (i.e. 1, 2) for Gender, and a second Bin column could be called BinI, with the appropriate range of numbers for Income with a step size of 1.  E.g. for Australia, BinI will contain the numbers from 1 through to 6. Refer to Topic 6 in the Excel Booklet for instructions on how to obtain and format a histogram. For full marks make sure the title of each histogram ends with your network ID (e.g. Histogram of Income bloggsj001).

ii.  Use Excel to produce Descriptive Summaries for the demographic variables Gender and Income for each country. Also compute Quartile 1, Quartile 3 and the Interquartile Range for each descriptive summary.  Add your network ID to the Descriptive Summaries output column names for each demographic variable (e.g. Gender should become Gender bloggsj001).

EXCEL Instructions:   Refer to Topic 7 in the Excel Booklet for instructions on how to obtain Descriptive Statistics, the two quartiles and the interquartile range.

iii.  In the Analysis section of your report, answer (a)-(c) below.  The analysis should not take more than 4 paragraphs of text.  Alternatively, bullet point format reporting is acceptable:

a)  Explain the purpose of Managerial Decision I.  Then, for each country, describe the shape (symmetry, modality, outliers) of the Gender and Income distributions.

Instructions for identifying outliers:  Whether an observation is an outlier is a matter of judgement. One rule commonly used for identifying outliers is the 1.5×IQR rule. An observation is suspected to be an outlier if it is more than 1.5×IQR below the first quartile Q1 or above the third quartile Q3.

(b)  Nominate appropriate summary measures (central tendency, dispersion) for the Gender and Income distributions for each country.   Give reason(s) for your choice and be sure to interpret the values of the summary measures you have chosen.  Be careful when interpreting Income!

(c)  Explain where you would market the following product and why: the oNetbook, the newest netbook from Orange Computers.  This netbook is popular with both genders and is favoured heavily by people earning at least AU$100,000, as Orange is the latest must-have in electronics.


Related Discussions:- Key demographic variables

Explain the various elements of the marketing process, A Convertible Ultrab...

A Convertible Ultrabook is a new type of notebook which functions both as a laptop and tablet mode when required. Ultrabooks are designed to feature reduced bulk without compromisi

Buying decision process, with reference to the purchase of a new television...

with reference to the purchase of a new television set explain the buying decision process which a typical consumer goes through demonstrate how company can formulate their marketi

Explain the marketing communications mix, Explain the Marketing Communicati...

Explain the Marketing Communications Mix Marketing communications mix comprises a set of tools (disciplines) which can be used in various combinations and different degrees of

Buying decision making process, Buying decision making process: Mark...

Buying decision making process: Marketers have to go beyond the various influences on buyers and develop an understanding of how consumers actually make their buying decisio

Societal marketing concept, The Societal Marketing Concept The societa...

The Societal Marketing Concept The societal marketing concept holds that the organization should find out the needs, wants, and interests of focused markets. Then It should de

Global sourcing of labour in competition, How is the global sourcing of lab...

How is the global sourcing of labour effective in competition international developments? Global sourcing of labour: Innovative uses of labour upon a global origin are e

Mathematics and baseball, A baseball left fielder throws a baseball from a ...

A baseball left fielder throws a baseball from a position 400 feet from home plate to the third baseman who is 90 feet from home plate. (Assume the two players are in the same lin

Determine tax revenue, The US government decides to subsidize solar panels....

The US government decides to subsidize solar panels. For each unit sold, the government pays $T to the buyer. Using a graph, show how this subsidy affects i) consumer surplus, I

Utility of the product life cycle, Utility of the product life cycle 1...

Utility of the product life cycle 1.       As forecasting tool: the study of product life cycle is an important tool for sales forecasting its study foretells that problems a

Define the storage in marketing function, Define the storage in marketing f...

Define the storage in marketing functions of physical treatment. Storage: Goods are usually produced into anticipation of the demand. All they are stored into warehouses u

Write Your Message!

Captcha
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