MKTG1487 Marketing Analytics Assessment 2 Brief Semester 01 2025 | RMIT

Published: 02 Jun, 2025
Category Assignment Subject Marketing
University RMIT University Module Title MKTG1487 Marketing Analytics

Business Problem   

Star. Inc. is a leading manufacturer of Double-Glazed Windows in Victoria, which provides thermal insulation solutions to home builders, contractors, and homeowners. The company has been the market leader of Window material since its inception in Victoria.   

However, due to increasing competition, the foreign market has entered the market with some competitors providing similar quality at a much cheaper price. At the same time, the cost of raw materials and shipment has been increasing due to the world economic situation, which overcomplicates the situation for Star. Inc.   

Star. Inc. has decided to: (1) develop a new product, and (2) engage in consumer service to understand its brand and how to maintain a sustainable competitive advantage. Specifically, the company wants to understand the following:   

  • What is the relative importance of brand, offering and relationship attributes in the company’s desired new products?  
  • Identify the customer’s willingness to pay for each attribute of double-glazed windows.

Analysis (All analysis should be done in the Excel sheet “Data and Analysis”)  

As a marketing analysis in Star. Inc., you have conducted a conjoint study in Victoria to identify the trade-off among different attributes and best presented for the needs of the consumers. Star. Inc. was particularly interested in the following attributes: (1) Tolerance, (2) Easy installation, (3) Aesthetics, and (4) Price. These attributes were identified by the market research firm to be the key drivers of consumers’ purchases, and each of these attributes can take different levels listed below.

MKTG1487 Marketing Analytics Assessment 2 Brief Semester 01 2025 | RMIT

From the possible combinations, 9 combinations/products were selected by you as potential combinations for a new product. These combinations are listed in the dataset (please refer to Excel). Participants (respondents) were asked to give a rating of each bundle from 0 (least preferred) to 100 (most preferred). That means each respondent must rate all 9 combinations. These combinations are provided in the dataset.  

The data has been collected by the market research company. Your tasks in this case assessment are to: (1) analyse the result through regression (you need to create dummy variables as well), (2) identify the most important attributes through part-worth utilities, (3) calculate purchase probability using a choice model, and (4) predict the accuracy of the model. For the case, only the first 20 respondents are shown, with their ratings for all 9 combinations. Information on these combinations and responses is recorded in the dataset. Furthermore, these respondents are divided into three different segments, which are outlined in the dataset.

Achieve Higher Grades with MKTG1487 Assignment Solutions

Order Non-Plagiarised Assignment

Questions   

These questions are designed to guide you with the report.    

Calculate the part-worth of all Double-glazed windows attribute levels.     

Calculate the relative importance of the attributes and provide insights on the attribute preferences of the three segments. You can expect what these segments (builders, contractors or homeowners) use based on their preferences. (Hint: Once you have calculated the attribute importances for all respondents, take the average of the attribute importances of respondents that belong in those segments.)     

In Victoria, the four companies below are identified as the competitors of Star. Inc.  The combination of their double-glazed windows is as follows:  Greener: Tolerance: Low Resistance, Easy Installation: 2 weeks, Windows Aesthetics: No Imperfection, Price: $90.   

  • Monday: Tolerance: Medium Resistance, Easy Installation: 1.5 weeks, Windows Aesthetics: Minimal Imperfection, Price: $80.  
  • Armed: Tolerance: High Resistance, Easy Installation: 1 week, Windows Aesthetics: No Imperfection, Price: $100.  
  • Abteen: Tolerance: Low Resistance, Easy Installation: 2 weeks, Windows Aesthetics: Minimal Imperfection, Price: $80.   

Calculate the purchase probability for each combination against these four competitors, using the Logit model.   

(Note: You will need to transform the above into dummy coding, calculate the utilities for all above double-glazed windows for each respondent, and then use the logit formula in Excel).    

Based on the calculation in Question 3, recommend Star. Inc. the best product to launch (i.e., from Combination 1 to Combination 9). In your report, you should also suggest the best combination that consumers want in different segments.  

To verify whether the conjoint model is reliable (accurate), each respondent has to select which competitors’ windows (i.e., four products mentioned in Question 3) they prefer. The respondents’ choice is recorded in the spreadsheet. Comment on the accuracy of the model to predict respondents’ choice.  (Note: You will need to use the table “Competitors: Utilities” and compare the results with the respondents’ selection. Ideally, a rational consumer always selects a product that yields the highest utility. 

Are you trying to find someone who can help with my MKTG1487 Marketing Analytics? Well! You're in the right place, our podium. Workingment provides Marketing Assignment Help. Our well-researched and talented professors can also provide you with odd assignments. Suppose you're judging whether to Write My Assignment with our professors. No doubt! Our team can help with your assignment. We also provide Free Sample assignments for your guidance. Get in touch right now!

If you want to see the related solution of this brief then click here:- Marketing Analytics
Workingment Unique Features

Hire Assignment Helper Today!


BBSC4103 Assignment: Strategic Supply Chain Management Question Semester 2025 | OUM

BBSC4103 Part 1: The purpose of this assignment is to help learners study the important of strategic alliances by focusing on inter-organisational relationships and the challenges in managing them.

BBHI4103 Industrial Relation Assignment Question | Open University Malaysia

BBHI4103 Part 1: The purpose of this assignment is to enhance learners' ability to discuss the perspectives in industrial relations and evaluate which perspective is the best for the selected organisation

Scientific Research Review Assignment 4 | USM

You are required to write an individual review paper on a topic of advancements in your area of study. This paper must demonstrate your ability to plan, execute, and present a scholarly task ethically and professionally.

BTEC Level 5 Unit 16: Computing Research Project Assignment Part 1 Brief

BTEC Level 5 Unit 16: Assignment Brief: Artificial intelligence is at the forefront of innovation within Computer Science that uses a combination of logic, algorithms and large data sets to produce an AI model.

ACC210 Accounting for Decision Making and Control TMA Assignment Question | SUSS

ACC210 Question 1  Cool Strokes Pte Ltd ("CS") manufactures white board markers for educational use. The company's markers are sold by the box at $50 each in 20x3.

BM414 Financial Decision Making CW1 Assignment Brief (SIG) | BNU

Suppose you are part of the Accounting and Finance team at Sheffield Insulation Group (SIG) plc. You are required to write a report to the senior management team of SIG plc, discussing the importance of accounting and finance functions.

7167EXQ Environmental Management Systems and Auditing CW1 Brief | CU

7167EXQ Assignment Task: Essay on the relevance of organisational behaviour on environmental management in an organisation You may approach this essay in one of two ways depending on your experience and knowledge.

BENV1015 History of Design Thinking Assignment 1 Brief Term 2 2025 | UNSW

The assignment develops your knowledge of historical design ideas and communication skills corresponding to the course learning outcomes below. It aims to give an appreciation of the implications of past movements, practitioners, and projects for current challenges.

7ME500 Advanced Mechanical Design and Manufacturing Engineering CW1 Report Assessment Brief | UoD

An integrated design, material selection, and manufacturing approach provides one of the key enabling capabilities needed to effectively evaluate specific areas of initial concept development and perform detailed engineering design and analysis throughout a product development cycle.

Atomic Structure & Bonding Assignment : Lab-Based Element Analysis and Molecular Case Study

Atmospheric ions are electrically charged particles that occur naturally in the atmosphere. They form in the upper atmospheric layers mainly because of the action of ultraviolet radiation from the sun, as well as in lower atmospheric layers as a result of radioactive radiation and cosmic rays.

Online Assignment Help in UK