fahrenheit_celsius_regression_illustration_1.xlsx

Sheet1

Fahrenheit Celsius rndm
144.68 61 -2
-82.32 -64 6
21.32 -11 10
-27.40 -30 -3
-136.80 -85 -9
55.92 9 7
97.68 36 -2
-97.84 -68 -2
14.48 -4 -10
-99.48 -71 2
165.24 73 -4
-102.88 -76 8
-68.76 -52 -3
169.48 71 4
-111.28 -81 9
-59.64 -53 8
-121.92 -84 4
55.84 18 -10
133.92 59 -9
152.08 66 -4
50.32 14 -8
140.28 56 3
-42.08 -41 3
102.20 40 -5
-32.52 -29 -10
-92.08 -66 0
177.88 76 3
-143.20 -90 -6
-28.80 -35 5
-94.08 -66 -2
92.28 31 2
-130.32 -89 5
162.20 65 8
-71.52 -54 -2
138.76 52 9
-156.24 -98 -4
-133.96 -92 7
40.88 1 7
145.92 59 3
101.04 33 7
216.00 100 -4
194.20 90 -7
-70.40 -55 1
47.92 9 -1
-3.36 -22 6
131.64 53 0
-77.92 -59 1
34.36 -3 8
114.84 43 2
-142.36 -97 8
152.44 63 2
9.56 -13 2
22.84 -7 4
211.12 99 -7
192.56 87 -3
70.88 26 -10
-141.48 -96 7
-56.12 -49 4
198.92 84 9
83.76 27 1
124.60 45 8
18.84 -7 0
6.80 -15 3
-95.08 -66 -3
186.16 82 0
94.80 35 -3
-39.56 -37 -2
64.56 12 10
161.24 73 -8
62.96 17 -1
-72.16 -57 3
-58.84 -43 -10
229.00 100 9
-121.68 -86 8
-30.56 -37 7
146.28 56 9
2.92 -16 1
-15.52 -29 7
51.32 14 -7
97.04 33 3
193.32 89 -6
18.48 -4 -6
136.64 53 5
190.56 87 -5
65.24 23 -10
-102.48 -71 -1
-131.32 -89 4
-52.08 -41 -7
-15.88 -26 1
100.56 37 -1
64.36 22 -9
-41.44 -38 -2
160.96 67 3
105.92 34 10
212.08 91 9
16.44 -12 7
-65.88 -51 -2
17.56 -13 10
-117.28 -81 3
-55.84 -43 -7
-93.44 -63 -7

X Variable 1 Line Fit Plot

Y 61 -64 -11 -30 -85 9 36 -68 -4 -71 73 -76 -52 71 -81 -53 -84 18 59 66 14 56 -41 40 -29 -66 76 -90 -35 -66 31 -89 65 -54 52 -98 -92 1 59 33 100 90 -55 9 -22 53 -59 -3 43 -97 63 -13 -7 99 87 26 -96 -49 84 27 45 -7 -15 -66 82 35 -37 12 73 17 -57 -43 100 -86 -37 56 -16 -29 14 33 89 -4 53 87 23 -71 -89 -41 -26 37 22 -38 67 34 91 -12 -51 -13 -81 -43 -63 144.68 -82.32 21.32 -27.4 -136.79999999999998 55.92 97.679999999999993 -97.839999999999989 14.48 -99.47999999999999 165.23999999999998 -102.88 -68.759999999999991 169.48 -111.28 -59.64 -121.91999999999999 55.84 133.91999999999999 152.07999999999998 50.32 140.28 -42.08 102.19999999999999 -32.519999999999996 -92.08 177.88 -143.19999999999999 -28.799999999999997 -94.08 92.28 -130.32 162.19999999999999 -71.52 138.76 -156.23999999999998 -133.95999999999998 40.880000000000003 145.91999999999999 101.03999999999999 216 194.2 -70.399999999999991 47.92 -3.3599999999999994 131.63999999999999 -77.919999999999987 34.36 114.83999999999999 -142.35999999999999 152.44 9.5600000000000023 22.84 211.11999999999998 192.56 70.88 -141.47999999999999 -56.11999999999999 198.92 83.759999999999991 124.6 18.84 6.8000000000000007 -95.08 186.16 94.8 -39.56 64.56 161.23999999999998 62.959999999999994 -72.16 -58.839999999999989 229 -121.67999999999998 -30.560000000000002 146.28 2.9200000000000017 -15.519999999999996 51.32 97.039999999999992 193.32 18.48 136.63999999999999 190.56 65.239999999999995 -102.47999999999999 -131.32 -52.08 -15.879999999999995 100.56 64.36 -41.44 160.95999999999998 105.91999999999999 212.07999999999998 16.440000000000001 -65.88 17.560000000000002 -117.28 -55.839999999999989 -93.44 Predicted Y 61 -64 -11 -30 -85 9 36 -68 -4 -71 73 -76 -52 71 -81 -53 -84 18 59 66 14 56 -41 40 -29 -66 76 -90 -35 -66 31 -89 65 -54 52 -98 -92 1 59 33 100 90 -55 9 -22 53 -59 -3 43 -97 63 -13 -7 99 87 26 -96 -49 84 27 45 -7 -15 -66 82 35 -37 12 73 17 -57 -43 100 -86 -37 56 -16 -29 14 33 89 -4 53 87 23 -71 -89 -41 -26 37 22 -38 67 34 91 -12 -51 -13 -81 -43 -63

X Variable 1

Y