Posts

Strategic Rationale for Bayer’s Acquisition of Monsanto

The Bayer’s acquisition of Monsanto was an offensive transaction that transformed to a worst corporate deal in Berlin. The acquisition of $63 billion was a significant shortcoming experienced in the gambit ranks. The struggle to take total control of Monsanto Co. has exposed the company into operation setback in future. The aim of Bayer was to transform Monsanto into a hub of invention in crop-science business an effort that did not materialize. After Monsanto acquisition in 2018, a case was filed in the court of law alleging that the crop-science business was associated with cancer and Bayer lost the lawsuit. After Bayer lost, the he was made to pay damage fees amounting to $190 million. In due time more plaintiffs totaling to 18,400 were filed against Bayer in acquisition of Montano. Bayer responded by filing appeals against the petitioners but Monsanto shares kept losing their value at rate of 30% dated from the closure of the deal. The drastic drop in the value of Monsanto share...
Post a Comment
Read more

Data Cleaning Using MS Excel

Image
Last time we discussed briefly about data collection methods. Once we have collected the data, we need to edit it with the aim of making it clean for the next step of analysis. We shall assume that after collection, our data was entered into MS Excel. Editing is the process of examining or scrutinizing data in order to identify any errors, mistakes or omissions. Under this process, we focus on the completeness of data (no missing values), distribution of the data and extreme or outliers in the data. Some of the errors that that we may have to deal with under this process are sampling errors, Non-sampling errors, biased errors, non-biased errors, and positive or negative errors. Sampling errors occur due to the type of sampling method used during the collection of data. Sampling errors mean the difference between the estimate of a value as obtained from the sample and the actual value. Non-sampling errors take place if randomization was not used during sample selection. Biased errors...
Post a Comment
Read more

Data Collection

As we had said in our earlier discussion, there are different methods that can be used to obtain data. These methods ensure reliability and adequacy of the data. The method used will depend on the degree of accuracy desired, nature of the study, objectives and scope of the study. Sources of Data We have two main sources of data; primary data and secondary data. Primary data is the data which is collected for the first time either directly or indirectly. It is usually authentic and raw. Secondary data is which is obtained from other individuals for a specific objective. It is not collected by the researcher. Secondary data, in most cases, might have gone through statistical operations in order to achieve the objectives for which it was first collected. There are four methods which we can use to obtain secondary data; Sampling, Observations, Questionnaires and Interviews. We shall discuss these methods in our subsequent discussions. Sources of secondary data are; 1. Journals an...
1 comment
Read more

Microsoft Excel for Data Analysis

Image
For the purpose of this tutorial, we shall use Excel 2013 and 2010. However, most formulas and methods discussed can be applicable to Excel 2007. Many people outside the field of data analysis understand the power of MS Excel in data analysis. Perhaps this is because they are little aware of the many statistical programs we have for the purpose of data analysis. However, those in the field of statistics tend to forget or ignore the power of excel in data cleaning, manipulation and even analysis and visualization. One of the advantages of using Excel is that it is easy to use. Its functions are easy to apply and you don’t need to memorize all of them. Now, let’s walk together step by step and I will show you however we can enter raw data into excel, clean it, perform some basic statistical procedures and visualize our data using charts and graphs. NOTE: For some later part of this series of tutorials, you must have Analysis ToolPak. The Analysis ToolPak is an Excel add-in program t...
Post a Comment
Read more

What is Statistics?

Statistics is a science that studies statistical methods. Statistical methods are scientific techniques that are used to plan and execute data collection, analysis, presentation and interpretation. Croxton and Cowden in their view, Statistics is a science of collection, presentation, analysis and interpretation of numerical data. Statistics should not be confused with a statistic. A statistic is a characteristic of a sample. It is used to estimate a value of population parameter. Statistics as a subject is divided into: 1. Statistical methods 2. Applied statistics Statistical methods are techniques and procedures by which numerical data are treated in order to gain insight from them. These methods as suggested by the definition of statistics are: 1. Data collection 2. Data organization 3. Data presentation 4. Data analysis 5. Data interpretation Data Collection Data collection is the process of obtaining data for the purposes of statistical...
Post a Comment
Read more