A

PROJECT REPORT ON
“Market research and customer data analysis
homecare and skincare domain”
HOLISTIC HEALTHCARE
Submited To
Savitribai Phule University Pune
In partial fulfillment of the
Requirements for Award
Of
Degree of
MASTERS OF BUSINESS ADMINISTRATION
Submitted by
Mr. Shivam Saste
MBA (Business analytics)
Under The Guidance of
Miss. Anila Alam

JSPM’S JAYAWANTRAO SAWANT INSTITUTE OF MANAGEMENT &

RESEARCH HADAPSAR,PUNE 412308

1
(

2
3
 DECLARATION

I the undersigned hereby declare that the project report entitled “Market research
and customer data analysis in homecare and skincare domain” is written and
submitted by me to the University of Pune in partial fulfillment of the requirement
for the award of degree of Masters of Business Administration under the guidance
of Miss. Anila Alam

This project is my original work and the conclusion drawn therein is based on the
material collected by myself.
I further declare that the information presented in this project is true and original to
the best of my knowledge.

Place
Date Shivam Saste

4
 ACKNOWLEDGEMENT

I consider it a privilege to express a few words of gratitude and respect to all who guided and
inspired me in successful completion of the project.

I take this opportunity to thank my project guide Miss. Anila Alam for his valuable guidance
and support.

I would like to thank Dr. Dipali as a company project guide for guiding me at every stage of the
project with ideas and innovations. I am extremely grateful to him/her for sparing time for me
even in his/ her busy schedule. This brings along and frames to my beloved institution the
JSPM’s Jayawantrao Sawant Institute of Management & Research, Hadapsar, Pune.

I also extend my particular thanks to Dr. Umesh Nath our HOD and to our Director Dr.
Manohar Karade. I would also like to thank all teachers and staff members who helped me
directly or indirectly in successful completion of this project.

I wish to give my sincere thanks to the entire team of Holistic Healthcare as well as my fellow
colleagues who supported me throughout my internship period.

Place:
Date: Shivam Saste

5
 EXECUTIVE SUMMARY

The focus of my project is the comprehensive analysis of customer data within the
healthcare domain. The primary objective is to derive actionable insights that contribute
to informed decision-making and strategic planning for our healthcare services.

The study examined the influence of production planning and control practices in the
manufacturing industry. It specifically looked into the capacity utilization, short-term
scheduling techniques, waiting time and processing, and quality control of the firms
to enhance customer satisfaction. The study concluded that the production planning
and control practices has impacted on the efficient utilization of the resources, waste
reduction reduced waiting time and processing, thus contributing to the profitability of
the industry. Production planning is the technique of observing and sketching the
various long processes of production. It is not wise to start production unless, "you
first plan your work and then work your plan" All the activities required for the
production process must be properly coordinated for successful production. There
should not be any stoppages in the production, otherwise there will be loss of time
and labour and it may affect the productivity.
It is concluded further that effectives production planning and control practices
contribute significantly to the consumer satisfaction.
As per summer internship is concern it is most important aspect of management
program because it gives the platform to learn the practical things and it also gives
the experience of how to face the challenges that comes in day to day life of
manager. This study deals with overall idea of production planning and control.

The most important objective is : -

To study production planning and control for Samson
Controls Private Limited.

Selection of company and proper selection or project topic is very vital factor in two
months project duration. Depending upon it, student can learn more and more
practical knowledge from market and industry. At the time of searching company for
summer internship I have to know about Samson Controls Private Limited which is
well known company in valves. So it is good. experience for me to learn more about
the production planning and control for Samson Controls Private Limited.

It is equally important to know about the company & its working environment.
During my frequent visit to Samson Controls, I started knowing about the
organization, studying about the different production activities & at the same was
learning about the technical know-hows of organization.

6
 INDEX

SR. PAGE
NO TOPIC NO.

1 INTRODUCTION 6 - 8

2 COMPANY PROFILE 9 - 11

3 OBJECTIVES AND SCOPE 12 - 14

4 REVIEW OF LITERATURE 15 - 18

5 RESEARCH METHODOLOGY 19 - 21

6 DATA INTERPRETATION 22 - 40

7 OBSERVATIONS AND FINDINGS 41 - 46

8 CONCLUSION 47 - 48

7
 CHAPTER 1
INTRODUCTION

8
 INTRODUCTION

Analyzing customer data is a crucial practice for businesses seeking to gain valuable insights
into customer behavior, preferences, and trends. This process involves collecting, processing,
and interpreting various types of data generated through customer interactions with a company's
products or services. The goal is to extract meaningful information that can inform strategic
decision-making, enhance customer experiences, and drive overall business success.

Customer data analysis encompasses a wide range of information, including purchase history,
online interactions, feedback, demographic details, and more. With the advent of advanced
technologies and data analytics tools, businesses can now delve deeper into understanding
customer journeys, predicting future behavior, and personalizing offerings.

The insights derived from customer data analysis can aid in tailoring marketing strategies,
optimizing product development, and improving customer service. By identifying patterns and
trends within the data, businesses can make informed decisions to enhance customer satisfaction,
loyalty, and retention.

In today's competitive landscape, where customer expectations are constantly evolving, the
ability to effectively analyze customer data provides a strategic advantage. It allows businesses
to stay agile, responsive, and customer-centric, ultimately fostering long-term relationships and
sustainable growth.

9
 CHAPTER : - 2
COMPANY PROFILE

10
 COMPANY PROFILE

Company Description : -

We are a leading manufacturer of Home Care and Personal Care Products, catering to customers
around the world since 2019. Our company is committed to producing high-quality and effective
products that enhance the daily lives of our customers. We strive to maintain the highest
standards of quality, safety, and sustainability in our manufacturing processes. Our products
include a wide range of Home Care and Personal Care Products, including laundry detergents,
fabric softeners, dishwashing liquids, hand soaps, body washes, and more. All of our products
are carefully formulated using the finest ingredients to ensure maximum effectiveness and safety
for our customers. At our company, we are dedicated to customer satisfaction. We work closely
with our customers to understand their needs and provide tailored solutions that meet their
specific requirements. We are committed to providing exceptional customer service, ensuring
that our customers receive the support they need, whenever they need it.

About Us : -

Our company was founded in 2019 with a vision to provide high-quality and effective Home
Care and Personal Care Products to customers around the world. Since then, we have been
committed to maintaining the highest standards of quality and safety in our manufacturing
processes. We take great pride in our products and the positive impact they have on our
customers' daily lives. Our team of experts is passionate about creating innovative and effective
products that meet the evolving needs of our customers. At our company, we believe that
sustainability is a critical part of our responsibility as a manufacturer.

We take great care to minimize our environmental impact by using sustainable materials and
processes in our manufacturing operations. We are also committed to supporting our local
communities through various initiatives and partnerships. We believe that by working together,
we can create a better world for all. Overall, our company is committed to providing exceptional
Home Care and Personal Care Products, exceptional customer service, and a commitment to
sustainability and social responsibility.

11
 CHAPTER 3

OBJECTIVES AND SCOPE

12
OBJECTIVE OF THE PROJECT

Objective : -

To analyse customer data for healthcare domain

OBJECTIVES for the Project :

A. Data Collection and Analysis : -

Gather relevant data sources, ensuring data accuracy and completeness.

B. Enhance Customer Engagement : -

Improve customer engagement strategies by utilizing data analytics to
better understand customer preferences and behaviors.

C. Competitor Analysis : -
Analyze market trends and competitors using data analytics to identify
growth opportunities and challenges.

D. Personalization Implementation : -
Implement data-driven personalization strategies, such as product
recommendations, to enhance the customer experience.

13
 SCOPE

• Customer Insights : -
Analyzing customer data.

• Market Trends Analysis : -

Identifying industry trends and competitor insights through data analytics.

• Personalization : -
Implementing data-driven personalization strategies to recommend products and services
to customers, improving their experience and increasing sales.

14
 CHAPTER : - 4

LITERATURE REVIEW

15
 REVIEW OF LITERATURE

 Academic Journals : -

Look for articles in reputable healthcare and data analysis journals. Journals like the
Journal of Healthcare Informatics Research, Journal of Medical Internet Research, and
Health Informatics Journal often publish studies related to healthcare data analysis and
customer behavior.

 Books : -

Explore books on healthcare analytics, data science, and customer behavior analysis.
Some recommended titles include "Healthcare Analytics for Quality and Performance
Improvement" by Trevor L. Strome and "Data-Driven Healthcare: How Analytics and BI
are Transforming the Industry" by Laura Madsen.

 Conference Proceedings : -

Proceedings from conferences in the fields of healthcare informatics, data science, and
customer experience can provide insights into the latest research and trends. Check out
conferences like the Healthcare Information and Management Systems Society (HIMSS)
Annual Conference.

 Government Publications:

Government health agencies often publish reports and studies on healthcare data and
customer satisfaction. For example, the World Health Organization (WHO) and the U.S.
Department of Health and Human Services may have valuable publications.

 White Papers and Reports:

Explore white papers and reports from healthcare technology and analytics companies.
These documents often provide practical insights and case studies. Companies like IBM,
SAS, and Deloitte frequently publish materials on healthcare analytics.

16
 Online Databases:

Utilize academic databases such as PubMed, IEEE Xplore, and ScienceDirect to search
for relevant articles and research papers. These platforms often provide access to a
wealth of academic literature.

 Case Studies:

Look for case studies that showcase successful applications of data analysis in the
healthcare sector. These can provide real-world examples and practical insights. Consider
searching on platforms like Harvard Business Review or consulting business analytics
providers.

17
 CHAPTER : - 5

RESEARCH METHODOLOGY

18
 RESEARCH METHODOLOGY

Meaning : -

The very common meaning of research is “a search for knowledge”. Research is an art
of scientific investigation. It is a movement from the known to unknown. C.R. Kothari
explains that Research methodology is a way to systematically solve their Research
problem.
A research methodology describes the techniques and procedures used to identify and analyze
information regarding a specific research topic. It is a process by which researchers design their
study so that they can achieve their objectives using the selected research instruments. It includes
all the important aspects of research, including research design, data collection methods, data
analysis methods, and the overall framework within which the research is conducted. While
these points can help you understand what is research methodology, you also need to know why
it is important to pick the right methodology.

Objective of Research
“To analyse customer data of homecare and healthcare domain.”

Research Design
Research design refers to the overall strategy or plan for conducting a research study. It outlines
the methods and procedures that will be used to collect and analyze data, as well as the goals and
objectives of the study. Research design is important because it guides the entire research
process and ensures that the study is conducted in a systematic and rigorous manner.

19
Method of Data Collection
Data includes facts which are required to be collected to achieve the objectives of the
project. With help of data analysis, the result is properly interpreted and policy decision
are taken. Both the primary and secondary sources of data have been used to conduct the
study.
Primary Data Collection : -

Primary data collection is the process of gathering original and firsthand Information
directly from the source or target population. This type of data collection involves collecting data
that has not been previously gathered, recorded, or published. Primary data can be collected
through various methods such as surveys, interviews, observations, experiments, and focus
groups. The data collected is usually specific to the research question or objective and can
provide valuable insights that cannot be obtained from secondary data sources. Primary data
collection is often used in market research, social research, and scientific research.

Secondary Data Collection : -

Secondary data collection is the process of gathering information from existing sources that have
already been collected and analyzed by someone else, rather than conducting new research to
collect primary data. Secondary data can be collected from various sources, such as published
reports, books, journals, newspapers, websites, government publications, and other documents.

Qualitative Data Collection : -

Qualitative data collection is used to gather non-numerical data such as opinions, experiences,
perceptions, and feelings, through techniques such as interviews, focus groups, observations, and
document analysis. It seeks to understand the deeper meaning and context of a phenomenon or
situation and is often used in social sciences, psychology, and humanities. Qualitative data
collection methods allow for a more in-depth and holistic exploration of research questions and
can provide rich and nuanced insights into human behavior and experiences.

20
Quantitative Data Collection : -

Quantitative data collection is a used to gather numerical data that can be analyzed using
statistical methods. This data is typically collected through surveys, experiments, and other
structured data collection methods. Quantitative data collection seeks to quantify and measure
variables, such as behaviors, attitudes, and opinions, in a systematic and objective way. This data
is often used to test hypotheses, identify patterns, and establish correlations between variables.
Quantitative data collection methods allow for precise measurement and generalization of
findings to a larger population. It is commonly used in fields such as economics, psychology,
and natural sciences.

Methodology Applied : -

Primary data collection : -Primary data collection in this process of I gathere original and
firsthand information directly from the source or target population. This type of data collection
involves collecting data that has not been previously gathered, recorded, or published. Primary
data can be collected through the Quastionnair. The data collected is usually specific to the
research question or objective and can provide valuable insights that cannot be obtained from
secondary data sources. Primary data collection is often used in market research, social research,
and scientific research .
Descriptive research is a research method describing the characteristics of the population or
phenomenon studied. This descriptive methodology focuses more on the “what” of the research
subject than the “why” of the research subject.The method primarily focuses on describing the
nature of a demographic segment without focusing on “why” a particular phenomenon occurs. In
other words, it “describes” the research subject without covering “why” it happens.

21
.

CHAPTER : - 6
DATA
INTERPRETATION

22
Products : -

Abhyang Tel

 Remove Skin Dryness

 Increase circulation

 Calm the nerves

 Norurishes entire body

Liquid fabric detergent

 Remove stain
 Good smell

23
Vendor Study

First done the survey to know the competition. And there market strategy.

Abhyanga Tel : -

BRAN TYPE M.R.P D MART

D QUANTIT PRICE
Y
Aloe Fresh 475 Buy 1 Get
Vaseline (Intensive Care) 400ml 1

Complete 10
(Healthy 400ml 460
Bright) 300
85gm 145
Original Pure 135
(Pure Skin
Jelly)

NIVEA Aloe 600ml 759 489

Hydration
400ml 460 325
Body Milk
(Nourishing
Lotion) 500
50ml 395
Smooth
(Smooth Milk) 105
200ml 95
Soft
(Soft Moisturizing 349
Cream) BUY 1 GET 1

Soft
(Berry
Blossom)

JOY Honey and

almonds 75oml 530 BUY 1
(Advance GET 1
Nourishing)

24
BRAND TYPE M.R.P SELLING
QUANLITY PRICE

POND’S Light Moisturiser 200 G 360 270

Super Light Gel 200 ML 445 BUY 1 GET 1

(Oil Moisturiser) FREE

LAKME Peach Milk 120 ML 250 225

(Moisturizer
Lotion)

CETAPHIL Moisturizer 80 GM 508 432

Lotion

HIMALAYA Aloe and cucu 400 ML 330 307

(Body Lotion)

SKY Rose 449 380

(Deep
Nourishing)

VASELINE Deep 400 ML 375 BUY 1 GET 1

Restore FREE
(Body Lotion)
435 ML 435
Cocoa Butter 261
(Body Lotion)
400 ML 475
Aloe Fresh 276
(Body Lotion)

NIVEA Ultra Rich 400 ML 549 BUY 1 GET 1

(Oil In Lotion) FREE

Cocoa 400 ML 550

Nourish BUY 1 GET 1
(Body Lotion) FREE
400 ML 500
Smooth
(Smooth 400
Milk)

25
Create Database : -

To collect the data or create the database Primary method is used. There are several way are used
to collect the data. For this study data Quastionnair survey method are used.

Created database some exaples are given bellow : -

Gender : - Total survey is 198 and from that 28.8% is male survey, female survey is
66.7% .

26
Trust level : - Most of the people trust the same brand which brand they use or buy.
Top three brand which is most of the people are use is Vaseline, Nivea and Mamaearth.
Vaseline users are 20.7%. Nivea users are 20.2%. and the mamaearth users are 20.7%.
And the most trusted brand are nivea, Vaseline and mamaearth.

27
As per the data quality of the moisturizer matters to the customers.
56.6% of the People prefer quality moisturizer. 14.1% people use organic brands. 10.6% people
prefer quantity.

28
 Mostly people prefer mild scented moisturizer. 66.5% people prefer mild scented
moisturizer.
46.2% people prefer non – scented moisturizer and the 3.6% people prefer strong scented
Moisturizer.

29
Huge amount of people want moisturizer as per their skin type. It is very imporstant to
Have moisturizer which is suit to there skin.

30
 D MART
BRAND TYPE QUANTITY M.R.P SELLING
PRICE

2L 430 319
ARIEL Matic Top Load

2L 430 305
TID Matic Top Load

2L 330 265
RIN Matic Liquid Pouch

TOP Load Matic 2L 430 330

SURF EXCEL Liquid
2L 490 375
Front Load

GENTEEL Liquid 2 kg 290 198

Detergent

Front Load 1L 245 BUY 1 GET 1

WIPRO FREE
SAFEWASH Top Matic 2L 430
330
Vendor Study :

Liquid Fabric Detergent : -

31
 BRAND TYPE QUANTITY M.R.P SELLING
PRICE

VANISH Liquid 800 ML 235 219

Matic Liquid 1L 220 205

SURF EXCEL
Easywash 1L 205 191

ARIEL Front Load 1L 265 247

Top Load 500 ML 120 95

KLIA
Front Load 500 ML 130 105

GENTEEL Kitted Bogo 1L 350 326

Gently Clean and

EZEE softens 1 kg 210 196
(Winterwear)

32
Create Database : -

To collect the data or create the database Primary method is used. There are several way are used
to collect the data. For this study data Quastionnair survey method are used.

Created database some exaples are given bellow : -

As per the diagram 69.8% female use liquid fabric detergent. And 30.2% male use liquid fabric
detergent. Here we can asume most of the users of fabric detergents are female.

33
Most of the people attract towards powder detergent. 74.1% people use powder detergent. And
43.7% people use liquid detergent.

34
Most of the people use Surf Excel, Ariel, and Rin. 45.2% people use Surf Excel, 20.6% people
use Ariel, and 15.1% people use Rin.

35
As per the diagram Quality, Brand, Quantity matter the most. 68.8% people prefer quality
20.1% people prefer brand.

36
Most of the people prefer mild scented fabric detergents. 75.8% people prefer mild scented
fabric detergent.

37
 Some people want to change there fabric detergent liquid and 16.8% people don’t want to
change
There fabric detergent.

38
Data Mining : -

 Data mining is the process of analyzing a large batch of information to discern trends and
patterns.
 Data mining can be used by corporations for everything from learning about what customers
are interested in or want to buy to fraud detection and spam filtering.
 Data mining programs break down patterns and connections in data based on what
information users request or provide.
 Social media companies use data mining techniques to commodify their users in order to
generate profit.
 This use of data mining has come under criticism lately as users are often unaware of the
data mining happening with their personal information, especially when it is used to
influence preferences.

Visualization : -

Data visualization is the representation of information and data using charts, graphs, maps, and
other visual tools. These visualizations allow us to easily understand any patterns, trends, or
outliers in a data set.

Data visualization also presents data to the general public or specific audiences without technical
knowledge in an accessible manner. For example, the health agency in a government might
provide a map of vaccinated regions.

The purpose of data visualization is to help drive informed decision-making and to add colorful
meaning to an otherwise bland database.

39
40
41
42
43
44
45
46
Data Analysis : -

Data analysis is the process of collecting, modeling, and analyzing data using various statistical
and logical methods and techniques. Businesses rely on analytics processes and tools to extract
insights that support strategic and operational decision-making.

All these various methods are largely based on two core areas: quantitative and qualitative
research.

Gaining a better understanding of different techniques and methods in quantitative research as

well as qualitative insights will give your analyzing efforts a more clearly defined direction, so
it’s worth taking the time to allow this particular knowledge to sink in. Additionally, you will be
able to create a comprehensive analytical report that will skyrocket your analysis.

Apart from qualitative and quantitative categories, there are also other types of data that you
should be aware of before dividing into complex data analysis processes.

These categories include:

 Big data: Refers to massive data sets that need to be analyzed using advanced software to
reveal patterns and trends. It is considered to be one of the best analytical assets as it
provides larger volumes of data at a faster rate.
 Metadata: Putting it simply, metadata is data that provides insights about other data. It
summarizes key information about specific data that makes it easier to find and reuse for
later purposes.
 Real time data: As its name suggests, real time data is presented as soon as it is acquired.
From an organizational perspective, this is the most valuable data as it can help you make
important decisions based on the latest developments. Our guide on real time analytics will
tell you more about the topic.
 Machine data: This is more complex data that is generated solely by a machine such as
phones, computers, or even websites and embedded systems, without previous human
interaction.

47
Abhyang Tel : -

Chi – Square test : -

1) To test the Brand Preference Hypothesis, use a chi-squared test for independence in R. This
test is suitable when you want to examine whether there is a significant association between
two categorical variables, such as brand preference, age groups, and genders.

● Null Hypothesis (H0): There is no significant difference in brand preference among

different age groups and genders.

● Alternative Hypothesis (H1): Brand preference varies significantly across age groups
and genders.

# Make sure the 'readxl' and 'xlsx' packages are installed

install.packages("readxl")

install.packages("xlsx")

# Load the required libraries

library(readxl)

# Read the Excel file

brand_data <- read_excel("C:\\Users\\Pragati\\Downloads\\AT_chi-square_test.xlsx")

# Rename the column names

colnames(brand_data) <- c("Age","Gender","Brand")

# Check for missing values

if (any(is.na(brand_data$Gender)) || any(is.na(brand_data$Brand))) {

stop("There are missing values in the 'Gender' or 'Brand' columns.")

# Create a contingency table

48
contingency_table <- table(brand_data$Gender, brand_data$Brand)

# Perform the chi-squared test

chi_result <- chisq.test(contingency_table)

print(chi_result)

Output : -

data: contingency_table
X-squared = 36.878, df = 40, p-value = 0.6116

49
2) The Chi-square test will help to determine if there are significant differences in trust levels
among different moisturizer brands. If the Chi result is significant, hoc analysis to identify
which specific brands show significant differences in trust levels.
 Null Hypothesis (H0): There is no significant difference in the level of trust among
different moisturizer brands.
 Alternative Hypothesis (H1): Certain brands are trusted more than others by the target
audience.
# Make sure the 'readxl' and 'xlsx' packages are installed
install.packages("readxl")
install.packages("xlsx")
# Load the required libraries
library(readxl)
# Read the Excel file
brand_data <- read_excel("C:\\Users\\Pragati\\Downloads\\AT_chi-
square_test.xlsx")
# Rename the column names
colnames(brand_data) <- c("trust","Brand")
# Check for missing values
if (any(is.na(brand_data$trust)) || any(is.na(brand_data$Brand))) {
stop("There are missing values in the 'trust' or 'Brand' columns.")
}
# Create a contingency table
contingency_table <- table(brand_data$trust, brand_data$Brand)
# Perform the chi-squared test
# Perform the chi-squared test
chi_result <- chisq.test(contingency_table)
print(chi_result)

Output : -
data: contingency_table
X-squared = 30.454, df = 8, p-value = 0.0001757

50
3) To test the Usage Times Hypothesis, you can use a chi-squared test for independence in R.
This test will help you examine whether there is a significant association between brand
preference and the time of day when moisturizer is used.

 Null Hypothesis (H0): The time of day when moisturizer is used does not significantly
impact brand choice.
 Alternative Hypothesis (H1): Brand preference is influenced by the time of day when
moisturizer is typically used.

# Make sure the 'readxl' and 'xlsx' packages are installed

install.packages("readxl")

install.packages("xlsx")

# Load the required libraries

library(readxl)

# Read the Excel file

brand_data <- read_excel("C:\\Users\\Pragati\\Downloads\\Time_brand.xlsx")

# Rename the column names

colnames(brand_data) <- c("Time", "Brand")

# Check for missing values

if (any(is.na(brand_data$Time)) || any(is.na(brand_data$Brand))) {

stop("There are missing values in the 'Time' or 'Brand' columns.")

# Create a contingency table

contingency_table <- table(brand_data$Time, brand_data$Brand)

# Perform contingency's exact test

chi_result <- chisq.test(contingency_table)

# View the results

print(chi_result)

51
Output : -

data: contingency_table
X-squared = 30.77, df = 30, p-value = 0.4268

52
Liquid Fabric Detergent : -
Chi-square test : -

1) Type of Detergent:
 H0: There is no significant difference in satisfaction levels between consumers who
prefer liquid detergent and those who prefer powder detergent.
 H1: Consumers who prefer liquid detergent have significantly higher satisfaction levels
compared to those who prefer powder detergent.

# Make sure the 'readxl' and 'xlsx' packages are installed

install.packages("readxl")
install.packages("xlsx")
# Load the required libraries
library(readxl)
# Read the Excel file
brand_data <- read_excel("C:\\Users\\Pragati\\Downloads\\fdl_chi-square_test.xlsx")
# Rename the column names
colnames(brand_data) <- c("Preferance","Satisfaction")
# Check for missing values
if (any(is.na(brand_data$Preferance)) || any(is.na(brand_data$Satisfaction))) {
stop("There are missing values in the 'Preferance' or 'Satisfaction' columns.")
}
# Create a contingency table
contingency_table <- table(brand_data$Preferance, brand_data$Satisfaction)
# Perform the chi-squared test
chi_result <- chisq.test(contingency_table)
# View the results
print(chi_result)
Output : -
data: contingency_table
X-squared = 199, df = 198, p-value = 0.4667
53
2) Detergent Brand:

 H0: There is no significant difference in satisfaction levels between consumers who trust
a specific detergent brand and those who do not express a strong brand preference.

 H1: Consumers who trust a specific detergent brand have significantly higher
satisfaction levels compared to those who do not express a strong brand preference.

# Make sure the 'readxl' and 'xlsx' packages are installed

install.packages("readxl")
install.packages("xlsx")
# Load the required libraries
library(readxl)
# Read the Excel file
brand_data <- read_excel("C:\\Users\\Pragati\\Downloads\\fdl_chi-
square_test.xlsx")
# Rename the column names
colnames(brand_data) <- c("Satisfaction","trust")
# Check for missing values
if (any(is.na(brand_data$Satisfaction)) || any(is.na(brand_data$trust))) {
stop("There are missing values in the 'Satisfaction' or 'trust' columns.")
}
# Create a contingency table
contingency_table <- table(brand_data$Satisfaction,brand_data$trust)
# Perform the chi-squared test
chi_result <- chisq.test(contingency_table)
# View the results
print(chi_result)

Output : -

data: contingency_table
X-squared = 199, df = 198, p-value = 0.4667

54
3) Purchase Decision Factors:

 H0: The factors influencing the purchase decision do not vary significantly across
different age groups.

 H1: The factors influencing the purchase decision vary significantly across different age
groups.

# Make sure the 'readxl' and 'xlsx' packages are installed

install.packages("readxl")
install.packages("xlsx")
# Load the required libraries
library(readxl)
# Read the Excel file
brand_data <- read_excel("C:\\Users\\Pragati\\Downloads\\fdl_chi-
square_test.xlsx")
# Rename the column names
colnames(brand_data) <- c("Age","Brand")
# Check for missing values
if (any(is.na(brand_data$Age)) || any(is.na(brand_data$Brand))) {
stop("There are missing values in the 'Age' or 'Brand' columns.")
}
# Create a contingency table
contingency_table <- table(X= brand_data$Age, brand_data$Brand)
# Perform the chi-squared test
chi_result <- chisq.test(contingency_table)
# View the results
print(chi_result)

Output : -
data: contingency_table
X-squared = 199, df = 198, p-value = 0.4667

55
QUALITY ASSURANCE

Meaning : -

The quality assurance process helps a business ensure its products meet the quality standards set
by the company or its industry. Another way to understand quality assurance (QA) is as a
company’s process for improving the quality of its products.

Many businesses view their QA program as a promise to internal stakeholders and customers
that the company will deliver high-quality products that provide a positive user experience.

Quality Assurance (QA) for skin care and home care products is essential to ensure safety,
efficacy, and consistency. Let’s explore how QA applies to these products:

1. Cosmetics and Skin Care Products:

o Quality Control (QC): This involves testing raw materials, intermediates, and finished
products. It ensures that the product meets defined specifications.
o Good Manufacturing Practice (GMP): GMP ensures that cosmetics are produced
consistently and meet quality standards. It covers aspects like hygiene, documentation,
and facility maintenance.
o Integrated Quality Control: QA integrates quality control at every step, from raw
material sourcing to packaging. It aims to prevent defects and maintain uniform
quality1.

2. Safety and Consumer Protection:

o QA ensures that cosmetics are safe for use. It involves assessing ingredients, stability,
and potential allergens.
o The ultimate goal is to protect consumers’ well-being and safety. QA cannot rely solely
on end-product testing; it must be integrated throughout the production process1.

3. Home Care Products:

o QA for home care products (such as cleaning agents, detergents, and disinfectants)
follows similar principles.
o It involves testing raw materials, ensuring proper labeling, and verifying compliance
with safety regulations.
o Integrated QA ensures consistent quality and safety for household products1.

4. Third-Party Services:
o Companies often partner with third-party quality assurance services to verify product
safety and compliance.
o These services assess ingredients, stability, labeling, and overall quality.
o QIMA, for example, offers comprehensive QA services for cosmetics and beauty
products
56
 CHAPTER : - 7

OBSERVATION AND FINDING

57
 OBSERVATIONS AND FINDINGS

Holistic healthcare Quality assurancy : -

All the products are carefully formulated using the finest ingredients to ensure maximum
effectiveness and safety for of the customers. At holistic healthcare, they are dedicated to
customer satisfaction. They work closely with their customers to understand their needs and
provide tailored solutions that meet their specific requirements. Holistic hrealthcare are
committed to providing exceptional customer service, ensuring that our customers receive the
support they need, whenever they need it.

1.Customer Demographics:

Observation:
The customer base in the homecare and skin care domain is diverse, with a significant
representation across various age groups and geographical locations.

Finding:
Age group, Gender here the null hypothesis is rejected. There is no significiant difference.

2. Product Preferences and Time:

Observation:
Through analysis, it's evident that certain skincare products are more popular than others.

Finding:
Focusing marketing efforts on promoting popular products and understanding the reasons
behind their popularity can inform product development and inventory management.
Here the null hypothesis is accepted means there is difference in Preferance and time

3. Seasonal Trends:

Observation:
Seasonal variations impact customer purchasing behavior, with a surge in certain products
during specific times of the year.

Finding:
Implementing seasonal marketing campaigns and adjusting inventory levels accordingly can
optimize sales and customer satisfaction.

58
Liquid Fabric detergent : -

1. Customer Satisfaction:

Observation:
Customer reviews and feedback indicate high satisfaction with the effectiveness of homecare
and skincare products.

Finding:
Leveraging positive customer testimonials in marketing materials can enhance brand reputation
and attract new customers.

2. Social Media Impact:

Observation:
Social media mentions and interactions significantly influence customer engagement in the
homecare and skincare domain.

Finding:
Investing in social media marketing and monitoring online conversations can be crucial for
brand awareness and customer relationship management.

3. Brand Loyalty:

Observation:
A portion of customers exhibits strong brand loyalty, repeatedly purchasing specific products.

Finding:
Implementing loyalty programs or personalized promotions for repeat customers may further
enhance customer retention.

4. Influencer Collaborations:

Observation:
Collaborations with influencers in the homecare and skincare space have a noticeable impact on
customer engagement.

Finding:
Continuing influencer partnerships and exploring new collaborations can be a viable marketing
strategy.

59
5. Product Bundling Opportunities:

Observation:
Certain combinations of homecare and skincare products are frequently purchased together.

Finding:
Introducing bundled product offerings or cross-selling complementary items can capitalize on
these purchasing patterns.

11. Customer Communication Preferences:

Observation: Customers show a preference for email communication for product updates and
promotions.

Finding: Tailoring communication channels based on customer preferences, such as email

marketing, can improve message reception and engagement.

60
 LIMITATIONS

1. Sample Size and Representation:

Limitation:
The analysis is based on a specific dataset, and the sample size may not fully represent the entire
customer population in the homecare and skincare domain.
Implication:
Generalizing findings to the broader market should be done cautiously. Consideration of a more
diverse dataset in future studies could provide a more comprehensive understanding.

2. Data Quality and Accuracy:

Limitation:
The accuracy of findings is contingent on the quality of the input data. Incomplete or inaccurate
data may impact the reliability of results.
Implication:
Efforts to improve data quality, such as regular data audits and validation, should be prioritized.
It's also essential to acknowledge potential biases in the data.

3. Privacy and Ethical Considerations:

Limitation:
Customer data, especially in the skincare domain, may include sensitive information. Ensuring
compliance with privacy regulations and ethical standards is challenging but essential.
Implication:
Continuous vigilance in adhering to data protection regulations and ethical guidelines is crucial.
Transparency with customers about data usage is also necessary to maintain trust.

4. External Influences:

Limitation:
External factors, such as economic conditions, global events, or industry trends, may have
influenced customer behavior during the analysis period.
Implication:
While the analysis provides insights into customer data, external factors should be considered in
the interpretation of results. Long-term monitoring and sensitivity analyses can help account for
external influences.

61
5. Limited Customer Feedback Channels:

Limitation:
The analysis relies on available customer feedback channels, and feedback from less common
channels may be underrepresented.
Implication:
Exploring additional feedback channels, such as direct interviews or surveys, can provide a more
comprehensive understanding of customer sentiments and preferences.

6. Inability to Causally Link Variables:

Limitation: The analysis identifies correlations between variables, but establishing causal
relationships may be challenging.
Implication: Future research could incorporate experimental designs or advanced statistical
methods to explore causal links between specific marketing strategies and customer behavior.

7. Dynamic Nature of Social Media:

Limitation: Social media data is dynamic and subject to rapid changes in trends and user
behavior.
Implication: Real-time monitoring and periodic updates to the analysis may be necessary to
capture emerging trends and shifts in customer sentiment on social media platforms.

62
CHAPTER 8

CONCLUSION

63
 CONCLUSION

The analysis of customer data within the homecare and skincare domain has provided valuable
insights into consumer behavior, preferences, and market dynamics. Through a comprehensive
examination of various aspects, we have uncovered patterns and trends that can significantly
impact business strategies and decision-making.
As per the chi-square test Brand preference varies significantly across age groups and genders.
And There is no significant difference in the level of trust among different moisturizer brands.
And Brand preference is influenced by the time of day when moisturizer is typically used.

64