Conduct data analysis and prepare a report for your boss about your findings, which will also include an analysis of how data informs a future strategy for growth. 

Topic: Conduct Quantitative Analysis

Scenario

Your boss, the CEO of Mountain Air Recreation, Inc., has invited you to her office to tell you that the Board is considering the launch of a new product offering: luxury resort skiing. This offering will complement their existing line of high-adventure outdoor recreational sport offerings, which include jungle safaris, scuba diving, wilderness hiking, and helicopter skiing. The marketing team has done a great deal of research on the target audience and believes the company will make a handsome profit on the new resort. The CEO wonders, however, if the introduction of a luxury sport activity will affect their guests’ perceptions of the company, which is known for its rugged outdoor activities. She also wonders if downhill skiing —and the accompanying requirement to manage mountain forest growth—will damage the company’s reputation as a responsible steward of the environment. She is convinced that if the company moves forward with this project, it will be vital to integrate the marketing effort with a communications campaign designed to enhance the image of the company as one that not only sells high-end adventure but cares deeply about the environment and enjoying it responsibly.

The CEO provides you with demographic and psychographic data about the company’s guests and asks you to provide an analysis of the data to inform her recommendations to the Board about the long-term wisdom of entering the high-end ski resort market.

The CEO has scheduled an offsite planning meeting to discuss the new business endeavor and has asked you to prepare worksheets in Excel to support her presentation at the upcoming meeting.

You plan to analyze the data using standard statistical methods in Microsoft Excel and to develop statistics as well as charts and graphs to support the presentation of data.

Conduct data analysis and prepare a report for your boss about your findings, which will also include an analysis of how data informs a future strategy for growth.

Once you have reviewed the scenario, review the project overview, approximate time commitment, and competencies that you will be responsible for in this project.

Your boss tasked you with providing an analysis of data that may help her come to conclusions about the viability of adding a luxury skiing feature to the resort.

The questions may help you to interpret the data. Be sure to review each tab again to ensure that you can base your conclusions on the data.

Your 250- to 300-word essay will include the following:

a one-paragraph narrative summary of your findings, describing patterns of interest

an explanation of the potential relevance of such patterns

a description of how you would investigate further to determine if your results could be perceived as good or bad for the company

You may find it helpful to create your essay in a Word document before copying and pasting it into the text box on the QR Analysis tab.When you have completed your essay, review the order of tabs.