[SOLVED] Quantitative Analysis

REPORT STRUCTURE – Part 1 – 1,000 words (excluding tables, references, appendices) Use Headings – to separate the sections 1. Introduction – state the aim of your report and variables you have selected 2. Sampling Method: ? Explain the process of sample selection with reference to an appropriate sampling method. Here you need to explain and justify your sampling procedure using references from books. ? Provide brief details about your target population and state whether your sample is likely to be representative of your target population ? Discuss advantages and disadvantages of your sampling method in relation to other sampling methods. For example, a random sample is appropriate in statistics because it gives every firm in the population equal chance of being selected; however, random sampling does not stratify the population and, therefore, certain attributes/characteristics of firms can be over- or under-represented (e.g. firms in certain industries). ? Apply discussion of the sampling method to your assignment (do not merely paraphrase book’s material). It is not a very good justification to mention that simple random sampling method was chosen because it is ‘simple’, ‘less time-consuming’ and ‘cheap’. 3. Data & Variables – explain the meaning of variables you have selected (including the source of data) and what transformations were made. Here you need to show formulas and explain the ratios chosen (i.e. explain what your ratios show/indicate). Use this file for further explanation of the ratios: Ratios Description.docx You can create a table with the main variables Table 1: Definitions of the main variables Variables Measure/Formula Explanation Profitability ROCE/ROA/Profit Margin 4. Histograms and Descriptive Statistics – Produce histograms and descriptive statistics (min/max, mean/median, standard deviation, skewness and kurtosis) for profitability (ROCE or ROA or Profit Margin) and the other two variables you have (e.g. Firm Size, Liquidity, Tangibility, Asset Growth, Debt Ratio). Present your Histograms and Descriptive Statistics within the main text: ? Histograms: comment on the shape of the distribution. Additionally, you can comment on: o How many companies made a profit and how many made a loss. Are there any outliers? o How many companies have liquidity ratio of above and below 1. Are there any outliers? o If you choose firm size, you can show both the original variable (Sales in th GBP) and the LN(Sales). This can help your interpretation for firms size, i.e. the largest company had £Xm of Sales in 2018. o Do your histograms and statistics show any outliers? ? Descriptive Stats: comment on mean/median/min/max/standard deviation/skewness & kurtosis If there is any outlier and you have made adjustments to the variables (i.e. created a new variable and removed the outlier), please mention and justify how & why you did 5. Conclusion – a brief summary of what was done and what results were obtained. ? ‘This report examines….’ ? ‘The main results from histograms show that most companies in the sample [here you can briefly comment on profitability and other variables]’ REPORT STRUCTURE – Part 2 – 1,500 words (excluding tables, references, appendices) Use Headings to separate the sections • Introduction – state the aim of your report and the variables you selected to conduct the analysis (see Assignment part 2 to find the aim of the report) – approx. 100 words. Outliers and Adjustments – discuss any adjustments that were made to your variables. approx. 200-300 words (depends on the number of outliers in your dataset). If there are any outliers and you have made adjustments to the variables (i.e. created a new variable and removed the outlier), please mention and justify how & why you did it. To provide justification use your descriptive statistics (skewness/kurtosis) as well as histograms. You can relate your discussion to the assumptions of correlation and regression analysis (sensitive to outliers). Refer to material uploaded in week-6&7 resources – there are references you can use as well. If your data does not have outliers, you can discuss/justify that there are no outliers in your data and explain why adjustments were not required (based on skewness and kurtosis values and assumptions of correlation and regression analysis). • Correlation Analysis (Approx. 250-350 words) Produce Scatterplots. The first step in the correlation analysis would usually involve producing scatter plots to visually identify whether there is any linear association between profitability (ROCE, ROA or profit margin) and each of the other two variables you have (LNSales, Liquidity (Current Ratio), Tangibility, Asset Growth, Debt Ratio). If you removed any outliers, you can show the scatter plot with and without outliers and compare the results. Produce correlation table and comment on the results. Your correlation table should have one profitability ratio (ROCE, ROA or profit margin) and the other two variables you have (e.g. Firm Size (LNSaless), Liquidity (Current Ratio), Tangibility, Asset Growth, Debt Ratio). Present your Tables within the main text. – Discuss/comment on the relationship between profitability and each of the other two variables. – Check whether there is any potential problem of multicollinearity (if you perform multiple regression analysis). At this stage you need to choose whether you will conduct simple or multiple regression analysis. It would be good to justify your choice (for example, based on multicollinearity (relationship between Xs); number of observations; articles you read). Excel file (if you use Excel for your analysis): FTSEALLSHARE_AllFirms_ANALYSIS Example.xlsx ? • Regression Analysis – either simple or multiple: approx. 400-500 words. ? State the hypotheses that are tested in this report ? Discuss the main results in relation to the significance levels and the sign of the relationship. State whether your results show evidence in support of the hypothesized relationship. Here you can also discuss R2 and Adj. R2 (and F test for Multiple Regression). ? You may wish to discuss whether your result was expected. Here you could provide a comparison of your results with the results obtained from the correlation analysis and previous findings (i.e. use articles uploaded on Canvas under “Articles for Reading”). • Limitations – Discuss limitations of your study (e.g. sample size, variables used, limitations of correlation and linear regression methods used) approx. 250-350 words. • Conclusion – approx. 100-150 words. – Based on your results, draw a conclusion on the factors influencing firm profitability. ‘This report examines….’ ‘The main results from correlation and regression analysis show……’ [comment on the main factors related to profitability according to your results] – You can also make suggestions for further research in relation to factors that could influence firm performance (i.e. what improvements could be made in future study – more observations; more years; more variables).


Struggling to find relevant content? Order a custom essay on
[SOLVED] Quantitative Analysis
Let our experts save you the hassle
Order Now

Request assignment answer

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Great job! Thank you.
Customer 452707, May 29th, 2022
Strategic Management
Thank you very much for the help, really appreciate it
Customer 452821, June 27th, 2022
My paper was sent back after my due date time
Customer 452901, November 12th, 2022
Computer science
extremely happy with the service, again! You guys are the best.
Customer 452715, July 27th, 2022
Thank you great job
Customer 452813, July 10th, 2022
Web programming
thank you so much. This was very helpful and I was able to understand the assignment better after seeing it completed.
Customer 452715, September 22nd, 2022
Business and administrative studies
Customer 452813, June 30th, 2022
Customer 452653, October 31st, 2021
I can work with it and massage it to what I need. Thank You
Customer 452827, July 19th, 2022
Great work. thank you again!
Customer 452707, August 7th, 2022
Awesome Work!
Customer 452587, February 24th, 2022
Thank you MyCoursebay team for your support. With your help I got an A for my past courses
Customer 452635, May 7th, 2022
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
error: Content is protected !!

Save More. Score Better. Use coupon code SPECIAL for a 15%discount