Decision Science NMIMS Assignment Solution

$10.62

DS Assignment Solution Dec 2020

Decision Science

  1. The data of two variables X and Y is given below:

 

TABLE BELOW

YX
345
456
554
656
757
658
667
668
776
776
878
979
1280
1381
1584
1789

 

  1. Calculate the correlation between X and Y
  2. Apply the regression between X and Y (as dependent variable)
  3. Estimate the R square
  4. Predict Y when X = 50

 

Q2. Following ungrouped data of Sales of a company (in millions) is available

Decision Science

  1. Make the frequency distribution table with appropiate class interval, frequency, cumulative frequency.
  2. Calculate the mean, median, mode and quartiles of grouped data.
  3. Calculate the standard deviation, variance and range
  4. Make the following diagrams: Histogram, Frequency Polygon, Ogive

 

3.a. For a certain type of computers, the length of time between charges of the battery is normally distributed with a mean of 50 hours and a standard deviation of 15 hours. Mr Y owns one of these computers and wants to know the probability that the length of time will be between 50 and 70 hours.

3.b. The length of life of an instrument produced by a machine has a normal distribution with a mean of 12 months and standard deviation of 2 months. Find the probability that an instrument produced by this machine will last (a) Less than 7 months (b) Between 7 and 12 months

 

Previous Semester

Q1. Identify the type of the variable in the following table

Table Given Below

VariableData Type
aGender
bEducation Background
cSatisfaction
dMotivation
eExchange Rate
fGold price
gPreference of cars
hTeachers Feedback
iGrades in post-graduation
jMarital Status
kQuality of services
lAge group
mGDP
nInterest rate
oTwitter comments
pFacebook pictures

Q2. Following data of performance scores is available of employees working with a company. You are required to perform the following:

 

  1. Make the frequency distribution, Calculate the frequency and the Cumulative frequency

 

  1. Calculate the mean, median, quartiles and Mode

 

  1. Calculate the variance and the standard deviation

 

Table: Performance score of the employees:

 

TABLE BELOW

 

5233709557614760
5764549438618948
5039946359318846
6888934882827273
7470927698918068
3233317554486253
3664636692989142
3654718684553343
9134646789784762
9792535668553667
9342517736935166
4466633368799276
8353867635404346
5541363942964277
6053385195569363
4869493395378364
8362963485324085
3959776235343992
5489364583348690
3961888655337740
6954303879774459
9534389180905840
8845957180438953
6140316158538894
9163609498535345
5034757490988766

 

Q3. a. In continuation with the data of performance scores of employees in previous example, perform the following:

  1. Calculate the range and interquartile range
  2. Calculate the z scores
  3. Calculate the skewness and Kurtosis (using excel)
  4. Comment on the distribution of the data

Q3. b. In the continuation with data of performance scores of employees in previous example, perform the following:

  1. Make the histogram
  2. Plot the box-plot diagram
  3. Plot the frequency polygon
  4. Plot the Ogive diagram