Homework: Applied Business Analytics
Instructions: Applying Analytic Techniques to Business
In the last homework, you were asked to prepare the first part of your analytics report by creating graphs and calculating some descriptive statistics. In this homework, you will write your 6to 8 page analytics report by interpreting those graphs and statistics, and explicitly connecting those interpretations to implications in the practical business context.
The first step in creating meaningful information from raw data is to represent the data effectively in graphical format and to calculate any required statistics. The second step is interpreting and explaining those graphs and statistics in order to apply them in the business context.
In the previous homework, you were asked to create the first part of your analytics report by preparing graphs and calculating some descriptive statistics. In this homework, you will complete your analytics report by interpreting those graphs and statistics, and connecting those interpretations explicitly to implications in the business context.
In business and applied analytics, oftentimes you are interested in drawing conclusions about a population of interest. However, it may not be feasible or practical to gather data on the entire population. In those cases, data is gathered from a sample or subset of the population. Analyses done on the sample are then used to draw inferences regarding the overall population; this mathematic process is referred to as inferential statistics. In this homework, we begin discussing the topics of sampling and drawing inferences.
All the inferential statistical techniques and methods covered in this course are considered parametric techniques and require certain assumptions to be used and for the results to be reliable, many of which are assumptions about an underlying distribution. Nonparametric techniques require no assumption about underlying distributions and are often used when the assumptions of parametric techniques are not met. Although these are beyond the scope of this introductory course, they are a great option for additional reading and research.
Analytics projects often result in two distinct types of reports or summaries: one tailored to the executive level, which takes the form of a presentation, and the other, a detailed analytics report, which documents an analysis so thoroughly that another analyst can reproduce the analysis exactly. Many times, the latter type is referred to by other departments or analysts wishing to conduct a similar analysis on similar data or by the same analyst who wants to repeat the analysis on a new or revised set of data. In this homework, you will learn the essential elements that should be included in a report at this level of detail and you will create your own analytics report addressing the business problem you have been working on.
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 the stock prices that you presented graphically in your report for the last homework. This time your task is to analyze and interpret those graphical representations of the company stocks and to write a report about your findings for your supervisor.
Your Role
You are an analyst in the same business that you used for the last homework. Your role is to turn data into meaningful information through the use of descriptive statistics and analysis.
Instructions
After reviewing and integrating your instructor's feedback on your previous homework, complete the report as follows:
1. For each graph you created, write at least one 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?
2. For each statistic you calculated, spend at least one sentence explaining what the statistic represents.
• What does the mean tell you?
• 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?
3. 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 to inform business decisions?
• How will you connect those interpretations explicitly to implications for the practical business context?
Create a 6 to 8 page report containing:
• An APA-formatted title page.
• A one-page introduction of your chosen company that you created in your previous homework.
• A section labeled "Graphical Representations of Data" that includes the four graphs you created as well as your interpretations of each graph.
• A section labeled "Descriptive Statistics" with the statistics you calculated as well as your interpretations of the statistics.
• A one-page conclusion in which you describe the potential business applications of the data and your interpretations.
• An references page. Remember to cite the source of your financial data.
Example Homework: You may use the following to give you an idea of what a Proficient or higher rating on the scoring guide would look like:
Evaluation
1. Competency 1: Apply data analytic techniques to make inferences about a business need.
• Interpret four different graphical representations of data.
• Interpret descriptive statistics for two different variables.
2. Competency 2: Present the results of data analysis in clear and meaningful ways to multiple stakeholders.
• Explain the business applications from the interpretations of the data.
Format your homework according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the homework, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.