View the step-by-step solution to:

Crusty 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

There are (3) deliverables identified as "case studies" listed below. The data is attached.


Use graphical and numeric methods of descriptive statistics to summarize the data. At a minimum your report should include:
1) Descriptive statistics
a. Frequency and percent frequency distributions for key variables
b. Bar and/or Pie charts of distributions developed in step one
c. Scatter diagrams for key variables
d. In all, you must comment on your results.
2) Numeric methods
a. For example, average, mean, variance, and range
b. Comment on correlation and covariance between key variables
c. In all comparisons, comment on your findings.

Case Studies
1) Using the same data set as above perform simple linear regression and multiple linear regressions (due 27 October) on the key variables.
2) Comment on goodness of fit
3) Discuss which variables you would include and why
Crusty 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
Background image of page 1
Sign up to view the entire interaction

Top Answer

Dear Student We at present are unable to work on your question due to unavailability of a... View the full answer

Sign up to view the full answer

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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online