Tutorial for College Data Analysis PowerPoint Screen Shots Tutorial for College Data Analysis-7 1

Table of Contents Topic and Page Numbers: • Illustration of Data File: 3 • Descriptive Statistics: 4-6 • Confidence Interval: 7-11 • Charting: 12 • Pivot Tables: 13 • Correlation/Conditional Formatting: 14-20 • Testing-Two Variances: 21-25 • Hypothesis Test – Two Means: 26-33 • Regression Analysis/Normal Test Plot: 34-40 • ANOVA: 41-45 • Percentiles and quartiles: 46-47 Tutorial for College Data Analysis-7 2

Illustration of Part 1A for States Alabama, Colorado, Louisiana, and West Virginia Tutorial for College Data Analysis-7 3

Tutorial for College Data Analysis-7 3-4 How to Do Descriptive Statistics in Excel

Tutorial for College Data Analysis-7 3-5 • Enter dialog box details • Check box for summary statistics • Click OK How to Do Descriptive Statistics in Excel

Tutorial for College Data Analysis-7 Descriptive Statistics Output • Excel Output 3-6 Mean Median Mode Standard Deviation Variance Range

Interval Estimation - Heritage Software Interval Estimation - Heritage Software Issue: The company has service representatives who answer calls from customers. The managers are interested in estimating the mean call time Objective: Use Excel 2007+ to help construct a confidence interval estimate for population mean call time. Data file is Heritage.xls Tutorial for College Data Analysis-7 7

Interval Estimation – Heritage Software • Open file Heritage.xls • The file contains 25 entries Tutorial for College Data Analysis-7 8

Interval Estimation – Heritage Software • Select the Data tab • Select Data Analysis • Select Descriptive Statistics Tutorial for College Data Analysis-7 9

Interval Estimation – Heritage Software 95% Confidence interval = 7.088 +/- 1.915 5.173 ---------------- 9.003 Tutorial for College Data Analysis-7 10

Interval Estimation – Heritage Software • Conclusion : We are 95% confident that the true population mean is between 5.173 and 9.003. Tutorial for College Data Analysis-7 11

Charting Tutorial for College Data Analysis-7 12

Pivot Tables • Please review the series of YouTube videos on Sakai under Resources on Sakai for the College Data Analysis. Tutorial for College Data Analysis-7 13