Statistics for Management

In: Business and Management

Submitted By harishdeepak
Words 7158
Pages 29
Appendix B: Instructor’s Manual
Assignments (with Solutions) using the Movie Data
Accompanying Article Available at

Note to Instructors: Our students, like many introductory business statistics students, have access to SPSS and Minitab so in most cases these exercises provide specific instructions for these two packages. We have also included instructions for Excel 2007. While we are cognizant of the issues with using Excel for statistical analyses, we also realize its simplicity for basic functions such as graphing, and we use it in our classes along with Minitab and SPSS because we feel that business students should be proficient in its use.

We used SPSS version 15, Minitab version 15, and Excel 2007 to write the following instructions. If your students will be using other versions of these softwares or if you prefer that your students use different statistical software, you will need to edit the instructions accordingly before distributing to your students.

Exercise 1: Data Retrieval and Graphing

Learning Objectives:
1. Locate and retrieve data from a web site.
2. Place retrieved data into Excel and format appropriately. (This step is recommended because the format from the website is not easily imported directly into SPSS and Minitab).
3. Create and format a time series plot in SPSS, Minitab, Excel or other software.

Instructions for the students: For this exercise you will use movie box office data found at You will locate data for a specific movie, bring the data to Excel to format it, and then create a time series plot using SPSS, Minitab, Excel or other software.

1. Go to and click the Movie Archive button, found in the left column of the page. Click the letter of the alphabet for the first word in the title of your…...

Similar Documents


...Justine joy balberanImportance of Statistics in Different Fields Statistics plays a vital role in every fields of human activity. Statistics has important role in determining the existing position of per capita income, unemployment, population growth rate, housing, schooling medical facilities etc…in a country. Now statistics holds a central position in almost every field like Industry, Commerce, Trade, Physics, Chemistry, Economics, Mathematics, Biology, Botany, Psychology, Astronomy etc…, so application of statistics is very wide. Now we discuss some important fields in which statistics is commonly applied.  (1) Business:           Statistics play an important role in business. A successful businessman must be very quick and accurate in decision making. He knows that what his customers wants, he should therefore, know what to produce and sell and in what quantities. Statistics helps businessman to plan production according to the taste of the costumers, the quality of the products can also be checked more efficiently by using statistical methods. So all the activities of the businessman based on statistical information. He can make correct decision about the location of business, marketing of the products, financial resources etc…(2) In Economics:           Statistics play an important role in economics. Economics largely depends upon statistics. National income accounts are multipurpose indicators for the economists and administrators. Statistical methods are used......

Words: 741 - Pages: 3


...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 into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Lind, D. A., Marchal, W. G., & Wathen, S. A. (2011). Basic statistics for business and economics (7th ed.). New York, NY: McGraw-Hill/Irwin. McClave, J. T., Benson, P. G., & Sincich, T. (2011). Statistics for business and economics (11th ed.). Boston, MA: Pearson-Prentice Hall. All electronic materials are available on the student website. |Week One: Understanding the Meaning of Statistics ......

Words: 3466 - Pages: 14


...Confidence Interval is 15.08 ounces (rounded to two decimal places). The final stage in my investigation consisted of conducting a hypothesis test to verify if the claim that a bottle contains less than 16 ounces of soda is supported. Since the claim is in regards to the proportion of soda inside of the bottle, the hypothesis test is for the parameter (How to Test, 2014). The claim is p ≠ 0.16 ounces. There is enough evidence to support this claim and to reject the claim made by my company, which suggests p = 0.16 ounces. Therefore, p ≠ 0.16 ounces is the alternative hypothesis, and the null hypothesis is p = 0.16 ounces. H0: p = 0.16 H1 p ≠ 0.16 The sample size is n = 30 and the sample proportion is 2/30. The value of the test statistic is the z-value corresponding to the sample proportion under the assumption that H0 is true (How to Test, 2014). I calculated 2/30-0.16. Next, I calculated √(0.16(1-0.16) )/30. Finally, I divided the first calculation by the second calculation and received ≈ -1.394. Since H1 contains the symbol ≠, my hypothesis test is two-tailed and must have two critical values. The critical values are –Zα/2 and Zα/2 where Zα/2 is the Z-value that cuts off an area in the right tail of a standard normal density. The significance level is 0.05. Therefore the critical values rounded to three decimal places are ≈ -1.960 and 1.960. –Zα/2 = –Z0.025 ≈ -1.960 Zα/2 = Z0.025 ≈ 1.960 Since the test value does not fall in the critical region, the......

Words: 880 - Pages: 4


...Refer to the "Visual Learner: Statistics" for examples to help complete the problems in the attached worksheet. Also, to aide in the Excel calculations, view the appropriate section of the Excel tutorials. Answer each question completely in the Excel worksheet provided. Name: Date: Topic One: Mean, Variance, and Standard Deviation Please type your answer in the cell beside the question Iam attaching the forum below  Workbook Exercises 11 and 16 Due Date: Jun 29, 2014 23:59:59       Max Points: 80 Details: Complete Exercises 11 and 16 in Statistics for Health Care Research: A Practical Workbook, and submit as directed by the instructor. In order to receive full credit on calculated answers, please show your work. (Use Word's equation editors, etc., and/or provide a short written description as to how you obtained the final result.) ------------------------------------------------- EXERCISE 11 USING STATISTICS TO DESCRIBE A STUDY SAMPLE ------------------------------------------------- STATISTICAL TECHNIQUE IN REVIEW Most studies describe the subjects that comprise the study sample. This description of the sample is called the sample characteristics which may be presented in a table or the narrative of the article. The sample characteristics are often presented for each of the groups in a study (i.e. experimental and control groups). Descriptive statistics are used to generate sample characteristics, and the type of statistic used depends on the level......

Words: 3145 - Pages: 13


...characteristics which may be presented in a table or the narrative of the article. The sample characteristics are often presented for each of the groups in a study (i.e. experimental and control groups). Descriptive statistics are used to generate sample characteristics, and the type of statistic used depends on the level of measurement of the demographic variables included in a study (Burns & Grove, 2007). For example, measuring gender produces nominal level data that can be described using frequencies, percentages, and mode. Measuring educational level usually produces ordinal data that can be described using frequencies, percentages, mode, median, and range. Obtaining each subject's specific age is an example of ratio data that can be described using mean, range, and standard deviation. Interval and ratio data are analyzed with the same type of statistics and are usually referred to as interval/ratio level data in this text. RESEARCH ARTICLE Source: Troy, N. W., & Dalgas-Pelish, P. (2003). The effectiveness of a self-care intervention for the management of postpartum fatigue. Applied Nursing Research, 16 (1), 38–45. Introduction Troy and Dalgas-Pelish (2003) conducted a quasi-experimental study to determine the effectiveness of a self-care intervention (Tiredness Management Guide [TMG]) on postpartum fatigue. The study subjects included 68 primiparous mothers, who were randomly assigned to either the experimental group (32 subjects) or the control group (36......

Words: 1436 - Pages: 6


...Statistics provides Hr managers with more confidence in dealing with uncertainty in spite of the flood of available data, enabling managers to more quickly make smarter decisions and provide more stable leadership to staff relying on them. Businesses are increasingly using Statistical techniques to convert data into information. Tools and techniques of Statistics are being widely used in HR in many domains that include Compensation survey, Performance Management, Employee Satisfaction Survey, Training Feedback Evaluation, Operational Research Techniques in HR, Human Resource Accounting, Acquisitions, Mergers, Restructuring and Downsizing, HR Budgeting etc. The most common areas where HRM can use information gathered from statistics to make improvements and changes within the company, include the following: Compensation survey: This will help the HR team identify if compensation programs, such as pension schemes, are working or if areas need to be addressed. This will help them identify how many staff are involved on a pension scheme and will help them tailor the service to suit their needs. Employee satisfaction: By carrying out staff surveys and questionnaires the HR will be able to identify how happy and satisfied the employees feel within the workplace. This will help identify areas where more attention or investment is needed and may even help a potential problem from growing out of control. Training and support: By regularly asking staff if they feel they......

Words: 872 - Pages: 4


...Quantitative Data Categorical Limited number – distinct categories No Quantitative Large number Yes Possible values for variable Measurement units? EXAMPLE. Which variables are quantitative and which are categorical? Employee # Age (years) Annual Income (in Performance 1,000s of dollars) Rating (1-5 scale) 5543 48 50 – 100 4.5 2431 34 20 – 49 3.9 7281 31 0 – 19 3.4 Job Type Management Clerical Maintenance 2. SURVEYS AND SAMPLING Population: _______ individuals with a common characteristic that you want to generalize about Parameter: fact or characteristic about _____________ Sample: ________ of population Statistic: fact or characteristic about ______________ EXAMPLE. Mattel claims that less than 5% of all its Hot Wheels toys are defective. When testing 100 Hot Wheels toys from a production run of 7000 toys, 7% were found to be defective. What is the: a) Population? c) Parameter? Poor (Biased) Sampling   Convenience sampling: Choosing respondents that are __________ to obtain Voluntary response: Respondents volunteer, so those with __________ opinions are more likely to respond b) Statistic? d) Sample? Sampling Designs 1. Simple Random Sampling (SRS): Every individual has an equal chance of being selected 2. Stratified Random Sampling: Divide population into ______________ subgroups and randomly select from each stratum 3. Cluster Random Sampling: Divide population into ______________ subgroups that are representative of population and select a few......

Words: 2677 - Pages: 11


...possibilities, it is statistics that is relied upon to find solutions to the problems and help determine what possibilities are truly feasible. Statistics may be best defined as the means by which data is gathered, analyzed, and interpreted to better understand a problem or situation. There are two types of data that can be analyzed in statistics. These are quantitative and qualitative data. Quantitative data deals with actual numbers and percentages, things that can be measured. Qualitative data deals with things which cannot be measured, but only perceived, such as color, texture, or odor. For example, one may say that a painting’s dimensions are 15” by 20”. This is quantitative data. One may then say that the painting’s primary color used is yellow. This is qualitative data. Quantitative data deals with quantity, where qualitative data deals with quality. There are four levels of measuring data in statistics. These levels are, in ascending order of specificity: nominal, ordinal, interval, and ratio. Nominal levels of measurement deal with names and categories. Ordinal levels deal with ordering the data, but no distinguishing observations can be made. On the interval level, data can be ordered in a way that does make sense and make a difference in perception. At the ratio level, meaningful ratios can be made to represent the data at hand. For example, distance works on a ratio level. In business, statistics plays a vital role in the decision making process. Statistics......

Words: 575 - Pages: 3


...Welcome to… π ∑θ Business statistics (MA-205) 1 Business Statistics π ∑θ Why study Business Statistics? • To become a better consumer of other people’s data • To facilitate communication • To improve computer skills • To overcome either too little or too much information • To develop technical literacy • To improve career mobility 2 Business Statistics π ∑θ Lecturer: Business Statistics Ammara 3 Business Statistics π ∑θ Lecture Overheads and Textbook Lecture overheads: posted on the Business Statistics Group Group name: business_statistics_bba Group home page: Group email: before the week in which lectures are given. Textbook: Richard I. Lavin and David S. Rubin, “Statistics for Management”, Prentice Hall, New York,7th edition(2000) 4 Business Statistics π ∑θ • • • • Assessment Final Examination: Midterm Examination: Quizzes/Homework/Term Project: Total: 45% 35% 20% 100% 5 Business Statistics Regular work and study is the key to success π ∑θ • It can never be emphasised strongly enough how true this is for Business Statistics • This course rewards those students who put constant effort into it over the semester 6 Business Statistics π ∑θ How to do well in the class Statistics is a problem-solving subject. Practice in problem solving, and completing and understanding the assigned reading......

Words: 865 - Pages: 4


...825 100 915 1191 1151 630 1175 952 1100 1140 750 1140 1370 960 1035 1280 1. What is the 78th percentile of the data set? a. 1160.6 b. 1177.88 c. 1151 d. 1171 e. None of the above, specify__________ 2. What is the IQR of the data set? a. 160.25 b. 153 c. 1270 d. 313.25 e. None of the above, specify__________ 3. What is the percentile rank for the observation, 1126.58? a. 56.77 d. 67 b. 66 e. None of the above, specify__________ c. 66.66 Use the following data for the next 2 questions: The following data give the salaries (in thousands of dollars) of the pitchers of baseball team. 5375 4333 350 2125 215 235 3000 2833 4125 13350 750 10000 763 1533 8000 Page 1 of 5 STATISTICS FOR BUSINESS (BA080IU) Midterm Examination Review | SAMPLE TEST 06 Vietnam International University (VNU) – HCMC INTERNATIONAL UNIVERSITY (IU) 4. What are the mean and the variance of the data set? a. 3799.13; 3924.85 b. 3799.13; 15404474.98 c. 2905.17; 14377509.98 Semester 01, Academic Year 2014 - 2015 ------o0o-----d. 2905.17; 15404474.98 e. None of the above, specify__________ 5. Using the Chebyshev’s Theorem, what is the interval that contains the salaries of at least 74% of all the pitchers of baseball team? a.  4050.57; 11648.84 d.  4977.11; 12575.37 e. None of the above, specify__________ b.  7975.43; 15573.69 c.  3898.14; 11496.40 6. At a car park there are 121 vehicles, 75 of which are cars, 26......

Words: 2058 - Pages: 9


...1. Original Data. Due to the recent restructure of the company that resulted in personnel redundancy, the top management of JSC “TESS” * requested to investigate the average level of the job satisfaction (JSL) of the employees. To carry out the analysis we have collected 203 questionnaires (Appendix _) as a sample of total population. Total population: 1200 employees. The main objectives of the analysis are: * To compare the mean JSL with the top-management statement; * To find out if there is a significant difference in mean JSL between the groups of employees with different work experience at the company. * To investigate if the mean JSL differs between the branches of the company. The data set used for the analysis: Variable | How the variable is measured | Branch | Branches of the company:1= TESS-Nizhnevartovsk, TESS-Kogalym2= TESS Head Office, TESS-Surgut3=TESS-Tyumen, TESS-Khanty-Mansiysk | Number | Number of the respondent | Work_Exp | Work Experience in JSC “TESS”:1= 2 year or less 2= more than 2 years | JSL | Job Satisfaction Level:Ratings from 1 to 5 where 1= very unsatisfied, 5= very satisfied and 0= no answer/blank | 1.2. Revised Data. Test for Normal Distribution To proceed with the analysis it is necessary to determine if the data are distributed normally. The Histogram below as well as the Descriptive Statistics (Appendix 1, Table 1b) show that the data distribution is leptokurtic (kurtosis is 2,021) and negatively skewed...

Words: 2253 - Pages: 10


...a rationale for your answer. The baseline 14.00 and posttest 13.36. Yes. It shows that there were little to no change in depression. 4. Compare the mean baseline and posttest depression score of the control groups? Provide a rationale for your answer. Both the baseline and posttest depression score were 10.40. This score indicates that the self management of ESRD may benefit from Empowerment Intervention in the future. 5. Which group’s score had the least variability or dispersion? Provide a rationale for your answer. The control group had the least amount to variability of dispersion. The control group only had one are of dispersion that was self-care/ self efficacy for the baseline and posttest. 6. Did the empowerment variable or self-care self efficacy variable demonstrate the greatest amount of dispersion? Provide a rationale for your answer. Self-care self efficacy SD baseline 14.02 posttest 12.24: empowerment SD baseline 9.02 posttest 8.91 7. The mean is a measurement of central tendency of a distribution while the SD is measure of dispersion of its scores. Both X and SD are descriptive statistics. 8. What was the mean severity for renal disease for the research subjects? What was the dispersion or variability of the renal disease severity scores? Did the severity score vary significantly between the control group and the experimental group? Is this important? Provide a rationale for your answer. The mean severity was moderately severe (...

Words: 448 - Pages: 2

Relationship of Statistics and Effective Management

...Relationship of Statistics and Effective Management Relationship of Statistics and Effective Management I thank you for allowing me the opportunity to explain how statistics is beneficial to me in my position as a manager. As you are well aware, decision making is a key aspect in your role as a manager. No person can be expected to always do things perfectly, as we are all human. Knowing this, when I make a decision that affects myself and the company as a whole I want to be certain that I am seeing a good view of things. Basing decisions solely on feelings or pressure from various departments of the company are not always the best thing for the company. So to help with the assurance to make sure I am making logical beneficial decisions for the company I employ statistics. Before our budgets are created for the next fiscal year, I log into the computer and run several reports. The reports that I run are based on statistics. The end result or numbers that are printed out are pulled from information on several other databases. Things such as expenses, sales, material costs all are plugged into formulas. I then run other formulas to evaluate the data based on several variables or what if scenarios. I then present the final information to our Controller showing potential profits or losses for our company based on activity. When the time comes to undertake a new project, research must first be performed. When information is gathered or......

Words: 718 - Pages: 3


...The purpose of this paper is to determine which methods of statistics are used as a measuring tool and what levels of measurements are used or could be used to improve the decision-making process for this organization. Statistics in the Workplace Many areas of the hospital facility use statistics in measurement. How do statistics affect this hospital healthcare facility in women services? One example is measuring nurse/patient ratios based on patient census and acuity. Patient acuity and census determines how many nurses are assigned to each patient based on their acuity. This also ensures patient and personnel safety. Patient satisfaction surveys are performed to improve patient care outcome as measured by HCAHPS (Hospital Consumer Assessment of Healthcare Providers and Systems); these tactics were discovered by the Studer Group. HCAHPS encourages leaders and staff members alike to realize the results are meaningful and that they translate to better, more consistent quality care, which in turn translates to better patient outcome (Robinson & Cook, RN, 2010). Other examples, flu vaccinations offered to each mother during flu season (October-February), C-sections to epidural usage stats, evidence base practice-based on data collections, mathematitons work out acceptable variable/quantities acceptably, maternal hepatitis B status (mandatory reporting by the state of Fresno, county), all delivery-related statistics for internal distribution (total number of deliveries,......

Words: 1085 - Pages: 5


...Statistics are the use of data to classify, organize, analyzing, summarize, and collecting numerical information in large quantities. There are actually only two different types of statistics. Statistics are the collection of data, and the organization of the data. The two types of statistics that can be used are qualitative and quantitative ("What Are The Different Type Of Statistics", n.d). The other names for qualitative and quantitative are inferential statistics and Descriptive statistics. The Qualitative method deals with descriptions in which the data observed not measured, which includes colors, textures, smell, tastes, and appearance. The Quantitative method uses numbers. The data measured, like the length, height, area, volume, time etc The levels of statistics are nominal in which objects have names or labels. When the data is in order, the name is the ordinal level. The interval level shows where the difference between data has a meaning. The last one the ratio level where the ratio has a meaning and a natural zero starting point. The role of statistics in business decision making is very vital to businesses is because the data provided helps make sure of less mistakes. Statistical analysis of a representative group of consumers can provide a reasonably accurate, cost-effective snapshot of the market with faster and cheaper statistics than attempting a census of very single customer a company may ever deal with. The statistics can also afford leadership......

Words: 377 - Pages: 2