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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!