Please use R to solve and explain fully

Market Planning, Inc., a marketing research firm, has obtained the prescription sales data in the table below for n = 20 independent pharmacies.

These variables can be described precisely as follows:

y = average weekly prescription sales over the past year (in units of $1000)

x₁ = floor space (in square feet)

x₂= percent of floor space allocated to the prescription department

x₃ = number of parking spaces available for the store

x₄ = monthly per capita income for the surrounding community (in units of $100)

x₅ is an independent variable that equals 1 if the pharmacy is located in a shopping center and equals 0 otherwise (x₅ is called a dummy variable)

a. Output the stepwise regression of the data in this exercise. Set, both alpha_entry and alpha_stay equal to .15. What is the final model arrived at by stepwise regression?

b. Perform a backward elimination procedure on the same data. Describe the order in which the independent variables are removed by the backward elimination procedure.

c. Is the model arrived at by backward elimination the same as the model arrived at by stepwise regression?

Your first job out of college will pay you $47,000 in year 1 (exactly one year from today), growing at a rate of 3.9% per year thereafter. You will also receive a one time bonus of $22,000 at the same time as your first salary. You plan to retire in 44 years (you'll receive 44 years of salary). If the applicable discount rate is 5%, what is the present value of these future earnings today? Round to the nearest cent.

Your first job out of college will pay you $47,000 in year 1 (exactly one year from today), growing at a rate of 3.9% per year thereafter. You will also receive a one time bonus of $22,000 at the same time as your first salary. You plan to retire in 44 years (you'll receive 44 years of salary). If the applicable discount rate is 5%, what is the present value of these future earnings today? Round to the nearest cent.

1) A 7% Commonwealth government bond has three years to maturity. Given that the bond pays coupons semi-annually (i.e. twice a year) and a coupon payment has just been made, what is the present value (price) of the bond if the market interest rate is 9% and the face value of the bond is $100,000?

2) You have observed the returns for an investment in Telstra shares for the last five years. This shows returns of 23%, -17%, 8%, 22% and 3%. Calculate the average return, variance, and standard deviation of these shares.

3) You own a portfolio that is invested as follows: $11,600 in shares of Rendezvous hotel, $7,800 in shares of Crown Plaza, $14,900 in shares of Carlton & United Breweries, and $3,200 in shares of Domino’s Pizza . What is the portfolio weight of shares of Carlton & United Breweries?

4) One year ago, you bought a share for $36.48. You received a dividend of $1.62 per share last month and sold the share today for $40.18. What is the capital gains yield on this investment?

Select a company of your choice, Aflac, and write a six to eight (6-8) page paper in which you:

1.Evaluate a company’s recent (with in the last year) actions dealing with risk and uncertainty.

2.Offer advice for improving risk management.

3.Examine an adverse selection problem your company is facing and recommend how it should minimize its negative impact on transactions.

4.Determine the ways your company is dealing with the moral hazard problem and suggest best practices used in the industry to deal with it.

5.Identify a principal-agent problem in your company and evaluate the tools it uses to align incentives and improve profitability.

6.Examine the organizational structure of your company and suggests ways it can be changed to improve the overall profitability.

7.Use at least five (5) quality academic resources in this assignment. Note: One of your references regarding your should have been published within the last 6 months. Note: Wikipedia does not qualify as an academic resource.

You are serving on a jury. A plaintiff is suing the city for injuries sustained after a freak street sweeper accident. In the trial, doctors testified that it will be five years before the plaintiff is able to return to work. The jury has already decided in favor of the plaintiff. You are the foreperson of the jury and propose that the jury give the plaintiff an award to cover the following: (a) The present value of two years’ back pay. The plaintiff’s annual salary for the last two years would have been $36,000 and $39,000, respectively. (b) The present value of five years’ future salary. You assume the salary will be $43,000 per year. (c) $100,000 for pain and suffering. (d) $15,000 for court costs. Assume that the salary payments are equal amounts paid at the end of each month. If the interest rate you choose is an EAR of 8 percent, what is the size of the settlement?