Order from us for quality, customized work in due time of your choice.
Project: Analyze NYSE Data
Submission Phase
Success Criteria Specifications
The
Project: Analyze NYSE Data
Submission Phase
Success Criteria Specifications
The student has uploaded a written report as PDF or PowerPoint necessary for review.
A PDF file or PowerPoint presentation has been uploaded as part of a zipped folder.
The student has provided an Excel file or a link to a Google Sheet necessary for review. This file should contain individual tabs for the dataset, a calculation of the summary statistics, a dashboard for the Profit and Loss statement, and a Forecasting model with scenarios.
In case the student did not include an Excel file as part of the submission, the Google link should be included in the PDF or slides document with appropriate permissions to validate the formulas and tables.
The spreadsheet (Excel or Google Sheets) should contain individual tabs for the dataset, calculation of the summary statistics, a dashboard for the Profit and Loss statement, and a Forecasting model with scenarios. There can be additional tabs in the Workbook that are needed for the dashboard and forecasting model.
Exploration of Summary Statistics
Success Criteria Specifications
The student is able to calculate measures of center for quantitative data and interpret it correctly.
The student utilizes measures of center (Mean and Median) to derive insights. Merely stating the value of the summary statistics is insufficient; thus, it is crucial to include a brief insight related to each one in the written desсrіption.
Includes the calculations of the measures of center in a tab named summary statistics in the spreadsheet, as mentioned in the rubric above.
Includes the interpretation of the measures of center in your written report (PDF or PowerPoint).
For example, The mean total revenue for companies categorized under the Pharmaceutical industry ($26,325,440,909.09) was higher compared to the mean total revenue for all healthcare industries ($23,142,217,458.76). It looks like companies in the Pharmaceutical industry have a higher total revenue on average than all industries categorized under Health Care.
The student is able to calculate measures of spread for quantitative data and interpret it correctly.
The student utilizes measures of spread (Standard Deviation and Range) to derive insights. Merely stating the value of the summary statistics is insufficient; thus, it is crucial to include a brief insight related to each one in the written desсrіption.
Please include the calculations in the same tab summary statistics as mentioned in the rubric point above.
Please include the interpretation of the measures of spread in your written report (PDF or Powerpoint): For instance, consider the following insight based on the range: The Range for the Agriculture sector Total Revenue at $5 Billion is higher than the Range of Total Revenue for the Telecommunications sector at only $2 Billion. It looks like companies in the Agriculture sector have more significant variability in the total revenues they receive because their range is more spread out.
The student is able to build graphs for quantitative and categorical data.
The student uses at least one plot to explore the data. The plots may include histograms, box plots, scatterplots, and bar charts to explore data and gain insights. Screenshots of values in a table do not count.
The student is able to present findings in an understandable way.
An appropriate visual is chosen to present the data. All labels are legible, and the visual has appropriate axis labels.
Every visualization should have:
chart title (including which year′s data the chart depicts)
x-axis title
x-axis labels
y-axis title
y-axis labels
Please refer to the finished slide example page in the classroom for an example.
Communication Phase
Success Criteria Specifications
The student is able to avoid making inferential or causal statements when using desсrіptive statistics.
The results of the analysis are presented such that any limitations are clear. The analysis does not state or imply that one change causes another based solely on a correlation.
The results do not imply facts about a larger group of individuals based on desсrіptive values. Language is only applied to the specific data provided unless a correct analysis beyond the course material is conducted that allows for inference.
The student is able to choose the correct statistical analysis and a plot to visualize the results.
This rubric point summarizes the requirements for communicating the results of your analysis:
Student uses the appropriate data type (quantitative) for statistical analysis.
Interpretation of measures of center and spread is described in the context of the analysis.
Student uses at least one visualization to communicate the results.
Business Metrics
Success Criteria Specifications
The student demonstrates proficiency in correctly utilizing financial metrics within an income statement (profit and loss statement) as well as in a forecast model.
The student has accurately input the appropriate formula for each business metric in both the income statement (P&L statement) and the forecast model.
Please make sure to include a separate tab in your spreadsheet for the P&L and forecast model.
Make sure that the P&L statement includes a dropdown list for selecting the ticker symbol, including all tickers from the dataset. Note that a dropdown in the forecast model is optional, as the forecast analysis can be done for a single company.
The student provides appropriate assumptions for the financial model scenarios.
The student provides appropriate assumptions based on gross margin, revenue growth, and operating margin for the financial model (forecast) scenarios.
Excel Functions and Modeling
Success Criteria Specifications
The student can use various Excel functions.
The student demonstrates using VLOOKUP or INDEX and MATCH statements. The student can use the appropriate functions, such as OFFSET and MATCH, to create forecast scenarios.
Suggestions to Make Your Project Stand Out
The visuals go above and beyond to be appealing and informative.
Visuals not included in this course we used to communicate in creative ways.
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)
Order from us for quality, customized work in due time of your choice.