issuhub.com

Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1

  • Chapter Contents

  • GETTING STARTED WITH EXCEL

  • Getting Started

    • Special Files for This Book

    • Installing the StatPlus Files



  • Excel and Spreadsheets

    • Launching Excel

    • Viewing the Excel Window

    • Running Excel Commands



  • Excel Workbooks and Worksheets

    • Opening a Workbook

    • Scrolling through a Workbook



  • Worksheet Cells

    • Selecting a Cell

    • Moving Cells



  • Printing from Excel

    • Previewing the Print Job

    • Setting Up the Page

    • Printing the Page



  • Saving Your Work

  • Excel Add-Ins

    • Loading the StatPlus Add-In

    • Loading the Data Analysis ToolPak

    • Unloading an Add-In



  • Features of StatPlus

    • Using StatPlus Modules

    • Hidden Data

    • Linked Formulas

    • Setup Options



  • Exiting Excel

  • Chapter

  • WORKING WITH DATA

  • Data Entry

    • Entering Data from the Keyboard

    • Entering Data with Autofi ll

    • Inserting New Data



  • Data Formats

  • Formulas and Functions

    • Inserting a Simple Formula

    • Inserting an Excel Function



  • Cell References

  • Range Names

  • Sorting Data

  • Querying Data

    • Using the AutoFilter

      • Using the Advanced Filter

      • Using Calculated Values

      • Importing Data from Text Files

      • Importing Data from Databases

        • Using Excel’s Database Query Wizard

        • Specifying Criteria and Sorting Data



      • Exercises

      • Chapter

      • WORKING WITH CHARTS

      • Introducing Excel Charts

      • Introducing Scatter Plots

      • Editing a Chart

        • Chart Resizing and Moving an Embedded

        • Moving a Chart to a Chart Sheet

        • Working with Chart and Axis Titles

        • Editing the Chart Axes

        • Working with Gridlines and Legends

        • Editing Plot Symbols



      • Identifying Data Points

        • Selecting a Data Row

        • Labeling Data Points

        • Formatting Labels



      • Creating Bubble Plots

      • Categories Breaking a Scatter Plot into

      • Plotting Several Variables

      • Exercises

      • Chapter

      • DESCRIBING YOUR DATA

      • Variables and Descriptive Statistics

      • Frequency Tables

        • Creating a Frequency Table

        • Using Bins in a Frequency Table

        • Defi ning Your Own Bin Values



      • Working with Histograms

        • Creating a Histogram

        • Shapes of Distributions

        • Breaking a Histogram into Categories



      • Working with Stem and Leaf Plots

      • Distribution Statistics

        • Percentiles and Quartiles

        • and the Mode Measures of the Center: Means, Medians,





    • Measures of Variability

    • Kurtosis Measures of Shape: Skewness and

    • Outliers



  • Working with Boxplots

    • Concept Tutorials: Boxplots



  • Exercises

  • Chapter

  • PROBABILITY DISTRIBUTIONS

  • Probability

  • Probability Distributions

    • Discrete Probability Distributions

    • Continuous Probability Distributions

    • Concept Tutorials: PDFs



  • Random Variables and Random Samples

    • Concept Tutorials: Random Samples



  • The Normal Distribution

    • The Normal Distribution Concept Tutorials:



  • Excel Worksheet Functions

    • Normal Data Using Excel to Generate Random

    • Charting Random Normal Data

    • The Normal Probability Plot



  • Parameters and Estimators

  • The Sampling Distribution

    • Sampling Distributions Concept Tutorials:

    • The Standard Error



  • The Central Limit Theorem

    • The Central Limit Theorem Concept Tutorials:



  • Exercises

  • Chapter

  • STATISTICAL INFERENCE

  • Confi dence Intervals

    • z Test Statistic and z Values

    • with Excel Calculating the Confi dence Interval

    • Interpreting the Confi dence Interval

    • The Confi dence Interval Concept Tutorials:



  • Hypothesis Testing

    • Types of Error

    • An Example of Hypothesis Testing

    • Acceptance and Rejection Regions

      • p Values

      • Concept Tutorials: Hypothesis Testing

      • Hypothesis Testing Additional Thoughts about

      • The t Distribution

        • Concept Tutorials: The t Distribution

        • Working with the t Statistic

        • Constructing a t Confi dence Interval

        • The Robustness of t



      • Applying the t Test to Paired Data

      • Paired Data Applying a Nonparametric Test to

        • The Wilcoxon Signed Rank Test

        • The Sign Test



      • The Two-Sample t Test

        • Test Statistics Comparing the Pooled and Unpooled

        • t Statistic Working with the Two-Sample



      • Testing for Equality of Variance

      • Applying the t Test to Two-Sample Data

      • Two-Sample Data Applying a Nonparametric Test to

      • Final Thoughts about Statistical Inference

      • Exercises

      • Chapter

      • TABLES

      • PivotTables

        • PivotTable Removing Categories from a

        • by the PivotTable Changing the Values Displayed

        • Bar Chart Displaying Categorical Data in a

        • Pie Chart Displaying Categorical Data in a



      • Two-Way Tables

      • Computing Expected Counts

      • The Pearson Chi-Square Statistic

        • Concept Tutorials: The x^2 Distribution

        • Excel Working with the x^2 Distribution in

        • Statistic Breaking Down the Chi-Square



      • Other Table Statistics

      • Frequencies Validity of the Chi-Square Test with Small





  • Tables with Ordinal Variables

    • Two Ordinal Variables Testing for a Relationship between

    • Custom Sort Order



  • Exercises

  • Chapter

  • REGRESSION AND CORRELATION

  • Simple Linear Regression

    • The Regression Equation

    • Fitting the Regression Line

    • Regression Functions in Excel



  • Exploring Regression

  • Performing a Regression Analysis

    • Plotting Regression Data

    • Calculating Regression Statistics

    • Interpreting Regression Statistics

    • Table Interpreting the Analysis of Variance

    • Parameter Estimates and Statistics

    • Residuals and Predicted Values



  • Checking the Regression Model

    • Testing the Straight-Line Assumption

    • the Residuals Testing for Normal Distribution of

    • the Residuals Testing for Constant Variance in

    • Residuals Testing for the Independence of



  • Correlation

    • Correlation and Slope

    • Correlation and Causality

    • Coeffi cient s Spearman’s Rank Correlation

    • Correlation Functions in Excel



  • Creating a Correlation Matrix

    • Variable Correlation with a Two-Valued

    • Bonferroni Adjusting Multiple p Values with



  • Creating a Scatter Plot Matrix

  • Exercises

  • Chapter

  • MULTIPLE REGRESSION

  • Parameters Regression Models with Multiple

    • The F Distribution Concept Tutorials:

    • Using Regression for Prediction

    • Regression Example: Predicting Grades

      • Output Interpreting the Regression

      • Multiple Correlation

      • Equation Coeffi cients and the Prediction

      • t Tests for the Coeffi cients



    • Testing Regression Assumptions

      • Observed versus Predicted Values

      • Values Plotting Residuals versus Predicted

      • Variables Plotting Residuals versus Predictor

      • Normal Errors and the Normal Plot

      • Summary of Calc Analysis



    • Sex Discrimination Regression Example:

      • Regression on Male Faculty

      • Using a SPLOM to See Relationships

      • Correlation Matrix of Variables

      • Multiple Regression

      • Interpreting the Regression Output

      • Data Residual Analysis of Discrimination

      • Normal Plot of Residuals

      • Are Female Faculty Underpaid?

      • Drawing Conclusions



    • Exercises

    • Chapter

    • ANALYSIS OF VARIANCE

    • One-Way Analysis of Variance

    • Comparing Hotel Prices Analysis of Variance Example:

      • ANOVA Assumptions Graphing the Data to Verify

      • Variance Computing the Analysis of

      • Table Interpreting the Analysis of Variance



    • Comparing Means

      • Factor Using the Bonferroni Correction

      • When to Use Bonferroni



    • Comparing Means with a Boxplot



  • Regression One-Way Analysis of Variance and

    • Indicator Variables

    • Fitting the Effects Model



  • Two-Way Analysis of Variance

  • A Two-Factor Example

  • Comparing Soft Drinks Two-Way Analysis Example:

    • Assumptions Graphing the Data to Verify

    • The Interaction Plot

    • Analysis of Variance Using Excel to Perform a Two-Way

    • Table Interpreting the Analysis of Variance



  • Summary

  • Exercises

  • Chapter

  • TIME SERIES

  • Time Series Concepts

  • Temperatures Time Series Example: The Rise in Global

    • Series Plotting the Global Temperature Time

    • Temperature Analyzing the Change in Global

    • Looking at Lagged Values



  • The Autocorrelation Function

    • Temperature Applying the ACF to Annual Mean

    • Other ACF Patterns

    • Temperature Applying the ACF to the Change in



  • Moving Averages

  • Simple Exponential Smoothing

    • Smoothing Forecasting with Exponential

    • Forecast Assessing the Accuracy of the

    • Exponential Smoothing Concept Tutorials: One-Parameter

    • Choosing a Value for w



  • Two-Parameter Exponential Smoothing

    • Calculating the Smoothed Values

    • Exponential Smoothing Concept Tutorials: Two-Parameter



  • Seasonality

    • Multiplicative Seasonality

    • Additive Seasonality

    • Seasonal Example: Liquor Sales

      • Boxplot Examining Seasonality with a

      • Plot Examining Seasonality with a Line

      • Applying the ACF to Seasonal Data

      • Adjusting for Seasonality



    • Smoothing Three-Parameter Exponential

      • Forecasting Liquor Sales



    • Constant (optional) Optimizing the Exponential Smoothing

    • Exercises

    • Chapter

    • QUALITY CONTROL

    • Statistical Quality Control

      • Controlled Variation

      • Uncontrolled Variation



    • Control Charts

      • Testing Control Charts and Hypothesis

      • Variable and Attribute Charts

      • Using Subgroups



    • The x Chart

      • Known Calculating Control Limits When s Is

      • x Chart Example: Teaching Scores

      • Unknown Calculating Control Limits When s Is

      • x Chart Example: A Coating Process



    • The Range Chart

    • The C Chart

      • C Chart Example: Factory Accidents



    • The P Chart

      • P Chart Example: Steel Rod Defects



    • Observations Control Charts for Individual

    • The Pareto Chart

    • Exercises

    • APPENDIX

    • Excel Reference

    • Bibliography

    • Index



Free download pdf
Get our desktop app
Company
Features
Documentation
Resources
© ISSUHUB. 2024. All rights reserved.