Tutorial for College Data Analysis-7.pptx - Tutorial for College Data Analysis PowerPoint Screen Shots Tutorial for College Data Analysis-7 1 Table of

# Tutorial for College Data Analysis-7.pptx - Tutorial for...

This preview shows page 1 - 15 out of 47 pages.

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
Correlation Analysis – Midwest Distribution Issue: The company wants to analyze the relationship between salary and years with the company.

#### You've reached the end of your free preview.

Want to read all 47 pages?

• Spring '14
• Debbie-BorieHoltz
• Statistics, College Data Analysis