Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The data set for your analysis includes variables related to Global Bikes most recent sales data. You should be familiar with most of the variables,

The data set for your analysis includes variables related to Global Bike’s most recent sales data. You should be familiar with most of the variables, but here are some hints on this data set.
The sales team at Global Bike (GB) is concerned about new competitors in the market. A strategic planning meeting is scheduled for the first of the month. Your job is to explore the data and provide insights into GB’s current customer base and sales data. Nina Kane and her colleagues in Germany believe that Global Bike has 4 groups of customers with distinct characteristics. She also knows that customers have changed over the past few years and so any analysis that you provide on the groups should be focused on the newest data available.


Global Bike Case Study

Product

ProdDescr

ProdCat

CatDescr

Division

SalesQuantity

RevenueUSD

DiscountUSD

CostsUSD

PRTR1000

Professional Touring Bike-Black

TOU

Touring Bike

BI

4

14080.02

422.41

8320

DXTR1000

Deluxe Touring Bike-Black

TOU

Touring Bike

BI

8

26400

792

15600


Create a cluster analysis for Nina.

1. What can you tell Nina about the customer groups? 

2. Define how you clustered the transactions for Nina. 

3. What variables did you use? 

4. Did you use any filters? 

5. If so what were they?

Step by Step Solution

3.42 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

1 What can you tell Nina about the customer groups Cluster analysis is a method of data analysis used to define and identify customer groups Cluster analysis helps to determine customer segments which ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transport Operations

Authors: Allen Stuart

2nd Edition

978-0470115398, 0470115394

More Books

Students also viewed these General Management questions