Monday, November 9, 2020
Animate a PPT with the Zoom Feature
Been in a situation where you had to convert values in columns or rows into comma separated values (csv)? Maybe you got a column of value and you needed to query it in another system, BUT that system needed the input values separated by commas (or semicolons). Using Google sheets, there are actually a couple of ways you can do this and I'll show three examples with three different functions to make it happen.
Monday, November 2, 2020
Perform an Approximate Match in Power Query
Monday, October 26, 2020
Calculate a Two Way ANOVA with Replication in Excel
A two-way ANOVA test analyzes the effect of independent variables on the expected outcome along with their relationship to the outcome itself. Basically you'd use a two-way ANOVA when you want to know how two independent variables, in combination, affect a dependent variable. Excel make ANOVA calculation fairly easy. This video covers the basics of how to perform an ANOVA with replication test. The key concept to remember here is to see if there is a strong relationship of the interaction between the factors and if there is, it determines that the individual analysis of the factors are not as significant. So you'll need to do a deeper dive on which interactions are affecting your data.
Subscribe to:
Posts (Atom)