Class examples

xlsx

School

Colorado State University, Fort Collins *

*We aren’t endorsed by this school

Course

601

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

29

Uploaded by BailiffOkapiMaster695

Report
Wax 1 Wax 2 Wax 3 Anova: Single Factor 27 33 29 30 28 28 SUMMARY 29 31 30 Groups Count 28 30 32 Wax 1 5 31 30 31 Wax 2 5 Wax 3 5 ANOVA Source of Variation SS Between Groups 5.19999999999999 Within Groups 33.2 Total 38.4 They are not different since the P-Value is high random noise: Within Groups 33.2 Wax 1 Wax 2 Wax 3 Wax 4 Anova: Single Factor 27 33 29 1 30 28 28 2 SUMMARY 29 31 30 1 Groups 28 30 32 2 Wax 1 31 30 31 5 Wax 2 Wax 3 Wax 4 ANOVA Source of Variation Between Groups Within Groups Total units of differences due to noies:
Sum Average Variance 145 29 2.5 152 30.4 3.3 150 30 2.5 df MS F P-value F crit 2 2.6 0.939759 0.417678 3.885294 12 2.766667 14 Count Sum Average Variance 5 145 29 2.5 5 152 30.4 3.3 5 150 30 2.5 5 11 2.2 2.7 SS df MS F P-value F crit 2861.8 3 953.9333 346.8848 9.164E-15 3.238872 44 16 2.75 2905.8 19 2905.8 2861.8 Between Groups
Anova: Single Factor 48 48 73 73 51 51 54 54 63 63 63 63 SUMMARY 57 57 66 66 61 61 Groups Count 54 54 64 64 54 54 Plant 1 5 62 62 74 74 56 56 Plant 2 5 Plant 3 5 ANOVA Source of Variation SS Between Groups 490 Within Groups 308 Total 798 Plant 1 Plant 1 Buffalo Buffalo Plant 2 Plant 2 Pittsburgh Pittsburgh Plant 3 Plant 3 Detroit Detroit
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Sum Average Variance 275 55 26 340 68 26.5 285 57 24.5 df MS F P-value F crit 2 245 9.545455 0.003306 3.885294 12 25.66667 14
Plant 1 Buffalo Plant 2 Pittsburgh Bonus structure 1 48 57 Bonus structure 2 54 63 Bonus structure 3 53 59 Bonus structure 4 77 71 Bonus structure 5 64 66 Bonus structure 6 59 64 SUMMARY Count Sum Bonus structure 1 3 156 Bonus structure 2 3 180 Bonus structure 3 3 170 Bonus structure 4 3 212 Bonus structure 5 3 191 Bonus structure 6 3 177 Plant 1 Buffalo 6 355 Plant 2 Pittsburgh 6 380 Plant 3 Detroit 6 351 ANOVA Source of Variation SS df 608 5 82.3333333333335 2 Error 181.666666666667 10 Total 872 17 Anova: Two-Factor Without Replication Rows (bonus Stracture) Columns (Plants)
Plant 3 Detroit 51 63 58 64 61 54 Average Variance 52 21 60 27 56.6666666666667 10.3333333333333 70.6666666666667 42.3333333333333 63.6666666666667 6.33333333333333 59 25 59.1666666666667 106.166666666666 63.3333333333333 25.0666666666667 58.5 26.7 MS F P-value F crit 121.6 6.69357798165139 0.0054964 3.325834530413 41.1666666666667 2.26605504587157 0.1542967 4.1028210151304 18.1666666666667 No Repliacation
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Buffalo Buffalo Pittsburgh Pittsburgh Detroit Detroit Not Raise Eligible Not Raise Eligible 48 48 57 57 51 51 54 54 63 63 63 63 53 53 59 59 58 58 Raise Eligible Raise Eligible 77 77 71 71 64 64 64 64 66 66 61 61 59 59 64 64 54 54 Anova: Two-Factor With Replication SUMMARY Buffalo Pittsburgh Detroit Not Raise Eligible Count 3 3 3 Sum 155 179 172 Average 51.66666666667 59.6666666666667 57.33333333333 Variance 10.33333333333 9.33333333333333 36.33333333333 Raise Eligible Count 3 3 3 Sum 200 201 179 Average 66.66666666667 67 59.66666666667 Variance 86.33333333333 13 26.33333333333 Total Count 6 6 6 Sum 355 380 351 Average 59.16666666667 63.3333333333333 58.5 Variance 106.1666666667 25.0666666666667 26.7 ANOVA Source of Variation SS df MS 304.2222222222 1 304.2222222222 82.33333333333 2 41.16666666667 122.1111111111 2 61.05555555556 Sample (Raise eligability) Columns (Plants) Interaction (Raise eligability * plant)
Within 363.3333333333 12 30.27777777778 Total 872 17
EX 1 With replication Total 9 506 56.22222 26.69444 9 580 64.44444 44.27778 F P-value F crit 10.04771 0.008072 4.747225 1.359633 0.29361 3.885294 2.016514 0.17579 3.885294
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
20 21 22 22 23 24 30 31 32 33 34 35 50 51 52 51 52 53 Anova: Two-Factor With Replication SUMMARY Plant 1 Buffalo Plant 2 Pittsburgh Plant 3 Detroit Total Low bonus structure Count 2 2 2 6 Sum 42 44 46 132 Average 21 22 23 22 Variance 2 2 2 2 ium bonus structure Count 2 2 2 6 Sum 63 65 67 195 Average 31.5 32.5 33.5 32.5 Variance 4.5 4.5 4.5 3.5 high bonus structure Count 2 2 2 6 Sum 101 103 105 309 Plant 1 Buffalo Plant 2 Pittsburgh Plant 3 Detroit Low bonus structure medium bonus structure high bonus structure
Average 50.5 51.5 52.5 51.5 Variance 0.5 0.5 0.5 1.1 Total Count 6 6 6 Sum 206 212 218 Average 34.333333333333 35.333333333333 36.333333333333 Variance 180.26666666667 180.26666666667 180.26666666667 ANOVA Source of Variation SS df MS F Sample 2683 2 1341.5 574.92857142857 Columns 12 2 6 2.5714285714286 Interaction 0 4 0 0 Within 21 9 2.3333333333333 Total 2716 17
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
EX 2 med
P-value F crit 3.205949917E-10 4.2564947290938 0.1308199855582 4.2564947290938 1 3.6330885114191
20 30 40 22 33 44 30 40 50 33 44 55 40 50 60 44 55 66 Anova: Two-Factor With Replication SUMMARY Plant 1 Buffalo Plant 2 Pittsburgh Plant 3 Detroit Total Low bonus structure Count 2 2 2 6 Sum 42 63 84 189 Average 21 31.5 42 31.5 Variance 2 4.5 8 91.1 dium bonus structure Count 2 2 2 6 Sum 63 84 105 252 Average 31.5 42 52.5 42 Variance 4.5 8 12.5 93.2 high bonus structure Count 2 2 2 6 Sum 84 105 126 315 Average 42 52.5 63 52.5 Plant 1 Buffalo Plant 2 Pittsburgh Plant 3 Detroit Low bonus structure medium bonus structure high bonus structure
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Variance 8 12.5 18 95.9 Total Count 6 6 6 Sum 189 252 315 Average 31.5 42 52.5 Variance 91.1 93.2 95.9 ANOVA Source of Variation SS df MS F Sample 1323 2 661.5 76.326923076923 Columns 1323 2 661.5 76.326923076923 Interaction 0 4 0 0 Within 78 9 8.6666666666667 Total 2724 17
P-value F crit 2.267013484E-06 4.2564947290938 2.267013484E-06 4.2564947290938 1 3.6330885114191
Pre-Program Pre-Program -Program -Program Dogs Dogs 28 28 25 25 42 42 44 44 31 31 27 27 Cats Cats 14 14 13 13 19 19 20 20 12 12 12 12 Anova: Two-Factor With Replication SUMMARY Pre-Program Post-Progr Total Dogs Count 3 3 6 Sum 101 96 197 Average 33.6666666666667 32 32.83333 Variance 54.3333333333333 109 66.16667 Cats Count 3 3 6 Sum 45 45 90 Average 15 15 15 Variance 13 19 12.8 Total Count 6 6 Sum 146 141 Average 24.3333333333333 23.5 Variance 131.466666666667 137.9 ANOVA Source of Variation SS df MS F 954.083333333334 1 954.0833 19.53754 2.08333333333348 1 2.083333 0.042662 Sample (Animal Type) Columns (treatment)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2.0833333333332 1 2.083333 0.042662 Within 390.666666666667 8 48.83333 Total 1348.91666666667 11 there is a significant difference between dogs and cats, but no differnces between the programs Interaction (different effect of treatment on animal type)
Dogs Dogs Cats Cats Anova: Two-Facto SUMMARY Dogs Count Sum Average Variance Cats Count Sum Average Variance Total Count Sum Average Variance ANOVA P-value F crit Source of Variation 0.002226 5.317655 Sample 0.841523 5.317655 Columns
0.841523 5.317655 Interaction Within Total there is a signific
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Pre-Program Pre-Program Post-Program Post-Program 28 28 2.8 2.8 42 42 4.2 4.2 31 31 3.1 3.1 14 14 1.4 1.4 19 19 1.9 1.9 12 12 1.2 1.2 or With Replication Pre-Program Post-Program Total 3 3 6 101 10.1 111.1 33.6666666666667 3.36666666666667 18.51667 54.3333333333333 0.543333333333337 297.3777 3 3 6 45 4.5 49.5 15 1.5 8.25 13 0.13 59.927 6 6 146 14.6 24.3333333333333 2.43333333333333 131.466666666667 1.31466666666667 SS df MS F 316.213333333334 1 316.2133 18.59896 1438.83 1 1438.83 84.62876
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
211.68 1 211.68 12.45054 136.013333333333 8 17.00167 2102.73666666667 11 cant difference between dogs and cats, and also a differnces between the programs.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
P-value F crit 0.00257143859 5.317655 2E-05 5.317655
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0.0077486034 5.317655
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Fasting Keto High Impact 76 65 78 90 76 65 76 90 76 65 74 90 74 90 76 79 76 70 55 90 low Impact 88 65 76 67 76 67 76 87 56 78 76 56 76 54 98 56 88 54 78 56 Anova: Two-Factor With Replication SUMMARY Fasting Keto Total High Impact Count 10 10 20 Sum 737 794 1531 Average 73.7 79.4 76.55 Variance 44.45556 141.3778 96.57632
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
low Impact Count 10 10 20 Sum 788 640 1428 Average 78.8 64 71.4 Variance 121.9556 126.2222 175.2 Total Count 20 20 Sum 1525 1434 Average 76.25 71.7 Variance 85.67105 189.1684 ANOVA Source of Variation SS df MS F P-value F crit Sample (impact) 265.225 1 265.225 2.444407 0.126693 4.113165 Columns (Fasting VS Keto) 207.025 1 207.025 1.908016 0.175698 4.113165 Interaction 1050.625 1 1050.625 9.682932 0.003631 4.113165 Within 3906.1 36 108.5028 Total 5428.975 39
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Fasting Keto Low Fat High Impact 76 65 141 78 90 168 76 65 141 76 90 166 76 65 141 74 90 164 74 90 164 76 79 155 76 70 146 55 90 145 Low Impact 88 65 153 76 67 143 76 67 143 76 87 163 56 78 134 76 56 132 76 54 130 98 56 154 88 54 142 78 56 134 Extreme Impact 100 100 200 100 100 200 100 100 200 100 100 200 100 100 200 100 100 200 100 100 200 100 100 200
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
100 100 200 100 100 200 Anova: Two-Factor With Replication SUMMARY Fasting Keto Low Fat Total High Impact Count 10 10 10 30 Sum 737 794 1531 3062 Average 73.7 79.4 153.1 102.066667 Variance 44.45556 141.3778 131.6556 1451.23678 Low Impact Count 10 10 10 30 Sum 788 640 1428 2856 Average 78.8 64 142.8 95.2 Variance 121.9556 126.2222 119.2889 1323.75172 Extreme Impact Count 10 10 10 30 Sum 1000 1000 2000 4000 Average 100 100 200 133.333333 Variance 0 0 0 2298.85057 Total Count 30 30 30 Sum 2525 2434 4959 Average 84.16667 81.13333 165.3 Variance 185.7989 308.0506 718.9759 ANOVA Source of Variation SS df MS F P-value F crit Sample (exercise) 24789.07 2 12394.53 162.85845 4.142938E-29 3.109311 Columns (diet) 136758.5 2 68379.23 898.47158 5.122764E-56 3.109311 Interaction (exercise * diet) 4218.267 4 1054.567 13.8565195 1E-08 2.484441 Within 6164.6 81 76.10617 Total 171930.4 89
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help