Highlights
Question 1
Imagine that you work for an energy tech company, namely, gSUNSolar. The company is active in selling and installing solar panels for homeowners. The recent increase in the price of oil and gas has increased interest in new renewable energy sources; therefore, gSUNSolar wants to get the most out of this situation.
In this regard, the CEO decided to run an ad campaign on Facebook. The CEO decided to run the following two different types of ad campaigns on Facebook:
1) ‘No targeting’: do not target any specific user on Facebook
2) ‘Targeting’: target users who are interested in one of the following topics (which is provided by Facebook):
The CEO of gSUNSolar is now done with the campaign and is asking you to evaluate the results. In particular, the CEO would like to understand the following:
A) Did the ‘Targeting’ campaign generate more shares (compared to the ‘No targeting’ campaign)? (explain)
B) Which topic(s) should be considered for targeting users in future campaigns (that potentially create more shares)?
To this end, you are provided with a sample of Facebook campaign results, containing around 100,000 users (around 40% were in the ‘Targeted’ campaign and the rest in the ‘No targeting’ campaign; see 'gSUNSolar_a.csv' dataset). The dataset includes the following variables:
|
Variable Name |
Description |
|
id |
ID of the user (anonymized by Facebook) |
|
share |
number of times the user shared the ad |
|
target |
"yes" if the user was in the ‘Targeted’ campaign and "no" otherwise |
|
topic |
the topic that the user was interested in: = a: “Vegan food” = b: “Saving on energy bills” = c: “Saving the planet” = d: “Luxury products” = e: “Green energy” |
|
device |
the device type of the user |
|
distance |
the distance of the user from the location of the company (in miles; based on the user’s IP address) |
|
browsing_time |
time (in minutes) spent on the ad |
Use the provided dataset (i.e., 'gSUNSolar_a.csv') and run a linear model that helps you to
address CEO’s questions.
In addition to answering the questions raised by the CEO, you conducted a similar analysis (as above) to investigate:
C) Did the ‘Targeted’ campaign generate more profit than the ‘No targeting’ campaign? Discuss ‘why’ based on your results (10 points).
To investigate the question in part C, you use the same dataset as above and replace the
variable ‘share’ with two other variables: ‘profit’ (i.e., expected profit in £ realized from those users that shared the ad) and ‘ad_cost’ (i.e., the money in £ that you paid to Facebook to display the ad to a user).
Notes that you should consider in your answer:
console. Everything else (e.g., your code, tables, and words in your figures) counts.
Question 2
An apparel retailer would like to understand its current customers better. To this aim, the retailer is asking you to: Identify and group its existing customers into meaningful clusters that individuals within a cluster are similar to each other but different than those individuals in other clusters.
To this end, you put together a dataset (i.e., 'Retailer.csv') including the following list of variables:
|
Variable Name |
Description |
|
ID |
ID of the customer |
|
service.sat |
expressed satisfaction with the retailer (0 – 100, where 0 is extremely dissatisfied) |
|
sustainable |
the number of previous 'sustainable products' that the customer purchased |
|
male |
"yes" if the customer is male, "no" otherwise |
|
rent |
"no" if the customer owns a house, "yes" otherwise |
|
income |
the income of the respective customer (in £) |
|
child |
no. of children in the insurer’s family |
|
referral |
the number of other customers that the focal customer referred to the retailer |
Notes that you should consider in your answer:
console. Everything else (e.g., your code, tables, and words in your figures) counts.
Question 3
Assume you are the CEO of a real estate company. You would like to gain more insights about the market.
|
Variable Name |
Description |
|
ID |
ID of the property |
|
price |
price of the property in £ |
|
type |
type of the property |
|
bedrooms |
number of bedrooms the property has |
|
bathrooms |
number of bathrooms the property has |
|
area_a |
area of the property (in m2) |
|
area_b |
area of the property (in ft2) |
|
furnished |
the furnishing situation of the property |
|
level |
the level that the property is located |
|
price_b |
price of the property converted from £ into $ |
|
payment_option |
the payment option that the property is available for purchase |
|
delivery_term |
the delivery situation of the property |
Based on the structure and the information in the dataset
Notes that you should consider in your answer:
This IT and Computer Science has been solved by our PhD Experts at My Uni Paper. Our Assignment Writing Experts are efficient in providing a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing styles.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.