Question
FAST ANSWERS_PHD
SSG120IMPROVEWeek7.xlsxImprove (Scatter Diagram)
| Objective: | |||||||||
| A team member has been saying since day one that there is a correlation between | |||||||||
| temperature and the thickness. Should the team have listened? Construct a scatter | |||||||||
| diagram and calculate the correlation coefficient to see if she is correct. | |||||||||
| Instructions for you: | |||||||||
| Step 1: Construct a scatter diagram using the Room Availability and Patient Arrival Time data. | |||||||||
| Step 2: Calculate the correlation coefficient between the two variables. | |||||||||
| Step 3: Determine the direction and strength of the relationship (if any) between | |||||||||
| temperature and thickness. | |||||||||
| Data: | |||||||||
| Data: | Paient Arrival Time | Room Availability | |||||||
| 0.554 | 154 | Scatter diagrams in Excel 2003 or earlier
Diane Johnson: Instructor: 1) Click on Chart icon on top task bar, OR Click on the INSERT menu option at the top menu bar. 2) Click on SCATTER from the Standard Types tab 3) Click Next 4) Highlight both columns of data and finish according to the directions. If you would like to print this tip, right click on the cell and select EDIT COMMENT. Then just highlight and copy the text, and paste in a document for printing. |
|||||||
| 0.553 | 153 | ||||||||
| 0.552 | 152 | Scatter diagrams in Excel 2007 or later
Diane Johnson: Instructor: 1) Highlight both columns of data 2) Click INSERT tab at the top 3) Go to CHART category 4) Click on SCATTER and your scatter diagram appears If you would like to print this tip, right click on the cell and select EDIT COMMENT. Then just highlight and copy the text, and paste in a document for printing. |
|||||||
| 0.551 | 152 | ||||||||
| 0.549 | 151 | Correlation Coefficient - Excel 2003 or earlier
Diane Johnson: Instructor: 1) Click on the fx in the top bar and CORREL, or click on INSERT, function, CORREL. 2) Highlight each column of data as an ARRAY 3) Click Okay. 4) Excel will calculate the correlation coefficient. The correlation coefficient ranges between zero and one. Zero is no correlation and '1' is a perfect correlation. __________________________________________ -1.0 to -0.7 strong negative association. -0.7 to -0.3 weak negative association. -0.3 to +0.3 little or no association. +0.3 to +0.7 weak positive association. +0.7 to +1.0 strong positive association. If you would like to print this tip, right click on the cell and select EDIT COMMENT. Then just highlight and copy the text, and paste in a document for printing. |
|||||||
| 0.549 | 151 | ||||||||
| 0.548 | 151 | Correlation Coefficient - Excel 2007 or later
Diane Johnson: Instructor: 1) Click on the fx in the top bar and CORREL, or click on FOMULAS, INSERT function, CORREL. 2) Highlight each column of data as an ARRAY 3) Click Okay. 4) Excel will calculate the correlation coefficient. The correlation coefficient ranges between zero and one. Zero is no correlation and '1' is a perfect correlation. __________________________________________ -1.0 to -0.7 strong negative association. -0.7 to -0.3 weak negative association. -0.3 to +0.3 little or no association. +0.3 to +0.7 weak positive association. +0.7 to +1.0 strong positive association. If you would like to print this tip, right click on the cell and select EDIT COMMENT. Then just highlight and copy the text, and paste in a document for printing. |
|||||||
| 0.548 | 151 | ||||||||
| 0.548 | 151 | ||||||||
| 0.547 | 151 | ||||||||
| 0.547 | 151 | ||||||||
| 0.547 | 151 | ||||||||
| 0.547 | 151 | ||||||||
| 0.547 | 151 | ||||||||
| 0.547 | 151 | ||||||||
| 0.546 | 151 | ||||||||
| 0.546 | 150 | ||||||||
| 0.546 | 150 | ||||||||
| 0.546 | 150 | ||||||||
| 0.546 | 150 | ||||||||
| 0.546 | 150 | ||||||||
| 0.545 | 150 | ||||||||
| 0.545 | 150 | ||||||||
| 0.545 | 150 | ||||||||
| 0.545 | 149 | ||||||||
| 0.545 | 149 | ||||||||
| 0.545 | 149 | ||||||||
| 0.545 | 148 | ||||||||
| 0.543 | 148 | ||||||||
| 0.543 | 148 | ||||||||
| 0.542 | 147 | ||||||||
| 0.542 | 147 | ||||||||
| 0.541 | 146 | ||||||||
| 0.540 | 146 | ||||||||
| 0.538 | 145 | ||||||||
| Target Assignment Date - Submit by the end of Week 7 or earlier | |||||||||
| INCLUDE SCATTER DIAGRAM AND CORRELATION FORMULA | |||||||||
| Project: | SSG120 | ||||||||
| Deliverable: | Scatter Diagram | ||||||||
| Student last name: | Your last name here | ||||||||
| Is there strong correlation between patient arrival time and room availability? | HINT!
Lois Jordan: Be sure to base your decision on the criteria for "strong" correlation shown in this class! |
||||||||
|
Diane Johnson: Instructor: 1) Highlight both columns of data 2) Click INSERT tab at the top 3) Go to CHART category 4) Click on SCATTER and your scatter diagram appears If you would like to print this tip, right click on the cell and select EDIT COMMENT. Then just highlight and copy the text, and paste in a document for printing. |
Diane Johnson: Instructor: 1) Click on the fx in the top bar and CORREL, or click on INSERT, function, CORREL. 2) Highlight each column of data as an ARRAY 3) Click Okay. 4) Excel will calculate the correlation coefficient. The correlation coefficient ranges between zero and one. Zero is no correlation and '1' is a perfect correlation. __________________________________________ -1.0 to -0.7 strong negative association. -0.7 to -0.3 weak negative association. -0.3 to +0.3 little or no association. +0.3 to +0.7 weak positive association. +0.7 to +1.0 strong positive association. If you would like to print this tip, right click on the cell and select EDIT COMMENT. Then just highlight and copy the text, and paste in a document for printing. |
Diane Johnson: Instructor: 1) Click on the fx in the top bar and CORREL, or click on FOMULAS, INSERT function, CORREL. 2) Highlight each column of data as an ARRAY 3) Click Okay. 4) Excel will calculate the correlation coefficient. The correlation coefficient ranges between zero and one. Zero is no correlation and '1' is a perfect correlation. __________________________________________ -1.0 to -0.7 strong negative association. -0.7 to -0.3 weak negative association. -0.3 to +0.3 little or no association. +0.3 to +0.7 weak positive association. +0.7 to +1.0 strong positive association. If you would like to print this tip, right click on the cell and select EDIT COMMENT. Then just highlight and copy the text, and paste in a document for printing. |
IF there is strong correlation, is it positive or negative? | ||||||
| (Answer with positive, negative or N/A) | |||||||||
| What is the correlation coefficient between the two variables? | |||||||||
| (Use six decimal places) | |||||||||
| Please 'hand-in' your assignments throughout the course. | |||||||||
| DO NOT SAVE THEM FOR THE END. | |||||||||
| Procrastinators: The deadline for having all project deliverables 100% correct | |||||||||
| is 7 days prior to the end of the course. |
Improve (FIshbone)
| Dr. Deasley's Office Improvement Project | |
| Alternate Issues Catagorization Scheme (People, Process, Technology, Culture, Data) | |
| Note: - Other forms of categorization may also be used based on the situation: i.e. 5M’s of Efficient Manufacturing: | |
| (Manpower, Materials, Machines, Methods, Measurement, (Money, Mother Nature, Management) | |
| (People, Process, Techology, Culture, Information (Data) |
Patient Wait Times (Y)
Management
Man
Method
Measurement
Machine
Material
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
Cause
