It seems like you’ve provided the instructions for a group assignment related to analyzing the performance of firms in a chosen industry listed on the NYSE using Microsoft Excel. Here’s a general outline of how you can approach each of the tasks and the deliverables:
Task 1: Tracking Stock Performance
Create a Microsoft Excel spreadsheet.
Input the stock prices of the 20 firms for the last 5 years, recording monthly data.
Use appropriate visual tools like line charts or candlestick charts to visualize the stock price trends.
Task 2: Calculating Descriptive Statistics
Calculate descriptive statistics for each firm, including measures like mean, median, standard deviation, and any other relevant statistics.
Aggregate the data for the industry and calculate descriptive statistics for the industry as a whole.
Task 3: Investment Decision
Analyze the data to identify firms with strong performance based on factors like consistent growth, low volatility, or any other criteria you choose.
Justify your investment decisions for the top 3 firms, citing statistics and any additional information you gathered from external sources such as newspapers or firm websites.
Task 4: Identifying Trends
Examine the data to identify any trends or patterns that are evident in the stock market performance of these firms over the past 5 years.
Deliverables:
Create an Excel sheet that includes all the data, charts, and statistics related to the tasks.
Write a Word document with explanations for why specific charts, graphs, and analyses were used for each task.
Summarize your findings in the Word document, providing a 100-200 word summary for each task.
Ensure proper housekeeping by correctly formatting your documents, including page numbers, charts, and appropriate references in APA format for external sources.
Submit the Excel sheet and Word document to your instructor.
Assessment:
You will be graded on the appropriateness of the charts, graphs, and tables used in each task and the explanations provided for their use.
Summarize what you found in each task and ensure your analysis is supported by statistics.
Pay attention to the formatting and referencing requirements specified in the rubric.
Your peers will also assess your work, so ensure clarity and thoroughness in your submission.
Remember to collaborate effectively with your group members, communicate regularly through the provided tools, and ensure that each member contributes to the assignment. Good luck with your analysis!
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount