There is no pages or words limit and its a basic assignment. If you hav any questions please let me know. Thank you
Microsoft Word - MBAF502_ProjectI PROJECT I Course Name and Number: MBAF 502: Quantitative Reasoning & Analysis Project 1: Descriptive Statistics and Comparative Analysis Weight = 25% Due May 20, 2022, at 23:59 pm. DESCRIPTION In this assignment, students will collect data on the stock performance of a specific company/asset (approved by the instructor). This group project will focus on learning how to navigate and analyze data using Microsoft Excel and its embedded Visual Basic for Applications (VBA) programming language and Gretl. Students will apply statistical techniques to financial and business models to develop and solve or simulate the core issues. Under Part 1 of this project, students will perform basic analytics and descriptive statistics. Under Part 2 of this project, data sets collected in Phase I will be utilized to explore central and variation tendencies, create index numbers, and write analytics report that will compare the above data for statistically significant differences. PART 1: Data Collection and Descriptive Statistics INSTRUCTIONS Step 1. Install Excel onto your computer using your myucw.ca credentials. Excel Add-ins: Load Excel Analysis ToolPak for visual basic analytics and Solver, where necessary. Step 2. Download and install programing language Gretl (or a statistical tool of your preference); Gretl is available at http://gretl.sourceforge.net , GNU GPL licence, crossplatform. Step 3. Financial Markets Analysis: Extract stock market data of the selected company, or asset (digital asset like cryptocurrencies) for the analysis for a selected time period. Step 4: Define the measure of central tendency. What does each measure tell us? Step 5: Provide a summary statistics and reflect on the major indices from your summary statistics (mean, median, mode, minimum value, maximum value, range, standard deviation, etc.) Step 6. Check the visualizations of the stock price vs time, histograms, and boxplots. Step 7. Write 1000 words report describing the results that you have observed in the analysis of data from Step 5: 5.1 What data were used? 5.2 How were the data acquired? 5.3 How were the data processed? 5.4 How were the visualizations constructed? 5.5 What were the major events observed from 1 year of data? 5.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, market crashes, market bubble, trends, mass adoption, hype, or any socio-political business and nun-business environment dynamics that affected the performance of the stock market) 5.7 How did these major events reflect in the data visualizations? PART 2: Comparative Analysis Here you will perform a comparative analysis using the performance indices. Follow the following instruction for this part of the project. INSTRUCTIONS Step 1. Acquire and visualize data for another related company/asset like the one acquired under part 1. The time interval for the Step 2. What were the major events that have occurred in the market (for example, market rallies, market crashes, changes in government policies, economic situation)? Step 3. How did these major events reflect in the behaviour of the company/asset chosen above? Step 4. Write 1000 words report comparing the performance of S&P500 with the company selected in Phase 1: 4.1 Which of the compared items exhibited higher returns. 4.2 Which of the compared items exhibited higher volatility. 4.3 Using the hypothesis test framework, analyze whether the differences in returns are statistically significant. 4.4 Using the hypothesis test framework, analyze whether the differences in volatilities are statistically significant. Note 1 Variance_ Example (Gretl Sample Data) Bartlett and Levene tests for homogeneity of variance across groups. From the Gretl sample file, use the data on aNIST data for variance tests to work on the following data analysis. (Hint: to access the data, go to Gretl File> Sample File > Gretl > NIST data for variance tests) (Sample data from NIST http://www.itl.nist.gov/div898/handbook/eda/section3/eda3581.htm ) Note 2 Do make use of additional sources to support your argument wherever necessary. Please cite any additional sources you might use. Your work is evaluated based on the content organization, originality, substance and analytical skill you bring in as it is reflected in the quality of the final output. Make sure you create a clear distinction between each section and subsection of the work with a proper flow and transition across. P.S: Please, provide a proper citation (both in-text citation and reference list) of any resource used in this work. Use APA Standard for the format of your final submission ------------------------------------------------------------------------------------------------------------------------------------------------------------