Mba Analysis

1853 words - 8 pages

USING EXCEL TO FIND MEASURES OF ASSOCIATION
by Edward F. Stafford, Jr., PhD
Professor of Management Science, UAH

Purpose of Handout
The purpose of this handout is to describe how to obtain measures of association between two variables using the Microsoft Excel software. These measures include covariance and correlation. For the most part, each measure may be obtained in two ways: (1) “by hand”; and (2) by Excel’s fX function operator. “By hand” does not mean to actually do the computations by hand; rather, it means to use Excel for statistical computations as though the fX function operator did not exist.

Example Problem
An example problem is used to demonstrate all of the features ...view middle of the document...

Stafford

06/08/01

Page 1

There are three variables in the sample data. We will compute each measure of variability six times (3 variables)x(2 ways of computing). The measures will be posted to a Solutions Table as shown in Figure 2. This template is included in the Excel spreadsheet described above.

Figure 2. Template for Results of Calculations, Measures of Association Sorting the Data
DO NOT SORT THIS DATA. Sorting data before computing measures of association causes X-Y pairs of observations to be separated, thus invalidating the values obtained.

Preliminary Activities
There is space below the original data for computing the Sum (Totals), Count, Mean, and Standard Deviation (Std Dev) for each of the three variables. Previous handouts and assignments have explained how to do this. Use the 3 icon and the fX icon to accomplish these computations. Dragging can speed up this process. The results are shown in Figure 3.

Figure 3. Summary Statistics on Original Data
Next, copy the original data into the proper columns of “Work Space for Hand Computations” table on the spreadsheet. We will be using these data to compute various measures necessary to compute the covariance and correlation values. Now that we know how to clean up unwanted lines {see “Using Excel to Find Measures of Variability”}, clean up the unwanted lines just as soon as they appear on your spread sheet. Also, remember to save often.

Preparing to Compute Association Measures by Hand
The computational formula for the sample covariance, sXY, between two variables X and Y, is as follows:

s XY

 n  n   ∑ X i   ∑Yi    n  i =1   i =1   ∑ X iYi −  n = i =1 n−1
Dr. Stafford 06/08/01 Page 2

MSC 287 Handout

USING EXCEL TO FIND MEASURES OF ASSOCIATION

And the computational formula for the sample correlation, rXY, between two variables X and Y, takes on one of two forms as shown in the following:

rXY =

s XY = (s X )( sY )

 n   n  ∑ X i   ∑Yi  n    ∑ X iYi − i =1 n i =1 i =1   n  ∑X i  n   ∑ X i2 − i =1 n i =1
2

 n   ∑Yi  n   2 ∑Yi − i =1n i =1

2

where sX and sY are the standard deviations of the X- and Y-variables. Thus we need to compute 3X, 3Y, 3X2, 3Y2, and 3XY for each pair of variables for which we want to measure covariance and correlation. The “Work Space for Hand Computations” is now set up to accomplish the computation of all required summation values. Start by placing the cursor in cell I10, the first value for Work2, then place the cursor in the equation box and type “=H10^2". Press Enter and the value 7056 {84 x 84} appears in this cell. Drag cell I10 down the length of the column, but not beyond the table end line. Repeat this process for cell K10 {type “=J10^2" in the equation box} and cell M10 {type “=L10^2" in the equation box} , then drag these columns to complete the computations of the squares of the three variables. Now would be a good time to clean up your unwanted lines....

Other Papers Like Mba Analysis

Value of an Mba Essay

1741 words - 7 pages Abstract The purpose of this paper is to construct and support an argument on a decision I made to pursue an MBA degree to gain both knowledge and insight into complex business problems and solutions. The argument will be based on a “What’s My Jungian 16-Type Personality?” test and a general benefits analysis of postgraduate MBA education. The paper will evaluate my personal score from the test as an ENTP result, which describes individuals who

Reason for Mba Essay

2124 words - 9 pages 1. It gives you credibility with your business peers. Having an MBA demonstrates your commitment to the business because you've invested the substantial time and energy required to obtain the degree. It shows that you value the business perspective and recognize that the technology you implement, support and develop is intended to enable business activities and is not an end in itself. An MBA also indicates that you've mastered a certain level

The Mba Decision

2513 words - 11 pages THE MBA DECISION 1. How does Ben’s age affect his decision to get an MBA? In our opinion, Age is one of the important factor that affects someone decision to continue study. In this case, Ben is now 28 years old. He graduated from college six years ago when he’s age is 22 years old. Assuming that Ben already working for about 5 years since graduated from college, so that he would have enough money from salary saving in5 years to do his MBA

Mba for Melbourne

3238 words - 13 pages A MessAge froM the DeAn Welcome to Melbourne Business School’s new Executive MBA. This new program complements our long-running Senior Executive MBA, which for more than 20 years has been equipping senior executives with the tools and skills to lead organisations. Our graduates can be found in the executive ranks of sectors from banking, mining, health and government to the law. Our aim is to educate ambitious, highly-skilled business

The Mba Decision

2952 words - 12 pages enough money to cover the entire cost of his MBA program, it is the best option for him to get the MBA at Wilton University 4. Ben believes that the appropriate analysis is to calculate the future value of each option. How would you evaluate this statement? 1. Keeping his current work for 40 years There are several factors to be considered to calculate the future values (FV) of the first options are: His annual salary at the firm is

Mba 550 Concept Worksheet

1412 words - 6 pages delivery. In addition, the vendors may want a percentage of the payment before any product is distributed. Short-term, or current, assets and liabilities are collectively known as working capital (Brealey et al, 2005). Working capital practices include credit management, inventory management, cash, and marketable securities. Credit management includes the terms of sale, the promise to pay, credit analysis, the credit decision, and collection

Mba - Global Communications

5233 words - 21 pages identified, do these match or stack-up against the end-state goals? (Elver, 2005).[This should describe several possible alternative solutions, based on what you learned during your generic benchmarking exercise. Be sure that these are specific and actionable solutions. Triple click anywhere in this paragraph to begin typing.] Analysis of Alternative Solutions (Step 5) Looking carefully at the end-state goals, Global will choose four of the

Mba Operations Management

2923 words - 12 pages Operations Management MBA International Topic Operations Function Within a Facilities Services Company William Peden Registration No. 200965241 MacTaggart University of Strathclyde July 2009 Word Count 2750 Contents Contents

Mba Bus Eccon

2682 words - 11 pages towards monopoly, due to less competition, the firms have more control over price of product. 9 First the background to the problem is provided. Graph 13 and the accompanying narrative is used to provide evidence of the claim that reduced average has lead to reduced supply and high prices. This is very good, and is the basis for insightful analysis regarding short and long term strategies of firms. A real understanding of the importance

Mba Mba Mba Mba

3139 words - 13 pages Harvard Business Review Case study Analysis BY John Raphael Marty Vitality Health A better Corporate Performance Management System to Retain Top Talent Vitality Health Vitality Health Introduction Issues Beth Williams stepped in to fill the shoes of Fred Kikuchi in 2009 as the new CEO. Her primary stated purpose was to “find a better way to identify and reward top performers in order to keep ‘A’ players in their

Mba 560 Corporate Compliance Report

2010 words - 9 pages Corporate Compliance Report MBA 560 Introduction Corporations must be properly equipped to meet the responsibilities for internal controls. The highly visible and competitive natures of businesses today require management to achieve proficiency in various areas. Operations must be efficient and effective, reliable financial data must be compiled, while adhering to applicable laws and regulations at all times. The Council of

Related Essays

Mba 500 Gap Analysis

4439 words - 18 pages Running head: GAP ANALYSIS: GLOBAL COMMUNICATIONS Gap Analysis: Global Communications Ben Johnson University of Phoenix Gap Analysis: Global Communications Global Communications has fallen behind in an industry in which change is required for survival. Its stock prices have fallen as has the confidence of its investors. The major problem is that competition in the telecommunications industry has become fierce with too many

Business Analysis Mba 521

2597 words - 11 pages In 2007 it took seven economists 11 months to decide what should have seemed obvious given all the foreclosures, bank failures, and layoffs that the United States is officially mired in a recession. Many economists believe the current downturn could be the worst since the recession of 1980-1982, when the United States unemployment rate soared above 10%. There are many reasons for the recession of 2008, but mostly because the irrational

Mba Answer Essay

1068 words - 5 pages MBA Masters Program in Business Administration {2 - Sem} FINANCE MANAGEMENT Submitted by: - _______________________ Max. Marks: - 100 All the questions are compulsory. The first five questions shall be of 16marks each and the last questions shall be of 20 marks. Q1 (A) What are the primary objectives of corporate management in India? (B) Why is the correlation between securities returns in a portfolio

Pursuing My Mba Essay

862 words - 4 pages deliverables require a level of analysis, research, and teamwork that can be an invaluable learning experience for me. The majority of MBA programs have a Capstone course that applies all of the course material that I would learn in the typical MBA. And to really top it off, there is also usually an Entrepreneurship elective where you can develop a business plan. I’ve had an idea for a business for quite awhile, which is another great opportunity