Categories
Writers Solution

Objects or variables are clustered into homogeneous groups that are similar to each other and dissimilar to other groups.

one using RStudio Programming programm.

Cluster Analysis
(hierarchical & non-hierarchical)
• Grouping/clustering similar objects/cases (or also variables) into groups.
• Homogeneous/heterogeneous groups? • Segments? – Segmentation
• Profiles?
• Grouping variables?
[see also: N. K. Malhotra & D. F. Birks, 2007, Marketing Research: An Applied Approach (Chapter 23:
Cluster Analysis), 3rd European Edition, Prentice Hall, Inc., Pearson Education Limited, Essex, England.] Modul University Vienna
Aim
• Objects or variables are clustered into homogeneous groups that are similar to each other and dissimilar to other groups.
• Group/cluster membership is not known in advance. There is no a priori information. A data-driven grouping solution is produced.
• Number of clusters not fixed in advance when using hierarchical clustering but is selected subsequent to the procedure. Using nonhierarchical clustering the number of clusters has to be pre-specified. Different solutions should be compared.
• Optimum result for k clusters is not necessarily the same as hierarchical result for the kth step
• Result may heavily depend on the procedure chosen!
You will always get some cluster solution, also if there are no reasonable clusters!
Importing data in R: .csv-files
Locate the file and enter the path and file name to import the dataset

Modul University Vienna
Scatterplot
How many cultural and sporty activities would you plan for a one month trip?
Optional: Standardization
If variables used for cluster analysis are measured on different scales, they have to be standardized in the forefront (Z scores most frequently used). Otherwise measurement scale differences may have an influence on the result!
Standardization:
[Mean value deducted from every observation and divided by the standard deviation.]
Modul University Vienna
Hierarchical clustering procedure
Clustering procedure for hierarchical clustering can be
• agglomerative – every object starts in a separate cluster which are grouped into bigger and bigger clusters until all objects are in one cluster
• or divisive – a single cluster with all objects is split up until all objects are in separate clusters (also see Dendrogram) Linkage methods:
• Single linkage = nearest neighbour
• Complete linkage = farthest neighbour
• Average linkage = average distance between all pairs
• Centroid method = distance between cluster centroids
• Variance methods (minimize within-cluster variance) Ward‘s method – most frequently used! – combines clusters with smallest increase in overall sum of squared distance to the cluster means
Hierarchical clustering
Distance measure
• Similarity is determined by the distance between groups
• Default: Squared Euclidean distance – most often used – interval scale;
(v=number of variables, X and Y are the objects to be compared) various alternative distance measures available for interval, counts or binary data: e.g. City-Block or Manhattan-distance (sum of absolute distances), for binary data: -distance
Depending on the chosen distance measure results may change!
Modul University Vienna
Perform cluster analysis

Agglomeration schedule
• X1 and X2: If the values are negative, the two observations were merged at this stage (singleton agglomerations). If it is positive, it was merged at a former stage of the algorithm (non-singleton observations).
• cluster height: the criterion usedfor the agglomeration procedure (here the squared Euclidean distance).
• One can observe a dramatic increase in step 37. Further collapsing the 3 to two clusters will be problematic.
Modul University Vienna
Dendrogram
• Vertical lines represent distances between clusters that are put together.
• Coefficients are rescaled, here 0-50.
How many clusters
• Distances of last two stages are very large.
• Decision on three clusters? Or two? Depends on objectives!
• …are relevant in terms of practical/managerial considerations?
• Theoretically based? Literature?
• Useful sizes?
• Meaningful interpretation of cluster characteristics possible?
• Distance between clusters?
Modul University Vienna
Dendrogram
• Distances of last two stages are very large.
• Decision on three clusters? Or two? Depends on objectives!

Cluster membership and information
• Cluster membership variable of the 3 cluster solution is produced.

• The 1st group has 15 observations, the 2nd and 3rd have 12.

• The 1st group is neither interested in culture nor sports. The 2nd group is interested in culture but not in sports. The 3rd group is interested in sports but not in culture.
Modul University Vienna
Non-hierarchical clustering: k-means
• Disadvantage: Number of clusters has to be a priori fixed!!!
• Advantage: computationally less burdensome compared with hierarchical cluster analysis if many observations are contained in the dataset
• Optimising partitioning: Objects are reassigned iteratively between clusters and do not necessarily stay within one cluster once assigned to it (contrary to hierarchical clustering)
• Iteration:
1. Each objects is assigned to the cluster with thenearest cluster center (least squared Euclidean distance)
2. Recalculation of cluster centers
3. Loop: Continue with step 1
Distance measure
• Similarity (between preferably interval scaled variables) is determined by the squared Euclidean distance
• Notation: n=number of observations i=1,…,n
x and y are the objects to be compared
• The variance (squared Euclidean distances between all clustering variables and the centroid of each cluster), or socalled within cluster variation, is minimized.

Modul University Vienna
Number of clusters, iteration and random starts
• The number of clusters must be specified a priori!!!
• k-means uses an iterative algorithm to determine the cluster centers (1. objects are assigned to nearest cluster center, 2. calculation of cluster center, 3. continues with step 1). iter.max sets the maximum number of iterations. During classification the algorithm will continue iterating until iter.max iterations have been conducted or the convergence criterion is reached.
• Hint: A high iter.max value is recommended (e.g. 1,000) to allow for a high number of iteration steps and the algorithm to converge.
• As the final result depends on the starting values, k-means clustering should be run with several random starting values, here 25. The one with the lowest within-cluster variation will automatically be selected.
Random starts
• The a priori selected number of clusters must be specified!!!
• k-means uses an iterative algorithm to determine the cluster centers. iter.max sets the maximum number of iterations. During classification the algorithm will continue iterating until iter.max iterations have been done or the convergence criterion is fulfilled.
• If convergence criteria is not achieved the number of maximum iterations has to be increased until enough iteration steps (1. objects are assigned to nearest cluster center, 2. calculation of cluster center, 3. continues with step 1) are processed.
• Hint: A high max_iter value is recommended (e.g. 1,000) to allow for a high number of iteration steps and the algorithm to converge.
Modul University Vienna
Perform k-means clustering

• The number of cases in each cluster shows the size of each cluster in the dataset.
• Cluster means are the means of variables within clusters.
• Cluster vector = cluster membership
Cluster membership
• The cluster membership shows the case number in the rownames
(values 1 to 39) and the cluster number in the kcluster.cluster column.
• Case number 1 belongs to cluster 3, case number 13 belongs to cluster 1…
Modul University Vienna
Print k-means solution and cluster center
• Final Cluster Centers are the means of variables within clusters.

Cluster comparison
• Attention!
Judgement of differences between clusters for variables used in the algorithm via t-test or ANOVA?
No hypothesis test in the usual meaning, just descriptive!
Just an indicator which variables are relevent for clustering.
= Proper validation only by means of an external criterion not involved in cluster analysis!
= Profiling
Modul University Vienna
Profiling
• First, groups are described on the basis of the variables used for k-means clustering.
• Second, profiling describes clusters by means of other relevant variables not used during the clustering procedure (e.g. demographic, psychographic, geographic… characteristics).

GET THE COMPLETED ASSIGNMENT

ASSIGNMENT COMPLETED AT CapitalEssayWriting.com

MAKE YOUR ORDER AND GET THE COMPLETED ORDER

CLICK HERE TO ORDER THIS PAPER AT CapitalEssayWriting.com ON  Objects or variables are clustered into homogeneous groups that are similar to each other and dissimilar to other groups.

NO PLAGIARISM, Get impressive Grades in Your Academic Work

Categories
Writers Solution

CREATE A CLUSTERED COLUMN CHART OBJECT FOR CELLS A4:G9.

For this project, you create a column chart to illustrate April–September revenue for Classic Gardens and Landscapes. You also build a pie chart sheet to graph the proportion that each category contributes to total revenue.

[Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6]

File Needed: ClassicGardens-03.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-ClassicGardens-03.xlsx

SKILLS COVERED IN THIS PROJECT

  • Create a chart object.
  • Size and position a chart object.
  • Edit and format chart elements.
  • Edit the source data for a chart.
  • Build a pie chart sheet.
  • Use texture as fill.
  • Add and format data labels in a chart.

Alternate Instruction for Microsoft 365 Apps icon This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

  1. OPEN THE CLASSICGARDENS-03.XLSX START FILE. IF THE WORKBOOK OPENS IN PROTECTED VIEW, CLICK THE ENABLE EDITING BUTTON SO YOU CAN MODIFY IT. THE FILE WILL BE RENAMED AUTOMATICALLY TO INCLUDE YOUR NAME. CHANGE THE PROJECT FILE NAME IF DIRECTED TO DO SO BY YOUR INSTRUCTOR, AND SAVE IT.

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

  1. CREATE A CLUSTERED COLUMN CHART OBJECT FOR CELLS A4:G9.
  2. MOVE THE CHART OBJECT SO THAT ITS TOP-LEFT CORNER IS AT CELL A12. SIZE THE BOTTOM OF THE CHART TO REACH CELL H30.
  3. EDIT THE CHART TITLE TO DISPLAY CGL MAJOR SALES REVENUE AND PRESS RETURN. ON THE SECOND LINE, TYPE SECOND AND THIRD QUARTERS.
  4. APPLY CHART STYLE 14 TO THE CHART.
  5. FORMAT THE FIRST LINE AND THE SECOND LINE OF THE CHART TITLE TO A FONT SIZE OF 20 PT.
  6. APPLY A 1 PT BLACK, TEXT 1 (SECOND COLUMN) OUTLINE TO THE CHART AREA.
  7. VERIFY THAT THE CHART IS STILL SELECTED. IN THE HIGHLIGHTED RANGE IN THE WORKSHEET, DRAG THE RESIZE POINTER TO REMOVE THE DESIGN CONSULTING DATA SERIES FROM THE CHART (FIGURE 3-71).Resize handle is lower-right corner of cell G8Figure 3-71 Resize the chart by dragging the resize pointer
  8. CREATE A 3-D PIE CHART SHEET FOR CELLS A4:A9 AND CELLS H4:H9. MOVE THE CHART TO ITS OWN SHEET NAMED REVENUE BREAKDOWN. HINT: USE THE MOVE CHART BUTTON [CHART DESIGN TAB, LOCATION GROUP].
  9. EDIT THE CHART TITLE TO DISPLAY REVENUE BY CATEGORY. CHANGE THE FONT SIZE TO 32.
  10. SELECT THE LEGEND AND CHANGE THE FONT SIZE TO 12.
  11. APPLY THE WOVEN MAT TEXTURE FILL (FIRST ROW, FOURTH COLUMN) TO THE PATIO AND FURNITURE SLICE.
  12. Select the pie shape and add data labels to display in the center of each slice.
    1. DISPLAY THE FORMAT DATA LABELS TASK PANE, CHOOSE THE ACCOUNTING FORMAT [LABEL OPTIONS BUTTON, NUMBER GROUP], AND SET 0 DECIMAL PLACES.
    2. CHANGE THE DATA LABEL FONT SIZE TO 14 PT AND APPLY BOLD [HOME TAB, FONT GROUP].
  13. DESELECT THE CHART.
  14. SAVE AND CLOSE THE WORKBOOK (FIGURE 3-72).Excel 3-4 completed chart sheetsFigure 3-72 Excel 3-4 completed worksheet and chart
  15. UPLOAD AND SAVE YOUR PROJECT FILE.
  16. SUBMIT PROJECT FOR GRADING.
  • GET SOLUTION FOR THIS ASSIGNMENT

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    NO PLAGIARISM

    • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
    • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
    • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
    • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
    • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
    • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. CREATE A CLUSTERED COLUMN CHART OBJECT FOR CELLS A4:G9.
    • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services.

    Get Professionally Written Papers From The Writing Experts 

    Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays