Data Analysis and Modeling || Fall, 2016 || Pokhara University || BCIS

Data Analysis and Modeling – Fall, 2016

This is the question set along with answers Data Analysis and Modeling Fall 2016, which was taken by the Pokhara University.

Pokhara University – Data Analysis and Modeling Fall 2016

Level: Bachelor	Semester –Fall	Year: 2016
Program: BCIS		Full Marks: 100
Course: Data Analysis and Modeling		Pass Marks: 45
Course: Data Analysis and Modeling		Time: 3hrs.

Attempt all the questions.

1. A corporation owns several companies. The strategies planner for the corporation believes dollars spent on advertising can to some extent be a predictor of total sales dollars. As an aid in long-term planning, the planner, gathers the following sales and advertising information from several of the companies for 2011 ($ millions).
  
  a) Find the coefficient of correlation between sales and advertisement. Test the significance of the coefficient of correlation at a 5% level of significance.
  b) Develop the linear regression equation that best fits the given data. What sale is expected for spent on advertising 20 million dollars?
  c) Obtain standard error of estimate and interpret its meaning.
2. 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 House is a full-service interior design store that sells custom blinds, carpets, and wall coverings. The store manager, Saadwee, contracted with a sales-force selection company to conduct per-hiring tests on four aptitudes. She 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. Using the computer, She generated the following SPSS output for the best-fitting multiple regression.
  
  i. Write the regression equation for sales growth in terms of the four factors tested.
  ii. How much of the variation in sales growth is explained by the aptitude tests?
  iii. Is the overall model significant as a whole?
  iv. At a significance level of 0.05, which of the aptitude tests are significant explanatory variables for sales growth? (Derive your inference based on the p-value approach).

a) MK Publication Company is interested to determine how its sales have changed over the year. A summary of the sales record of books of different subjects is given below.

Calculate the un-weighted quantity index number to show the change in sales over the latter two years and interpret your results.
b) Draw the PERT network diagram with the following data and find the critical path and critical activities. What is the minimum time required to complete the project?

1. Enviro-tech Engineering, a company that specializes in the construction of anti-pollution filtration devices, has recorded the following sales record over the last six-year.
  
  a) Develop the second-degree estimating equation that best describes these data. Estimate the sales of antipollution filtration devices for 2003.
  b) Calculate the percent of trend and relative cyclical residual. Plot relative cyclical residual over time and interpret the meaning of the value of relative cyclical residual for the year 2000.
  c) Apply the exponential smoothing method to forecast the sales for the year 2003 with a smoothing constant of 0.3. Assume that the forecast sales for 1997 to be 12 hundred thousand dollars.
2. a) Prakriti assembles stereo equipment for resale in her shop. She offers two products, turntables, and cassette players. She makes a profit of $10 on each turntable and $6 on each cassette. Both must go through two steps in her shop assembly and bench checking. A turntable takes 12 hours to assemble and 4 hours to bench check. A cassette player takes 4 hours to assemble but 8 hours to bench check. Looking at this month’s schedule, sally sees that she has 60 assembly hours uncommitted and 40 hours of bench checking time available.
  i. Formulate the problem as a LPP.
  ii. Use graphic linear programming to find her best combination of turntables and cassette player. What is the total profit on the combination you found?
  iii. Obtain the dual of the given LP

Problem.b) Find dual of following primal linear programming problem.
Minimize =

Subject to the constraints

a) A manufacturer has distribution centers located at A, B, and C. These centers have available 8, 4, and 8 units of his product. His retail outlets require 5, 2, 4, 6, and 3 units respectively. The shipping cost per unit (in rupees) between each center and outlet is given in the following table.

Determine the optimum transportation cost.
b) The following are the group index numbers and the group weights of a working-class family budget. Construct the cost of living index number by assigning the given weights by using arithmetic and geometric mean.
Write a short note on any two:
a) Stepwise technique of regression model building.
b) Active and inactive constraints and their role in optimization.
c) Autocorrelation and its consequences in estimation.