Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

No. CGPA Background Specialisation Work Experience Age (in years) 1 3.24 Commerce Finance 2 23 2 3.14 Commerce Finance 1 21 3 3.72 Commerce Finance

No. CGPA Background Specialisation Work Experience Age (in years)
1 3.24 Commerce Finance 2 23
2 3.14 Commerce Finance 1 21
3 3.72 Commerce Finance 2 23
4 3.06 Commerce Finance 4 21
5 3.14 Commerce Finance 2 22
6 3.14 Commerce Finance 2 23
7 3.06 Commerce Finance 0 22
8 3.17 Commerce Finance 3 21
9 2.97 Commerce Finance 2 22
10 3.14 Commerce Finance 4 23
11 3.69 Commerce Finance 2 24
12 2.85 Commerce Finance 4 25
13 2.92 Commerce Marketing 2 23
14 2.79 Commerce Marketing 3 25
15 3.22 Commerce Marketing 3 22
16 2.87 Commerce Marketing 5 22
17 3.14 Commerce Marketing 1 22
18 3.17 Commerce Marketing 4 23
19 3.22 Economics Finance 1 26
20 2.58 Economics Finance 2 25
21 3.36 Economics Finance 1 22
22 3.17 Economics Marketing 3 21
23 2.59 Economics Marketing 5 24
24 2.97 Engineer Human Resources 4 31
25 2.92 Engineer Marketing 5 23
26 3.03 Engineer Marketing 4 23
27 2.79 Engineer Marketing 2 25
28 2.77 Engineer Marketing 3 23
29 2.97 Engineer Marketing 21 25
30 3.11 Engineer Marketing 3 27
31 3.33 Engineer Marketing 1 24
32 2.65 Engineer Marketing 2 23
33 3.14 Engineer Marketing 2 24
34 2.97 Engineer Marketing 3 23
35 3.39 Engineer Marketing 4 24
36 3.08 Engineer Marketing 3 23
37 3.3 Engineer Marketing 3 27
38 2.94 Engineer Marketing 3 24
39 3.25 Engineer Marketing 2 23
40 3.14 Engineer System 3 23
41 3.36 Engineer System 2 26
42 2.95 Information Finance 2 24
43 2.98 Technology Finance 5 23
44 2.82 Information Marketing 3 24
45 2.98 Information Marketing 3 26
46 3.33 Information Marketing 2 24
47 2.96 Information Marketing 4 27
48 3.67 Information System 3 25
49 3.22 Science Finance 1 25
50 3.14 Science Finance 3 22
51 3.17 Science Finance 2 26
52 3.25 Science Human Resources 0 21
53 3. 10 Science Marketing 2 22
54 2.85 Science Marketing 5 24
55 3.25 Science Marketing 2 22
  1. At one of the Management Institutes, a sample of 55 second Year MBA students was selected, and information gathered relating to their age, background of graduation, work experience prior to joining MBA, CGPA score at the end of First Year, and area of specialization. The collected data is mentioned above-

(a) Present the above data with the help of tables, charts and graphs.

(b) Calculate the measures of location and dispersion of CGPA, age and work experience for all backgrounds and specializations. Combine these measures, wherever possible, for all the backgrounds and specializations separately. Discuss the findings.

(c) Study and comment on correlations between CGPA and age for students of all backgrounds viz. commerce, science etc.,

(d) Summarize your findings and present a managerial report.

2. An investor is concerned with the market return for the coming year, where the market return is defined as the percentage gain ( or loss, if negative) over the year. The investor believes there are five possible scenarios for the national economy in the coming year- rapid expansions, moderate expansions, no growth, moderate contractions and serious contraction. Furthermore, she has used all of the information available to her to estimate that the market returns for these scenarios are, respectively 23%, 18%,15%,9% and 3% .Also she has assessed the probabilities of these outcomes are 0.12, 0.40,0.25, 0.15 and 0.08. Use this information to describe the probability distribution of the market return. Calculate, average return, standard deviation and variance of the probability distribution of the market return for the coming year and comment.

3. The personnel department of ZTel, a large communication company, is reconsidering its hiring policy. Each applicant for a job must take a standard exam and the hire or no hire decision depends at least in part on the result of the exam. The scores of all applicants have been examined closely. They are approximately normally distributed with mean 525 and standard deviation 55.

The current hiring policy occurs in two phase. The first phase separates all applicants into three categories: automatic accepts, automatic rejects and maybe. The automatic accepts are those whose test scores are 600 or above. The automatic rejects are those whose test scores are 425 and above. All other applicants ( the maybes) are passed on to the second phase where their previous job experience, special talents, and other factors are used as hiring criterial. The personnel manager at ZTel wants to calculate the percentage of applicants who are automatic accepts or rejects, given the current standards. She also wants to know how to change the standards to automatically reject 10% of all applicants and automatically accept 15% of all applicants.

4.An American consumer organization is currently examining the relationship among several variables including gasoline mileage as measured by miles per gallon; the horsepower of the car's engine and the weight of the car (in pounds). A sample of 50 recent car models was selected and the results recorded. (provided in below table)

MPG Horsepower Weight
43.1 48 1985
19.9 110 3365
19.2 105 3535
17.7 165 3445
18.1 139 3205
20.3 103 2830
21.5 115 3245
16.9 155 4360
15.5 142 4054
18.5 150 3940
27.2 71 3190
41.5 76 2144
46.6 65 2110
23.7 100 2420
27.2 84 2490
39.1 58 1755
28 88 2605
24 92 2865
20.2 139 3570
20.5 95 3155
28 90 2678
34.7 63 2215
36.1 66 1800
35.7 80 1915
20.2 85 2965
23.9 90 3420
29.9 65 2380
30.4 67 3250
36 74 1980
22.6 110 2800
36.4 67 2950
27.5 95 2560
33.7 75 2210
44.6 67 1850
32.9 100 2615
38 67 1965
24.2 120 2930
38.1 60 1968
39.4 70 2070
25.4 116 2900
31.3 75 2542
34.1 68 1985
34 88 2395
31 82 2720
27.4 80 2670
22.3 88 2890
28 79 2625
17.6 85 3465
34.4 65 3465
20.6 105 3380

(a) Using the sample dataattached, calculate the sample meanand standard deviationfor the variables: -

1. Miles per gallon (MPG)

2. Horsepower

3. Weight (in pounds)

(b) Is there any evidence of skewness in the data sets? Which data set displays greatest skewness?

(c) Using the sample data on MPG, calculate the sample proportionof vehicles whose fuel economy exceeds 37 mpg and its corresponding standard deviation.

(d) Indicate all possible relationship between the variables and comment on it. (You may use scatter diagram or Karl Pearson's correlation coefficient)

(e) Using the complete data set and using simple ordinary least squares regression formulaedevelop twomodels to explain the behavior of gasoline mileage (Miles per gallon) as a function of their-

(i) Horsepower

(ii) Weight

Which model best describes the behavior of gasoline mileage? Explain your reasons here.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Linear Algebra Applications Version

Authors: Howard Anton, Chris Rorres

11th Edition

1118879163, 9781118879160

More Books

Students also viewed these Mathematics questions

Question

5. It is the needs of the individual that are important.

Answered: 1 week ago