**Financial Data Analysis**

**Criteria:****1**. Correctness of the identification of the data type and methodology used **2**. Successful application using the computer software (Excel) **3**. Interpretation of the results and correct answers to the question(s) **4**. Professional presentation of the assignment

A-Plus Writing Help For University Students

Get expert assistance in any academic field. All courses and programs covered.

Get Help Now!**QUESTION 1 **

Some critics of television complain that the amount of violence shown on television contributes to violence in our society. Others point out that television contributes to the high level of obesity among children. Now, we may have to add financial problems to the list. A sociologist theorised that people who watch television frequently are exposed to many commercials, which in turn lead them to buy, resulting in increasing debt. To analyse this belief, a researcher plans to survey a sample of families across the country.

**Briefly explain****(a)** What type of survey method could the researcher use and why?**(b)** What sampling method could the researcher use to select his/her sample and why?**(c)** What kind of issues could the researcher face in this data collection?

Suppose the researcher collected data from 430 randomly selected families. For each family, the total debt (in $) and the number of hours the television is turned-on (TV Hours) per week were recorded. The data are stored in file 1TVDEBT.xlsx and available in the course website under Assessment. Using this data and EXCEL, answer the Parts B, C and D below.

**First, the researcher wishes to use the graphical descriptive methods to present the data for the two variables.**

**(d) **He suggests using 10 classes such as class intervals 0-6, 6-12, 12-18,for the TV Hours variable and class intervals 0-30000, 30000-60000, 60000-90000,for the Total Debt variable. Explain how he could have decided on the number of classes as 10.

**(e)** Use appropriate BIN values to draw histograms for the two variables and comment on the shape of the two distributions (Hint: draw the frequency polygon as well).

Second, the researcher wishes to use the numerical descriptive measures to summarize the data.

**(f**) Prepare a numerical summary report about the data on the two variables the researcher has considered by including the summary measures, mean, median, range, variance, standard deviation, smallest and largest values and the three quartiles, for each variable.

**(g) **Use five of the above summary measures to represent the summary information in a box plot for each variable (hand drawn and scanned is OK). Comment on the outliers (if any) Third, the researcher wishes to use graphical descriptive method and a numerical descriptive measure to analyse the strength of the linear relationship between the two variables.

**(h)** Use an appropriate plot to show the relationship between variables, Total Debt and TV Hours.

**(i) **Compute a measure of the direction and strength of a linear relationship between the two variables. Interpret this value.

**(j)** Comment on the sociologist’s theory that ‘people who watch television frequently are exposed to many commercials, which in turn lead them to buy, resulting in increasing debt’.

**QUESTION 2 **

A financial analyst recorded the quarterly returns on investment for three shares and stored the data in file 2RETURN.xlsx. Using the data and performing the calculations in EXCEL, answer the following questions.**A.** a Calculate the mean and variance of each of the three shares.**b **If you wish to construct a portfolio that maximises the expected return, what should you do?**c **If you wish to construct a portfolio that minimises the risk, what should you do?

**QUESTION 3 ****A**. A new credit card company is investigating various market segments to determine whether it is profitable to direct its advertising specifically at each one. One of the market segments is composed of Asian migrants. The latest census indicates that there are 2.01 million Asian migrants in Australia. A survey of 475 Asian migrants asked each how they usually pay for products that they purchase. The responses are:

1 Cash

2 Cheque

3 Visa

4 MasterCard

5 Other credit card.

The responses are recorded and stored in file 3ACARD.xlsx. Estimate with 95% confidence the number of Asian migrants in Australia who usually pay by credit card.

**B**. An insurance company boasts that 90% of its customers who make claims are satisfied with the service. To check the accuracy of this declaration, the company conducts an annual Claimant Satisfaction Survey in which customers are asked whether they were satisfied with the quality of the service (1 = Satisfied and 2 = Unsatisfied). Their responses are recorded and stored in file 3BSERVICE.xlsx. Can we infer at the 5% level of significance (?= 0.05) that the satisfaction rate is less than 90%?

**QUESTION 4 ****Income vs Height of MBA men**

One general belief held by observers of the business world is that taller men earn more money than shorter men. In a study reported in the Wall Street Journal, 30 MBA graduates, all about 30 years old, were surveyed and asked to report their annual incomes and their heights. These responses are recorded in 4MBA.xlsx.

**a**. Estimate a linear relationship between heights and annual income of MBA graduates and interpret your results.

**b**. Do these data provide sufficient statistical evidence to infer at the 5% significance level that taller men with MBAs earn more money than shorter ones?

**c**. Obtain two measures to check the fitness of the model. Do you think that this model is good enough to be used to estimate and predict income on the basis of height? If not, explain why not. If so, predict the income of 183cm tall men with MBAs.

**QUESTION 5 **

An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries Compilation of the COVID-19 epidemic data commenced on the 31st of December 2019. First identified in Wuhan, China, and by April 2020, had spread to more than 200 countries worldwide with more than 3 million confirmed positive cases and about 235,000 deaths worldwide. In September 2021, worldwide, the number of confirmed positive cases has surpassed 231 million and the number of deaths has exceeded 4.74 million. In December 2020, a number of COVID19 vaccinations completed their trials and were approved by several governments of countries to be used for their citizens.

The number of worldwide confirmed COVID-19 positive cases and number of deaths as reported on the 26th of September 2021 by country (for countries which have had more than 1000 confirmed COVID-19 cases) is given in 5COVID19WORLD.xlsx.

**A. Using the data in worksheet ‘Cases&Deaths’ of 5COVID19WORLD.xlsx answer the following questions.**

**a**. Identify the top 15 countries by ranking the total number of confirmed COVID-19 cases and draw a bar chart. Comment on the chart.

**b**. Use an appropriate chart to show the share of the number of confirmed cases in the top 15 countries in the world total (combine the rest of the countries as ‘Other’).

**c**. As the population sizes are different, to compare the number of confirmed COVID-19 positive cases across countries, considering the number of confirmed cases per 10,000 persons would provide a better comparison across countries. For the top 15 countries identified in part a, calculate the total number of confirmed cases per 10,000 persons. Sort the data from largest to smallest and draw a bar chart of number of confirmed cases per 10,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in part a.

**d**. Identify the top 15 countries by ranking the total number of COVID-19 deaths and draw a bar chart. Comment on the chart.

**e**. Use an appropriate chart to show the share of the number of deaths in the top 15 countries in the world total (combine the rest of the countries as ‘Other’).

**f**. As the population sizes are different, to compare the number of COVID-19 related deaths across countries, considering the number of deaths per 10,000 persons would provide a better comparison across countries. For the top 15 countries identified in part d, calculate the total number of deaths per 10,000 persons. Sort the data from largest to smallest and draw a bar chart of number of deaths per 10,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in part d.

**g**. Obtain the proportion (in percentage) of number of COVID-19 related deaths per number of COVID-19 cases for each country. Identify the top 15 countries with the highest percentage among all countries and present them in a bar chart. Compare your results with the results in part f.

**h**. Based on your analysis above in parts c, f and g, in your opinion, comment on which countries have been successful and which countries are of concern in dealing with the COVID-19 pandemic with respect to number of cases and deaths.

**B. Using the data in sheet ‘Vaccination’ of 5COVID19WORLD.xlsx answer the following questions.**

**i**. Identify the top 15 countries by ranking the total number of vaccinations and draw a bar chart. Comment on the chart.

**j**. Use an appropriate chart to show the share of the number of vaccinations in the top 15 countries in the world total (combine the rest of the countries as ‘Other’).

**k**. As the population sizes are different, to compare the number of COVID-19 vaccinations across countries, considering proportion of the population vaccinated would provide a better comparison across countries. Calculate the proportion of the population vaccinated (in percentages) for each country. Sort the data from largest to smallest and identify the top 15 countries. Draw a bar chart of proportion of the population vaccinated for the top 15 countries.Comment on the chart.

**l**. Compare the top 15 countries most affected based on the number of cases and deaths per 10,000 persons in parts c and f with the top 15 countries vaccinated in part k. Are any of the most affected countries in parts c and f able to vaccinate their population better than others?

This **7802GBS-Accounting & Finance Assignment **has been solved by our **Accounting & Finance Expert **at **TV Assignment Help. **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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Welcome to our Online Essay Writing Agency. Securing higher grades costing your pocket? Order your assignment online at the lowest price now! Our online essay writers are able to provide high-quality assignment help within your deadline. With our homework writing company, you can order essays, term papers, research papers, capstone projects, movie review, presentation, annotated bibliography, reaction paper, research proposal, discussion, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch

** We write papers within your selected deadline. Just share the instructions**