Statistical Analysis

Statistical Analysis

There are many ways for a manger to conduct analysis based on an organization 's data resources . Primarily , these types of analyses can provide some more insights on how a particular company can establish improvements on work processes decide on significant investment matters and delegate an illustrative picture on how the business performs . In this aspect , the use of Microsoft 's Excel program can make it easier for managers to interpret and analyze data values

One valuable contribution that MS Excel can provide to a manager 's data analysis

is the process of numerical tabulation . Primarily , Excel was built in a way in which code value numbers can be tabulated so that they can reflect a particular part of the whole data context . In this case , it would be much easier for the user to perform analyses on these figures . Upon tabulation , the manager can set up the parameters of rows and columns so that he can easily define what the numbers actually represent . Moreover , Excel provides the flexibility of importing and organizing data coming from large scale numerical sets (Microsoft Corp 2008 , making it truly indispensable for the company managers

By the time the values were tabulated , the manager can then use the analysis tool pack of Excel for different statistical analyses . One very powerful tool of Excel is to provide the user with the descriptive analysis . The user can simply highlight the data values and click on the user interface named Function . This will then generate statistical descriptive of Mean , Median , Mode , Standard Deviation and Variance . All of these statistical values are relatively important in any types of procedures concerning the behavior of data which will then give the manager a good glimpse of the actual company performance

In another way , the manager can also interpret data by using Excel 's function tools in high level Statistical analysis like the t-test , z-test and correlation . These tests will give the user an opportunity to test some forms of data relationships within the set of numerical parameters and aid in the decision making of the manger when it comes to hiring , profit generation and investment allocation

The ethical issues which could rise in setting gender , age position , department and other relative factors in the hiring process could only be reflected on the types of losses or gains which can be attributed in such form of decision making . The main ethical consideration when it comes to gender and age factor cannot be realized until there is a significant loss in the productivity of the company . Of course , using a survey method can actually present the availability of employee pros based on these criterions . However , the company will not be able to predict whether such factors can actually affect productivity . For the aspect of hiring procedures based solely on general employee satisfaction , the main ethical concern is that the company may not be exposed to dilemmas set forth by sustaining the satisfaction attribute for employees . The business may have a...