## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
## Welcome! Want to learn more? See two factoextra-related books at https://goo.gl/ve3WBa

Section 1

## # A tibble: 1 × 5
##   Region `Investment Product` TotalInvestment TotalNetReturn AggregateROI
##   <chr>  <chr>                          <dbl>          <dbl>        <dbl>
## 1 North  Bond Fund                    3048398        182639.         5.99

Answers for Section 1

1.

The most profitable region and product category based on aggregate ROI are North and Bond Fund respectively, with an aggregate ROI of 5.99

2.

The observed data on customer investment preferences by age group highlights distinct patterns that reflect both conventional wisdom and evolving trends in financial behavior. Younger investors (ages 17-34) exhibit a balanced interest across investment products with a noticeable tilt towards Equity Funds, which likely corresponds to their higher risk tolerance and longer investment horizons. This trend continues robustly into the middle age groups (ages 35-54), who demonstrate a marked preference for Equity Funds alongside a significant interest in Bonds and Balanced Funds, indicative of ongoing wealth accumulation efforts during prime earning years.

As investors transition into older age groups (ages 55-69), there is a visible shift towards more conservative investment choices. The preference for Bond Funds increases significantly, especially among those nearing retirement, reflecting a strategic shift towards securing income and capital preservation. This age group’s reduced engagement with higher risk options like Crypto ETFs and Equity Funds hughlights a typical risk-averse strategy aimed at ensuring financial stability in retirement.

Overall, Equity Funds dominate the preference across most age groups, affirming their role in long-term growth strategies, while the rising popularity of Bond Funds with increasing age highlights their importance in retirement planning. Balanced Funds maintain steady appeal due to their dual focus on growth and safety, appealing to a broad audience. In contrast, Crypto ETFs, though least popular overall, find favor predominantly among the younger, more risk-tolerant investors, suggesting a generational openness to emerging asset classes. These patterns not only inform product strategy and client engagement but also suggest targeted approaches for marketing and educational initiatives to better align with the financial goals and risk profiles of each demographic.

3.

Customised Investment Solutions and Communication: The data illuminates distinct investment inclinations across various age brackets. Financial institutions can harness this by crafting customised investment offerings that cater to the unique needs and risk appetites of different demographics. For the youthful clientele (ages 17-34), who display an enthusiasm for equities and emerging assets like Crypto ETFs, firms should introduce products that capitalise on growth and technological advancements. For individuals in their mid-life (ages 35-54), a blend of equities for growth potential and bonds for security could address their need for balanced financial planning as they near their peak earning period. For the senior segment (ages 55-69), who show a preference for bonds and balanced funds, products should focus on stability, income generation, and capital preservation. Correspondingly, communication strategies should be nuanced to reflect the values and investment logic that resonate with each age group, utilising the most effective channels and messaging to enhance engagement.

Enhanced Educational Programmes and Bespoke Advisory Services: Investing in educational initiatives and advisory services can serve as a pivotal strategy for attracting and retaining clients by equipping them with the knowledge to make informed investment choices. For younger investors, educational content could introduce the fundamentals of investing, emphasise the importance of early investments, and explore a variety of market instruments, including digital options. For those in their middle years, more complex subjects like strategic asset allocation, retirement planning, and diversification benefits would be pertinent. For older clients, sessions on managing investments post-retirement, estate planning, and tax-efficient strategies would offer significant value. Providing personalised advisory services tailored to each life stage not only helps retain clients but also attracts new ones through recommendations and enhanced client satisfaction.

Section 2

## 
## Call:
## lm(formula = InvestmentAmount ~ ., data = model_data)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -26295.3 -12162.1   -207.6  12103.5  25657.9 
## 
## Coefficients: (1 not defined because of singularities)
##                                   Estimate Std. Error t value Pr(>|t|)    
## (Intercept)                      2.612e+04  1.857e+03  14.068   <2e-16 ***
## RiskToleranceLow                -1.568e+03  8.258e+02  -1.899   0.0577 .  
## RiskToleranceModerate           -5.969e+02  8.099e+02  -0.737   0.4612    
## RiskToleranceHigh                       NA         NA      NA       NA    
## MaritalStatusMarried             4.140e+02  9.453e+02   0.438   0.6615    
## MaritalStatusDivorced            1.064e+02  9.548e+02   0.111   0.9113    
## MaritalStatusWidowed             5.994e+02  9.587e+02   0.625   0.5319    
## `EducationLevelBachelor's`       1.726e+02  9.584e+02   0.180   0.8571    
## `EducationLevelMaster's`         2.193e+02  9.449e+02   0.232   0.8165    
## EducationLevelPhD                8.668e+02  9.683e+02   0.895   0.3708    
## `EmploymentStatusSelf-Employed`  1.529e+02  9.480e+02   0.161   0.8719    
## EmploymentStatusUnemployed       1.750e+03  9.469e+02   1.848   0.0648 .  
## EmploymentStatusRetired          9.297e+02  9.295e+02   1.000   0.3173    
## Age                             -3.058e+01  2.253e+01  -1.357   0.1748    
## Income                           1.571e-03  6.714e-03   0.234   0.8150    
## DI_Ratio                         1.177e+01  2.552e+01   0.461   0.6447    
## Dependents                      -2.677e+02  2.381e+02  -1.124   0.2610    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 14160 on 1784 degrees of freedom
## Multiple R-squared:  0.006911,   Adjusted R-squared:  -0.001438 
## F-statistic: 0.8277 on 15 and 1784 DF,  p-value: 0.6472

Answers for Section 2

1.

The multivariate linear regression model was built on the Investment Amount ($) based on the customer attributes of Risk Tolerance, Marital Status, Education Level, Employment Status, Age, Income, Debt-to-Income Ratio and the No. of Dependents.

2.

At a 5% level of significance, there are no indicators in particular that stand out and thus I will be using a 10% level of significance for the purpose of this analysis. The most significant predictors are the Low Risk Tolerance with a coefficient of -1.57 and a p-value of 0.058, and the Unemployed Employment Status with a coefficient of 1.75 and p-value of 0.065. Since both of these predictors have a p-value of less than 0.1, they are statistically significant at a 10% level of significance. Holding all other variables constant, on average the Low Risk Tolerance is associated with a decrease in Investment Amount by $1568. The negative coefficient for “RiskToleranceLow” suggests that individuals with low risk tolerance tend to invest less money, presumably because they prefer safer, less volatile investment options, which generally require smaller investment amounts. This aligns with typical financial behavior, where lower risk tolerance is associated with a more conservative investment strategy. Holding all other variables constant, on average the Unemployed Employment Status is associated with an increase in Investment Amount by $1750. The large positive coefficient for “Unemployed” suggests a strong positive impact on Investment Amount. This might seem counterintuitive but could reflect specific behaviors or economic factors not captured directly by other variables in the model. For example, unemployed individuals might be liquidating investments or receiving lump-sum severance packages, influencing their reported Investment Amounts.

###3. The current regression model, intended to predict Investment Amount based on various customer attributes, demonstrates limited effectiveness, with an R-squared of only 0.69% and an adjusted R-squared that is negative. These metrics indicate that the model fails to explain a significant portion of the variance in the investment amounts and may indeed be worse than a model without any predictors at all. The F-statistic’s associated p-value of 0.6472 further suggests that the model does not significantly outperform a simple mean model. Such findings imply that the selected predictors might not be adequately capturing the underlying dynamics influencing investment decisions, or perhaps key variables are missing. Additionally, the negative adjusted R-squared suggests possible overfitting with irrelevant predictors that do not enhance the model’s predictive power. To enhance model performance, a thorough review and possible revision of the predictor variables are recommended. Consideration should also be given to exploring non-linear relationships and alternative modelling approaches that might better capture complex interactions within the data.

Section 3

## Warning: No shared levels found between `names(values)` of the manual scale and the
## data's colour values.
## No shared levels found between `names(values)` of the manual scale and the
## data's colour values.

## Warning: No shared levels found between `names(values)` of the manual scale and the
## data's colour values.
## No shared levels found between `names(values)` of the manual scale and the
## data's colour values.

Answers for Section 3:

The clustering analysis using k-means has successfully segmented the customer base into three distinct groups predominantly based on Age and Income. This analysis revealed that although Risk Tolerance did not significantly differentiate these groups, Age and Income effectively identified three distinct segments. Each segment is represented by a specific colour for visual clarity in the analysis: Cluster 1 (Red), Cluster 2 (Green), and Cluster 3 (Blue).

Profile of Each Cluster:

Cluster 1 (Red): Young, Lower Income This cluster includes younger adults, likely in the initial stages of their careers or in entry-level positions, characterised by lower income levels. They require educational resources on financial planning and entry-level investment opportunities that accommodate their early financial building phase.

Cluster 2 (Green): Middle-Aged, Mid to High Income Comprising middle-aged individuals who are well-established in their careers, this group enjoys stable and higher income levels. They often manage complex financial responsibilities and would benefit from comprehensive financial planning services, including retirement and educational funding strategies.

Cluster 3 (Blue): Older, High Income This cluster consists of senior professionals or those nearing retirement, possessing the highest income levels within our clientele. Their financial strategies focus on wealth preservation and estate planning, requiring sophisticated management services and conservative investment products.

Targeting strategies:

Red Cluster (Young, Lower Income): We should engage these customers with digital-first banking solutions, financial literacy programmes, and micro-investing options that promote gradual wealth accumulation. Targeted communications should utilise digital channels to match their tech-savvy preferences and promote financial education as a foundation for long-term financial health.

Green Cluster (Middle-Aged, Mid to High Income): For this demographic, offering advanced financial tools and advisory services that address their broad financial responsibilities is crucial. Services should include tax planning, investment diversification, and proactive retirement planning, all communicated through personalised direct marketing and interactive workshops.

Blue Cluster (Older, High Income): Engagement strategies should focus on providing premium services such as bespoke wealth management, exclusive investment opportunities, and in-depth legacy planning consultations. Communications should prioritise security, convenience, and personalised service, using more traditional, high-touch channels to reflect their established financial behaviours and preferences. Conclusion Through detailed segmentation and targeted strategies, we ensure that the financial services are highly tailored and relevant to each cluster. By specifying the colours associated with each cluster—Red for younger, lower-income customers, Green for middle-aged professionals, and Blue for older, high-income individuals—we enhance the clarity and effectiveness of strategic planning and client communications. This methodical approach highlights commitment to addressing the diverse financial needs of our customers while fostering enhanced engagement and loyalty.

Section 4

Answers for Section 4:

To maximise the return on investment (ROI) within the constraints specified by the company, a structured and strategic approach is essential. The following paragraphs outline a comprehensive strategy to achieve this, denominated in Singapore Dollars (SGD) and utilising British English spelling:

Initial Dataset Enhancement and Risk Assessment

The initial step involves augmenting the dataset with a unique Product ID for each investment product, such as BF1 for Balanced Fund, BF2 for Bond Fund, CF1 for Crypto ETF, and EF1 for Equity Fund. This addition will facilitate precise tracking and management of investments. Each product is classified under a risk category—Low, Moderate, or High—based on historical performance data. The analysis aims to identify which products within each risk category have historically offered the highest ROI. This determination is crucial as it directs the initial allocation of funds and ensures compliance with the diversification mandate.

Strategic Allocation Framework

The investment strategy begins with ensuring that the minimum required investment of S$1,000 is allocated to the highest ROI product within each risk category. This step not only adheres to the diversification requirements but also sets a foundation for a balanced investment portfolio. Considering the total budget cap of S$50,000, the initial allocation across the three categories would typically utilise S$3,000 (S$1,000 in each category).

Optimising the Remaining Budget

After the initial allocation, the remaining S$47,000 is distributed with a focus on maximising ROI. This involves prioritising further investment towards the products with the highest ROI, taking into account their associated risk categories. The investment distribution is adjusted based on a detailed analysis of potential returns and risk assessments, where higher allocations might be directed towards moderate to high-risk categories if they offer significantly higher returns.

Formula for Allocation and ROI Calculation

Investment allocation across different products is guided by the formula: \[ \text{Investment} = \text{Base Allocation} + (\text{Income Factor} \times \text{Income Weight}) - (\text{Debt-to-Income Factor} \times \text{DTI Weight}) + (\text{Risk Tolerance Factor} \times \text{Risk Weight}) \] where the base allocation ensures the minimum investment requirement is met, and additional funds are allocated based on adjusted ROI expectations derived from historical data. The expected overall ROI is calculated using a weighted average, considering the allocated amounts and their respective ROIs: \[ \text{Weighted ROI} = \sum \left(\frac{\text{Investment Amount}_i \times \text{ROI}_i}{\text{Total Investment}}\right) \]

Continuous Review and Adjustment

The investment strategy incorporates a dynamic adjustment mechanism, where the performance of each investment, tracked via the Product ID, is regularly reviewed. Adjustments are made to optimise ROI while ensuring the risk profile of the portfolio remains within acceptable limits. This proactive management approach allows for reallocation of funds between products to respond to changing market conditions and ROI data.

Conclusion

This detailed and strategic approach to investment, leveraging enhanced data tracking and a sophisticated allocation formula, ensures that the company’s investments are not only diversified across different risk levels but also optimised for maximum ROI within the given constraints of S$50,000. The use of Product IDs for precise tracking and the integration of financial and risk data into the allocation process are key to achieving targeted and effective investment outcomes, ensuring the company’s financial goals are met with a high degree of accuracy and efficiency.