3.1 In-Class Activity

Lab6a - Frequency Distribution Tables in Data Analysis Raw Data Results Survey on Team Effectivness for Stakeholders # of Respondents Q1 Q2 Q3 1 1 1 1 2 1 1 1 3 1 1 1 4 2 1 1 5 2 1 1 6 2 1 1 7 1 3 3 8 1 3 3 9 2 3 3 10 3 3 3 11 3 2 4 12 3 2 4 13 2 2 4 14 2 4 4 15 1 4 5 16 4 4 5 17 5 4 5 18 3 4 5 19 3 4 5 20 3 4 5 Respondant Totals Number Proportion Respondants 20 100% 1 Vendors 6 30% 2 Client 7 35% 3 Internal Partners 7 35% Expectation: Team will perform at ≤ 2.51

Decision Rules = Overall Means

A. Which question scored the very best overall? Explain. Question #4 scored the very best because it is closer t is 2.10. B.Which question scored the very worst overall? Explain Question #3 scored the very worst because it is farther mean is 3.20. C. Did Team Performance "meet Expectations?" Why? Yes, the team met expectations because the overall m standard that was pre-set. D. What does the expectations meet value mean? To meet expectations at 2.51 means the team can be

Distribution Table Q3 Q4 Q5 6 10 0 0 6 12 4 0 8 4 0 0 6 4 0 20 20 20 3.20 2.10 2.40 2.51 h a sense of common purpose and ectives. and importance. en working with me and/or my group. ly and respecttfully. nion.

Lab6a - Frequency Distribution Tables in Data Analysis Raw Data Results Survey on Team Effectivness for Stakeholders # of Respondents Q1 Q2 Q3 1 1 1 1 2 1 1 1 3 1 1 1 4 2 1 1 5 2 1 1 6 2 1 1 7 1 3 3 8 1 3 3 9 2 3 3 10 3 3 3 11 3 2 4 12 3 2 4 13 2 2 4 14 2 4 4 15 1 4 5 16 4 4 5 17 5 4 5 18 3 4 5 19 3 4 5 20 3 4 5 Respondant Totals Number Proportion Respondants 20 100% 1 Vendors 6 30% 2 Client 7 35% 3 Internal Partners 7 35% Expectation: Team will perform at ≤ 2.51

Decision Rules = Overall Means

A. Which question scored the very best overall? Explain. Question #4 scored the very best because it is closer t is 2.10. B.Which question scored the very worst overall? Explain Question #3 scored the very worst because it is farther mean is 3.20. C. Did Team Performance "meet Expectations?" Why? Yes, the team met expectations because the overall m standard that was pre-set. D. What does the expectations meet value mean? To meet expectations at 2.51 means the team can be

Distribution Table Q3 Q4 Q5 6 10 0 0 6 12 4 0 8 4 0 0 6 4 0 20 20 20 3.20 2.10 2.40 2.51 nse of common purpose and s. mportance. rking with me and/or my group. d respecttfully.

Lab 6b - Burndown Chart Burndown Chart # Dates Planned Tasks Actual Tasks Variance 1 9/1/2023 30 25 5 2 9/2/2023 29 24 5 3 9/3/2023 28 28 0 4 9/4/2023 27 26 1 5 9/5/2023 26 26 0 6 9/6/2023 25 20 5 7 9/7/2023 24 14 10 8 9/8/2023 23 16 7 9 9/9/2023 22 18 4 10 9/10/2023 21 5 16 11 9/11/2023 20 6 14 12 9/12/2023 19 7 12 13 9/13/2023 18 8 10 14 9/14/2023 17 10 7 15 9/15/2023 16 10 6 Total 15 345 243 102 Variance = as variance decreases, our forcast is better. Standard Deviation = as Sigma squared decreases, our forcast is better.

Directions: Calculate the Variance and standard deviations in the table and then insert a Chart. Standard Deviation 2.24 2.24 0.00 1.00 0.00 2.24 3.16 2.65 2.00 4.00 3.74 3.46 3.16 2.65 2.45 34.98 45170 45171 45172 45173 45174 45175 45176 45177 45178 45179 45180 1 2 3 4 5 6 7 8 9 10 1 0 5 10 15 20 25 30 35 Project A Burndown Chart Planned Tasks Actual Tasks Variance Standard Devia

Lab 6b - Burndown Chart Burndown Chart # Dates Planned Tasks Actual Tasks Variance 1 9/1/2023 30 25 5 2 9/2/2023 29 24 5 3 9/3/2023 28 28 0 4 9/4/2023 27 26 1 5 9/5/2023 26 26 0 6 9/6/2023 25 20 5 7 9/7/2023 24 14 10 8 9/8/2023 23 16 7 9 9/9/2023 22 18 4 10 9/10/2023 21 5 16 11 9/11/2023 20 6 14 12 9/12/2023 19 7 12 13 9/13/2023 18 8 10 14 9/14/2023 17 10 7 15 9/15/2023 16 10 6 Total 15 345 243 102 Variance = as variance decreases, our forcast is better. Standard Deviation = as Sigma squared decreases, our forcast is better.

Directions: Calculate the Variance and standard deviations in the table and then insert a Chart. Standard Deviation 2.24 2.24 0.00 1.00 0.00 2.24 3.16 2.65 2.00 4.00 3.74 3.46 3.16 2.65 2.45 34.98 45170 45171 45172 45173 45174 45175 45176 45177 45178 45179 1 2 3 4 5 6 7 8 9 10 0 5 10 15 20 25 30 35 Project A Burndown Chart Planned Tasks Actual Tasks Variance

Lab6c Pareto Chart Step#1 Sort impact weights from largest to smallest Step#6 Ans Step #2 Calculate a Cum total for each Problem Step #3 Calculate Cum % using division Step #4 Create Pareto Chart Step #5 Name Chart # Defects Impact Weights Cum Total Cum % 1 G 18 18 20% 2 H 14 32 36% 3 C 12 44 50% 4 A 11 55 63% 5 B 9 64 73% 6 E 9 73 83% 7 D 8 81 92% 8 F 7 88 100% Total 88 Question: Which of the Problems will you focus on fixing and why? We will focus on fixing defects: A, B, C, H & G because these represent the weightiest defects pe and Pareto Chart visual.

swer the question below. Place Pareto Chart Here er the table This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.