DATA ANALYTICS EXAM Harvard Case Solution & Analysis

DATA ANALYTICS EXAM Case Solution

Question 1

1. The expected profits for the medium and large scale products are calculated as 145 (in thousands) and 140 respectively. In order to meet the objectives for maximizing profits, the Apple Incorporation should choose the medium scale expansion projects, which are providing higher expected profit than the large scale expansion projects.
2. The variances for both the investment are shown below along with the standard deviation, as shown below. The variance of medium scale projects is lower than the variance for the large scale projects. Similarly, the medium scale projects have the standard deviation of 36.91 while the standard deviation for large scale projects is 78.74%. So, with the objective of minimizing risks, the company should chooses medium scale projects with low variance and standard deviation.

Question 2 (a)

Mean = μ = 50 hours

Standard Deviation = σ = 15 hours

Finding probability that the length of time will be 50 to 70 hours i.e. 50 < X < 70

As we know,

Z = (x – μ) / σ

For x = 50

Z = (50 – 50) / 15 = 0

For x = 70

Z = (70 - 50) / 15 = 1.33

In standard format, 0 < Z < 1.33, and by using the Z-table the probability that the length time will be between 50 to 70 hours is equal to 0.4082.

 Question 3: A

Question 3: B

The Pearson Moment Product Correlation is 0.97 showing strong relationship between Revenue and Mobile advertising.

Question 3: C

Question 3: D

Question 4

Regression equation

Bank Performance = 639.146 + 56.99987*(Director Shareholding) – 0.010504*(Female Directors) +3.754429*(Independent Directors) –9.502082*(Board Size) + 223.0755*(Bank Size)

Constant – C = 639.146

The constant explains that the bank performance would be 639.146, if the value for all of independent variables would be zero.

Slope Coefficients

The slope coefficient for the independent variable “Director Shareholding” is 56.99987. It explains that there exists a positive relationship with the director shareholding and the bank performance. If the director shareholding increases by 1 unit the bank performance will increase by 56.99987 units.

The slope coefficient for the independent variable “Female Directors” is– 0.010504. It explains that there exists a negative relationship between the female directors and the bank performance. If the female directors increase by 1 unit the bank performance will decrease by 0.010504 units.

The slope coefficient for the independent variable “Independent Directors” is 3.754429. It explains that there exists a positive relationship between the independent directors and the bank performance. If the independent directors increase by 1 unit the bank performance will increase by 3.754429 units.

The slope coefficient for the independent variable “Board Size” is– 9.502082. It explains that there exists a negative relationship between the board size and the bank performance. If the board size increase by 1 unit the bank performance will decrease by 9.502082 units.

The slope coefficient for the independent variable “Board Size” is 223.0755. It explains that there exists a positive relationship between the bank size and the bank performance. If the bank size increase by 1 unit the bank performance will increase by 223.0755 units.

Statistical Significance of Variables – Using T-statistics

In terms of t-tests at 5% significance level, the t-value must be greater than critical value 0f +1.96 or less than -1.96. According to this standard, all of the variables are statistically significant except the female directors and the board size. It means that the director shareholding, independent directors and the bank size has a statistically significant impact on the banks’ performance, as their t-values are greater than the critical value of +1.96 at 95% confidence level..........................

This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.

Related Case Solutions & Analyses:

Nucor at a Crossroads American Home Products Corp. The NFLs Digital Media Strategy Supplement to MedCath Corporation (A) and MedCath Corporation (B) eBay Inc.: Stock Option Plans (B) Building a Sustainable Profitable Business: Fair Trade Coffee (B) Family Feud: Andersen vs. Andersen (A) Introduction to Patents and Trade Secrets Turning an Elephant into a Cheetah: The Turnaround of Indian Railways Four Seasons Goes to Paris