Either copy & paste each answer from your data sheet, or round your answers to two decimal places where applicable.

Mean

Standard Error

Median

Mode  (report #N/A if no mode)

Standard Deviation

Sample Variance

Kurtosis

Skewness

Range

Minimum/smallest

Maximum/Largest

Sum

Count

Did you notice the mistake in the video while using the data analysis tool? The data range to B1:B100 was selected instead of B1:B101 so there were only 99 values for the Count when the data analysis tool ran. Be sure not to make the same mistake.

The Robinson Corporation has $44 million of bonds outstanding that were issued at a coupon rate of 12.650 percent seven years ago. Interest rates have fallen to 11.750 percent. Mr. Brooks, the Vice-President of Finance, does not expect rates to fall any further. The bonds have 17 years left to maturity, and Mr. Brooks would like to refund the bonds with a new issue of equal amount also having 17 years to maturity. The Robinson Corporation has a tax rate of 30 percent. The underwriting cost on the old issue was 4.40 percent of the total bond value. The underwriting cost on the new issue will be 2.70 percent of the total bond value. The original bond indenture contained a five-year protection against a call, with a call premium of 6 percent starting in the sixth year and scheduled to decline by one-half percent each year thereafter. (Consider the bond to be seven years old for purposes of computing the premium.) Use Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. Assume the discount rate is equal to the aftertax cost of new debt rounded up to the nearest whole percent (e.g. 4.06 percent should be rounded up to 5 percent)

a. Compute the % discount rate.

b. Calculate the present value of total outflows.

c. Calculate the present value of total inflows.

d. Calculate the net present value.

The data below are the heights of fathers and sons (inches). There are 8 rows in total.

Father Son

1. Which statistical test would you use to determine if there is a tendency for tall fathers to have tall sons and short fathers to have short sons? Test for the statistical significance.

2. Compute the regression equation for predicting sons' heights from fathers' heights.

3. Use the equation from #2 to predict the height of a son whose father is 46 inches tall.

4. Should you use the regression equation to predict the hight of a son whose father had a height of 25" when he was the same age as his son?

5. Which statistical test would you use to determine if generations get taller. The question is, are sons taller than their fathers were at the same age?

We are interested in exploring the relationship between the weight of a vehicle and its fuel efficiency (gasoline mileage). The data in the table show the weights, in pounds, and fuel efficiency, measured in miles per gallon, for a sample of 12 vehicles.

• Part (b)

  r = -0.71 (correlation coefficient).
  Yes, it is significant
• Part (c) Find the equation of the best fit line. (Round your answers to four decimal places.)       ŷ = ________x + _______

Part (e)

What percent of the variation in fuel efficiency is explained by the variation in the weight of the vehicles, using the regression line? (Round your answer to the nearest whole number.)
%

Part (g)

For the vehicle that weighs 3000 pounds, find the residual

(y − ŷ).

(Round your answer to two decimal places.)


Does the value predicted by the line underestimate or overestimate the observed data value?

underestimate or overestimate    

Part (i)

The outlier is a hybrid car that runs on gasoline and electric technology, but all other vehicles in the sample have engines that use gasoline only. Explain why it would be appropriate to remove the outlier from the data in this situation.

The outlier lies directly on the line, so the error residual (y − ŷ) is zero. The outlier represents a different population of vehicles compared to the rest.     The outlier is creating a curved least squares regression line. The outlier does not lie directly on the line, but it is close.

Remove the outlier from the sample data. Find the new correlation coefficient and coefficient of determination. (Round your answers to two decimal places.)

Find the new best fit line. (Round your answers to four decimal places.)
ŷ = __  x + __

Apple Corporation is structured into three divisions: Austin, Brown and Caden. Each division operates as a separate stand-alone business, and is designated as an investment centre. The company uses return on investment (ROI) to evaluate the performance of each division. For the purpose of calculating divisional ROI, invested capital is defined as total assets (net book value) less current liabilities, and divisional operating profits after tax are used. Each division is required to achieve an ROI of at least 9%. The following data relates to the financial performance of the divisions for the year of 2019: Austin Brown Caden Operating Profits $1,000 $900 $1,200 Total Assets (NBV) 18,000 4,000 36,000 Current Liabilities 8,000 1,000 11,000 ROI 10% 30% 4.8% Both Austin and Brown mainly operate education centers with focus on conducting computer and IT courses. Major assets of Austin Division include computer equipment, popular software and furniture and fixtures. All these assets have been used since the business was set up in 2016. No additional purchase of new assets was made. Although Brown operates in a similar business, it has different operational philosophy. Brown leases its computer equipment and software in order to have the most updated IT facilities for their customers. Therefore, the lease (rental) expenses account for a high percentage of its total operating expenses. Caden runs two restaurants which were newly set in 2019. The target customers are the highclass clusters. Therefore, high amount was spent on decent and splendid furniture and decoration. Based on the ROI calculation, the management would rank Brown as the top performer while Caden is required to put significant effort to improve its performance.

REQUIRED: ( At least 100 words)

Suggest TWO points in the case that needs to be taken into account when interpreting divisional performance by using ROI.

Grant Corporation (C Corp) has two shareholders:  Hugh (owns 50%) and Bullocks Corporation (50%).  Grant Corporation makes $75,000 cash distribution to each shareholder on December 31, 2019.   Hugh is an individual but Bullocks Corporation is a C Corporation.  Hugh’s stock basis is $20,000 and Bullocks’ stock basis is $40,000.  What are the tax consequences to Hugh and Bullocks on the distributions for each of the separate situations?

a.  Current E&P is positive $40,000 and Accumulated E&P is negative $15,000.

b.  Current E&P is negative $17,000 and Accumulated E&P is positive $27,000

1. Compare and contrast four socioemotional theories of aging.

2. Describe some of the personality changes of late adulthood.

Define ageism, and provide two original examples of ageism.

Imagine that you are an older adult. Indicate and explain the policy issues of concern to you.

Indicate the role of attachment in later adulthood.

Explain what an elderly, ethnic woman can expect to experience during late adulthood.

If you were an older adult, what could you expect to happen to aspects of your social relations such as relationships with adult children and friendship?

8. Evaluate your own culture’s regard for the elderly in terms of the seven factors most likely to predict high status for the elderly.

Explain how the selective optimization with compensation model could help you age successfully.

The expansion of the Istanbul International Airport has drawn media attention for its revolutionised baggage service which shortened the time a passenger needed to collect his or her baggage. To gauge the performance of its newly-installed baggage carousel, the department of aviation services has collected a random dataset on the number of bags per minute handled by Baggage Carousel A and Baggage Carousel B. These are two different carousels. You would like to summarise the dataset, compare the two carousels and reportto the department of aviation services. Your answers should address the following:

1. Choose appropriate graphs to visualise the dataset and provide relevant descriptive statistics and a brief commentary.

2. Compute the average time a passenger needs to wait to see the next piece of baggage. State the assumption you need to make this computation. Hint: what is the assumption behind modelling inter-arrival waiting time as an exponentially distributed variable?

3. Based on your assumptions for both carousels, compute (a) the probability that in one minute there are less than 7 bags and (b) the probability that in one minute there are less than 10 bags. Compare your computed results to what you observe from the data.

4. Explain why you do or do not think your assumption is valid for this dataset.

John Decides to make 10 end-of year deposits of $10,000 into a fund starting one year from now. He is planning to withdraw $20,000 each year for 5 years, starting one year after the last deposit. The fund pays 8% per year compounded annually. Determine the balance in the fund immediately after the last withdrawal.

street performer offers you a chance to play his game for the low price of $10.

His game involves you pushing two different buttons. One of the buttons, when pushed, has a 10% chance of winning you $40;

and the oth er button, when pushed, has a 20% chance of winning you $25. You are allowed two button presses( e ither pushing the same button twice or pushing each button once) in a single game.

Is it worth playing?