graph in excel to represent correlation of 3 parametersHow to create a 4 variables chart in excel?How to plot...
Where are a monster’s hit dice found in the stat block?
How would a Dictatorship make a country more successful?
The effects of magnetism in radio transmissions
Eww, those bytes are gross
Does Windows 10's telemetry include sending *.doc files if Word crashed?
Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?
A minimum of two personnel "are" or "is"?
Checking for the existence of multiple directories
Book where aliens are selecting humans for food consumption
Help Me simplify: C*(A+B) + ~A*B
How to convert a ListContourPlot into primitive usable with Graphics3D?
Can an insurance company drop you after receiving a bill and refusing to pay?
Isn't using the Extrusion Multiplier like cheating?
Can you earn endless XP using a Flameskull and its self-revival feature?
What is the in-universe cost of a TIE fighter?
Difference between two quite-similar Terminal commands
Contest math problem about crossing out numbers in the table
Why do members of Congress in committee hearings ask witnesses the same question multiple times?
Why Normality assumption in linear regression
Disable the ">" operator in Rstudio linux terminal
How to explain planetary rings pulsating?
If I delete my router's history can my ISP still provide it to my parents?
We are very unlucky in my court
Quenching swords in dragon blood; why?
graph in excel to represent correlation of 3 parameters
How to create a 4 variables chart in excel?How to plot a line chart with multiple “Y” axis variables of different units?Zero values in Excel logarithmic chart: Can the warning be suppressed?EXCEL: Want to incorporate two charts in one line graph (with averages)Is it possible to edit the source representation of objects in Excel?Running Excel Line Graph?How to Fix Excel Graph to stop drawing line when data ends (not auto extend line to zero)?Running excel line graphWhat is the use of standard deviation error bar in excel?How to graph data interval versus price in Excel?How to use excel to graph time points with proper spacing?Excel 2016 chart to compare growth with 4 parameters
I have some data in excel and I would like to make a graphical representation of those data. Structure of my data:
persons ID : from 1 to 485 to every person, there is one parameter like average jumping distance and another parameter (like height) and finally there is a class to which every person belongs to (1, 2 or 3).
To assign persons to classes I have used k-means algorithm.
Now I would like to make a graph of this result. How can I do it please in excel (or by using another tool)?
Thank you
microsoft-excel charts
asked May 23 '14 at 16:30
user2179427user2179427
12
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have some data in excel and I would like to make a graphical representation of those data. Structure of my data:
persons ID : from 1 to 485 to every person, there is one parameter like average jumping distance and another parameter (like height) and finally there is a class to which every person belongs to (1, 2 or 3).
To assign persons to classes I have used k-means algorithm.
Now I would like to make a graph of this result. How can I do it please in excel (or by using another tool)?
Thank you
microsoft-excel charts
asked May 23 '14 at 16:30
user2179427user2179427
12
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have some data in excel and I would like to make a graphical representation of those data. Structure of my data:
persons ID : from 1 to 485 to every person, there is one parameter like average jumping distance and another parameter (like height) and finally there is a class to which every person belongs to (1, 2 or 3).
To assign persons to classes I have used k-means algorithm.
Now I would like to make a graph of this result. How can I do it please in excel (or by using another tool)?
Thank you
microsoft-excel charts
asked May 23 '14 at 16:30
user2179427user2179427
12
I have some data in excel and I would like to make a graphical representation of those data. Structure of my data:
persons ID : from 1 to 485 to every person, there is one parameter like average jumping distance and another parameter (like height) and finally there is a class to which every person belongs to (1, 2 or 3).
To assign persons to classes I have used k-means algorithm.
Now I would like to make a graph of this result. How can I do it please in excel (or by using another tool)?
Thank you
microsoft-excel charts
microsoft-excel charts
asked May 23 '14 at 16:30
user2179427user2179427
12
asked May 23 '14 at 16:30
user2179427user2179427
12
asked May 23 '14 at 16:30
user2179427user2179427
12
asked May 23 '14 at 16:30
user2179427user2179427
12
asked May 23 '14 at 16:30
user2179427user2179427
12
12
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The answer depends on what you're trying to show. You could do something as simple as an XY/Scatter Chart with Jumping Distance and Height on your Axis and your Class encoded by marker shape or color. A basic, exploratory chart may look like this:
If you're trying to distinguish the three classes, I recommend a Lattice Chart (Small Multiples) with three identically structured charts (same Axis categories and scales), each showing one Class. In the image below, the same data is shown in two variations, one per row. The first series (row) is a basic small multiple, with the original point formatting (from the image above) maintained. In the second series (row), all the points were left on the chart for reference, with each class individually highlighted.
answered May 23 '14 at 16:45
davdav
7,69532043
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f757980%2fgraph-in-excel-to-represent-correlation-of-3-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The answer depends on what you're trying to show. You could do something as simple as an XY/Scatter Chart with Jumping Distance and Height on your Axis and your Class encoded by marker shape or color. A basic, exploratory chart may look like this:
If you're trying to distinguish the three classes, I recommend a Lattice Chart (Small Multiples) with three identically structured charts (same Axis categories and scales), each showing one Class. In the image below, the same data is shown in two variations, one per row. The first series (row) is a basic small multiple, with the original point formatting (from the image above) maintained. In the second series (row), all the points were left on the chart for reference, with each class individually highlighted.
answered May 23 '14 at 16:45
davdav
7,69532043
add a comment |
The answer depends on what you're trying to show. You could do something as simple as an XY/Scatter Chart with Jumping Distance and Height on your Axis and your Class encoded by marker shape or color. A basic, exploratory chart may look like this:
If you're trying to distinguish the three classes, I recommend a Lattice Chart (Small Multiples) with three identically structured charts (same Axis categories and scales), each showing one Class. In the image below, the same data is shown in two variations, one per row. The first series (row) is a basic small multiple, with the original point formatting (from the image above) maintained. In the second series (row), all the points were left on the chart for reference, with each class individually highlighted.
answered May 23 '14 at 16:45
davdav
7,69532043
add a comment |
The answer depends on what you're trying to show. You could do something as simple as an XY/Scatter Chart with Jumping Distance and Height on your Axis and your Class encoded by marker shape or color. A basic, exploratory chart may look like this:
If you're trying to distinguish the three classes, I recommend a Lattice Chart (Small Multiples) with three identically structured charts (same Axis categories and scales), each showing one Class. In the image below, the same data is shown in two variations, one per row. The first series (row) is a basic small multiple, with the original point formatting (from the image above) maintained. In the second series (row), all the points were left on the chart for reference, with each class individually highlighted.
answered May 23 '14 at 16:45
davdav
7,69532043
The answer depends on what you're trying to show. You could do something as simple as an XY/Scatter Chart with Jumping Distance and Height on your Axis and your Class encoded by marker shape or color. A basic, exploratory chart may look like this:
If you're trying to distinguish the three classes, I recommend a Lattice Chart (Small Multiples) with three identically structured charts (same Axis categories and scales), each showing one Class. In the image below, the same data is shown in two variations, one per row. The first series (row) is a basic small multiple, with the original point formatting (from the image above) maintained. In the second series (row), all the points were left on the chart for reference, with each class individually highlighted.
answered May 23 '14 at 16:45
davdav
7,69532043
edited May 23 '14 at 17:09
answered May 23 '14 at 16:45
davdav
7,69532043
answered May 23 '14 at 16:45
davdav
7,69532043
answered May 23 '14 at 16:45
davdav
7,69532043
7,69532043
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f757980%2fgraph-in-excel-to-represent-correlation-of-3-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
