Please see attachments for scenario and requred 4 steps to be completed
How to Make an SPC c Chart in Excel Transcript
I’d like to take a minute and show you how to make a statistical control chart and using the Excel OM software.
So if I go to my tab for Excel OM, you should already have installed on your computer, I can look it up either by chapter in the book or alphabetically. In this case, I’m going to be looking for a quality control chart and we’re going to be using the c Chart for this exercise. And let’s say I have five days’ worth of data or five samples or five weeks’ worth of data. You can put a title here if you want. And let’s go ahead and make sure that the graph button is checked. Select OK.
All right, it’s going to give me the number of sample errors. So say the first… First, we’ll use weeks. Saying Week 1, I had 10 errors that week. Maybe the next week I had seven errors, the next one four, and then seven errors, and six errors. And say that my company really wants to have a very tightly controlled error rate. So maybe I would change my standard deviation to two here.
So this produces my c Chart. And as you can see, everything is within control because you’re within the upper and lower control limits. So I hope this helps.
worldwide.erau.edu
All rights are reserved. The material contained herein is the copyright property of Embry-Riddle Aeronautical University, Daytona Beach, Florida, 32114. No part of this material may be reproduced, stored in a retrieval system, or transmitted in any form, electronic, mechanical, photocopying, recording or otherwise without the prior written consent of the University.