Question: DESCRIPTION In this assignment, students will collect econometric data on the stock performance of a specific company (approved by the instructor). This group project will

DESCRIPTION In this assignment, students will collect econometric data on the stock performance of a specific company (approved by the instructor). This group project will focus on learning how to navigate and analyze data using Excel. INSTRUCTIONS Step 1. Install Excel onto your computer using your myucwca credentials. Step 2. Install Excel \"Analysis ToolPak." Step 3. Use the instructor-prepared Excel spreadsheet to acquire stock data of the selected company for the analysis. Step 4. Select a 1-year time interval for the analysis and enter it into an Excel worksheet. Step 5. Check the visualizations of the stock price vs time, histograms, and boxplots. Step 6. Write a 1000 to 1500 words report describing the results that you have observed in the analysis of data from Step 5: 6.1 What data were used? 6.2 How were the data acquired? 6.3 How were the data processed? 6.4 How were the visualizations constructed? 6.5 What were the major events observed from 1 year of data? 6.6 What were the major events that happened for the selected company in the same period? (For example, change of executive manager, new policies, products, marketing campaigns, operational changes) 6.? How did these major events reflect in the data visualizations
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
