...Department of Mathematics Created by Prof. Tan Le & Hang Lai STATISTICS – EXCEL 2010 INSTRUCTIONS Table of Contents 1. Open Microsoft Excel .............................................................................................................................................. 3 2. Bar Charts.................................................................................................................................................................... 4 3. Pie Charts..................................................................................................................................................................... 7 4. Line Charts ................................................................................................................................................................ 10 5. How to install the Data Analysis Package in Excel 2010? ..................................................................... 11 6. Descriptive Statistics ............................................................................................................................................ 12 7. Histograms ................................................................................................................................................................ 14 8. Making an Ogive ...........................................................................................................................
Words: 4093 - Pages: 17
...for identification purposes only and may be trademarks of their respective companies. Windows is a registered trademark of Microsoft Corporation. Apple, Mac, and the Mac logo are trademarks of Apple Computer, Inc., registered in the U.S. and other countries. This product uses WinWrap Basic, Copyright 1993-2007, Polar Engineering and Consulting, http://www.winwrap.com. Printed in the United States of America. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. ISBN-13: 978-1-56827-401-0 ISBN-10: 1-56827-401-7 1234567890 11 10 09 08 Preface The SPSS Statistics 17.0 Brief Guide provides a set of tutorials designed to acquaint you with the various components of...
Words: 24142 - Pages: 97
...NOTES TOPIC 1: Introduction to Statistics (Textbook Chapter 1) Introduction No doubt you have noticed the large number of facts and figures, often referred to as statistics, that appear in the newspapers and magazines you read, websites you visit, television you watch (especially sporting events), and in grocery stores where you shop. A simple figure is called a statistic. A few examples: • Home and condominium sales declined 6.5% in Charleston, South Carolina in April, 2006 compared to sales in April, 2005. • Tuition and fees for resident undergraduate students at public four year institutions averaged $5,491 for 2005-06, a 7.1%increase over 2004-05. • Approximately 24 million medicare beneficiaries were enrolled in the new prescription drug program as of January, 2006. • The government reported that 138,000 jobs were added to the economy in April, 2006. • The Dow Jones Industrial Average was 11,094.04 on May 30, 2006. You may think of statistics simply as a collection of numerical information. However, statistics has a much broader meaning. Learning Objectives After completing this chapter, you will be able to: 1. Understand why we study statistics. 2. Explain what is meant by descriptive statistics and inferential statistics. 3. Distinguish between a qualitative variable and a quantitative variable. 4. Distinguish between a discrete variable and a continuous variable. 5. Distinguish among nominal, ordinal...
Words: 2749 - Pages: 11
...Group Project: Coca Cola CocaProProposal Group Project: Coca Cola CocaProProposal Megan Bond (Team Lead) Taryn Keenan Allysa Kiedpool Krista Samples Nicole Smith July 12, 2014 BA 615 Dr. Mohammad Oskoorouchi Megan Bond (Team Lead) Taryn Keenan Allysa Kiedpool Krista Samples Nicole Smith July 12, 2014 BA 615 Dr. Mohammad Oskoorouchi Contents Executive Summary………………………………………………………………………………………………3 Analysis & Approach…………………………………………………………………………………………….4 Pie Charts……………………………………………………………………………………………………4 Line Charts……………………………………………………....……………………………………..…5 Descriptive Statistics and Variation…………………………………….………………………8 Histograms…………………………………..…………………………………….……………….……10 Confidence Intervals…………………………………..……………………………………….……13 Hypotheses and Hypothesis Test…………….……………………..………………………..15 Scatter Plots and Correlation……………….……………………………………………….....18 Conclusion……………………………………………………………………………………………….…………22 Recommendations…………….…………………………………………………………………….…………22 Executive Summary As a company, Coca Cola always strives to keep their customers happy. The corporate goal is to deliver all customer orders with 100% accuracy and within the customer’s time window. A metric the company has developed to measure this is On Time and In Full (OTIF), which illustrates the percentage of the orders sent out on a particular day that were within the customer’s time window and with 100% of the cases the customer...
Words: 5018 - Pages: 21
... | | | |QNT/351 | | | |Quantitative Analysis for Business | | | |Dr. Jacquelyn B. Frausto | | Copyright © 2013, 2012, 2011 by University of Phoenix. All rights reserved. Course Description This course integrates applied business research and descriptive statistics. Students will learn to apply business research and descriptive statistics in making better business decisions. Other topics include examination of the role of statistics in research, statistical terminology, the appropriate use of statistical techniques, and interpretation of statistical findings in business and research. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged...
Words: 3466 - Pages: 14
...[pic] [pic] IST COLLEGE UNIVERSITY OF HERTFORDSHIRE B.Sc. in Psychology Level 1 Academic Year: 2012-2013 Module: Research Methods Lab Report 4 The effect of Word Processing on Memory ability Tutor: Mary Christopoulou Student: Panagiotis Moschonas Submission Date: 25/3/13 The effect of Word Processing on Memory ability Many researchers have done experiments or had conducted studies about the memory and our ability to storage information inside our brain and recall them when we need them. We divide our memory in three “pieces” the short-term memory and the long-term memory and the sensory memory. This memory model was explained by the researchers Atkinson and Shiffrin 1968. First is the sensory memory, it can memorize things only for a few seconds. The visual system possesses iconic memory for visual stimuli like the shape, the size and the color of an object. Second is the short-term memory, in this case we can store some information for a longer period so that we can be able to use them for example we can memorize a telephone number long enough to dial it and use it, after...
Words: 1914 - Pages: 8
...Introduction to Statistics QTM403 Basic Information Program | BBA 3 (Hons.) | Semester | Fall 2015 | Credit Hours | 3 | Pre requisites (if any) | Mathematics | Resource Person | Iftikhar Hussain | Contact information | ihgrw85@gmail.com | Course Description: Important decisions are rarely made by intuition alone. We need to use the data to develop our insights and to support our analysis. Quantitative analysis includes the tools and techniques with which we seek to replicate reality mathematically and statistically. Statistical Techniques are applied in all the functions of business like Operations, Marketing, HR, Finance etc. The aim of this course is to learn when a technique is appropriate and what it can achieve. The emphasis throughout the course is on concepts and reasoning rather than technical details. You should acquire some basic data analysis skills but most importantly, become a more informed and critical producer and user of business Statistical analyses. Learning Objectives: Ser. # | Course Learning Objectives | Link with Program Learning Objectives | 1 | To understand the basic concepts and principles used in Business Statistics. | To inculcate business knowledge and analytical skills in graduates to think decisively in order to develop innovative solutions to problems in a business environment. | 2 | Organizing qualitative and quantitative data into a frequency table, displaying the data through charts and graphs...
Words: 1330 - Pages: 6
...snaptutorial.com PSYCH 625 Week 1 Individual Assignment Basic Concepts in Statistics Worksheet PSYCH 625 Week 1 Individual Assignment Reliability and Validity Matrix PSYCH 625 Week 1 Individual Assignment Time to Practice – Week One PSYCH 625 Week 2 Individual Assignment Time to Practice – Week Two PSYCH 625 Week 2 Learning Team Assignment Statistics Project Import Data Into IBM ® SPSS ® Software PSYCH 625 Week 3 Individual Assignment Time to Practice – Week Three PSYCH 625 Week 3 Learning Team Assignment Hypothesis Testing Problem Worksheet PSYCH 625 Week 3 Learning Team Assignment Statistics Project Descriptive Statistics PSYCH 625 Week 4 Individual Assignment Time to Practice – Week Four PSYCH 625 Week 4 Learning Team Assignment Statistics Project Comparing Means PSYCH 625 Week 5 Individual Assignment Programmatic Assessment Time to Practice – Week Five PSYCH 625 Week 5 Learning Team Assignment Statistics Project Correlations PSYCH 625 Week 6 Individual Assignment Overview of Important Statistical Tests PSYCH 625 Week 6 Learning Team Assignment Statistics Project Presentation ----------------------------------------- PSYCH 625 Week 1 Individual Assignment Basic Concepts in Statistics Worksheet For more classes visit www.snaptutorial.com Complete the following questions. Be specific and provide examples when relevant. Cite any sources consistent with APA guidelines. What are statistics and how are they used in the behavioral sciences? Your answer should be...
Words: 1679 - Pages: 7
...Statistics for Business and Economics Chapter 1 Describing Data: Graphical Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall Ch. 1-1 1.1 Dealing with Uncertainty Everyday decisions are based on incomplete information Consider: Will the job market be strong when I graduate? Will the price of Yahoo stock be higher in six months than it is now? Will interest rates remain low for the rest of the year if the federal budget deficit is as high as predicted? Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall Ch. 1-2 Dealing with Uncertainty (continued) Numbers and data are used to assist decision making Statistics is a tool to help process, summarize, analyze, and interpret data Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall Ch. 1-3 1.2 Key Definitions A population is the collection of all items of interest or under investigation N represents the population size (N ≈ Infinity) A sample is an observed subset of the population n represents the sample size A parameter is a specific characteristic of a population A statistic is a specific characteristic of a sample Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall Ch. 1-4 Population vs. Sample Population a b Sample cd b ef gh i jk l m n o p q rs t u v w x y z Values calculated using population data are called parameters Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall c gi o n r ...
Words: 2494 - Pages: 10
...decide what the lower and upper control limits will be in the sample means plus the sample range of the statistics. With consequence for the study offer evidence of ranges to progress to intensification the competence of the method. According to Chase, Jacobs, and Aquilano (2006) “the process, of collecting data, analyzing the data, and formulating an improvement plan is considered part of statistical process control.” Examination of the Data To describe diverse values required to build individually an X-bar plus the R chart first there is the must have based data need for the calculator. These are the numbers that I collected in the preceding last four weeks. The method of drive to a job interview was used, plus the numbers that was collect is itemizing below at this time in the table. Time entail on the road to a job interview Day wk. 1 wk. 2 wk. 3 wk. 4 Sample Means Sample Range 1 55 47 40 50 48.00 8 2 40 65 67 30 50.50 37 3 50 55 45 47 49.25 3 4 35 45 51 40 42.75 16 5 40 45 45 45 43.75 5 Data Collected Summary As seen from the information above, “we” could grasp the time it take to drive to a job interview on all days of the week from the previous four weeks I collected statistics. Moreover offered the table is a sample...
Words: 1124 - Pages: 5
...on the effectiveness of Onglyza, along with diet and exercise, for treating diabetes. Based on chapter one reading the population is the population in a statistical study is the complete set of people or things being studied (Bennett, Briggs, Triola, 2009). Therefore the population consists of all diabetic patients. 2. In the following scenario identify the type of statistical study that was conducted. A Gallop poll surveyed 1,018 adults by telephone, and 22% of them reported that they smoked cigarettes within the past week. Based on our chapter one as well as our chapter two reading the statistical study that was conducted was; Simple Random sampling which fell into descriptive statistics, this is what deals with describing raw data in the form of graphics and sample statistics (Bennett, Briggs, Triola, 2009). Furthermore the study is of quantitative data; which consist of values representing counts or measurements; you...
Words: 1601 - Pages: 7
...Balances by Income (Histogram) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Credit Balances by Size (Scatterplot) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Credit Balances by Location (Box Plot) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Size Frequency (Dotplot) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Conclusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 INTRODUCTION AJ Davis is a department store chain with many customers who hold credit accounts at the store. The company’s management group wants to analyze the data collected and summarized to determine if there is any connection or relationship between the information gathered from the customers. Sample of 50 credit customers with the following variables: 1) LOCATION (Rural, Urban, Suburban) 2) INCOME (in $1,000’s) 3) SIZE (the number of people living in the household) 4) YEARS (the number of years that the customer has lived in the current location) 5) CREDIT BALANCE (the customers current credit balance) The process of...
Words: 1194 - Pages: 5
...of his own: O’Malley currently is enrolled in his second year of the history Ph.D. program at Johns Hopkins University. 22 22 Occupational Outlook Quarterly ● For O’Malley and thousands of others, the desire for a doctorate outweighs concern about the job market that awaits after graduation. Most Ph.D. candidates are willing to dedicate themselves to intensive research and study because they enjoy the subject matter. Winter 2002-03 Statistics also show other, more tangible payoffs for Ph.D. recipients when they enter the labor force. Unemployment rates are consistently lower and earnings are significantly higher for people with a Ph.D. degree than they are for people with lower levels of educational attainment. As chart 1 shows, doctoral degree holders in 2001 had an unemployment rate of slightly more than 1 percent and median annual earnings of $66,000—considerably Elka Jones is an economist in the Office of Occupational Statistics and Employment Projections, BLS, (202) 691-5719. Chart 1 better than the 3.7-percent unemployment rate and $30,300 median earnings of the population aged 25 and older. This article explores some challenges that Ph.D. candidates face, from earning the degree to seeking employment. The first section briefly describes what a Ph.D. degree is and what it entails...
Words: 5981 - Pages: 24
...individual uses. There is data used for budgeting, staffing, and supplies. Data is collected on demographics of the patient population. Data is measured constantly in patients; vital signs, lab values, and measurements of all sorts. We also conduct clinical trials in vast numbers collecting data on efficacy, treatment variation, modalities, and outcomes. 2. One example of descriptive statistics we use in our work place is yearly charts depicting prevalence of falls hospital wide. These charts are shown in a number of ways and are divided by unit so that each unit can be compared one with the other. Additionally, they have charts showing the yearly trends by unit and hospital-wide. They get fairly detailed on some of them showing specific categories of fall occurrence, for example; assisted vs. unassisted; Falls due to toileting; falls by time of day; falls by assessed risk category. This practice is highly effective and allows everyone to see where, when, and how falls are occurring. It also provides insight into how to go about reducing the instances. 3. Where I work we do use inferential statistics, in fact we apply it a lot. We administer chemotherapy and study its effects. We collect data from sample populations (trials) and based on the analysis develop protocols to treat patients for side effects that are commonly associated with the treatment, regardless of actual occurrence or rather before assumed occurrence. An example of this is the chemotherapy “nadir” effect; data...
Words: 710 - Pages: 3
...MODULE 6 EXERCISE Linear Correlation IRINA QUENGA EG 381 STATISTICS 02/22/2015 ITT TECHNICAL INSTITUTE Task 1: Listed below are baseball team statistics, consisting of the proportions of wins and the result of this difference: Difference (number of runs scored) - (number of runs allowed). The statistics are from a recent year, and the teams are NY—Yankees, Toronto, Boston, Cleveland, Texas, Houston, San Francisco, and Kansas City. Difference 163 55 –5 88 51 16 –214 Wins 0.599 0.537 0.531 0.481 0.494 0.506 0.383 A) Construct a scatter plot, find the value of the linear correlation coefficient r, and find the critical values of r from Table VI, Appendix A, p. A-14, of your textbook Elementary Statistics. Use α = 0.05. B) Is there sufficient evidence to conclude that there is a linear correlation between the proportion of wins and the above difference? Task 2: A classic application of correlation involves the association between temperature and the number of times a cricket chirps in a minute. Listed below are the numbers of chirps in 1 minute and the corresponding temperatures in °F: Chirps in 1 Min 882 1188 1104 864 1200 1032 960 900 Temperature (°F) 69.7 93.3 84.3 76.3 88.6 82.6 71.6 79.6 A) Construct a scatter plot, find the value of the linear correlation coefficient r, and find the critical values of r from Table VI, Appendix A, p. A-14, of your textbook Elementary Statistics. Use α = 0.05. B) Is there a linear correlation between the number of...
Words: 539 - Pages: 3
