Dear students, get latest Solved assignments and case study help by professionals.
Mail us at : help.mbaassignments@gmail.com
Call us at : 08263069601
NMIMS Global Access
School for Continuing Education (NGA-SCE)
Course:Decision Science
Internal Assignment Applicable for April 2021 Examination
Assignment Marks: 30
- Considering Y as a dependent variable, a regression model is applied with three independent variables X1 X2 and X3. The results of the regression analysis are shown below:
Model | R | R Square | Adjusted R Square | ||||
1 | .969a | .939 | .930 | ||||
ANOVAa | |||||||
Model | Sum of Squares | df | Mean Square | F | Sig. | ||
Regression | 1123.258 | 3 | 374.419 | 97.893 | .000b | ||
1 | Residual | 72.671 | 19 | 3.825 | |||
Total | 1195.929 | 22 |
a. Dependent Variable: Y
b. Predictors: (Constant), X5, X3, X4
Coefficientsa | |||||
Model | Unstandardized Coefficients | Standardized | t | Sig. | |
Coefficients | |||||
B | Std. Error | Beta | |||
(Constant) | 35.681 | 3.399 | 10.496 | .000 | |
X3 | -.654 | .158 | -.986 | -4.151 | .001 |
1 | |||||
X4 | .233 | .054 | 1.111 | 4.275 | .000 |
X5 | .115 | .024 | .806 | 4.749 | .000 |
a. Dependent Variable: Y
Answer the following:
1. Define R and R Square.
- What is the significance of F test.
- Which variable has the highest impact on Y.
- Write the regression equation.
- Calculate Y if X1= 10, X2 =20 and X3 =5
(10 Marks)
- The monthly sales (number of Cars sold) is recorded of a car dealer. Following ungrouped is available
52 | 33 | 70 | 95 | 57 | 61 |
57 | 64 | 54 | 94 | 38 | 61 |
50 | 39 | 94 | 63 | 59 | 31 |
68 | 88 | 93 | 48 | 82 | 82 |
74 | 70 | 92 | 76 | 98 | 91 |
32 | 33 | 31 | 75 | 54 | 48 |
36 | 64 | 63 | 66 | 92 | 98 |
36 | 54 | 71 | 86 | 84 | 55 |
91 | 34 | 64 | 67 | 89 | 78 |
97 | 92 | 53 | 56 | 68 | 55 |
93 | 42 | 51 | 77 | 36 | 93 |
44 | 66 | 63 | 33 | 68 | 79 |
83 | 53 | 86 | 76 | 35 | 40 |
55 | 41 | 36 | 39 | 42 | 96 |
60 | 53 | 38 | 51 | 95 | 56 |
48 | 69 | 49 | 33 | 95 | 37 |
83 | 62 | 96 | 34 | 85 | 32 |
39 | 59 | 77 | 62 | 35 | 34 |
54 | 89 | 36 | 45 | 83 | 34 |
39 | 61 | 88 | 86 | 55 | 33 |
a. Prepare the frequency distribution table showing the class interval (less than 10, 11 to 20, and so on), frequency of each class interval and cumulative frequency.
b. Calculate the mean, median, mode and quartiles of grouped data.
c. Calculate the standard deviation, variance and range
d. Make the following diagrams: Histogram, Frequency Polygon, Ogive
(10 Marks)
3.a. It is estimated that 50% of emails are spam emails. Some software has been applied to filter these spam emails before they reach your inbox. A certain brand of software claims
that it can detect 99% of spam emails, and the probability for a false positive (a non-spam email detected as spam) is 5%. Now if an email is detected as spam, then what is the
probability that it is in fact a non-spam email? (5 Marks)
3.b. The time taken to assemble a car in a certain plant is a random variable having a normal distribution of 20 hours and a standard deviation of 2 hours. What is the probability that a car can be assembled at this plant in a period of time
- less than 19.5 hours?
- between 20 and 22 hours?
(5 Marks)
Dear students, get latest Solved assignments and case study help by professionals.
Mail us at : help.mbaassignments@gmail.com
Call us at : 08263069601
**********