View the step-by-step solution to:

# sty Dough Pizza Company Possible values for each variable Store store ID Store 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

1) Calculate, average, mean, variance, and range and comment on correlation and covariance between key variables

2) Using the same data set as above perform simple linear regression and multiple linear regressions on the key variables, comment on goodness of fit and discuss which variables you would include and why

usty Dough Pizza Company Possible values for each variable Store Store Size Seating Order Options store ID s = small Y = yes Y = yes Number Number Number Number Dollars Number Number Y = yes T = Twitter Positive Dollars Y = Yes Number Yes M = medium N = No N = No N= No W = Website Negative N = No No L = Large F=Fax VL = Very Large T&W = Twitter and Website All = all three Store Store Size Seating Order Options 1 M N No 8560 2 3 13 \$5,136.77 27 110772 No All Positive \$1,276.00 Yes 41 No 2 S N No 4289 2 6 16 \$1,347.13 26 459234 Yes T Positive \$1,018.00 No 54 Yes 3 L Y Yes 10003 4 6 13 \$4,978.79 38 456491 Yes T&W Positive \$1,265.00 Yes 50 Yes 4 M N Yes 5675 0 0 8 \$20,825.42 40 227922 Yes T&W Positive \$1,763.00 Yes 56 No 5 L Y No 11866 2 2 9 \$13,476.19 36 371592 No All Negative \$2,030.00 Yes 56 No 6 L Y No 10045 3 3 7 \$9,927.01 50 488511 Yes T&W Positive \$844.00 No 41 No 7 VL Y Yes 21131 3 5 14 \$34,291.88 16 86780 No All Positive \$3,114.00 No 126 Yes 8 VL Y No 17030 3 7 17 \$23,663.12 29 156121 Yes F Positive \$2,287.00 Yes 134 No 9 M N No 8836 4 7 14 -\$6,915.54 23 112862 Yes All Positive \$1,170.00 Yes 52 No 10 M N No 5522 3 6 16 -\$337.10 26 360705 Yes T&W Positive \$992.00 Yes 58 No 11 VL Y Yes 18847 4 5 17 \$23,521.01 26 176305 Yes T&W Positive \$2,051.00 Yes 152 Yes 12 VL Y No 21568 3 5 12 \$28,575.14 22 123338 No T&W Positive \$2,575.00 No 53 No 13 M N No 5247 2 5 9 \$429.21 33 268506 Yes T Positive \$1,065.00 Yes 49 No 14 L Y Yes 14695 3 5 9 \$18,103.62 26 354116 Yes W Positive \$2,174.00 Yes 61 Yes 15 VL Y Yes 17854 4 8 19 \$20,840.36 41 184963 Yes T&W Positive \$1,985.00 Yes 196 Yes 16 L Y No 12164 3 6 17 \$9,158.87 23 481474 Yes T Positive \$994.00 Yes 63 Yes 17 M N Yes 8905 3 4 12 \$11,371.21 23 227712 Yes T Positive \$2,193.00 Yes 20 No 18 L Y No 10207 2 2 10 \$14,256.41 25 346712 Yes T&W Positive \$2,340.00 Yes 90 No 19 VL Y Yes 21621 3 4 15 \$31,923.92 26 460815 Yes T Positive \$2,958.00 No 130 No 20 VL Y No 21606 4 5 10 \$22,289.99 41 410385 No T Positive \$1,724.00 Yes 50 Yes 21 L Y No 14943 2 4 10 \$22,483.55 46 221246 Yes F Negative \$2,025.00 Yes 83 No 22 M N Yes 8732 2 2 10 \$11,162.55 17 380353 No T&W Positive \$1,894.00 Yes 35 No 23 M N Yes 8615 2 5 14 \$14,338.94 19 476440 Yes All Positive \$2,266.00 Yes 18 No 24 M N Yes 6988 2 6 11 \$10,625.84 18 397040 Yes All Positive \$1,995.00 No 59 Yes 25 VL Y No 18842 4 7 16 \$18,324.18 49 122976 No T&W Positive \$1,776.00 Yes 114 No 26 VL Y Yes 16623 5 7 13 \$13,795.58 41 310280 Yes T&W Positive \$2,337.00 Yes 105 No 27 VL Y No 19778 5 7 15 \$14,762.19 30 175385 Yes F Positive \$2,245.00 Yes 175 No 28 VL Y Yes 18053 5 7 20 \$18,549.84 18 75535 Yes T&W Positive \$2,118.00 Yes 162 Yes 29 S N Yes 4104 0 3 3 \$17,763.54 49 24143 Yes T Negative \$1,914.00 No 57 No 30 L Y Yes 11394 3 7 14 \$16,219.60 44 527203 Yes W Positive \$1,835.00 Yes 90 Yes 31 L Y No 14549 3 4 12 \$11,904.07 15 520172 No All Positive \$1,878.00 Yes 58 Yes 32 M N No 9834 3 3 13 -\$2,225.03 33 280566 No F Positive \$1,275.00 Yes 46 Yes 33 VL Y Yes 15084 3 6 10 \$24,419.68 41 464284 Yes All Positive \$1,745.00 Yes 182 Yes 34 M N No 9244 3 4 11 \$3,081.84 50 36443 Yes All Positive \$1,044.00 Yes 20 No 35 L Y No 13682 2 4 12 \$16,462.82 24 204618 No W Negative \$2,007.00 Yes 45 No 36 L Y No 10032 4 5 10 \$181.37 25 294171 No All Positive \$842.00 Yes 79 Yes 37 L Y Yes 14810 3 7 17 \$13,932.64 47 85635 No W Positive \$2,245.00 Yes 55 No 38 VL Y No 21330 3 5 11 \$31,814.90 19 467900 Yes All Positive \$3,019.00 Yes 83 No 39 VL Y No 20265 3 4 15 \$23,700.78 41 489281 No All Positive \$1,891.00 Yes 100 No 40 VL Y No 19778 5 8 21 \$17,658.57 42 497767 Yes All Positive \$2,355.00 Yes 174 No 41 M N Yes 5016 0 2 2 \$16,880.36 47 490757 No W Positive \$1,809.00 No 22 Yes 42 M N No 6638 0 3 10 \$19,022.15 24 182350 Yes T&W Positive \$1,826.00 Yes 48 No 43 M N Yes 8680 2 2 8 \$14,598.32 33 484319 Yes F Positive \$2,296.00 Yes 36 No 44 M N No 8628 2 5 14 \$7,252.26 17 372456 Yes F Positive \$898.00 No 31 No 45 VL Y No 18377 3 5 15 \$27,992.79 31 410093 Yes T Positive \$2,212.00 No 52 No 46 L Y No 13405 2 6 9 \$21,844.69 39 113185 Yes T&W Negative \$1,675.00 Yes 75 No 47 L Y No 12863 3 6 14 \$11,182.94 34 64639 Yes T Positive \$2,089.00 Yes 60 No 48 VL Y No 19778 4 7 17 \$17,802.64 49 518836 No T Negative \$2,388.00 Yes 156 Yes 49 L Y Yes 12263 2 5 12 \$21,989.24 15 342944 Yes T&W Positive \$2,195.00 No 67 Yes 50 L Y No 12245 2 6 10 \$19,127.69 25 289188 Yes All Positive \$1,982.00 Yes 55 Yes 51 L Y No 10391 2 2 7 \$16,000.33 38 280234 Yes F Positive \$2,297.00 Yes 64 No 52 M N No 6894 3 7 13 -\$2,248.87 25 459727 Yes All Positive \$1,225.00 Yes 53 No 53 L Y No 10840 3 5 9 \$8,802.94 22 102935 No T&W Negative \$990.00 No 87 No 54 M N Yes 6496 2 4 11 \$9,228.71 31 513112 Yes T&W Positive \$978.00 Yes 32 No 55 VL Y Yes 20518 5 9 20 \$16,852.34 40 233542 Yes W Positive \$1,745.00 Yes 152 Yes 56 VL Y Yes 15444 5 7 17 \$10,691.53 34 489134 Yes F Negative \$1,948.00 Yes 51 Yes 57 L Y No 13367 3 4 12 \$16,933.96 50 106263 Yes All Positive \$1,815.00 Yes 46 Yes 58 VL Y No 19562 3 6 17 \$24,409.42 43 422216 Yes T&W Negative \$2,167.00 Yes 164 Yes 59 VL Y Yes 15764 5 8 15 \$7,943.73 24 323334 No T&W Positive \$1,276.00 Yes 197 Yes 60 M N No 9488 3 6 17 \$9,350.99 27 245189 Yes All Negative \$837.00 No 48 Yes Liquor License Student Population Competitors within 2 Miles Competitors within 5 Miles Competitors within 15 Miles Monthly Profit Pizza Varieties Population within 20 miles Do they Delivery Review in local newspaper Monthly Advertising expenditure Offer Pizza by the Slice Parking Spots Buffet on Weekends Liquor License Student Population Competitors within 2 Miles Competitors within 5 Miles Competitors within 15 Miles Monthly Profit Pizza Varieties Population within 20 miles Do they Delivery Review in local newspaper Monthly Advertising expenditure Offer Pizza by the Slice Parking Spots Buffet on Weekends
onthly Profiquor Licens titors within Store Size tion within 2dent Popula Population is students -\$6,915.54 2 4 2 112862 8836 7.83% -\$2,248.87 2 3 2 459727 6894 1.50% -\$2,225.03 2 3 2 280566 9834 3.51% -\$337.10 2 3 2 360705 5522 1.53% \$181.37 2 4 3 294171 10032 3.41% \$429.21 2 2 2 268506 5247 1.95% \$1,347.13 2 2 1 459234 4289 0.93% \$3,081.84 2 3 2 36443 9244 25.37% \$4,978.79 1 4 3 456491 10003 2.19% \$5,136.77 2 2 2 110772 8560 7.73% \$7,252.26 2 2 2 372456 8628 2.32% \$7,943.73 1 5 4 323334 15764 4.88% \$8,802.94 2 3 3 102935 10840 10.53% \$9,158.87 2 3 3 481474 12164 2.53% \$9,228.71 1 2 2 513112 6496 1.27% \$9,350.99 2 3 2 245189 9488 3.87% \$9,927.01 2 3 3 488511 10045 2.06% \$10,625.84 1 2 2 397040 6988 1.76% \$10,691.53 1 5 4 489134 15444 3.16% \$11,162.55 1 2 2 380353 8732 2.30% \$11,182.94 2 3 3 64639 12863 19.90% \$11,371.21 1 3 2 227712 8905 3.91% \$11,904.07 2 3 3 520172 14549 2.80% \$13,476.19 2 2 3 371592 11866 3.19% \$13,795.58 1 5 4 310280 16623 5.36% \$13,932.64 1 3 3 85635 14810 17.29% \$14,256.41 2 2 3 346712 10207 2.94% \$14,338.94 1 2 2 476440 8615 1.81% \$14,598.32 1 2 2 484319 8680 1.79% \$14,762.19 2 5 4 175385 19778 11.28% \$16,000.33 2 2 3 280234 10391 3.71% \$16,219.60 1 3 3 527203 11394 2.16% \$16,462.82 2 2 3 204618 13682 6.69% \$16,852.34 1 5 4 233542 20518 8.79% \$16,880.36 1 0 2 490757 5016 1.02% \$16,933.96 2 3 3 106263 13367 12.58% \$17,658.57 2 5 4 497767 19778 3.97% \$17,763.54 1 0 1 24143 4104 17.00% \$17,802.64 2 4 4 518836 19778 3.81% \$18,103.62 1 3 3 354116 14695 4.15% \$18,324.18 2 4 4 122976 18842 15.32% \$18,549.84 1 5 4 75535 18053 23.90% \$19,022.15 2 0 2 182350 6638 3.64% \$19,127.69 2 2 3 289188 12245 4.23% \$20,825.42 1 0 2 227922 5675 2.49% \$20,840.36 1 4 4 184963 17854 9.65% \$21,844.69 2 2 3 113185 13405 11.84% \$21,989.24 1 2 3 342944 12263 3.58% \$22,289.99 2 4 4 410385 21606 5.26% \$22,483.55 2 2 3 221246 14943 6.75% \$23,521.01 1 4 4 176305 18847 10.69% \$23,663.12 2 3 4 156121 17030 10.91% \$23,700.78 2 3 4 489281 20265 4.14% \$24,409.42 2 3 4 422216 19562 4.63% \$24,419.68 1 3 4 464284 15084 3.25% \$27,992.79 2 3 4 410093 18377 4.48% \$28,575.14 2 3 4 123338 21568 17.49% \$31,814.90 2 3 4 467900 21330 4.56% \$31,923.92 1 3 4 460815 21621 4.69% \$34,291.88 1 3 4 86780 21131 24.35%
Show entire document

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents