Review the Final Project template and determine how best to analyze and interpret the data. Students must
Fantastic news! We've Found the answer you've been seeking!
Question:
Review the Final Project template and determine how best to analyze and interpret the data.
Students must use all the Excel functions we have used this semester to manipulate the data
provided. You must use everything listed below at least ONCE in your analysis. You determine
where and how to use the Excel components. I repeat...EACH component must be used at least
once. For example: You may need one component for one question, but two or three components for
another question. Failure to use all of the components will result in a deduction of points.
PivotTables
PivotCharts
Excel formulas VLOOKUP or HLOOKUP
Excel formula IF
Excel formula Nested IF
Conditional Formatting
Use Sort where necessary.
Page of
Answer the following questions:
a Should underperforming restaurants be closed or sold?
b Should highperforming restaurants be expanded to accommodate more seats?
c Should the company spend more or less on advertising?
d In which markets should the advertising budget be adjusted?
e How is The Pitts Stop Restaurants performing compared to the competition?
f How are units of like size performing relative to each other?
Considering your expertise, your CEO has given you the freedom to consider other hypothetical
questions and answer them in your analysis.
Related Book For
Posted Date: