S.no.

Sales boys Adcost outlets var comp customers

1 81 15 20 35 17 4 70
2 23 10 12 10 13 4 43 The owner of the pizza Corner Bangalore would like to build
3 18 7 11 14 14 3 31 model consisting of six factors to predict the sale of pizza. D
months on sales and six different factors were collected for
4 8 2 6 9 13 3 10 Input:
5 16 4 10 11 12 4 17  
6 4 1 5 6 12 5 8 Dependent variables:
 
7 29 4 14 15 15 2 39 Y=Monthly sales in rs.
8 22 7 12 16 16 3 40 Independent variables:
9 15 5 10 18 15 4 30 X1= No. of delivery boys.
10 6 3 5 8 13 2 16 X2=Cost of ad in Rs.
X3=No. of out lets
11 45 13 17 20 14 2 30 X4=Variety of pizza’s
12 11 2 9 10 12 3 20 X5=Competitors activity index
13 20 5 12 15 12 3 25 X6=No. of existing customers (‘000)
14 60 12 18 30 15 4 50
15 5 1 5 6 12 5 20
ner Bangalore would like to build a regression
ors to predict the sale of pizza. Data for the past 15
fferent factors were collected for the purpose.

dex
ers (‘000)
Exp (yearsTestScore Salary($) Degree
4 78 24 0 A software firm collected data for a sample o
programmers. A suggestion was made that
7 100 43 1 Exp (years) analysis could be used to determine if salary
1 86 23.7 0 TestScore the years of experience and the score on the
5 82 34.3 1 Salary($) programmer aptitude test.
The years of experience, score on the aptitu
8 86 35.8 1 Degree corresponding annual salary ($1000s) for a s
10 84 38 1 programmers is shown in columns
0 75 22.2 0 = annual salary ($1000)
1 80 23.1 0 x1 = years of experience
x2 = score on programmer aptitude test
6 83 30 0
x3 = 0 if individual does not have a graduate
6 91 33 1 1 if individual does have a graduate de
9 88 38 1 (x3 is a dummy variable)
2 73 26.6 0
10 75 36.2 1
5 81 31.6 0
6 74 29 0
8 87 34 1
4 79 30.1 0
6 94 33.9 1
3 70 28.2 0
3 89 30 0
m collected data for a sample of 20 computer
A suggestion was made that regression
be used to determine if salary was related to
xperience and the score on the firm’s
ptitude test.
xperience, score on the aptitude test, and
g annual salary ($1000s) for a sample of 20
is shown in columns
ary ($1000) 0.335508
experience
programmer aptitude test
dual does not have a graduate degree
idual does have a graduate degree
ummy variable)
year Income Ad. ExpenMarketingDistribut Forex Earnings
1 3854.6 52 82.6 316.3 174.5
2 4757.9 60.2 97.8 318 202.2
3 5973.5 63.7 132.8 366 331.6 Siyaram’s is a well-established company in the textile and garment industry pro
4 6792.1 98.2 154.3 501.7 525.3 Mr. Ramesh Poddar group. The company’s business is divided into three major
5 7643 134.3 192 502.8 735.3 segments: textile, files and tools, and Air Charter Services. The textile business f
core business with a contribution of 77% to the total sale during the year 2006-
6 9522.9 156 253.8 679 984.6 1 provides the Income, Ad Expenditure, Marketing Expense, Distribution Expens
7 11670.9 267.4 292.6 755.8 1122.7 Forex Earnings of Raymond Ltd from March 1990 (financial year 1999-1990) to M
8 12716.9 283.6 326.7 898.7 1590.3 2007 (financial year 2006- 2007).
9 15728.5 246.9 383.8 1200.3 2235.7 1.Generate a four Bivariate Regression Models (Scatter plots only) by taking inc
10 16342.1 365.8 432.2 949.4 1804.4 dependent variable and different combinations of independent variables sepera
11 17248.4 469 547.1 1262.7 2170.6
12 21413.9 455.7 473.9 1025.8 2220.1 2. On the basis of regression output (Scatter plot only) answer the following qu
Is it suitable to run regression analysis? How will you decide?
13 10935.8 548.7 418.1 82.4 1704.9
14 11234.9 493.8 414.6 88.6 1760.9 3. Are the independet variables significantly related to each other. How will you
15 12686.8 448.8 373.8 110.7 2141.5 Discuss what implication will the significant relationship of independent variable
have in predicting the Income in Bivariate regression.
16 12724.5 437.6 421.4 148.1 2653
17 14678.8 531.3 478.9 155.1 2688.4 4. Run a Multiple regression Ananlysis and read your output
18 15277.6 664.2 525.6 113 2261.1
19 3854.6 52 82.6 316.3 174.5
20 4757.9 60.2 97.8 318 202.2
21 5973.5 63.7 132.8 366 331.6
22 6792.1 98.2 154.3 501.7 525.3
23 7643 134.3 192 502.8 735.3
24 9522.9 156 253.8 679 984.6
25 11670.9 267.4 292.6 755.8 1122.7
26 12716.9 283.6 326.7 898.7 1590.3
27 15728.5 246.9 383.8 1200.3 2235.7
28 16342.1 365.8 432.2 949.4 1804.4
29 17248.4 469 547.1 1262.7 2170.6
30 21413.9 455.7 473.9 1025.8 2220.1
31 10935.8 548.7 418.1 82.4 1704.9
32 11234.9 493.8 414.6 88.6 1760.9
33 12686.8 448.8 373.8 110.7 2141.5
34 12724.5 437.6 421.4 148.1 2653
35 14678.8 531.3 478.9 155.1 2688.4
36 15277.6 664.2 525.6 113 2261.1
textile and garment industry promoted by
ness is divided into three major
er Services. The textile business forms the
total sale during the year 2006-2007Table
ting Expense, Distribution Expense and
90 (financial year 1999-1990) to March

(Scatter plots only) by taking income as

of independent variables seperately.

ot only) answer the following question:

ll you decide?

lated to each other. How will you decide?

ationship of independent variables will
ssion.

your output
student salary marks commonscore awarenesslIQ
1 5.5 65 88 78 105 In a survey taken by placement department of a leading B
2 16.5 90 93 95 120 school four parameters were identified of utmost importance
3 4.5 65 63 56 100 namely marks, common score at the time of admission,
awareness level and IQ level of the candidate in predicting the
4 7 68 79 66 100 most expected salary of the candidate. Use predictive model to
5 3.5 67 58 77 100 analyze the relationship among variables and answer the
6 6 62 85 87 110 following:
Use regression analysis to investigate the relationship between
7 4 84 77 44 105 salaries offered to the candidate and other independent
8 7.5 82 78 66 105 variables. Discuss your findings.
9 2.75 75 53 68 100 Based on your analysis, do you think all the variables contribute
significantly?
10 10.5 81 95 54 115 State assumptions of regression analysis.
11 5 74 68 50 110 1. sample is taken from Normal population
12 9 88 78 78 115 2. Al the independent variables are independent of each other.
13 4 65 63 45 100 Discuss role of ANOVA in regression analysis.
 
14 4.5 84 68 56 100
15 2.5 68 58 43 95
16 8.5 71 89 68 110
17 12.5 92 91 76 120
18 3 53 55 71 100
19 8.75 77 77 77 100
20 6.5 68 79 45 105
21 13.5 89 89 56 115
22 5.5 68 64 43 100
23 4 63 62 40 100
24 5 65 69 55 100
25 7.6 74 71 68 105
eading B
importance
ission,
redicting the
ctive model to
wer the

ship between
endent

bles contribute

of each other.