 Calculating the Power of the F Test

By
Conrad Carlberg
 Apr 11, 2013
 Conrad Carlberg shows how to calculate the power of the F test directly and avoid relying on the power charts in the appendices of statistics texts.

 The Concept of Statistical Power

By
Conrad Carlberg
 Apr 11, 2013
 Conrad Carlberg spells out the real meaning of the term statistical power. He describes how to use it to help design a statistical analysis, design your hypotheses, and decide on a sample size that's large enough without being wasteful.

 The Noncentrality Parameter in the F Distribution

By
Conrad Carlberg
 Apr 11, 2013
 Conrad Carlberg shows how to calculate the noncentrality parameter. He also shows how to use it with the probability density function to create Excel charts that display the shape of noncentral F distributions.

 The Statistical Power of tTests

By
Conrad Carlberg
 Apr 11, 2013
 Conrad Carlberg shows how changing the nature of hypotheses, increasing the sample size, and using a dependent groups design progressively increase the power of the more basic ttest.

 Customizing an Excel 2013 Pivot Table

By
Bill Jelen, Michael Alexander
 Mar 12, 2013
 This chapter covers six functional areas in making pivot table customization: Minor Cosmetic Changes, Layout Changes, Major Cosmetic Changes, Summary Calculations, Advanced Calculations, and Other (less common) Options.

 How Excel's LINEST() Handles Collinearity

By
Conrad Carlberg
 Mar 5, 2013
 Excel expert Conrad Carlberg discusses the implications of the manner in which LINEST() implements QR decomposition for its results—implications which are largely undocumented and which involve the unannounced removal of a variable from the regression equation.

 Excel's LINEST() Function Deconstructed

By
Conrad Carlberg
 Feb 25, 2013
 For the user to fully understand how LINEST() calculates its results, it is necessary to walk through the individual calculations, starting with the coefficients, moving to the sums of squares and ending with the standard errors. This article discusses the required calculations and shows how they can be carried out directly on the worksheet using just a smattering of Excel's matrix functions.

 Excel 2013 VBA and Macros: Referring to Ranges

By
Bill Jelen, Tracy Syrstad
 Feb 21, 2013
 This chapter shows you different ways of referring to ranges such as specifying a row or column. You also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.

 Using the Excel 2013 Interface

By
Bill Jelen
 Feb 20, 2013
 This chapter introduces the Excel 2013 interface elements such as the ribbon, formula bar, and status bar.

 Forcing the Constant in Regression to Zero: Understanding Excel's LINEST() Error

By
Conrad Carlberg
 Feb 12, 2013
 One of the options in Excel's LINEST() function is to force the constant in the regression equation to a value of zero. This article focuses on a serious error in the LINEST() results when the option is selected. The error was not corrected until Excel 2003, and it remains in Excel 2010.

 Predictive Analytics in Microsoft Excel: Building Your Own Data Collector

By
Conrad Carlberg
 Aug 22, 2012
 Suppose you supply a product that another company or companies resell on their own websites. Although those companies might share their web traffic information with you, it’s more likely that they regard it as proprietary. This chapter show how to retrieve data from the web and perform analytics without the active cooperation of the source website.

 Rotating Factors with Excel using Varimax

By
Conrad Carlberg
 Jun 25, 2012
 Conrad Carlberg discusses a method in Excel used to rotate principal components to a simple structure that clarifies the meaning of the factors.

 Using Principal Components in Excel

By
Conrad Carlberg
 Jun 22, 2012
 Conrad Carlberg describes a test using Excel that looks at how states in different regions of the United States exhibit similar crime patterns.

 What to Expect from Microsoft Office 15

By
Brien Posey
 Jun 5, 2012
 Office 15 promises to be the most significant Microsoft Office release in quite some time. Brien Posey explains why this new release is such a big deal and what you can expect from it.

 Excel Web App Improvements, Part 2

By
Laura Acklen
 Dec 13, 2011
 Laura Acklen covers the enhancements to the Excel Web App in the second installment in a multipart series.

 Excel Web App Improvements, Part 1

By
Laura Acklen
 Dec 12, 2011
 Laura Acklen describes (in this first in a multipart series) the latest updates to the Excel Web App.

 Statistical Analysis with Excel 2010: Using Excel with the Normal Distribution

By
Conrad Carlberg
 Jun 22, 2011
 Excel offers more worksheet functions that pertain to the normal distribution than to any other. This chapter explains what a normal distribution is and how to use those Excel functions that map it.

 Improve Your Pivot Tables with PowerPivot for Excel 2010

By
Bill Jelen
 May 31, 2011
 Bill "MrExcel" Jelen walks you through the five benefits of PowerPivot (and shows you solutions to five problems pivot tables could never resolve).

 Tiny Charts Help Others to Visualize Your Data

By
Bill Jelen
 May 27, 2011
 Professor Edward Tufte described sparklines as "dataintense, designsimple, wordsized graphics." Bill "MrExcel" Jelen helps you understand sparklines in Excel 2010 and how they can benefit you.

 Creating Microsoft Excel Charts That Show Trends

By
Bill Jelen
 Nov 29, 2010
 "Mr Excel" Bill Jelen shows how to choose the most effective type of chart and which settings to use to show various trends over time. He also discusses the strengths and limitations of Excel's available chart options.
