Published by: sadikshya
Published date: 25 Jun 2021
This is the question set Data Analysis and Modelling Spring 2015, which was taken by the Pokhara University.
Pokhara University – Data Analysis and Modelling Spring 2015
Level: Bachelor | Semester –Spring | Year: 2015 |
Program: BBA/BI/BCIS/BBA-TT | Full Marks: 100 | |
Course: Data Analysis and Modelling | Pass Marks: 45 | |
Time: 3hrs. |
Section “A”
Very Short Answer Questions
Attempt all the questions.
Section “B”
Descriptive Answer Questions
Attempt any six questions
Calculation shows that
SX = 34 SX2 = 122.6
SY = 1371 SY2 = 201121
SXY = 4954
12.The money Bank desires to open a new checking account for customers who will write at least 30 checks per month to assist in selecting new customers, the bank has studied the relationship between the number of checks written and the age and income of eight of their present customers. AGE was recorded to of nearest year and annual INCOME was recorded in thousand dollars. The data follow:
PICTURE
13. The sales manager responsible for the appliance division of a large consumer products company has collected the following data regarding unit sales for his division during the last 5 years.
PICTURE
The equation describing the secular trend for appliance sales is
Where 1993 = 0 and x units = 1year
14.
15. a) Consider the following time series data.
PICTURE
Use α=0.2 to compute the exponential smoothing forecast values for the time series. What is the forecast for week 7? Calculate MSE as well
b)Four jobs are to be done on four different machines. The cost ( in rupees ) of producing its job on the machine is given:
PICTURE
16.Yahoo trucking company has a contract to move 115 truckloads of sand per week between three sand-washing plants W, X, and Y, and the three destinations, A, B, and C. Cost and volume information is given below. Compute the starting solution by Vogel’s approximation method and then find an optimal solution by using MODI Method.
PICTURE
17.A small project composed of eight activities and their time estimates are as follows:
PICTURE
Section “C”
Case Analysis
18.a) Successful selling is as much an art as a science, but many sales managers believe that personal attributes are important in predicting sales success. Design Alley is a full-service interior design store that sells custom blinds, carpets, and wall coverings. The store manager, Mr. Adhikari, contracted with a sales- force selection company to conduct a pre-hiring tests on four aptitudes. Mr. Adhikari has collected sales growth data for 25 of the salespeople who were hired, along with the scores from the four tests of aptitude: creativity, mechanical ability, abstract thinking, and mathematical calculation. Mr. Adhikari generated the following Minitab output.
PICTURE
PICTURE
b) You are the manager of a small store that specializes in hats, sunglasses, and other accessories. You are considering a sales promotion of a new line of hats and sunglasses. You will offer the sunglasses only to those who purchase two or more hats, so you will sell at least twice as many hats as pairs of sunglasses. Moreover, your supplier tells you that, due to seasonal demand, your order of sunglasses cannot exceed 100 pairs. To ensure that the sale items fill out the large display you have set aside, you estimate that you should order at least 210 items in all.