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®

We Want to Hear from You!

As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what we’re doing right, what we could do better, what areas you’d like to see us publish in, and any other words of wisdom you’re willing to pass our way.

We welcome your comments. You can email or write to let us know what you did or didn’t like about this book—as well as what we can do to make our books better.

Please note that we cannot help you with technical problems related to the topic of this book.

When you write, please be sure to include this book’s title and author as well as your name and email address. We will carefully review your comments and share them with the author and editors who worked ...