book

Regression Analysis Microsoft® Excel®

by Conrad Carlberg

May 2016

Beginner to intermediate

368 pages

11h 41m

English

Que

Read now

Unlock full access

How Variation Is MeasuredThe Standard DeviationThe Standard Error of the Mean
Measuring CorrelationCalculating CorrelationCorrelation and CausationRestriction of Range
Predicting with Correlation and Standard ScoresPredicting with Regression Coefficient and InterceptShared VarianceThe TREND() FunctionPartial and Semipartial Correlations
Array-Entering LINEST()Comparing LINEST() to SLOPE() and INTERCEPT()The Standard Error of a Regression CoefficientThe Squared Correlation, R2The Standard Error of EstimateUnderstanding LINEST()’s F-ratioThe General Linear Model, ANOVA, and Regression AnalysisOther Ancillary Statistics from LINEST()
A Composite Predictor VariableUnderstanding the TrendlineMapping LINEST()’s Results to the WorksheetBuilding a Multiple Regression Analysis from the Ground UpUsing the Standard Error of the Regression CoefficientUsing the Models Comparison Approach to Evaluating PredictorsEstimating Shrinkage in R2
About AssumptionsThe Straw ManCoping with Nonlinear and Other Problem DistributionsThe Assumption of Equal SpreadUnequal Variances and Sample Sizes
Dummy CodingEffect CodingOrthogonal CodingFactorial AnalysisStatistical Power, Type I and Type II ErrorsCoping with Unequal Cell Sizes
Contrasting the ResultsStructuring a Conventional ANCOVAStructuring an ANCOVA Using RegressionChecking for a Common Regression LineTesting the Adjusted Means: Planned Orthogonal Coding in ANCOVAANCOVA and Multiple Comparisons Using the Regression ApproachMultiple Comparisons via Planned Nonorthogonal ContrastsMultiple Comparisons with Post Hoc Nonorthogonal Contrasts

Content preview from Regression Analysis Microsoft® Excel®

About the Author

Conrad Carlberg (www.conradcarlberg.com) is a nationally recognized expert on quantitative analysis and on data analysis and management applications such as Microsoft Excel, SAS, and Oracle. He holds a Ph.D. in statistics from the University of Colorado and is a many-time recipient of Microsoft’s Excel MVP designation.

Carlberg is a Southern California native. After college he moved to Colorado, where he worked for a succession of startups and attended graduate school. He spent two years in the Middle East, teaching computer science and dodging surly camels. After finishing graduate school, Carlberg worked at US West (a Baby Bell) in product management and at Motorola.

In 1995 he started a small consulting business that provides ...