Salesforce Acquire Tableau Software Case Solution
Proceeding which, I have used the regression to find out the relationship between the Index prices and Salesforce share prices at the start of the month and at the end of the month. By using the F statistics; it has been found that there is a relationship between the days and the start and ending or combined prices of Index and Salesforce, because the F test value is higher than the Critical F value, which indicates that the statistical evidences have been collected to reject the null hypothesis, followed by the conclusion of the research hypothesis, which states that there is a relationship between the days and the start and ending or combined prices of Index and Salesforce.The values are shown in Exhibit 3 of the document.
Further, the pre-acquisition and post-acquisition share price data have been analyzed which indicate that there is a relationship between the stock prices of Salesforce and Index before and after the acquisition, and it is found out that the p value is higher than the significance level of 0.10, which indicates that the strong statistical evidences have not been found to reject the null hypothesis which states that there is no relationship between the stock prices of Salesforce and Index, before and after the acquisition.The values are shown in Exhibit 4 of the document.
In the end the dummy-variables have been used to check the relationship between the stock prices of Salesforce and Index during the existence of these dummy variables, through the help of which it is found that there is a relationship between the stock prices of Salesforce and Index before and after the acquisition, because the p value is near to zero, which provides a strong statistical strong evidence to reject the null hypothesis. The values are shown in Exhibit 5 of the document.
To conclude, there isn’t any significant impact of acquisition found to be affecting or influencing any changes in the stock prices of Salesforce and the Index, but a change might occur when the other variables will be active, which tends to make an impact over the Salesforce stock prices with the Index one.
Exhibit 1
Output Table 2: Difference Between Two Means and Variance | |||||
Mean | Variance | Sample Size | Ref Variance | ||
Highest Mean | 0.002717 | 0.000667 | 100 | N31 | |
Lowest Mean | -0.002331 | 0.000534 | 100 | N36 | |
t Statistic | 0.005047 | 1.456719 | |||
0.003465 | |||||
Degrees of Freedom | 0.000000 | 197.579355 | |||
0.000000 | |||||
Approx. | 198.000000 | ||||
One Tailed or Two Tailed Test | 1 | ||||
Confidence Interval | 95.00% | ||||
Critical t | 1.652586 | ||||
Fail to Reject the Null | |||||
Difference Between Two Variances - Calculated from Above Summary | |||||
Highest Variance | 0.000938 | ||||
Lowest Variance | 0.000138 | ||||
F Statistic | 6.781884 | ||||
Critical F | 1.394061 | ||||
Reject the Null |
Exhibit 2
Difference Between Two Means - Stock | Difference Between Two Means - Index | |||||||||
Sample | Mean | Variance | Sample | Sample | Mean | Variance | Sample | |||
Beg of Month | 0.000259 | 0.000403 | 326 | Beg of Month | 0.000371 | 0.000078 | 326 | |||
End of Month | 0.001274 | 0.000302 | 371 | End of Month | 0.000372 | 0.000067 | 371 | |||
t Statistic | (0.001015) | (0.708908) | t Statistic | (0.000001) | (0.001294) | |||||
0.001432 | 0.000647 | |||||||||
Degrees of Freedom | 695 | Degrees of Freedom | 695 | |||||||
Computed t Statistic | (0.708908) | Computed t Statistic | (0.001294) | |||||||
Critical t | 1.963383 | Critical t | 1.963383 |
..........................
This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.