장바구니 담기 close

장바구니에 상품을 담았습니다.

장바구니로 계속쇼핑하기
엑셀을 활용한 품질경영
미리보기

엑셀을 활용한 품질경영

  • 노형진 ,유자양 ,동초희
  • |
  • 한올출판사
  • |
  • 2022-01-10 출간
  • |
  • 434페이지
  • |
  • 197 X 268 X 26 mm /1088g
  • |
  • ISBN 9791166471605
판매가

26,800원

즉시할인가

26,532 원

배송비

2,500원

(제주/도서산간 배송 추가비용:3,000원)

추가상품
상품선택
독서대 7,900원 독서대 선택안함 0원
수량
+ -
총주문금액
26,532원
장바구니 구매하기

※ 스프링제본 상품은 반품/교환/환불이 불가능하므로 신중하게 선택하여 주시기 바랍니다.

북스크린영상으로 만나보는 한 권의 책 이야기

목차


Part 01 통계적 품질관리 기본과정

Chapter 01 품질관리와 통계적 방법 ············································· 4

1. 품질관리의 기초지식 ···························································· 4

1) 품질관리의 개념 4

2) 품질관리와 문제해결기법 10

2. 통계적 품질관리 ································································ 11

1) 품질관리의 기법 11

2) 통계적 방법 15

3. 통계량에 의한 데이터의 요약 ··········································· 20

1) 기본 통계량에 의한 요약 20

2) 기술 통계법에 의한 요약 27

3) 공정능력지수 31

Chapter 02 그래프에 의한 데이터의 시각화 ································· 36

1. 그래프의 기본사항 ······························································ 36

1) 그래프의 목적과 종류 36

2) Excel의 그래프 작성기능 40

2. 그래프의 실제 ·································································· 42

1) 단일회답의 그래프화 42

2) 복수회답의 그래프화 49

3) 크로스 집계결과의 그래프화 50

Chapter 03 파레토도 ········································································ 57

1. 파레토도의 기본사항 ·························································· 57

2. 파레토도의 실제 ································································ 60

1) 파레토도의 작성 60

2) 파레토도의 응용 66

Chapter 04 히스토그램 ····································································· 70

1. 히스토그램의 기본 ······························································ 70

2. 히스토그램의 작성방법 ······················································ 72

3. 히스토그램의 대용 그래프 ················································· 84

1) 도트 플롯 84

2) 함수 REPT에 의한 대용 그래프 89

Chapter 05 이산확률분포 ································································· 93

1. 이항분포 ············································································· 93

2. 포아송 분포 ····································································· 112

3. 초기하분포 ······································································· 126

Chapter 06 연속확률분포 ······························································· 133

1. 정규분포 ··········································································· 133

2. 표준 정규분포 ·································································· 144

3. 지수분포 ··········································································· 152

Chapter 07 데이터의 수집과 표본추출법 ····································· 159

1. 데이터의 종류와 수집방법 ··············································· 159

2. 표본추출의 기본개념 ······················································· 163

3. 무작위추출법 ···································································· 163

1) 단순무작위추출법(simple random sampling) 164

2) 계통추출법(systematic sampling) 164

3) 집락추출법(cluster sampling) 165

4) 층별추출법(stratified sampling) 165

5) 다단추출법(multi-stage sampling) 165

4. 유의선출법 ······································································· 166

5. 표본추출의 실제 ······························································ 167

Chapter 08 관리도 ·········································································· 175

1. 계량치 관리도 ·································································· 175

1) 관리도의 개요 175

2) ? -x?? - R 관리도의 작성방법 179

3)? ~x?? - R 관리도의 작성방법 186

4) x?? - R?s 관리도의 작성방법 190

2. 계수치 관리도 ·································································· 196

1) pn 관리도의 작성방법 196

2) p 관리도의 작성방법 200

3) c 관리도의 작성방법 204

4) u 관리도 206

5) 관리도의 해석방법 209

Chapter 09 샘플링검사 ··································································· 213

1. 샘플링검사의 계획 ··························································· 213

1) 샘플링검사의 기초 213

2) 샘플링검사의 이론 215

3) OC 곡선과 샘플링검사방식의 설계 223

4) OC 곡선의 성질 225

5) 샘플링검사방식과 이해관계자의 보호 233

6) 샘플링검사의 절차 236

2. 각종 샘플링검사 ······························································ 237

1) 계수 규준형 샘플링검사 237

2) 계수 선별형 샘플링검사 240

3) 계수 조정형 샘플링검사 242

4) 계수 연속생산형 샘플링검사 243

5) 계량 규준형 샘플링검사 244

Chapter 10 관능평가 ······································································ 246

1. 관능평가의 기본사항 ························································ 246

1) 관능평가의 개념 246

2) 감각의 성질 247

2. 관능평가의 의의 ······························································ 251

3. 관능평가의 의미 ······························································ 252

1) 관능이란 무엇인가 252

2) JIS에 의한 관능평가의 정의 253

4. 관능평가의 특징 ······························································ 255

1) 관능평가와 이화학적 검사의 비교 255

2) 관능평가의 특질 256

5. 관능평가에 있어서의 데이터의 성질 ······························· 258

1) 척도의 분류 258

2) 관능평가에 있어서의 데이터 259

3) ‘간주한다’고 하는 것 261

6. 관능평가의 실제 ······························································ 262

1) 관능평가 데이터의 표현방법 262

2) 관능평가를 위한 수법 263

7. 관능특성 데이터의 분석과 통계적 관능평가법 ····················· 267

1) 관능특성 데이터의 분석 267

2) 통계적 관능평가법의 개요 267

3) 통계적 관능평가의 실제 269

Part 02 통계적 품질관리 응용과정

Chapter 11 실험의 계획과 실시 ···················································· 274

1. 실험계획법 ········································································ 274

1) 실험의 추진방법 274

2) 실험계획법의 용어 277

3) 인자의 종류 279

2. 실험의 실시 ····································································· 281

1) 실험의 원칙 281

2) 실험의 형식 284

Chapter 12 일원배치 실험 ····························································· 291

1. 일원배치 실험의 계획과 해석 ·········································· 291

1) 실험순서의 랜덤화 291

2) 분산분석의 이론 294

2. 데이터 분석의 실제 ························································· 299

1) 질적 인자의 경우 299

2) 양적 인자의 경우 310

3) 분석 도구에 의한 분산분석 315

Chapter 13 이원배치 실험 ····························································· 318

1. 반복이 없는 이원배치 실험 ············································· 318

1) 실험 데이터의 분석 318

2) Excel에 의한 데이터의 분석 323

3) 분석 도구에 의한 분산분석 328

2. 반복이 있는 이원배치 실험 ············································· 331

1) 실험 데이터의 분석 331

2) Excel에 의한 데이터의 분석 334

3) 분석 도구에 의한 분산분석 345

Chapter 14 다원배치 실험 ····························································· 350

1. 3원배치 실험 ···································································· 350

1) 실험 데이터의 분석 350

2) Excel에 의한 데이터의 분석 355

2. 난괴법 ·············································································· 363

1) 실험 데이터의 분석 363

2) Excel에 의한 데이터의 분석 366

Chapter 15 비모수통계분석 ··························································· 369

1. 크러스컬－월리스의 순위검정 ·········································· 369

1) 실험 데이터의 분석 369

2) Excel에 의한 데이터의 분석 372

2. 프리드만의 순위검정 ······················································· 375

1) 실험 데이터의 분석 375

2) Excel에 의한 데이터의 분석 377

Chapter 16 직교배열 ······································································ 381

1. 직교배열표에 의한 실험의 계획 ······································ 381

1) 직교배열표의 이용 381

2) 할당의 실제 386

2. 직교배열 실험의 데이터 분석 ········································· 388

1) 분산분석의 방법 388

2) Excel에 의한 직교표 데이터의 분석 391

Chapter 17 다중비교 ······································································ 401

1. 최소유의차법 ···································································· 401

1) 최소유의차법의 실제 401

2) Excel에 의한 해법 404

2. Bonferroni법 ··································································· 407

1) Bonferroni법의 실제 407

2) Excel에 의한 해법 409

● 참고문헌 / 412

● Index / 414
추천포스트

교환 및 환불안내

도서교환 및 환불
  • ㆍ배송기간은 평일 기준 1~3일 정도 소요됩니다.(스프링 분철은 1일 정도 시간이 더 소요됩니다.)
  • ㆍ상품불량 및 오배송등의 이유로 반품하실 경우, 반품배송비는 무료입니다.
  • ㆍ고객님의 변심에 의한 반품,환불,교환시 택배비는 본인 부담입니다.
  • ㆍ상담원과의 상담없이 교환 및 반품으로 반송된 물품은 책임지지 않습니다.
  • ㆍ이미 발송된 상품의 취소 및 반품, 교환요청시 배송비가 발생할 수 있습니다.
  • ㆍ반품신청시 반송된 상품의 수령후 환불처리됩니다.(카드사 사정에 따라 카드취소는 시일이 3~5일이 소요될 수 있습니다.)
  • ㆍ주문하신 상품의 반품,교환은 상품수령일로 부터 7일이내에 신청하실 수 있습니다.
  • ㆍ상품이 훼손된 경우 반품 및 교환,환불이 불가능합니다.
  • ㆍ반품/교환시 고객님 귀책사유로 인해 수거가 지연될 경우에는 반품이 제한될 수 있습니다.
  • ㆍ스프링제본 상품은 교환 및 환불이 불가능 합니다.
  • ㆍ군부대(사서함) 및 해외배송은 불가능합니다.
  • ㆍ오후 3시 이후 상담원과 통화되지 않은 취소건에 대해서는 고객 반품비용이 발생할 수 있습니다.
반품안내
  • 마이페이지 > 나의상담 > 1 : 1 문의하기 게시판 또는 고객센터 1800-7327
교환/반품주소
  • 경기도 파주시 문발로 211 1층 / (주)북채널 / 전화 : 1800-7327
  • 택배안내 : CJ대한통운(1588-1255)
  • 고객님 변심으로 인한 교환 또는 반품시 왕복 배송비 5,000원을 부담하셔야 하며, 제품 불량 또는 오 배송시에는 전액을 당사에서부담 합니다.