ECF6102 - Quantitative Skills For Business - TOP 48 ASX - Statistical Analysis - Regression Analysis - Statistics Assignment Help

ECF6102: Quantitative Skills For Business Statistics Assignment Help

Assignment Task:

ASSIGNMENT INSTRUCTIONS
This assignment is to be completed in two (2) parts: Part A Uses the data set called ‘TOP 48 ASX’ from the Blackboard site in the Assignment folder. You are required to answer a number of questions concerning the data set. This part involves you to perform the calculation for questions using the data set ‘TOP 48 ASX’. You should use your calculator, appropriate formulae, and statistical methodology to answer the questions. All the steps and working must be shown here, providing a clear and logical layout of your answer. (Use as much accuracy as is necessary and generally up to 4 decimal places). Some of the solutions also required to use Excel software (PhStat or Data Analysis). Provide a separate printout of your results where applicable.

Part B

This part requires you to undertake further statistical analysis using the data set ‘TOP 48 ASX’. Requirements areas above. This part requires you to undertake regression analysis using the data set ‘STOCKS PRICES 2018_2019’.

Part A – Statistical Analysis

QUESTION 1
Using the sample data attached, calculate the sample mean and standard deviation for the variables:
i. P/E ratio

ii. DPS 

iii. Did Yld I

v. P/Sales 
Note: Use Excel for this question. You must also show the formulas, which are used to calculate the above statists.

QUESTION 2
Check for normality for ALL the above variables in Question 1. Are there any variables that could be considered NOT approximately normally distributed? Use PhStat to determine your answer here. Include your printouts from PhStat supporting your reasoning.

QUESTION 3
Write a summary on descriptive statistical findings, referring to Questions 1 and 2.

QUESTION 4
Using the sample data, calculate the sample proportion of companies for which Dividend Yield exceeds 6.5%, and its corresponding standard deviation.

QUESTION 5
Set up and interpret the following confidence intervals:

i. a 95% confidence interval for the true population mean P/E ratio. 

ii. a 95% confidence interval for the true population mean P/Sales. 

iii. a 90% confidence interval for the true population proportion of all companies whose Dividend Yield is better than 6.5%.

QUESTION 6
A follow-up study will provide a point estimate of the population proportion of companies with Dividend Yield that exceeds 6.5%. The study must provide 90% confidence that the point estimate is within 0.1 of the population proportion. If no previous proportion estimate is available (do not refer to the calculation in Question 4 above), how large a sample would you recommend for this study? Explain your answer.

A follow-up study will provide a point estimate of the population proportion of companies with Dividend Yield that exceeds 6.5%. The study must provide 90% confidence that the point estimate is within 0.1 of the population proportion. If no previous proportion estimate is available (do not refer to the calculation in Question 4 above), how large a sample would you recommend for this study? Explain your answer.

Part B – Statistical Analysis (cont)

QUESTION 7
A stock market analyst claimed that on average the P/E ratio of all companies in the ASX 50 is more than 20. Do the data provide significant support for this claim?
Use a 5% significance level to test this claim. You should use both the critical value approach and the p-value approach to justify your answer. The relevant PhStat printout
should be also provided. Comment on your findings.
 

QUESTION 8
The Australian Financial Review has claimed that less than 20% of all companies in the ASX 50 have a dividend yield (%) that is 8% or more. How much evidence does the data providers need to support this claim? Use a 5% level of significance to test this claim. You should use both the critical value approach and the p-value approach to justify your answer. The relevant PhStat printout should also be provided. Comment on your findings.

This ECF6102: Statistics Assignment Help has been solved by our Statistics experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.