Home > Articles > Computer Software > Business Office Software > Spreadsheet Software

Spreadsheet Software

RSS Feed Subscribe to this topic  RSS details

79 Items

Sort by Date | Title

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 t-Tests
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 t-test.
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 multi-part series.
Excel Web App Improvements, Part 1
By Laura Acklen
Dec 12, 2011
Laura Acklen describes (in this first in a multi-part 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 "data-intense, design-simple, word-sized 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.

< Prev Page 1 2 3 4 Next >