Premium Essay

Data Analysis for Managers

In:

Submitted By ksenialu
Words 17186
Pages 69
DATA ANALYSIS for MANAGERS

MScBA
Instituto Universitário de Lisboa (ISCTE-IUL)

JOSÉ DIAS CURTO dias.curto@iscte.pt 2015/2016

i

Contents

Contents
1

Math introductory concepts

1

1.1

The real numbers system . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1

1.2

The concept of sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

2

1.3

Relations and functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

3

1.3.1

Linear function

3

1.3.2

Exponential function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

4

1.3.3

Logarithmic function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

5

1.3.4

Functions of two or more independent variables

5

1.3.5

The concepts of derivative and elasticity

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . .

5

Matrices and vectors

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

6

1.5

Descriptive statistics

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

6

1.6

How to prepare a le for statistical analysis

. . . . . . . . . . . . . . . . . . . . . .

7

1.7

Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

9

1.7.1

Investment Bank 1

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

9

1.7.2

Investment Bank 2

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

9

1.7.3

Derivative and Elasticity . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

9

1.7.4

Operations involving matrices . . . . . . . . . . . . . . . . . . . . . . . . . .

1.7.5

2

. . . . . . . . . . . . . . . . . . . .

1.4

Descriptive

Similar Documents

Premium Essay

Significance and Advantages of Regression Analysis

...Significance of Regression Analysis In statistics, regression analysis includes many techniques for modeling and analyzing several variables, when the focus is on the relationship between a dependent variable and one or more independent variables. More specifically, regression analysis helps one understand how the typical value of the dependent variable changes when any one of the independent variables is varied, while the other independent variables are held fixed. Most commonly, regression analysis estimates the conditional expectation of the dependent variable given the independent variables — that is, the average value of the dependent variable when the independent variables are held fixed. Less commonly, the focus is on a quantile, or other location parameter of the conditional distribution of the dependent variable given the independent variables. In all cases, the estimation target is a function of the independent variables called the regression function. In regression analysis, it is also of interest to characterize the variation of the dependent variable around the regression function, which can be described by a probability distribution. Regression analysis is widely used for prediction and forecasting, where its use has substantial overlap with the field of machine learning. Regression analysis is also used to understand which among the independent variables are related to the dependent variable, and to explore the forms of these relationships. In restricted circumstances...

Words: 784 - Pages: 4

Free Essay

Sr-Rm-022 Hr System Analysis

...SR-rm-022 HR System Analysis XXXX BSA/375 January 14, 2013 XXXXX SR-rm-022 HR System Analysis The SR-rm-022 service request calls for developing a new application for Riordan Manufacturing’s human resources department. According to the Apollo Group Inc. simulation (2011), Riordan Manufacturing wishes to, “Integrate existing variety of HR tools into a single integrated application. We would like to take advantage of a more sophisticated, state-of-the art, information systems technology in our Human Resources department.” In this paper I will address the key factors to analyze the HR system tools such as; Riordan key stakeholders, Joint Application Development, Use Cases, Process Models, Data Models, successful information gathering, and project scope. Riordan HRIS According to the Apollo Group Inc. simulation (2011), on the employee site under HRIS, the company’s HRIS was developed in 1992 and is a part of the financial systems package. It keeps track of the employees’ personal information, pay rate, personal exemptions for tax purposes, hire rate, seniority date, organizational information, and vacation hours. Changes to this information are submitted via special forms by the employee’s manager and entered into the system by the payroll clerk. Training and development records are kept in an Excel worksheet by a training and development specialist. Recruiters maintain applicant information for open positions, résumés are filed in a central storage area, and an Excel...

Words: 1696 - Pages: 7

Premium Essay

Is 315

...Information Technology Move System IS315 Systems Analysis and Design By Joe Instructor: Any Date Abstract Table of Content Information Systems Inventory Service (ISIS) ……… Week 2………....……. 1 Needs Analysis ……………………………………………………. Week 3 ……….……… 2 Feasibility Analysis …………………………………………..…. Week 4 …….. ………. 4 Data Flow Analysis …………………………………………..…. Week 5 ……….…….. 7 Decomposition Diagram ……………………………………… Week 6 …………….. 10 Financial Analysis ………………………………………………… Week 7 …………..… 11 References …………………………………………………………. Week 8 ……………… 15 Abstract The Information Technology Move System (ITMS) is designed to coordinate the movement of IT infrastructure, to include equipment from one location to another while maintaining connectivity for both the business and customer, and to remove downtime. In doing this it will reduce costs to both the business and customer. IS 315 – Week 2 * System name – Information Technology Move System * The system is designed to take all aspects of moving an organizations information technology from one location to another. * The items it will track and monitor are: * Amount of systems * Build up of new location * Termination of old location * Maintaining connectivity at both locations during the move of individuals * Type of system – This system will have the capability to coordinate the move of IT equipment from one location to a new location while maintaining connectivity...

Words: 2654 - Pages: 11

Premium Essay

Business Intelligence

... | |1.1 Problem definition and background to the problem |2 | |1.2 Scope and limitations of the report |2 | |1.3 The research question |3 | |1.4 A description of the rest of the report |3 | |1.5 Methodology |3 | |2. Findings derived from the Data Analysis | |2.1 Results pertaining to the employer |4 | |2.2 Results pertaining to the employee |12 | |3. Limitations And Conclusions |18 |...

Words: 3192 - Pages: 13

Premium Essay

The Research Process

...Chapter 04The Research Process CHAPTER LEARNING OBJECTIVES AFTER READING THIS CHAPTER, STUDENTS SHOULD UNDERSTAND… 1. Research is decision and dilemma centered. 2. The clarified research question is the result of careful exploration and analysis, and sets the direction for the research project. 3. How budgeting and value assessments influence the process for proposing research and, ultimately, research design. 4. What is included in research design, data collection, data analysis, and reporting. 5. Research process problems to solve. CHAPTER Lecture Notes THE RESEARCH PROCESS Stage 1: Clarifying the Research Question • The management-research question hierarchy process of sequential question formulation leads a manager or researcher from management dilemma to investigative questions. • The process begins with the management dilemma—the problem or opportunity that requires a business decision. • The management dilemma is usually a symptom of an actual problem, such as: □ Rising costs. □ The discovery of an expensive chemical compound that would increase the efficacy of a drug. □ Increasing tenant move-outs from an apartment complex. □ Declining sales. □ A larger number of product defects during the manufacture of an automobile. □ An increasing number of letters and phone complaints about postpurchase service • The management dilemma can also be triggered...

Words: 2274 - Pages: 10

Premium Essay

New Products Chapter 1

...MARKETING PLANNING – CHAPTER 2 Developing a marketing plan is a key responsibility. The marketing plan can be divided into two general parts: the situation analysis, which analyzes the background of the market for the product, and the objectives, strategy and programs based on the background analysis that direct the product manager’s actions. MARKETING PLAN A marketing plan is a written document containing the guidelines for the business center’s marketing programs and allocations over the planning period. Give life to a marketing plan = business plan (CEO) Marketing plan= Chief Marketing Officer. One-year time framework (mostly). Short states and implements. At the end, check and asses. Kotler (NOT MORE than 15 pages). Straight to the topic, NOT wide. What you need and how to get there. * Written document: not something stored in a product manager’s head. It provides a vehicle for communications between functional areas of the firm. It pinpoints responsibility for achieving results by a specified date. * Business center level: the precise level at which plans are written varies from organization to organization. For example, in a company using a band management organizational structure, a marketing plan is written for each brand that is a profit center. Alternatively, some companies write plans for groups of brands or products, particularly when fixed costs are difficult to allocate by individual product. While marketing planning is common, it occurs at different...

Words: 2172 - Pages: 9

Premium Essay

Accounting Information for Managers to Make Better Decisions

...Accounting Information for Managers To Make Better Decisions 1 Abstract This paper analysis how the accounting information would support the decision making process. The main goal of an accounting system is to provide financial information about the organization including financial situation and the performance of the organization. The decision makers should know the situation of the organization either by comparing competitors or previous periods’ performance in order to achieve the objectives of the company and this being possible by using accounting information. In addition, this thesis studies the importance of having effective and efficient accounting system to make better decision as it relates to increase the profitability target of an organization. Organizations should replace their weak accounting system in order to ensure that each team member in the Accounts Department is conscious of their role to produce good accounting information (1, Okoli Margaret). The result of this paper describes that providing right information to the right people in time via management reporting to maximize the use of reports in decision-making. 2 Introduction Any organization should survive and excel in the fast paced and ever changing market. We are living in the digital era so information can be found everywhere via websites, databases documents, reports, and emails. However, it’s important to read the historical data-set during decision making process but providing report in quick...

Words: 2005 - Pages: 9

Premium Essay

Management Information System

...planning and control at all levels. It complements the ultimate integration of required business information sub system both financial with in the company. According to Philip kolter- A marketing information system consist of people, equipment and procedures together,sort,analyse,evaluate and distribute the needed timely and accurate information and marketing decision makers. Professor Allen S. Lee states that research in the information system field examines more than the technological system,or just the social system or even the two side by side in addition it investigates the phenomena that emerge when the two interact. An information system can be any organized combination of people, hardware, software, communication network and data resources that collects, transforms and disseminates information in an organization. Purpose of Management Information System...

Words: 3129 - Pages: 13

Premium Essay

Recruitment Process

...selection process Vacancy arise  Job analysis  Job description  Person specification Job advertisement  Application form, scanning and shortlisting  Interviews, testing and selecting  Vacancy filled 1.1. Vacancy arises Firstly, the company needs to be aware of what position is lacking employee and how many people do they need. They also need to know what kind of skills and tasks that the future employee(s) need to do. This leads to the next stage: Job analysis. 1.2. Job analysis Job analysis is a “detailed examination of the tasks (performance elements) that make up a job (employee role)” (BusinessDictionary.com, n.d.) It shows what the employees are expected to do. The job analysis itself has the following: job description, person specification. Below is an example of a job analysis: Job Analysis Information Sheet Job title: Assistant Administration Manager Date: 23/10/14 Job Code: 002WN1 Dept.: Administration Superior’s Title: Administration Manager Hours worked: 7:30 AM to 5 PM Job Analyst’s Name: Shelly 1. Job purpose Assist the manager provide support for the performance of administrative functions and duties. Maintain and organize records (e.g. department records, budget data…) 2. Job duties Provide secretarial services to the administration manager and the administrators as requested; maintain calendars; arrange the room for events and meetings; carry out research; collect data and prepare the necessary reports; schedule...

Words: 1445 - Pages: 6

Premium Essay

Shroders

...division. As a graduate trainee within Investment you will be required to assist Fund Managers with research into particular investment strategies, providing analysis of the drivers of future returns and an understanding of the risks associated with them. The two­year programme will provide you comprehensive training and support together with the practical and theoretical experience to prepare you for an agile and global career within investment. As part of your training you will gain experience in some of the following areas: Equities Equities is Schroders’ largest asset class and we manage over £134.4bn* in equity assets. As part of a rotation within Equities you will be required to assist Fund Managers with researching companies within a variety of sectors and countries creating proprietary financial models and research notes. Prior to recommending a stock, you will be expected to generate independent forecasts on the key drivers of the business and present your research to the team. Your analysis and recommendations will be subject to rigorous scrutiny by senior investment professionals therefore you will enjoy early responsibility and will be rewarded by knowing you have played a key part of the investment decision making process. Data Consultants are responsible for delivering insights to our internal customers, the Investors. These will take the form of ad­hoc analysis reports and presentations, the creation of prototype tools and dashboards using tools like Tableau...

Words: 778 - Pages: 4

Free Essay

Treasury

...Charlotte Quiniou, CFA, Director in Fitch Ratings Fund and Asset Manager Rating Group Fitch money market fund (MMF) rating is far more than just a stamp on a fund. Its value for investors comes from the depth and breadth of the underpinning rating analysis and process. A key component of a Fitch MMF rating is also the regular, independent surveillance performed by Fitch’s analysts, which supports ongoing dialogue with fund managers, so that systematic mechanical reactions are avoided. To better serve investors, Fitch provides information on rated MMFs and developments in the money market industry, notably based on MMF surveillance information, through freely available periodic publications and online tools. A Disciplined procedures ensure consistency Fitch conducts analysis and assigns ratings on MMFs following a consistent, disciplined process that is applied globally. The diagram in Figure 1 provides a summary view of the major steps followed by Fitch when assigning or reviewing a MMF rating. At the start of the rating process, each MMF is assigned to a group of two analysts: the primary (or lead) analyst, and the secondary (or back-up) analyst. Analysts are responsible for leading the analysis and formulating a rating recommendation. The primary analyst is typically responsible for the continuous surveillance of the rating, once it has been assigned, and maintaining the dialogue with the fund manager on analytically-related topics. The secondary analyst is back-up...

Words: 2130 - Pages: 9

Free Essay

Brm Research Methods

...1 Management Commitment 4 2.4.2 Training and Development 4 2.4.3 Respect and Recognition 4 2.4.4 Role of pay 5 2.4.5 Proposed Replica to Motivate Workers in McDonald 6 Introduction 7 3.1 Qualitative & Quantitative Research Methods 7 3.2 Final selection for the project 7 2.3 Primary data or secondary data 8 2.4 Research Tools 8 2.5 Population Sample 8 2.6 Sampling technique 8 2.7 Advantages of qualitative research methods 9 2.8 interviews 9 2.8.1 Advantages and disadvantages of face to face interviews. 9 Literature Review 2.1 Motivation By Anne (2010) motivation basically came from a Latin-word-mover whose basic meanings indicate movement, in simple way using efficient approach/way for reaching final targets. According to Edwards (2007) nowadays in organizations motivation is treated like catalyst for getting competitive edge over rivals. By Jaffery (2009) a strong relationship exists between motivation and job performance. In view of Halverson (2005) motivation acts like oxygen for organizations and it is of huge importance especially in such business (services) where workers have direct link with consumers as in food business. It is a million dollar advice for managers in fats food companies that they must focus on identifying indicators which definitely stimulate workers for performing their jobs in an efficient manner. Fast food business has become very competitive nowadays almost all over the world. 2.2 Maslow’s Hierarchy of Needs Maslow’s theory of motivations...

Words: 2619 - Pages: 11

Premium Essay

Internet Field Trip

...What is Forecasting? Forecasting is the process of making statements about events whose actual outcomes have not yet been observed. Forecasting can be seen as a planning tool for managers to attempt to cope with the uncertainty of the future. Managers are constantly trying to predict the future, making decisions in the present that will ensure the continued success of their firms. Managers use forecasts for budgeting purposes. A forecast aids in determining volume of production, inventory needs, labor hours required, cash requirements, and financing needs. A variety of forecasting methods are available. However, consideration has to be given to cost, preparation time, accuracy, and time period. The manager must understand clearly the assumptions on which a particular forecast method is based to obtain maximum benefit. 1 Types of Forecasts Short Term Short-range forecasts typically encompass the immediate future and concern the day to day operations of a firm. A short-term forecast usually only covers a period of a few months and can be considered an “operating” forecast. Medium Term Medium-range forecasts typically span a few months up to a year. A forecast of this length can be considered “tactical” in nature. Long Term Long-range forecasts typically encompass a period longer than 1 to 2 years. These forecasts are considered strategic and are generally related to management’s attempt to plan new products or build new facilities. 2 Forecasting Methods Time Series ...

Words: 630 - Pages: 3

Premium Essay

Forecasting -

...What is Forecasting? Forecasting is the process of making statements about events whose actual outcomes have not yet been observed. Forecasting can be seen as a planning tool for managers to attempt to cope with the uncertainty of the future. Managers are constantly trying to predict the future, making decisions in the present that will ensure the continued success of their firms. Managers use forecasts for budgeting purposes. A forecast aids in determining volume of production, inventory needs, labor hours required, cash requirements, and financing needs. A variety of forecasting methods are available. However, consideration has to be given to cost, preparation time, accuracy, and time period. The manager must understand clearly the assumptions on which a particular forecast method is based to obtain maximum benefit. 1 Types of Forecasts Short Term Short-range forecasts typically encompass the immediate future and concern the day to day operations of a firm. A short-term forecast usually only covers a period of a few months and can be considered an “operating” forecast. Medium Term Medium-range forecasts typically span a few months up to a year. A forecast of this length can be considered “tactical” in nature. Long Term Long-range forecasts typically encompass a period longer than 1 to 2 years. These forecasts are considered strategic and are generally related to management’s attempt to plan new products or build new facilities. 2 Forecasting Methods Time Series ...

Words: 630 - Pages: 3

Premium Essay

Fasttrack Module #5

...unit)? -it performs calculations, makes comparisons, and controls the way data moves through the computer. -The CPU executes program instructions -The electronic circuitry of the CPU reads and interprets software instructions and processes data 2. Why is it important to know how much RAM a computer has? -It is important because software packages require a minimum amount; if the computer doesn’t have enough RAM, it won’t be able to use that particular software package. 3. What is the primary purpose of an Operating System? -It is to maximize the productivity of a computer system by operating in the most efficient manner. It reduces the amount of human intervention required during processing. 4. Which is the most important software component for many users today? - The Web-Browser/Internet 5. What is a Database? - A Database is a collection of integrated data files that give different people access to it for different purposes. 6. Why is Data considered a vital resource? - Most organizations couldn’t survive or succeed without quality data about their internal operations and external environment. 7. What is a Data Warehouse? - It is an integrated decision support database whose content derives from the various operational and analytical databases. It is historical and centralized source of data that has been standardized and integrated, used by managers and other professional users. 8. What are the 3 Network topologies? -Star...

Words: 2284 - Pages: 10