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
Image of page 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
Image of page 2
Illustration of Part 1A for States Alabama, Colorado, Louisiana, and West Virginia Tutorial for College Data Analysis-7 3
Image of page 3
Tutorial for College Data Analysis-7 3-4 How to Do Descriptive Statistics in Excel
Image of page 4
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
Image of page 5
Tutorial for College Data Analysis-7 Descriptive Statistics Output Excel Output 3-6 Mean Median Mode Standard Deviation Variance Range
Image of page 6
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
Image of page 7
Interval Estimation – Heritage Software Open file Heritage.xls The file contains 25 entries Tutorial for College Data Analysis-7 8
Image of page 8
Interval Estimation – Heritage Software Select the Data tab Select Data Analysis Select Descriptive Statistics Tutorial for College Data Analysis-7 9
Image of page 9
Interval Estimation – Heritage Software 95% Confidence interval = 7.088 +/- 1.915 5.173 ---------------- 9.003 Tutorial for College Data Analysis-7 10
Image of page 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
Image of page 11
Charting Tutorial for College Data Analysis-7 12
Image of page 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
Image of page 13
Correlation Analysis – Midwest Distribution Issue: The company wants to analyze the relationship between salary and years with the company.
Image of page 14
Image of page 15

You've reached the end of your free preview.

Want to read all 47 pages?

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture