You have been hired by an investment group that wants to learn more about what drives restaurant sales. You have been provided a sample of 173 restaurants located in a medium-sized city. You know the restaurants’ average weekly sales, as well as a number of other variables such as food type, if has road frontage, number of competitors within a certain distance, etc. See the legend on the right side of the Excel spreadsheet for definitions of all variables. You have been working with this data set (coding dummy variables and categorical variables).
Your task is to help the investor better understand the data that has been collected. What can they learn from this data set?
This assignment is open-ended by design. As the consultant, you will make decisions about what you wish to analyze and communicate to your client. You will analyze this information USING ONLY the tools that we have learned so far in this course. But you should strive to be as thorough as you can, given the length requirement (see below).
AGAIN, THERE IS A THOUGHT ORGANIZER POSTED IN THE MODULE THAT MIGHT HELP YOU IF YOU ARE HAVING TROUBLE COLLECTING YOUR THOUGHTS. EVERYONE SHOULD TAKE A LOOK AT THIS, AS IT HELPS TO SET EXPECTATIONS.
Your audience is your client, the investment group. You can assume that your audience has some very basic knowledge of statistics, and you should explain the implications of the statistics you generate to this audience. (They understand mean, median, mode–the basics–but might not fully understand concepts like standard deviation, percentiles, etc. so those require some explanation as to what the information is communicating. They might understand basics graphs but you need to be sure they understand the “takeaways” of your graphs. Do not “orphan” the graphs.)
This should be styled as a report with brief intro or executive summary, a discussion of the data with a clear organizational structure, and conclusion.
You are limited ONLY to the statistical topics we have covered. You may not conduct other types of analyses.
Your analysis must address content from BOTH Modules 1 and 2 and you should do your best to communication a variety of information.
Your analysis must include at least 3 different graphs and no more than 4. They must be different types of graphs that communicate different information. (A table is not a graph. You may have those as well, but they are in addition to graphs.)
Graphs should be large enough read (if they are not then it will detract from grades) but no so large that they waste tons of space (you don’t get credit for graphs that are oversized as a way of lengthening the report).
Do not stretch out graphs in order to take up more space…this decreases your content and will impact your grade. I know you guys understand what I mean.
Be sure the font inside graphs is readable (both color and font size are appropriate).
Please have a blank line before and after tables and graphs and before section headings.
Consider putting two graphs next to each other (see the video on how to do this) as to not waste a lot of space.
REMEMBER THAT A TABLE IS NOT A FIGURE. A CORR MATRIX IS A TABLE, NOT A FIGURE. YOU CAN HAVE TABLES BUT THEY DO NOT COUNT TOWARDS THE 3 FIGURE REQUIREMENT.
Your report may be no more than 2.5 pages in length.
This means you must think about what to focus on. This is part of the “open-endedness” of the assignment.
COACHES WILL NOT READ BEYOND 2.5 PAGES.
You cannot do a good job if you are much less than this length.
Please do NOT use a title page. Just put your name in the upper margin/header so you do not waste space. (It slows coaches down when they have to scroll past a title page.)
Please use 12-point font and 1-inch margins.
Paper will be single-spaced, but with a blank line before/after figures and tables and headings in order to make it readable.
You do NOT need to cite any data source.
While content will be given more weight, organization and writing quality contribute towards your grade. Take time to edit your work and reflect on the structure of your paper.
Reach out to Dr. Marks for any clarifications needed.
**NOTE: HAVING TROUBLE WITH GRAPHS NOT GOING WHERE YOU WANT THEM TO GO…THEN SEE THE SHORT VIDEO IN THE MODULE. IT SHOWS YOU TO MOVE THEM NEXT TO EACH OTHER…REQUIRES SOME PICTURE SETTINGS.
Be sure that:
You make interesting observations and connections and find ways to present data visually, in a meaningful way.
You speak to your audience, as defined below.
You explain to your client what the analysis CAN and CANNOT tell them about restaurant performance. (Be sure to incorporate this into your report.)
Your content is well crafted, well organized, information is correctly interpreted, and it is well explained.
You employ good technical writing tips, as communicated in lecture.
You have an appropriate tone, your work is well organized, your writing quality is high, and errors are caught in editing.
Your name is in the top header.
You have followed instructions fully.