I have to make a regression analysis chart for the information below bur inhave no idea how to do it could you assist me

i think rhe chart i just uploaded would show the regression anaysis better. I should use regression analysis on the compressors to conduct a "parameteix comparisons" across regions

-13- UV0341 Exhibit 7 WHIRLPOOL CORPORATION GLOBAL PROCUREMENT Plastic Injection Molding Part Data Price Quotes for Global Volumes 783-9488 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Albertos s 0.303 $ 0.056 $ 0.075 $ 0.434 Burgendorf $ 0.269 $ 0.041 0.041 $ 0.351 Christiansen $ 0.283 $ 0.045 $ 0.045 $ 0.373 Del Rio $ 0.326 $ $ 0.064 S 0.411 0.022 Press Size (tonnage) Tooling Cost Parts Per Mold 200 $ 13,500 4 400 $ 33,900 8 300 $ 25,500 6 200 $ 14,250 4 823-6516 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Press Size (tonnage) Tooling Cost Parts Per Mold Albertos $ 1.376 $ 0.303 $ 0.706 $ 2.384 Burgendorf $ 1.278 $ 0.537 $ 0.752 $ 2.567 Christiansen $ 1.369 $ 0.432 $ 0.643 $ 2.443 Del Rio $ 1.482 $ 0.128 $ 0.547 $ 2.158 750 $ 28,000 750 $ 37,450 1 600 $ 34,500 1 600 $ 31,540 1 925-1677 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Albertos $ 0.095 $ 0.032 $ 0.054 $ 0.181 Burgendorf $ 0.088 $ 0.049 $ 0.050 $ 0.187 Christiansen $ 0.092 $ 0.030 $ 0.047 $ 0.168 Del Rio $ 0.103 $ 0.024 $ 0.079 $ 0.206 Press Size (tonnage) Tooling Cost Parts Per Mold 400 $ 27,500 8 400 $ 31,450 8 600 $ 43,500 12 300 $ 30,100 4 346-0217 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Albertos $ 0.229 $ 0.127 $ 0.251 $ 0.608 Burgendorf $ 0.213 $ 0.234 $ 0.231 $ 0.678 Christiansen $ 0.212 $ 0.276 S 0.293 $ 0.781 Del Rio $ 0.241 $ 0.091 S 0.307 $ 0.638 Press Size (tonnage) 500 400 Tooling Cost $ 19,500 $ 21,450 Parts Per Mold 2 2 Note: Labor Cost/Unit includes both Direct and Indirect Labor 300 $ 17,500 1 300 $ 16,000 1 artisauthorized for use un TIT WHIRLPOOL CORPORATION GLOBAL PROCUREMENT Compressor Data Part Price/ Capacity Weight Number Unit Type Region BTU/Hr in Ibs. EER s 110-1974 34.49 SIO North America Reciprocating 3.26 5.68 111-0810 S 39.48 Scroll Europe 920 4.90 10.51 116-7080 32.08 720 4.28 Reciprocating North America 8.16 116-7532 $ 29,47 285 Reciprocating Europe 3.31 5.03 122-7151 $ 26.56 Reciprocating Europe 260 2.97 4.16 126-1065 $ 37.71 Scroll Europe 780 8.72 4.64 128-9814 $ 31.22 Reciprocating Europe 420 4.97 3.83 131-4060 $31.81 Reciprocating North America 430 4.74 4.30 135-5677 $ 41.31 Reciprocating Latin America 240 2.66 5.01 139-2202 31.97 Reciprocating North America 630 6.93 4.39 142-4903 $ 37.83 Reciprocating Latin America 345 4,01 5.33 143-1644 34.41 Reciprocating Europe 600 6.74 4.22 147-4990 28.23 Scroll North America 825 9.61 3.09 156-7534 33.45 Reciprocating North America 290 3.44 3.73 157-4140 $ 33.88 Reciprocating Latin America 350 3.85 4.49 162-5296 $ 29.30 Reciprocating Europe 435 4.76 4.37 165-4522 $ 36.77 Reciprocating Latin America 440 4.87 5.26 173-9008 $ 37.07 Reciprocating Latin America 580 6.49 5.17 182-7808 $ 39.33 Reciprocating Latin America 625 6.84 4.34 184-5143 $ 30.01 Reciprocating Europe 230 2.54 5.03 186-4136 $39.15 North America 10.58 3.30 192-1143 $ 40.73 Reciprocating Latin America 725 8.30 5.29 201-9244 $ 43.78 Reciprocating Latin America 785 9.03 5.10 209-4727 $ 26.68 Reciprocating Europe 120 1.36 4.37 223-0730 $ 38,44 Reciprocating Latin America 330 3.90 4.93 234-4640 $ 37.92 Reciprocating Latin America 405 4.80 4.49 235-5951 S 30.56 Reciprocating North America 1030 11.96 3.45 237-8072 $ 37.07 Reciprocating Europe 870 9.56 5.02 258-4726 s 30.85 Reciprocating North America 275 2.98 3.91 269-9744 S 32.95 Reciprocating Europe 700 8.30 4.04 297-7521 $ 32.46 Scroll North America 1090 12.77 3.80 306-4927 S 33.34 Reciprocating Europe 550 5.96 4.49 347-9507 $ 34.39 Reciprocating Europe 385 4.47 376-3080 $ 32.71 Reciprocating North America 280 3.18 4.40 395-0165 $ 28.14 Reciprocating Europe 245 2.91 4.68 448-4487 S 33.46 Reciprocating Europe 230 2.65 4.66 475-5893 $ 32.33 Reciprocating North America 355 3.91 4.06 509-1084 $ Scroll North America 10.48 3.02 577-9733 S 36.44 Scroll North America 850 9.73 3.70 601-0639 s 33.02 Reciprocating North America 405 4.42 3.86 656-1533 $ 31.98 Scroll North America 770 8.35 3.19 744-9083 S 31.66 Reciprocating North America 725 8.17 4.40 759-6425 $ 35.36 Reciprocating North America 465 5.02 4.14 845-6688 $ 30.72 Reciprocating North America 650 7.46 3.67 960-0588 $32.98 Reciprocating North America 560 6.13 3.18 * Energy Enceng Rating Scroll 895 Unit Volume 81,000 137,000 47,000 82,000 66,000 39,000 77,000 350,000 87.000 41,000 165,000 34,000 750,000 55.000 23,000 293.000 47,000 117,000 31,000 52,000 44.000 26,000 98,000 71,000 42.000 34,000 220,000 46,000 450,000 358.000 65,000 52.000 47.000 49,000 230,000 39,000 55.000 47,000 69,000 45,000 72,000 41,000 75,000 125,000 62,000 all ..... 39.89 930 This document is authorized for use only -13- UV0341 Exhibit 7 WHIRLPOOL CORPORATION GLOBAL PROCUREMENT Plastic Injection Molding Part Data Price Quotes for Global Volumes 783-9488 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Albertos s 0.303 $ 0.056 $ 0.075 $ 0.434 Burgendorf $ 0.269 $ 0.041 0.041 $ 0.351 Christiansen $ 0.283 $ 0.045 $ 0.045 $ 0.373 Del Rio $ 0.326 $ $ 0.064 S 0.411 0.022 Press Size (tonnage) Tooling Cost Parts Per Mold 200 $ 13,500 4 400 $ 33,900 8 300 $ 25,500 6 200 $ 14,250 4 823-6516 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Press Size (tonnage) Tooling Cost Parts Per Mold Albertos $ 1.376 $ 0.303 $ 0.706 $ 2.384 Burgendorf $ 1.278 $ 0.537 $ 0.752 $ 2.567 Christiansen $ 1.369 $ 0.432 $ 0.643 $ 2.443 Del Rio $ 1.482 $ 0.128 $ 0.547 $ 2.158 750 $ 28,000 750 $ 37,450 1 600 $ 34,500 1 600 $ 31,540 1 925-1677 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Albertos $ 0.095 $ 0.032 $ 0.054 $ 0.181 Burgendorf $ 0.088 $ 0.049 $ 0.050 $ 0.187 Christiansen $ 0.092 $ 0.030 $ 0.047 $ 0.168 Del Rio $ 0.103 $ 0.024 $ 0.079 $ 0.206 Press Size (tonnage) Tooling Cost Parts Per Mold 400 $ 27,500 8 400 $ 31,450 8 600 $ 43,500 12 300 $ 30,100 4 346-0217 Material Cost/Unit Labor Cost/Unit Production Cost/Unit Total Cost/Unit Albertos $ 0.229 $ 0.127 $ 0.251 $ 0.608 Burgendorf $ 0.213 $ 0.234 $ 0.231 $ 0.678 Christiansen $ 0.212 $ 0.276 S 0.293 $ 0.781 Del Rio $ 0.241 $ 0.091 S 0.307 $ 0.638 Press Size (tonnage) 500 400 Tooling Cost $ 19,500 $ 21,450 Parts Per Mold 2 2 Note: Labor Cost/Unit includes both Direct and Indirect Labor 300 $ 17,500 1 300 $ 16,000 1 artisauthorized for use un TIT WHIRLPOOL CORPORATION GLOBAL PROCUREMENT Compressor Data Part Price/ Capacity Weight Number Unit Type Region BTU/Hr in Ibs. EER s 110-1974 34.49 SIO North America Reciprocating 3.26 5.68 111-0810 S 39.48 Scroll Europe 920 4.90 10.51 116-7080 32.08 720 4.28 Reciprocating North America 8.16 116-7532 $ 29,47 285 Reciprocating Europe 3.31 5.03 122-7151 $ 26.56 Reciprocating Europe 260 2.97 4.16 126-1065 $ 37.71 Scroll Europe 780 8.72 4.64 128-9814 $ 31.22 Reciprocating Europe 420 4.97 3.83 131-4060 $31.81 Reciprocating North America 430 4.74 4.30 135-5677 $ 41.31 Reciprocating Latin America 240 2.66 5.01 139-2202 31.97 Reciprocating North America 630 6.93 4.39 142-4903 $ 37.83 Reciprocating Latin America 345 4,01 5.33 143-1644 34.41 Reciprocating Europe 600 6.74 4.22 147-4990 28.23 Scroll North America 825 9.61 3.09 156-7534 33.45 Reciprocating North America 290 3.44 3.73 157-4140 $ 33.88 Reciprocating Latin America 350 3.85 4.49 162-5296 $ 29.30 Reciprocating Europe 435 4.76 4.37 165-4522 $ 36.77 Reciprocating Latin America 440 4.87 5.26 173-9008 $ 37.07 Reciprocating Latin America 580 6.49 5.17 182-7808 $ 39.33 Reciprocating Latin America 625 6.84 4.34 184-5143 $ 30.01 Reciprocating Europe 230 2.54 5.03 186-4136 $39.15 North America 10.58 3.30 192-1143 $ 40.73 Reciprocating Latin America 725 8.30 5.29 201-9244 $ 43.78 Reciprocating Latin America 785 9.03 5.10 209-4727 $ 26.68 Reciprocating Europe 120 1.36 4.37 223-0730 $ 38,44 Reciprocating Latin America 330 3.90 4.93 234-4640 $ 37.92 Reciprocating Latin America 405 4.80 4.49 235-5951 S 30.56 Reciprocating North America 1030 11.96 3.45 237-8072 $ 37.07 Reciprocating Europe 870 9.56 5.02 258-4726 s 30.85 Reciprocating North America 275 2.98 3.91 269-9744 S 32.95 Reciprocating Europe 700 8.30 4.04 297-7521 $ 32.46 Scroll North America 1090 12.77 3.80 306-4927 S 33.34 Reciprocating Europe 550 5.96 4.49 347-9507 $ 34.39 Reciprocating Europe 385 4.47 376-3080 $ 32.71 Reciprocating North America 280 3.18 4.40 395-0165 $ 28.14 Reciprocating Europe 245 2.91 4.68 448-4487 S 33.46 Reciprocating Europe 230 2.65 4.66 475-5893 $ 32.33 Reciprocating North America 355 3.91 4.06 509-1084 $ Scroll North America 10.48 3.02 577-9733 S 36.44 Scroll North America 850 9.73 3.70 601-0639 s 33.02 Reciprocating North America 405 4.42 3.86 656-1533 $ 31.98 Scroll North America 770 8.35 3.19 744-9083 S 31.66 Reciprocating North America 725 8.17 4.40 759-6425 $ 35.36 Reciprocating North America 465 5.02 4.14 845-6688 $ 30.72 Reciprocating North America 650 7.46 3.67 960-0588 $32.98 Reciprocating North America 560 6.13 3.18 * Energy Enceng Rating Scroll 895 Unit Volume 81,000 137,000 47,000 82,000 66,000 39,000 77,000 350,000 87.000 41,000 165,000 34,000 750,000 55.000 23,000 293.000 47,000 117,000 31,000 52,000 44.000 26,000 98,000 71,000 42.000 34,000 220,000 46,000 450,000 358.000 65,000 52.000 47.000 49,000 230,000 39,000 55.000 47,000 69,000 45,000 72,000 41,000 75,000 125,000 62,000 all ..... 39.89 930 This document is authorized for use only