Hello team,
I need to compare two runs. Please view attached workbook. What is the best approach? Using Pivot tables?
How can I analyze/compare tab 1 and tab 2? How can I talk about it?
Regards,
BittenApple
Comparing two runs
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Comparing two runs
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Comparing two runs
Please tell us in detail what you want to compare. Plans? Subplans? Measures? Plans and Subplans? Plans and Measures? ...
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Comparing two runs
Hello team,
I want to compare all population, Passed, NotPassed, Open: for plan against plan, subplan against subplan, measure against measure.
I though variance can be a good means to compare, but on what other functionalities we can compare them. Min and Max?
Regards,
bitten
I want to compare all population, Passed, NotPassed, Open: for plan against plan, subplan against subplan, measure against measure.
I though variance can be a good means to compare, but on what other functionalities we can compare them. Min and Max?
Regards,
bitten
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Comparing two runs
You could indeed create pivot tables for each of the comparisons.
For a real comparison, you'd need to perform statistical analyses; you should consult a professional statistician about that - it's very easy to make grave mistakes.
For a real comparison, you'd need to perform statistical analyses; you should consult a professional statistician about that - it's very easy to make grave mistakes.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Comparing two runs
Hello Hans,
Thanks for the heads up.
I assumed that I can use getpivotdata to bring the data into cells and calculate a variance only.
And do a max or min on the next step.
What do you mean real analysis?
I found another function, I am not sure I am saying it correct: Anova...!!!, which is an adds on to Excel.
Thanks,
bita
Thanks for the heads up.
I assumed that I can use getpivotdata to bring the data into cells and calculate a variance only.
And do a max or min on the next step.
What do you mean real analysis?
I found another function, I am not sure I am saying it correct: Anova...!!!, which is an adds on to Excel.
Thanks,
bita
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Comparing two runs
ANOVA (Analysis of Variance) is a powerful tool, but you really need a professional statistician to assist you with that. Non-professionals can easily draw incorrect conclusions.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Comparing two runs
Hello Hans,
Thanks for your response.
Regards,
Bittenapple
Thanks for your response.
Regards,
Bittenapple