In Progress

Clustering analysis using R.

For this project, i need to add the output of our clustering analysis to the JC Dollars customer

data and characterize the segments.

1. Calculate the following demographic measures for each segment (cluster):

● Segment size (# of customers)

● Average age

● Average monthly income

● Average household size

● % Salaried

● % Self-employed

● % Homemakers

● % Single

● % Married

● % Homeowners

● % Responding to Promotion

Format output as if you will present this data to your manager (i.e., make your row labels easy to understand; round to a reasonable number of decimal places, etc).

2. Calculate the following financial measures for each segment (cluster):

● Average total spending in last 6 months

● Average basket margin

● Sum of total spending in the last 6 months

● Total profit per segment

You may add additional category-specific measures to this list if you would like.

3. Using the tables you created in parts 1 and 2, think about the key characteristics of each

segment. What sets each segment apart from the others in terms of demographics and

spending habits? Now, come up with a name for each segment and a brief description of the

key demographics (some variables will be more important than others, depending on the

segment). Use Powerpoint, Word, or a similar program to create a list or visual of the segment


Skills: R Programming Language, Research Writing, Statistical Analysis, Statistics

See more: compare tables using excel macro, populate summary agregate tables using informatica, creating tables using, k means clustering source code in r, k means cluster analysis in r, clustering in r tutorial, k means clustering r tutorial, how to interpret k-means clustering results in r, cluster package in r, clustering in r example, practical guide to cluster analysis in r pdf, display mysql tables using smarty php, expande collapse tables using javascript, oledb connection string pivot tables using vbscript, clone tables using php, create oracle database tables using sql, create oracle database tables using sql ddl, clustering analysis using excel, using excel for statistical analysis, Using R and TreePlan, perform software management tasks and answer questions about decision trees for these questions.

About the Employer:
( 5 reviews ) New Jersey, United States

Project ID: #18005270

14 freelancers are bidding on average $64 for this job


Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

$150 USD in 10 days
(156 Reviews)

I have a good hands on working with Advanced Excel, R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Application. My ar More

$100 USD in 10 days
(68 Reviews)

1. I am an expert in R programming, Statistics, regression analysis, using both Excel and SPSS, also expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done man More

$120 USD in 3 days
(113 Reviews)

Helllo I can achieve this project perfectly using R I can make classification using decision tree and kmeans please contact me for more details about the project best regards

$50 USD in 3 days
(45 Reviews)

I am an expert in data science, I've done a lot of projects in the field involving data pre-processing, data visualization, building predictive and clustering models using R and python, contact me for further discussio More

$10 USD in 2 days
(26 Reviews)

I have Masters degree in Economics and Statistics with 7years of professional experience working as a Quantitative Analyst (in the field of Statistics). A professional statistical analyst seeking opportunity to provid More

$75 USD in 1 day
(23 Reviews)

Hello I have been writing for over 5 years. My aim is to use my research skills, knowledge and experience in order to provide a high quality piece that meets your expectations. Please hire me, you will have the paper b More

$55 USD in 3 days
(17 Reviews)

With a 20 years of teaching experience at undergraduate level, I have a [login to view URL] Degree in Statistics and a Masters Degree in Software Engineering as well. I have taught courses like Probability for Engineers (to Materia More

$60 USD in 3 days
(3 Reviews)

Hi we are expert in R and python we are working for machine learning and data science supervised and unsupervised algorithms e.g Decision trees, SVM, Random forest, KNN, Regression, Clustering, ANN, RNN and specifica More

$20 USD in 10 days
(8 Reviews)

Hi, I am glad to connect with you. How are you doing today? I went through your project description and excel files. I express my interest to take up this work. To tell you about me: I have been working on Machin More

$111 USD in 3 days
(3 Reviews)

Hi, I can do your cluster analysis for you by using R programming language. I am a statistician by professional.I possessed master of science in statistics. I will ensure your best requirements. Relevant Skills and Ex More

$25 USD in 2 days
(1 Review)

Hello I'm Tim, a native Taiwanese. I'm a graduate student majoring in finance in National Chnug Cheng university in Taiwan graduated in 2017 June. I’m a passionate investment researcher who has experience researchin More

$45 USD in 10 days
(1 Review)

Hi, I am a data scientist and I have more than 3 years professional experience in this field. The task is quite simle for me and I required 4 days since I am working.

$50 USD in 4 days
(0 Reviews)

I am currently working as an expert in the field of social networking security using data science algorithms. Relevant Skills and Experience Master of Computer Engineering (Data Mining).

$30 USD in 10 days
(0 Reviews)