Statistical tools and data analysis

Assignment Help Operation Management
Reference no: EM131131451

Final Project Milestone Two: Statistical Tools and Data Analysis

Submit a paper and a spreadsheet that provides a justification of the appropriate statistical tools needed to analyze the company’s data, a hypothesis, the results of your analysis, any inferences from your hypothesis test, and a forecasting model that addresses the company’s problem.

For additional details, please refer to the Milestone Two Guidelines and Rubric document in the Assignment Guidelines and Rubrics section of the course.

selection of statistical tools and data analysis

III. Identify statistical tools and methods to collect data: A. Identify the appropriate family of statistical tools that you will use to perform your analysis. What are your statistical assumptions concerning the data that led you to selecting this family of tools? In other words, why did you select this family of tools for statistical analysis? B. Determine the category of the provided data in the given case study. Be sure to justify why the data fits into this category type. What is the relationship between the type of data and the tools? C. From the identified family of statistical tools, select the most appropriate tool(s) for analyzing the data provided in the given case study. D. Justify why you chose this tool to analyze the data. Be sure to include how this tool will help predict the use of the data in driving decisions. E. Describe the quantitative method that will best inform data-driven decisions. Be sure to include how this method will point out the relationships between the data. How will this method allow for the most reliable data?

IV. Analyze data to determine the appropriate decision for the identified problem: A. Outline the process needed to utilize your statistical analysis to reach a decision regarding the given problem. B. Explain how following this process leads to valid, data-driven decisions. In other words, why is following your outlined process important? C. After analyzing the data sets in the case study, describe the reliability of the results. Be sure to include how you know whether the results are reliable. D. Illustrate a data-driven decision

QSO 510 Final Project Case Addendum Vice-president Arun Mittra speculates: We have always estimated how many transformers will be needed to meet demand. The usual method is to look at the sales figures of the last two to three months and also the sales figures of the last two years in the same month. Next make a guess as to how many transformers will be needed. Either we have too many transformers in stock, or there are times when there are not enough to meet our normal production levels. It is a classic case of both understocking and overstocking. Ratnaparkhi, operations head, has been given two charges by Mittra. First, to develop an analysis of the data and present a report with recommendations. Second, “to come up with a report that even a lower grade clerk in stores should be able to fathom and follow.” In an effort to develop a report that is understood by all, Ratnaparkhi decides to provide incremental amounts of information to his operations manager, who is assigned the task of developing the complete analyses. A-Cat Corporation is committed to the pursuit of a robust statistical process control (quality control) program to monitor the quality of its transformers. Ratnaparkhi, aware that the construction of quality control charts depends on means and ranges, provides the following descriptive statistics for 2006 (from Exhibit 1). 2006 Mean 801.1667 Standard Error 24.18766 Median 793 Mode 708 Standard Deviation 83.78851 Sample Variance 7020.515 Kurtosis -1.62662 Skewness 0.122258 Range 221 Minimum 695 Maximum 916 Sum 9614 Count 12 The operations manager is assigned the task of developing descriptive statistics for the remaining years, 2007–2010, that are to be submitted to the quality control department. A-Cat’s president asks Mittra, his vice-president of operations, to provide the sales department with an estimate of the mean number of transformers that are required to produce voltage regulators. Mittra, recalling the product data from 2006, which was the last year he supervised the production line, speculates that the mean number of transformers that are needed is less than 745 transformers. His analysis reveals the following: t = 2.32 p = .9798 This suggests that the mean number of transformers needed is not less than 745 but at least 745 transformers. Given that Mittra uses older (2006) data, his operations manager knows that he substantially underestimates current transformers requirements. She believes that the mean number of transformers required exceeds 1000 transformers and decides to test this using the most recent (2010) data. Initially, the operations manager possessed only data for years 2006 to 2008. However, she strongly believes that the mean number of transformers needed to produce voltage regulators has increased over the three-year period. She performs a one-way analysis of variance (ANOVA) analysis that follows: 2006 2007 2008 779 845 857 802 739 881 818 871 937 888 927 1159 898 1133 1072 902 1124 1246 916 1056 1198 708 889 922 695 857 798 708 772 879 716 751 945 784 820 990 Anova: Single Factor SUMMARY Groups Count Sum Average Variance 2006 12 9614 801.1667 7020.515 2007 12 10784 898.6667 18750.06 2008 12 11884 990.3333 21117.88 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 214772.2 2 107386.1 6.870739 0.003202 3.284918 Within Groups 515773 33 15629.48 Total 730545.2 35 The results (F = 6.871 and p = 0.003202) suggest that indeed the mean number of transformers has changed over the period 2006–2008. Mittra has now provided her with the remaining two years of data (2009 and 2010) and would like to know if the mean number of transformers required has changed over the period 2006–2010. Finally, the operations manager is tasked with developing a model for forecasting transformer requirements based on sales of refrigerators. The table below summarizes sales of refrigerators and transformer requirements by quarter for the period 2006–2010, which are extracted from Exhibits 2 and 1 respectively. Sales of Refrigerators Transformer Requirements 3832 2399 5032 2688 3947 2319 3291 2208 4007 2455 5903 3184 4274 2802 3692 2343 4826 2675 6492 3477 4765 2918 4972 2814 5411 2874 7678 3774 5774 3247 6007 3107 6290 2776 8332 3571 6107 3354 6792 3513

Reference no: EM131131451

Questions Cloud

Effect of worker rights on global and developing economies : Considering the effect of worker rights on global and developing economies, take a position on whether or not the United States government should regulate the global workforce of the United States corporations. Justify your response.
Discuss advantages-disadvantages to private transportation : Extreme Hats wanted to bid on a huge festive event of which 6,200 large party hats would be needed. The Style A hats were cylinders that were 11 inches high and 12 inches in diameter and were packed into boxes that were 12 by 12 by 12 inches. Extreme..
What is the appropriate marketing strategies : What is the appropriate marketing strategies for the Memorial Sloan Kettering Cancer Centerof NY. Consider the organization’s lifecyle and marketplace lifecyle and make a recommendation on an appropriate strategy.
Identify the emotional and intellectual issues that arose : PROJECT TERMINATION. You may be surprised to hear that 40% of IT application development projects are canceled before they are completed. And, 33% of the remaining IT projects experience cost and schedule overruns and/or changes in scope. Describe th..
Statistical tools and data analysis : Submit a paper and a spreadsheet that provides a justification of the appropriate statistical tools needed to analyze the company’s data, a hypothesis, the results of your analysis, any inferences from your hypothesis test, and a forecasting model th..
What level of transformation enables creation of position : After a successful implementation of ERP at Elf Atochem, a new Demand Manager position was created. Describe the responsibility of this position. In terms of IT-enabled business process transformation, what level of transformation enables the creatio..
Address the adverse effects of sweatshop labor practices : Determine at least three (3) ways in which United States’ businesses can address the adverse effects of sweatshop labor practices. Provide one (1) specific example of each way that you have just determined to support your response.
What are optimal order quantity and the expected profit : The X Air Conditioning Company is considering purchase of a special shipment of portable air conditioners from Japan. Each unit will cost X $800 and be sold for $1250. X does not want to carry over surplus air conditioners to the following year. What..
Specialized in the sales of one type of special fishing hook : Bob of Bob’s Fish and Tackle, has a business that specialized in the sales of one type of special fishing hook. The annual volume of hooks was 4,000 hooks per keg, and they were sold to retail customers in an even flow. Explain the logic of the EOQ m..

Reviews

Write a Review

 

Operation Management Questions & Answers

  Describe a possible mission for operations

Describe a possible mission for operations also some associated strategies which fit subsequent business situations. Ambulance service. Production of standard automobile batteries.

  Optimal order quantity-determine number of orders per year

A mail-order house uses 16,390 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,0..

  Statements is true about the kaizen philosophy

Which of the following statements is true about the kaizen philosophy?

  Value chain-competitive advantage and customer delight

Please provide a one paragraph summary related to reviewing the following three critical concepts (value chain/competitive advantage/customer delight) when thinking about how a value chain creates competitive advantage.

  How the various rationales of spc can be used to analyze

There are different rationales for using SPC, including control variation, continual improvement, predictability of processes, elimination of waste, and product inspection. Discuss the importance of these rationales.

  Sociology is the systematic study of human society

According to Macionis (2011), sociology is the systematic study of human society, within which falls the sociological perspective. Based upon your textbook reading, how might you use the sociological perspective if you were visiting a different count..

  Seth noticed problem with way one of the pockets was strung

Seth recently purchased a new Brunswick Billiards table for his recreation room. The next day after delivery, Seth noticed a problem with the way one of the pockets was strung. Since it was a weekend, he didn’t expect to have it repaired. She gave Se..

  Production scheduling

A simple model is sometimes used in order to illustrate the production-scheduling maxim, ‘‘balance how, not capacity.’’ Consider a factory that consists of three workstations where each work piece must proceed through the workstations in sequence. Wh..

  What is marketings most important role

What is marketing's most important role? Create value for consumers. Bring needed products and services to consumer groups.

  Talk about ethical theory and business ethics

Talk about ethical theory and business ethics. Why should employers be ethical when it comes to making decisions? Do you know of any companies that were punished due to an unethical behavior?

  Electronic data sharing system

At Banco do Brasil, a large financial services company in South America with more than 3,000 branch locations, its internal audit department covers a geographically broad area and serves a considerable number of clients. It decided to develop a(n) __..

  How changes in disease incidence and prevalence can impact

Discuss death rates, life expectancy, infant mortality, and other key demographic determinants of health trends in the United States.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd