Looking for help in completing 'Quantitative Methods For Management' assignment.

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 given below:

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.

1.Olive Construction Company is determining whether it should submit a bit for a new shopping centre. In the past, Olive's main competitor, Base Construction Company, has submitted bids 70% of the time. If Base Construction Company does not bid on a job, the probability that Olive Construction Company will get the job is 0.50. If the Base Construction Company bids on a job, the probability that Olive Construction Company will get the job is 0.25.

a.If Olive Construction Company gets the job, what is the probability that Base Construction Company did not bid?

b.What is the probability that Olive Construction Company will get the job?

2.A Nielsen study indicates that 18 to 24 year olds spend a mean of 135 minutes watching video on their smartphones per month. Assume that the amount of time watching video on a smartphone per month is normally distributed and that the standard deviation is 15 minutes.

a.What is the probability that an 18-to 24 year old spends less than 112 minutes watching video on his or her smartphone per month?

b.What is the probability that an 18-to 24 year old spends between 112 and 158 minutes watching video on his or her smartphone per month?

c.What is the probability that an 18 to 24 year old spends more than 158 minutes watching video on his or her smartphone per month?

d.One percent of all 18 to 24 years old will spend less than how many minutes watching video on his or her smartphone per month?