Create a statistic for a sum that has been normalized with two other values Announcing the...
Antler Helmet: Can it work?
Using et al. for a last / senior author rather than for a first author
What is a Meta algorithm?
When to stop saving and start investing?
Does accepting a pardon have any bearing on trying that person for the same crime in a sovereign jurisdiction?
If 'B is more likely given A', then 'A is more likely given B'
What LEGO pieces have "real-world" functionality?
What is the correct way to use the pinch test for dehydration?
When -s is used with third person singular. What's its use in this context?
Disable hyphenation for an entire paragraph
Does surprise arrest existing movement?
How much radiation do nuclear physics experiments expose researchers to nowadays?
How to motivate offshore teams and trust them to deliver?
Letter Boxed validator
What's the purpose of writing one's academic bio in 3rd person?
Check which numbers satisfy the condition [A*B*C = A! + B! + C!]
Is there a service that would inform me whenever a new direct route is scheduled from a given airport?
Why one of virtual NICs called bond0?
How widely used is the term Treppenwitz? Is it something that most Germans know?
What is the longest distance a 13th-level monk can jump while attacking on the same turn?
Why is "Captain Marvel" translated as male in Portugal?
Did Kevin spill real chili?
Did Xerox really develop the first LAN?
How to recreate this effect in Photoshop?
Create a statistic for a sum that has been normalized with two other values
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Idempotence and the Rao–Blackwell theoremHow to test null hypothesis for spatial distribution?Making sense of 1-dimensional dataHow to extract an individual's (normalized) contribution from a group?Where should I use median instead of average?Grading system with multiple judgesStandard Deviation Divided by ErrorHow to formulate statistical hypothesis testing for a table of dataPrediction modelling using two categorical variablesUsing the normal distribution to find the probability of getting an exact value
$begingroup$
I'm trying to create a statistic about certain measurements normalized with other set of measurements. In the end I have to create a value that will represent the normalized measurements altogether.
As shown below in the table I have a variable called Entity for which a set of measurements is shown in the Value column. For the Entity variable I have other two measurement called n1 and n2 which I need to use to normalize the values in the Value column.
If I try to normalize Value per n1 the result shown in Value/n1 makes sense. By this I mean that the "ALL" value for the Entity variable can be compared with every other individual value, meaning that it is similar to all other individual values and can be used to show whether the other values are above or below a certain average (not certain if it can be called average).
The same case is when I normalize Value with n2.
The problem arises when I normalize Value per n1 and n2. In this case the "ALL" case has significantly lower value than all other individual cases in the Value/(n1*n2) column.
Forgive my poor terminology and lack of knowledge for type of statistic calculation. My background is not in mathematics.
Finaly my question is: is there a way to normalize Value with both n1 and n2 and then create an "ALL" row in which there is a value that can be used as a reference/average to compare to all other cases. I would not like to use average or median of all normalized cases.
statistics
asked Mar 23 at 22:27
adladl
1084
$endgroup$
add a comment |
$begingroup$
I'm trying to create a statistic about certain measurements normalized with other set of measurements. In the end I have to create a value that will represent the normalized measurements altogether.
As shown below in the table I have a variable called Entity for which a set of measurements is shown in the Value column. For the Entity variable I have other two measurement called n1 and n2 which I need to use to normalize the values in the Value column.
If I try to normalize Value per n1 the result shown in Value/n1 makes sense. By this I mean that the "ALL" value for the Entity variable can be compared with every other individual value, meaning that it is similar to all other individual values and can be used to show whether the other values are above or below a certain average (not certain if it can be called average).
The same case is when I normalize Value with n2.
The problem arises when I normalize Value per n1 and n2. In this case the "ALL" case has significantly lower value than all other individual cases in the Value/(n1*n2) column.
Forgive my poor terminology and lack of knowledge for type of statistic calculation. My background is not in mathematics.
Finaly my question is: is there a way to normalize Value with both n1 and n2 and then create an "ALL" row in which there is a value that can be used as a reference/average to compare to all other cases. I would not like to use average or median of all normalized cases.
statistics
asked Mar 23 at 22:27
adladl
1084
$endgroup$
add a comment |
$begingroup$
I'm trying to create a statistic about certain measurements normalized with other set of measurements. In the end I have to create a value that will represent the normalized measurements altogether.
As shown below in the table I have a variable called Entity for which a set of measurements is shown in the Value column. For the Entity variable I have other two measurement called n1 and n2 which I need to use to normalize the values in the Value column.
If I try to normalize Value per n1 the result shown in Value/n1 makes sense. By this I mean that the "ALL" value for the Entity variable can be compared with every other individual value, meaning that it is similar to all other individual values and can be used to show whether the other values are above or below a certain average (not certain if it can be called average).
The same case is when I normalize Value with n2.
The problem arises when I normalize Value per n1 and n2. In this case the "ALL" case has significantly lower value than all other individual cases in the Value/(n1*n2) column.
Forgive my poor terminology and lack of knowledge for type of statistic calculation. My background is not in mathematics.
Finaly my question is: is there a way to normalize Value with both n1 and n2 and then create an "ALL" row in which there is a value that can be used as a reference/average to compare to all other cases. I would not like to use average or median of all normalized cases.
statistics
asked Mar 23 at 22:27
adladl
1084
$endgroup$
I'm trying to create a statistic about certain measurements normalized with other set of measurements. In the end I have to create a value that will represent the normalized measurements altogether.
As shown below in the table I have a variable called Entity for which a set of measurements is shown in the Value column. For the Entity variable I have other two measurement called n1 and n2 which I need to use to normalize the values in the Value column.
If I try to normalize Value per n1 the result shown in Value/n1 makes sense. By this I mean that the "ALL" value for the Entity variable can be compared with every other individual value, meaning that it is similar to all other individual values and can be used to show whether the other values are above or below a certain average (not certain if it can be called average).
The same case is when I normalize Value with n2.
The problem arises when I normalize Value per n1 and n2. In this case the "ALL" case has significantly lower value than all other individual cases in the Value/(n1*n2) column.
Forgive my poor terminology and lack of knowledge for type of statistic calculation. My background is not in mathematics.
Finaly my question is: is there a way to normalize Value with both n1 and n2 and then create an "ALL" row in which there is a value that can be used as a reference/average to compare to all other cases. I would not like to use average or median of all normalized cases.
statistics
statistics
asked Mar 23 at 22:27
adladl
1084
asked Mar 23 at 22:27
adladl
1084
asked Mar 23 at 22:27
adladl
1084
asked Mar 23 at 22:27
adladl
1084
asked Mar 23 at 22:27
adladl
1084
1084
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
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
},
noCode: 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%2fmath.stackexchange.com%2fquestions%2f3159876%2fcreate-a-statistic-for-a-sum-that-has-been-normalized-with-two-other-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Mathematics Stack Exchange!
- 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.
Use MathJax to format equations. MathJax reference.
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%2fmath.stackexchange.com%2fquestions%2f3159876%2fcreate-a-statistic-for-a-sum-that-has-been-normalized-with-two-other-values%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
