Hi, I have an assignment I need help with. The question is below and I have attached the Excel spreadsheet with the data - the relevant sheet is simple linear regression.

I will leave a positive review for good work and an explanation, thank you!

Based on the following data of monthly sales and cost for 3 companies, perform a regression analysis and calculate fixed and variable cost ratios for each company. what can you infer from the results? (there is no relationship among the 3 companies) (excel file, sheet "simple linear regression")

Modeling for estimation: 1)you are planning to opening a conveyor belt sushi restaurant which offers all items at a single price in a certain downtown district of Tokyo. What model formula can you think of to estimate revenues and expenses?(assume that you have made sushi before)

Walking (minutes) Age (years) 13 6 5 9 7 12 7 4 1 4 7 8 2 13 5 8 6 4 2 5 8 6 11 11 5 7 5 4 4 9 9 9 4 10 6 6 6 6 1 4 5 4 Living space (m2) 24 33 31 28 36 2 12 6 7 6 33 35 41 18 31 35 28 34 41 29 29 28 26 35 30 30 30 34 33 23 23 9 6 27 7 7 7 9 7 6 6 6 22.15 17.83 23.63 27.76 23.32 31.03 26.22 22.16 36.54 40.04 17.83 23.1 16.11 17 23.63 25.8 21.8 22.33 18.27 27.06 26.7 29.06 20.85 21.31 29.52 34.41 35.79 30.82 30.82 33.78 34.02 32.76 22.16 44.89 29.39 47.97 32.71 36.82 36.54 40.04 42.82 30.2 South-facing 1 0 1 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 Rent + common services charge (yen) 69,000 70,000 80,000 84,000 87,000 116,000 119,000 129,000 166,000 170,000 70,000 76,000 69,000 72,000 80,000 82,000 75,000 79,000 83,000 85,000 85,000 98,010 83,000 84,000 96,000 94,000 108,000 105,000 110,000 115,000 118,000 125,000 129,000 130,000 142,000 149,000 154,000 154,000 158,000 170,000 178,000 169,000 Year 2008 2009 Period January February March April May June July August September October November December January February March April May June July August September October November December Number of stores 40,889 41,105 41,204 41,356 41,398 41,367 41,443 41,643 41,566 41,559 41,666 41,714 41,800 42,047 42,004 42,070 42,153 42,204 42,345 42,557 42,487 42,553 42,673 42,629 Year 2010 2011 Period January February March April May June July August September October November December January February March April May June July August September October November December Number of stores 42,704 42,919 42,815 42,865 42,879 42,889 42,995 43,270 43,281 43,268 43,291 43,372 43,393 43,636 43,492 43,492 43,560 43,541 43,690 43,985 43,969 44,062 44,250 44,403 Source: Japan Franchise Association Three Years Ago This Year 18 19 21 21 22 23 23 24 26 26 26 26 27 27 27 28 28 29 30 30 30 31 31 32 32 33 34 35 35 36 38 38 39 40 41 42 42 42 43 43 44 44 44 45 46 48 48 48 48 52 21 22 23 24 25 26 26 27 27 27 27 28 28 28 29 30 31 31 31 32 32 33 34 35 36 36 37 39 39 40 40 40 41 43 43 43 44 44 45 45 45 45 46 46 47 48 48 49 51 55 34.1 36.24 Ages of customers: Three years ago 18 19 21 21 22 23 30 30 30 31 31 32 42 42 43 43 44 44 23 32 44 24 33 45 26 34 46 26 35 48 26 35 48 26 36 48 27 38 48 27 38 52 27 39 28 40 28 41 29 42 Ages of customers: This year 21 22 23 24 25 31 32 32 33 34 44 44 45 45 45 26 36 46 27 36 46 27 37 47 27 39 48 27 39 48 28 40 49 28 40 51 28 40 55 29 41 30 43 31 43 31 43 26 35 45 Tokyo Team 1 Tokyo Team 2 Tokyo Team 3 Tokyo Team 4 Number of Staff 10 12 9 6 Number of Business Leads 175 222 119 130 Number of Proposals Submitted 113 135 77 65 Average Proposal Amount (million yen) 14 8 16.5 12.5 Number of Orders Received 25 45 18 20 Average Order Amount (million yen) 11.5 6.6 14.5 11.8 Total Amount of Orders (million yen) 287.5 297 261 236 0.477779 multiple R R 0.228273 R square R2 0.20898 R2 12.24249 42 23% weak causation F 1 1773.333 1773.333 11.83179 0.001375 40 5995.144 149.8786 41 7768.476 t P- 95% 95% 95.0% 95.0% 29.2027 13.68058 2.13461 0.038972 1.553223 56.85219 1.553223 56.85219 Test Score 0.612097 0.177949 3.439738 0.001375 0.252449 0.971745 0.252449 0.971745 erformance rating 3 years after promotion 1 65.92853 24.07147 2 65.92853 -20.92853 3 66.54063 -6.540625 4 66.54063 -0.540625 5 67.15272 -12.15272 6 67.76482 -15.76482 7 67.76482 20.23518 8 68.37692 -8.376917 9 69.60111 -3.601111 10 69.60111 -7.601111 11 70.21321 19.78679 12 70.8253 1.174695 13 71.4374 -7.437402 14 72.0495 -2.049499 15 72.0495 -13.0495 16 73.27369 4.726307 17 73.88579 4.11421 18 73.88579 -10.88579 19 74.49789 16.50211 20 75.10998 -2.109984 21 75.10998 -5.109984 22 75.10998 4.890016 23 75.10998 18.89002 24 76.33418 4.665822 25 76.94628 -2.946276 26 76.94628 15.05372 27 78.17047 20.82953 28 78.78257 5.217433 29 78.78257 7.217433 30 79.39466 10.60534 31 80.61886 -22.61886 32 81.23095 -11.23095 33 81.84305 -9.843052 34 83.06725 -8.067246 35 83.06725 -2.067246 36 84.29144 -7.29144 37 85.51563 -22.51563 38 85.51563 0.484366 39 85.51563 -1.515634 40 85.51563 11.48437 41 87.35193 11.64807 42 87.35193 2.648074 Test Score At Promotion Performance rating 3 years after promotion 60 60 61 61 62 63 63 64 66 66 67 68 69 70 70 72 73 73 74 75 75 75 75 77 78 78 80 81 81 82 84 85 86 88 88 90 92 92 92 92 95 95 90 45 60 66 55 52 88 60 66 62 90 72 64 70 59 78 78 63 91 73 70 80 94 81 74 92 99 84 86 90 58 70 72 75 81 77 63 86 84 97 99 90 110 100 90 f(x) = 0.6120970663x + 29.2027043342 R = 0.2282729071 80 Axis T it le Performance rating 3 years after promotion Linear (Performance rating 3 years after promotion) 70 60 50 40 60 65 70 75 80 Axis T it le 85 90 95 100 Client Transaction Transaction Transaction Transaction Profit ratio Client Profit ratio amount period amount period 1 2000 8 1 31 7300 12.5 4 2 2500 12 2 32 12000 15.8 7 3 3200 12.4 3 33 13000 16.2 6 4 4500 12.5 3 34 15600 14.5 4 5 5000 10.5 2 35 4000 8.7 2 6 2000 9.2 2 36 11050 9 1 7 1000 7.5 2 37 3500 7.7 1 8 500 7.6 3 38 4500 11.5 2 9 600 6.3 3 39 5500 11.9 3 10 1200 12.3 5 40 7500 12 3 11 1800 10.9 4 41 8500 10.1 2 12 2300 12.4 4 42 4000 8.8 2 13 5600 12.8 4 43 2000 7.2 2 14 9000 16.5 7 44 900 7.3 3 15 10000 16.5 6 45 1000 6.1 3 16 12000 14.8 4 46 2000 11.8 5 17 3000 8.9 2 47 2500 11.5 2 18 8500 9.2 1 48 2400 10 2 19 2600 7.8 1 49 3000 10.2 2 20 3250 11.8 2 50 3200 10.5 2 21 4160 12.2 3 51 1800 10.3 2 22 5850 12.3 3 52 1200 9 2 23 6500 10.3 2 53 1000 8 2 24 2600 9 2 54 500 7 2 25 1300 7.4 2 55 800 7.6 2 26 650 7.4 3 56 1500 8.5 2 27 780 6.2 3 57 1600 9.2 2 28 1560 12.1 5 58 1900 10.3 2 29 2300 10.7 4 59 2300 9.8 2 30 3000 12.2 4 60 2700 8.5 2 (Unit: Transaction amount = thousand yen, Profit ratio = %, Transaction period = years) 4-Apr 4-May 4-Jun 4-Jul 4-Aug 4-Sep 4-Oct 4-Nov 4-Dec 5-Jan 5-Feb 5-Mar 5-Apr 5-May 5-Jun 5-Jul 5-Aug 5-Sep 5-Oct 5-Nov 5-Dec 6-Jan 6-Feb 6-Mar Company L Sales Costs 211 187 228 199 246 255 264 232 277 244 270 241 262 233 242 222 230 247 225 207 215 195 237 208 213 189 230 202 248 259 268 235 277 246 271 242 264 235 244 224 234 250 227 209 216 195 239 210 Company M Company N Sales Costs Sales Costs 222 211 208 188 228 213 225 200 246 225 245 235 264 232 263 235 277 235 275 241 270 236 266 241 262 233 259 233 242 227 240 222 230 215 230 220 235 217 235 217 225 201 225 208 247 220 247 220 247 251 223 208 255 254 240 218 271 265 258 225 290 271 278 228 303 273 287 231 295 278 281 228 290 273 274 222 269 267 254 218 255 253 244 215 262 260 247 211 250 239 236 208 273 261 259 222 (Unit: 10 thousand yen for all the companies) I x II y x III y x IV y x y 10.0 8.04 10.0 9.14 10.0 7.46 8.0 6.58 8.0 6.95 8.14 6.77 8.0 5.76 13.0 7.58 13.0 8.74 13.0 12.74 8.0 7.71 9.0 8.81 8.77 11.0 8.0 9.0 8.0 9.0 7.11 8.0 8.84 8.33 11.0 9.26 11.0 7.81 8.0 8.47 14.0 9.96 14.0 8.1 14.0 8.84 8.0 7.04 6.0 7.24 6.0 6.13 6.0 6.08 8.0 5.25 4.0 4.26 4.0 3.1 4.0 5.39 19.0 12.5 12.0 10.84 12.0 9.13 12.0 8.15 8.0 5.56 7.0 4.82 7.0 7.26 7.0 6.42 8.0 7.91 5.0 5.68 5.0 4.74 5.0 5.73 8.0 6.89