You have been hired as a business analyst for Brunswick Bowling Centers. The sample data provided...

Transcribed Image Text:

You have been hired as a business analyst for Brunswick Bowling Centers. The sample data provided here is from a random sample of their bowling centers across the world. Your job is to produce a regression model from this data using Excel to answer the following questions. The regression model should use the following independent variables predicting the number of annual visitors (NumberVisitors) for each bowling center. PopulationWithin3Miles - number of people living within miles of the bowling center. NumberOrganized Leagues - the number of organized leagues at the bowling center. NumberLanes - the number of bowling lanes at the bowling center. Restaurant - a binary variable indicating whether the bowling center has a restaurant at the facility. = bo+b(PopulationWithin3Miles) + b(NumberOrganized Leagues)+ b3(NumberLanes) + b4 (Restaurant) Do not specify any units and do not show any commas. Use atol to know the minimum number of digits to specify (if atol = 0.002, specify at least three decimals). A B C D E 1 BowlingCenterID PopulationWithin3 Miles NumberOrganizedLeagues NumberLanes Restaurant NumberVisitors 1 7624 4 14 1 13075 2 6235 9 16 1 14281 3 7754 8 16 0 13520 5 4 8878 5 40 1 20140 6 5 4111 11 24 1 16112 6 10685 10 50 1 22659 7 4807 2 22 10205 9 8 4599 0 40 0 5938 10 9 5402 11 44 1 22976 11 10 6402 0 16 1 9618 12 11 3447 1 24 0 4943 13 12 2792 6 16 0 12086 14 13 6994 1 44 1 15985 15 14 10721 5 12 1 21208 16 15 7273 7 16 0 11133 17 16 3488 1 24 1 10369 18 17 8169 10 36 1 21769 19 18 5185 12 44 1 29238 20 19 8743 1 40 0 19033 21 20 8543 9 18 0 14167 22 21 3726 7 24 0 10360 23 22 7591 12 16 0 14472 24 23 6199 12 24 1 21213 25 24 8149 1 16 0 12175 26 25 9181 11 24 1 23690 27 26 6008 2 24 1 15327 28 27 3753 12 22 1 19005 29 28 7919 3 44 1 26932 30 29 3611 8 24 1 7829 31 30 3290 9 24 0 8901 32 31 10082 3 12 1 18222 33 32 8397 4 12 1 7907 34 33 5279 5 16 1 16076 35 34 2754 12 24 0 13367 36 35 3377 6 30 1 10386 37 36 5005 4 14 0 5234 38 37 1872 1 22 1 8048 39 38 7486 7 30 0 11625 40 39 4842 9 40 1 21871 41 40 7205 11 16 0 15378 42 41 7734 11 24 0 19317 43 42 9528 5 24 0 12402 44 43 1021 3 40 1 11838 45 44 7051 9 24 0 12134 45 7161 8 12 0 9082 47 46 9396 11 14 0 11626 48 47 7289 12 16 1 14392 49 48 6652 6 16 1 10290 50 49 6767 8 18 1 12992 51 50 8169 4 22 1 20020 52 51 6940 6 8 1 18470 53 52 7549 0 24 0 10518 54 53 7165 6 14 1 20260 55 54 2495 5 36 1 14311 56 55 6268 7 16 1 11275 57 56 8267 4 50 0 17037 58 57 6010 9 22 0 16530 59 58 5734 3 40 1 19530 60 59 3324 11 16 0 9314 61 60 8321 4 24 0 10722 62 61 4147 6 30 0 15332 63 62 5256 6 18 0 13371 64 63 7244 3 24 1 14607 65 64 6274 10 8 0 13742 66 65 4202 0 30 1 16076 67 66 4213 11 30 1 20228 68 67 5059 5 36 0 10435 69 68 7866 5 8 0 5447 70 69 6890 11 16 1 17563 71 70 4889 11 24 1 11980 72 71 5220 5 36 0 15159 73 72 3767 11 40 0 13980 74 73 3299 11 18 0 13426 75 74 4941 3 24 1 7112 76 75 6506 3 22 0 14736 77 76 5710 5 30 0 15763 78 77 3653 1 40 0 12171 79 78 7746 12 16 0 20409 80 79 7986 2 16 0 6266 81 80 4060 5 16 1 13509 82 81 7764 6 8 0 4825 83 82 6438 3 16 0 6783 84 83 5090 2 18 1 17771 85 84 6061 10 16 1 15991 86 85 7816 10 24 1 17045 87 86 2057 4 40 1 20462 88 87 6135 2 50 0 12158 89 88 8496 9 22 1 16890 90 89 5006 8 24 1 16912 91 90 7436 7 40 0 12334 92 91 5243 10 50 0 21018 93 92 4797 11 44 0 11747 94 93 4361 2 24 0 12636 95 GENERATION AND INTERPRETATION OF OUTPUT Download Excel Sheet: badm210_mp06_generate.xlsx What is the sample size in the dataset used to build the specified prediction model? Integer What is r-squared for this prediction model? number (rtol=0, atol=0.0002) What is the sum of squares regression (SSR) for this prediction model? number (rtol=0.01, atol=1) What is the estimated coefficient representing the relationship between PopulationWithin3Miles and NumberVisitors? number (rtol=0, atol=0.005) What is the most correct statistical interpretation of the intercept in this model? Use a 5% level of error (alpha). O (a) The model fit is -594.1 times greater than model fit of a regression with no intercept specified. O (b) Bowling centers all have NumberVisitors = -594.1. (c) There is a 5% chance that the best fit regression line passes through (x = 0, y = 0). (d) There is not statistical evidence that the best fit regression line passes through a point different from (0, 0). What is the correct interpretation of the t-statistic for Restaurant in the regression output? (a) The estimated slope of the relationship between Restaurant and NumberVisitors is 5.789 standard errors different from zero. O (b) You can expect to make a type I error in approximately 5.789 out of every 100 samples. O (c) The upper 95% confidence limit is 5.789 standard errors above the estimated coefficient. O (d) The estimated slope of the relationship between Restaurant and NumberVisitors is 5.789. You have been hired as a business analyst for Brunswick Bowling Centers. The sample data provided here is from a random sample of their bowling centers across the world. Your job is to produce a regression model from this data using Excel to answer the following questions. The regression model should use the following independent variables predicting the number of annual visitors (NumberVisitors) for each bowling center. PopulationWithin3Miles - number of people living within miles of the bowling center. NumberOrganized Leagues - the number of organized leagues at the bowling center. NumberLanes - the number of bowling lanes at the bowling center. Restaurant - a binary variable indicating whether the bowling center has a restaurant at the facility. = bo+b(PopulationWithin3Miles) + b(NumberOrganized Leagues)+ b3(NumberLanes) + b4 (Restaurant) Do not specify any units and do not show any commas. Use atol to know the minimum number of digits to specify (if atol = 0.002, specify at least three decimals). A B C D E 1 BowlingCenterID PopulationWithin3 Miles NumberOrganizedLeagues NumberLanes Restaurant NumberVisitors 1 7624 4 14 1 13075 2 6235 9 16 1 14281 3 7754 8 16 0 13520 5 4 8878 5 40 1 20140 6 5 4111 11 24 1 16112 6 10685 10 50 1 22659 7 4807 2 22 10205 9 8 4599 0 40 0 5938 10 9 5402 11 44 1 22976 11 10 6402 0 16 1 9618 12 11 3447 1 24 0 4943 13 12 2792 6 16 0 12086 14 13 6994 1 44 1 15985 15 14 10721 5 12 1 21208 16 15 7273 7 16 0 11133 17 16 3488 1 24 1 10369 18 17 8169 10 36 1 21769 19 18 5185 12 44 1 29238 20 19 8743 1 40 0 19033 21 20 8543 9 18 0 14167 22 21 3726 7 24 0 10360 23 22 7591 12 16 0 14472 24 23 6199 12 24 1 21213 25 24 8149 1 16 0 12175 26 25 9181 11 24 1 23690 27 26 6008 2 24 1 15327 28 27 3753 12 22 1 19005 29 28 7919 3 44 1 26932 30 29 3611 8 24 1 7829 31 30 3290 9 24 0 8901 32 31 10082 3 12 1 18222 33 32 8397 4 12 1 7907 34 33 5279 5 16 1 16076 35 34 2754 12 24 0 13367 36 35 3377 6 30 1 10386 37 36 5005 4 14 0 5234 38 37 1872 1 22 1 8048 39 38 7486 7 30 0 11625 40 39 4842 9 40 1 21871 41 40 7205 11 16 0 15378 42 41 7734 11 24 0 19317 43 42 9528 5 24 0 12402 44 43 1021 3 40 1 11838 45 44 7051 9 24 0 12134 45 7161 8 12 0 9082 47 46 9396 11 14 0 11626 48 47 7289 12 16 1 14392 49 48 6652 6 16 1 10290 50 49 6767 8 18 1 12992 51 50 8169 4 22 1 20020 52 51 6940 6 8 1 18470 53 52 7549 0 24 0 10518 54 53 7165 6 14 1 20260 55 54 2495 5 36 1 14311 56 55 6268 7 16 1 11275 57 56 8267 4 50 0 17037 58 57 6010 9 22 0 16530 59 58 5734 3 40 1 19530 60 59 3324 11 16 0 9314 61 60 8321 4 24 0 10722 62 61 4147 6 30 0 15332 63 62 5256 6 18 0 13371 64 63 7244 3 24 1 14607 65 64 6274 10 8 0 13742 66 65 4202 0 30 1 16076 67 66 4213 11 30 1 20228 68 67 5059 5 36 0 10435 69 68 7866 5 8 0 5447 70 69 6890 11 16 1 17563 71 70 4889 11 24 1 11980 72 71 5220 5 36 0 15159 73 72 3767 11 40 0 13980 74 73 3299 11 18 0 13426 75 74 4941 3 24 1 7112 76 75 6506 3 22 0 14736 77 76 5710 5 30 0 15763 78 77 3653 1 40 0 12171 79 78 7746 12 16 0 20409 80 79 7986 2 16 0 6266 81 80 4060 5 16 1 13509 82 81 7764 6 8 0 4825 83 82 6438 3 16 0 6783 84 83 5090 2 18 1 17771 85 84 6061 10 16 1 15991 86 85 7816 10 24 1 17045 87 86 2057 4 40 1 20462 88 87 6135 2 50 0 12158 89 88 8496 9 22 1 16890 90 89 5006 8 24 1 16912 91 90 7436 7 40 0 12334 92 91 5243 10 50 0 21018 93 92 4797 11 44 0 11747 94 93 4361 2 24 0 12636 95 GENERATION AND INTERPRETATION OF OUTPUT Download Excel Sheet: badm210_mp06_generate.xlsx What is the sample size in the dataset used to build the specified prediction model? Integer What is r-squared for this prediction model? number (rtol=0, atol=0.0002) What is the sum of squares regression (SSR) for this prediction model? number (rtol=0.01, atol=1) What is the estimated coefficient representing the relationship between PopulationWithin3Miles and NumberVisitors? number (rtol=0, atol=0.005) What is the most correct statistical interpretation of the intercept in this model? Use a 5% level of error (alpha). O (a) The model fit is -594.1 times greater than model fit of a regression with no intercept specified. O (b) Bowling centers all have NumberVisitors = -594.1. (c) There is a 5% chance that the best fit regression line passes through (x = 0, y = 0). (d) There is not statistical evidence that the best fit regression line passes through a point different from (0, 0). What is the correct interpretation of the t-statistic for Restaurant in the regression output? (a) The estimated slope of the relationship between Restaurant and NumberVisitors is 5.789 standard errors different from zero. O (b) You can expect to make a type I error in approximately 5.789 out of every 100 samples. O (c) The upper 95% confidence limit is 5.789 standard errors above the estimated coefficient. O (d) The estimated slope of the relationship between Restaurant and NumberVisitors is 5.789.