ECON940 Statistics for Decision Making - Assignment Help

Assume you work as a stock market analyst, to provide recommendations to your clients about stock investment. How would you go about making a reasonable choice among many stocks available? The objective of your report is to provide general guidelines for your clients to select a group of stocks, based on statistics evidence on different stock characteristics.

The data file “Stock returns” contains information of 6 variables from a sample of 1,469 stocks from 2016 to 2020. It is noted that some stock return information is missing from this data file. The variables and definitions are summarized in the following table:

Id Unique code for each stock
Year Year indicators for 2016, 2017, 2018, 2019 and 2020, respectively
Owner The types of owners issuing the stocks. 1 = Government; 2 = Families; 3 = Co-founders; 4 = Foreigners; 5 = Other types
Industry The types of industries that each stock belongs to. 1 = Agriculture; 2 = Mining; 3 = Manufacture; 4 = Electric power; 5 = Engineering; 6 = Wholesale; 7 = Transportation; 8 = Hi-Tech; 9 = Real estate; 10 = Services
Gender CEO gender type. 1 = Male; 0 = Female
Returns Stock annual returns

Assignment tasks:

  1. Visually present data and calculate descriptive statistics for the annual stock returns based on stock owner types. Comments on the location, shape and variability of these distributions.
  2. Visually present data and calculate descriptive statistics for the annual stock returns based on stock industries. Comments on the location, shape and variability of these distributions.
  3. Visually present data and calculate descriptive statistics for the annual stock returns based on years. Comments on the location, shape and variability of these distributions.
  4. It is claimed that annual returns of stocks owned by families are higher than annual returns of stocks owned by the government. Test this claim at 5% significance level (95% confidence level).
  5. It is claimed that annual returns of stocks from Service industry is higher than the annual returns of stocks from Mining industry. Test this claim at 5% significance level (95% confidence level).
  6. How did stock perform over this 5-year period? Using 5% significance level (95% confidence level).
  7. In 2020, the COVID-19 has affected the international travelling. So it is claimed that the annual returns of stocks from airline industry were lower in 2020, compared with the annual returns in the previous years. Test this claim at 5% significance level (95% confidence level).

Requirement:

  1. Please complete a business report, including the following sections: Executive summary, Business problem, Statistical problem, Main analysis, Conclusion/Recommendation.

Executive summary: This section summarizes the purpose of business report, and the key results and recommendation. (Less than 150 words)

Business problem: This section gives the background of this business report, and summarizes which problems will be examined. (Less than 150 words)

Statistical problem: This section gives the information of what statistical technique will be used in the analysis, and what statistical information will be provided. (Less than 150 words)

Main analysis: This section should include 7 subsections (using sub-headings), covering 7 assignment tasks discussed above.

Conclusion/Recommendation: This section summarizes the key findings that are relevant to your clients, and gives out direct recommendations. (Less than 150 words)

  1. Use 5% level of significance (95% confidence level) in your analyses for all questions of hypothesis testing.
  2. Excel outputs should be incorporated into your report.
  3. Using histogram to visualize the data.
  4. When calculating and reporting the descriptive statistics, coefficient of variations (CV) should be also calculated and reported.
  5. A table of content should be present (after Executive summary, and before the Business problem)
  6. Word limit for each section will be strictly imposed.

Expert's Answer

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

Professional

Online Tutoring Services

17,148

Orders Delivered

4.9/5

5 Star Rating

748

PhD Experts

 

Amazing Features

Plagiarism Free

Top Quality

Best Price

On-Time Delivery

100% Money Back

24 x 7 Support

Ask a New Question
*
*
*
*
*

TOP

Connect on WHATSAPP: +61-416-195006, Uninterrupted Access 24x7, 100% Confidential

X