can provide the documents with this problem theough email just comment

Exercise 1:

Open the College - JMP file.

Open Graph Builder: create a scatter plot with the regression line graph where:

y-axis = stud./fac. ratio

x-axis = Combined Math Verbal

Color = College Name

Take a snapshot of the graph.

A. Insert graph snapshot in PPT slide. Make a heading. In a text box state the 2 lowest stud./fac. ratio schools? Give their name, ratio, combined Math Verbal.

B. Run a K-means Cluster analysis using all the continuous variables except Graduation Rate. Number of Clusters set to range from 4 to 8 clusters.

a. Using CCC decide which solution is best.

b. Close the results for the clusters not the best according to CCC.

c. Color and save Clusters in the data table.

d. Create the Parallel Coordinate Plot for these cluster. Take screenshot of 2 cluster plots at a time. Create a slide for each of these cluster pairs. In a text box state for each cluster by its number state peak variables.

e. On the slide with final set of parallel plots state which clusters have very high stud./fac. Ratios?

C. Run a Fit Model where: y = graduation rate; x = cluster

a. Create a prediction profiler

b. In one screenshot capture the Summary of Fit table, Analysis of Variance table, Effects Tests table, and the Prediction Profiler. Put it in a slide. In a text box give the your assessment of how well this cluster solution predicts graduation rates and which cluster has the highest ratio of graduates.

D. In the data table sort the table by cluster. Which schools are those in the cluster with the highest graduation rates. In a new slide state which schools they are.

Exercise 2:

In tableau open the file global_superstore, Join sheets orders and returns.

Reference: https://help.tableau.com/v2020.1/pro/desktop/en-us/joining_tables.htm

Your goal is to create a 2 sheet dashboard.

Sheet 1:

a. Columns put Returned, Category, and Segment

b. Rows put SUM (Number of Records)

c. Color Segment

d. Create a column graph of Returned/Category/Segment

e. Sort decending

f. Take a screenshot and put in a slide

g. In a text box state which category overall had the most returns and give a total number. In the same text box state which segment overall had the most returns and give a total number.

Sheet 2:

a. Columns put Category and Segment

b. Rows put SUM (Sales)

c. Color by Segment

d. Create a column graph Category/Segment

e. Sort decending

f. Take a screenshot and put in a slide

g. In a text box state which category overall had the most sales and give a total number. In the same text box state which segment overall had the most sales and give a total number.

Now create your dashboard using the two sheets.

a. Label the sheets in the dashboard and take a screenshot and put the dashboard in a slide.

b. Is the category with the most sales the same with the most returns? In a text box answer the question: Yes or No; and restate which category has the most sales and which category has the most returns.