Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    Sl. No. Probable Cause Count

    Uploaded by

    Akshaya Lakshminarasimhan
    The document contains data from surveys of 200 employees at a company about the probable causes of complaints. It includes tables with the causes and their counts, sample size and number of complaints in different samples, and statistical analysis of the data like means, standard deviations, control limits, and a p-chart.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Sl. No. Probable Cause Count

    Uploaded by

    Akshaya Lakshminarasimhan
    25 views6 pages
    The document contains data from surveys of 200 employees at a company about the probable causes of complaints. It includes tables with the causes and their counts, sample size and number of complaints in different samples, and statistical analysis of the data like means, standard deviations, control limits, and a p-chart.

    Original Title

    Excel Solns

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains data from surveys of 200 employees at a company about the probable causes of complaints. It includes tables with the causes and their counts, sample size and number of complaints in different samples, and statistical analysis of the data like means, standard deviations, control limits, and a p-chart.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    25 views6 pages

    Sl. No. Probable Cause Count

    Uploaded by

    Akshaya Lakshminarasimhan
    The document contains data from surveys of 200 employees at a company about the probable causes of complaints. It includes tables with the causes and their counts, sample size and number of complaints in different samples, and statistical analysis of the data like means, standard deviations, control limits, and a p-chart.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 6

    Sl. No.

    Probable cause Count


    1 Less agile 5
    Delay In loading
    2 41
    and unloading
    Fraudulent
    3 14
    customers
    4 Rely on vendors 108
    5 Outdated trucks 10
    Low computer
    6 8
    literacy
    Redundant paper
    7 2
    work
    8 Lack of SOP 93
    Improper data
    9 16
    entry
    10 Leadership 3

    Sl No. Sample size No. of complaints p Value P(bar)

    1 200 14 0.07 0.05775


    2 200 8 0.04 0.05775
    3 200 13 0.065 0.05775
    4 200 18 0.09 0.05775
    5 200 15 0.075 0.05775
    6 200 5 0.025 0.05775
    7 200 12 0.06 0.05775
    8 200 17 0.085 0.05775
    9 200 21 0.105 0.05775
    10 200 20 0.1 0.05775
    11 200 9 0.045 0.05775
    12 200 7 0.035 0.05775
    13 200 5 0.025 0.05775
    14 200 11 0.055 0.05775
    15 200 21 0.105 0.05775
    16 200 14 0.07 0.05775
    17 200 10 0.05 0.05775
    18 200 3 0.015 0.05775
    19 200 4 0.02 0.05775
    20 200 4 0.02 0.05775
    Mean 11.55
    Std Dev 5.906953975033
    p(bar) 0.05775
    n(bar) 200
    UCL 0.107234059933
    LCL 0.008265940067
    StdDev 5.906953975033
    USL 23.62781590013
    LSL -6.170861925099
    Cpl 1
    Cpu 0.681559167448
    Cp 0.840779583724
    Cpk
    USL-Mean/3std dev 0.681559167448
    Mean-LSL/3std dev 1

    1.431623931624
    CAUSES OF COMPLAINTS ACCORDIN
    10 Leadership

    9 Improper data entry

    8 Lack of SOP

    7 Redundant paper work

    6 Low computer literacy

    5 Outdated trucks

    4 Rely on vendors

    3 Fraudulent customers

    2 Delay In loading and unloading

    1 Less agile

    0 20 40

    Upper Control Limit Lower Control Limit


    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522 p-chart
    0.107234059933478 0.008265940066522
    0.12 UCL=0.10
    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522 0.1
    0.107234059933478 0.008265940066522
    0.08
    0.107234059933478 0.008265940066522 p(bar)=0
    0.107234059933478 0.008265940066522 0.06

    0.107234059933478 0.008265940066522 0.04


    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522 0.02
    LCL=0.0
    0.107234059933478 0.008265940066522 0
    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522 Column E Column F Column G Column H
    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522
    0.107234059933478 0.008265940066522
    F COMPLAINTS ACCORDING TO GATI EMPLOYEES

    20 40 60 80 100 120

    This chart isn't available in your version of Excel.


    hart Editing this shape or saving this workbook into a different file format will
    UCL=0.10723 permanently break the chart.

    p(bar)=0.05775

    LCL=0.0082
    0 11 12 13 14 15 16 17 18 19 20

    Column G Column H
    Excel.

    nto a different file format will

    You might also like