Des Moines Area Community College Analytic Techniques to Business Report

Applying Analytic Techniques to Business

The first step in creating meaningful information to develop a business report for decision-making. The business report includes the analyzed raw data, effectively presents the analysis results in text and graphical format, as well as calculate any required statistics.

The second step is interpreting and explaining the graphs and statistics in order to understand the impact in the practical business context.

In the last assignment, you were asked to create the first part of your business analytics report by introducing a company, analyzing company stock data, developing graphs, and calculating some descriptive statistics.

In this assignment, you will adjust your business report to minimize limitations of one year’s worth of data. You will use the same company for this assignment and you will use 5 years of data.

You will also enhance your introduction/business context section of your business report based on your new graphs and your interpretation of the data graphs and descriptive statistics over a five year period. Your interpretation efforts of graphs and descriptive statistics will explicitly connect in the conclusion area. Conclusions and recommendations are the final effort in the development of a practical business report and should be supported by citations. Remember opinion is not allowed.

Scenario

Your supervisor has asked you to prepare a report for the quarterly company meeting. The first part of the task was to download the data and create scatterplots and histograms, and to calculate mean, median, and mode of 5 years of stock prices for your report. Now you must analyze and interpret those graphical representations of the company stock and write the report of your findings and recommendations for your supervisor.

Your Role

You are an analyst using the same company and five years of stock data. Having accessed the company data and placed it in an appropriate graphical format, you must now use descriptive statistics and analysis to develop a report to inform business decisions.

Instructions

After reviewing and integrating your instructor’s feedback on your previous assignment, complete the report as follows:

For each graph you created, write at least one well supported paragraph interpreting the graph: What does that graph represent? What does the shape of the graph tell you about how the data have changed over time?

For each statistic you calculated, include at least 2–3 well-supported sentences explaining what the statistic represents:

  • What does the mean tell you? How do you know?
  • What does it imply if the median is different from the mean?

What does the standard deviation tell you about the volatility of the data?

  • Write a new conclusions section in which you explain how these interpretations can be used in the company:
  • What are some trends about which company leaders should be aware?
  • How might the information you have provided be used in decision making in the company?
  • What are other analysts indicating about the stock?

Explicitly connect other analysts’ comments and recommendations to your interpretations to possible impact to the business context.

Don't hesitate - Save time and Excel

Are you overwhelmed by an intense schedule and facing difficulties completing this assignment? We at GrandHomework know how to assist students in the most effective and cheap way possible. To be sure of this, place an order and enjoy the best grades that you deserve!

Post Homework
Top