Financial Issues - Early Retirement - Report Writing Finance Assignment Help

Assignment Task:

COVID-19 has brought financial issues to Colleges and Universities in Ontario. In order to relief their budgets the province is willing to offer early retirement to some professors. The Ontario Ministry of Education has chosen you to help them to make this decision and analyse their data.

Question 1 – 2.5 points
In Excel open a new sheet and name it Answer 1.
Using the provided database, perform a random sampling with 300 samples.
Write down in the same sheet the steps and formulas you used to make the sampling

Question 2 – 2.5 points
Although you have the population, we are NOT GOING TO USE IT. We will deal only with your sample and consider for all next questions a SIGMA UKNOWN CASE.

Open a new sheet and name it Answer 2.
Calculate the confidence internal for your samplevariable Age mean with 99% of confidence. Leave all relevant calculus and formulas, they will be used for marking.
In a visible place write down to the Ontario Ministry of Education what number you just found means.

Question 3 – 5 points
Although you have the population, we are NOT GOING TO USE IT. We will deal only with your sample and consider for all next questions a SIGMA UKNOWN CASE.

Open a new sheet and name it Answer 3.
The province is willing to release the retirement package only if the average of professors age is higher or equal to 53 years. As per previous experiences they are assuming that once again there will be no necessity to release the package. Because this is an important matter, they want to have 99% of confidence.
Write down yourrecommendation to them using the proper statistic numbers. Explain why they should or should not release the packageand if more tests are necessary.

This Finance Assignment has been solved by our Finance Experts at onlineassignmentbank. 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.