Purchase Solution

Constructing a control chart using excel

Not what you're looking for?

Ask Custom Question

The funds-transfer department of a bank is concerned with turnaround time for investigations of funds-transfer payments. A payment may involve the bank as a remitter of funds, a beneficiary of funds, or an intermediary in the payment. An investigation is initiated by a payment inquiry or a query by a party involved in the payment or any department affected by the flow of funds. When a query is received, an investigator reconstructs the transaction trail of the payment and verifies that the information is correct and that the proper payment is transmitted. The investigator then reports the results of the investigation, and the transaction is considered closed. It is important that investigations be closed rapidly, preferably within the same day. The number of new investigations and the number of proportion closed on the same day that the inquiry was made are stored in FundTran.
a. Construct a control chart for these data.
b. Is the process in a state of statistical control? Explain
c. Based on the results of (a) and (b), what should management do next to improve the process?

A branch manager of a brokerage company is concerned with the number of undesirable trades made by her sales staff. A trade is considered undesirable if there is an error on the trade ticket. Trades with errors are canceled and resubmitted. The cost of correcting errors is billed to the brokerage company. The branch manager wants to know whether the proportion of undesirable trades is in a state of statistical control so she can plan the next step in a quality improvement process. Data were collected for a 30day period and stored in Trade.
a. Construct a control chart for these data.
b. Is the process in control? Explain.
c. Based on the results of (a) and (b), what should the manager do next to improve the process?

Attachments
Purchase this Solution
Solution Summary

The solution gives detailed steps on constructing control charts for given data using Excel and performs a short analysis. Two questions are answered in two excel files.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Constructing a p chart for given data using excel

    Please note that there are two tabs in excel. The solution gives detailed steps on constructing p chart for given data using excel and performs a short analysis.

  • Home Market Value vs Age: Scatter Chart, Trendline, Regression

    Using the data in the Excel file Demographics, determine if a linear relationship exists between unemployment rates and cost of living indexes by constructing a scatter chart and adding a trendline. What is the regression model and R1? 3.

  • Regression Analysis

    Using the data in the Excel file Demographics, determine if a linear relationship exists between unemployment rates and cost of living indexes by constructing a scatter chart and adding a trendline. What is the regression model and R1? 3.

  • create a histogram

    384977 Creating a Histogram Obtain the mean and standard deviation for data attached and create a histogram for data frequencies using Microsoft Excel program.

  • SQC- P chart

    Step by step method for constructing a p chart is given in the answer.

  • SPC Chart

    542868 Prepares SPC Chart Data Complete the following actions, using the Excel file "Optional Problem Data Student File" for the actions involve Excel: 1.

  • Control charts:X bar and R charts

    Prob. 7-7 in the attached worksheet a. construct a p chart and interpret the results b. after the process was determined to be under control, process monitoring began, using the established control limits.

  • Control Charts: Upper and Lower

    Thanks for using BrainMass. Excel file contains control chart and compares UCL and LCL against the points plotted.

  • 99.7% upper and lower control limits in a control chart

    I also uploaded an Excel file that demonstrates how to use Excel build-in functions to compute UCL and LCL. Please feel free to ask me if you have any further questions. What are the control limits in a control chart? What do they mean?

View More Related Solutions