OUTPUT:

Frequencies
Statistics
age gender education wrkexp
Valid 25 25 25 25
N
Missing 0 0 0 0

Frequency Table
Age
Frequency Percent Valid Percent Cumulative
Percent
<20 5 20.0 20.0 20.0
20-25 5 20.0 20.0 40.0
26-30 5 20.0 20.0 60.0
Valid 31-40 6 24.0 24.0 84.0
>40 4 16.0 16.0 100.0
Total 25 100.0 100.0

Gender
Frequency Percent Valid Percent Cumulative
Percent
Male 13 52.0 52.0 52.0
Valid Female 12 48.0 48.0 100.0
Total 25 100.0 100.0

Education
Frequency Percent Valid Percent Cumulative
Percent
high school 6 24.0 24.0 24.0
graduate in art and science
8 32.0 32.0 56.0
degree
Valid graduate professional
6 24.0 24.0 80.0
degree
post graduate degree 5 20.0 20.0 100.0
Total 25 100.0 100.0

Work Experience
Frequency Percent Valid Percent Cumulative
Percent
<1 year 5 20.0 20.0 20.0
1-5 years 9 36.0 36.0 56.0
Valid 5-10 years 3 12.0 12.0 68.0
10-20 years 3 12.0 12.0 80.0
>20 years 5 20.0 20.0 100.0
Total 25 100.0 100.0
Bar Chart:
OUTPUT:
Statistics
Gender of person Height in cms Weight in kgs
Valid 20 20 20
N
Missing 0 0 0
Mean 1.45 151.35 56.65
Median 1.00 151.00 54.50
Mode 1 156 45a
Std. Deviation .510 4.671 8.286
Variance .261 21.818 68.661
Range 1 19 25
Minimum 1 140 45
Maximum 2 159 70
25 1.00 148.25 50.25
Percentiles 50 1.00 151.00 54.50
75 2.00 155.75 64.75
a. Multiple modes exist. The smallest value is shown

Frequency Table:
Gender of person
Frequenc Percent Valid Cumulative
y Percent Percent
Male 11 55.0 55.0 55.0
Valid female 9 45.0 45.0 100.0
Total 20 100.0 100.0

Freque Percen Valid Cumulativ

Height in cms ncy t Percent e Percent

Frequenc Percent Valid Cumulative

45 2 10.0 10.0 10.0
y Percent Percent
47 1 5.0 5.0 15.0
140 1 5.0 5.0 5.0 49 1 5.0 5.0 20.0
146 2 10.0 10.0 15.0 50 1 5.0 5.0 25.0
148 2 10.0 10.0 25.0 51 2 10.0 10.0 35.0
149 2 10.0 10.0 35.0 53 2 10.0 10.0 45.0
150 2 10.0 10.0 45.0 54 1 5.0 5.0 50.0
151 2 10.0 10.0 55.0 55 1 5.0 5.0 55.0
Vali 152 1 5.0 5.0 60.0 Vali 56 1 5.0 5.0 60.0
d 153 1 5.0 5.0 65.0 d
59 1 5.0 5.0 65.0
154 1 5.0 5.0 70.0 61 1 5.0 5.0 70.0
155 1 5.0 5.0 75.0 64 1 5.0 5.0 75.0
156 3 15.0 15.0 90.0 65 1 5.0 5.0 80.0
158 1 5.0 5.0 95.0 68 2 10.0 10.0 90.0
159 1 5.0 5.0 100.0 69 1 5.0 5.0 95.0
Total 20 100.0 100.0 70 1 5.0 5.0 100.0
Tot
20 100.0 100.0
al
Bar Chart:
OUTPUT:

T-Test

One-Sample Statistics
N Mean Std. Deviation Std. Error Mean
Life in years 20 5.785 1.5517 .3470

One-Sample Test
Test Value = 5
t Df Sig. (2-tailed) Mean Difference 95% Confidence Interval of the
Difference
Lower Upper
Life in years 2.262 19 .036 .7850 .059 1.511
OUTPUT:
T-Test

Group Statistics
Gender of person N Mean Std. Deviation Std. Error Mean
Male 11 149.36 4.523 1.364
Height in cms
Female 9 153.78 3.768 1.256

Independent Samples Test

Levene's Test for t-test for Equality of Means
Equality of
Variances
F Sig. t df Sig. Mean Std. 95% Confidence Interval of the
(2- Differenc Error Difference
taile e Differenc Lower Upper
d) e
Equal
variances .024 .880 -2.336 18 .031 -4.414 1.889 -8.384 -.444
Heigh assumed
t in
cms Equal
17.98
variances not -2.381 .029 -4.414 1.854 -8.309 -.519
5
assumed
OUTPUT:

T-Test
Paired Samples Statistics
Mean N Std. Deviation Std. Error Mean
pretest score 65.45 20 8.642 1.932
Pair 1
posttest score 101.40 20 14.780 3.305

Paired Samples Correlations

N Correlation Sig.
Pair 1 pretest score & posttest score 20 .563 .010
OUTPUT:
One way:

Descriptives

sales in rs (lacs)
95% Confidence Interval for
Mean
N Mean Std. Deviation Std. Error Lower Bound Upper Bound Minimum Maximum
delhi 10 480.60 24.88 7.87 462.80 498.40 428 500
kolkata 10 433.30 42.34 13.39 403.01 463.59 378 500
mumbai 10 376.40 26.45 8.37 357.48 395.32 349 421
chennai 10 308.10 41.34 13.07 278.53 337.67 259 389
Total 40 399.60 73.28 11.59 376.16 423.04 259 500

Test of Homogeneity of Variances

sales in rs (lacs)
Levene
Statistic df1 df2 Sig.
1.421 3 36 .253

ANOVA

sales in rs (lacs)
Sum of
Squares df Mean Square F Sig.
Between Groups 166071.8 3 55357.267 45.936 .000
Within Groups 43383.800 36 1205.106
Total 209455.6 39

Post hoc test: Homogeneous subset:

 Multiple Comparisons

Dependent Variable: sales in rs (lacs)

Tukey HSD

Mean
Difference 95% Confidence Interval
(I) metro cities (J) metro cities (I-J) Std. Error Sig. Lower Bound Upper Bound
delhi kolkata 47.30* 15.52 .021 5.49 89.11
mumbai 104.20* 15.52 .000 62.39 146.01
chennai 172.50* 15.52 .000 130.69 214.31
kolkata delhi -47.30* 15.52 .021 -89.11 -5.49
mumbai 56.90* 15.52 .004 15.09 98.71
chennai 125.20* 15.52 .000 83.39 167.01
mumbai delhi -104.20* 15.52 .000 -146.01 -62.39
kolkata -56.90* 15.52 .004 -98.71 -15.09
chennai 68.30* 15.52 .001 26.49 110.11
chennai delhi -172.50* 15.52 .000 -214.31 -130.69
kolkata -125.20* 15.52 .000 -167.01 -83.39
mumbai -68.30* 15.52 .001 -110.11 -26.49
*. The mean difference is significant at the .05 level.

sales in rs (lacs)
a
Tukey HSD
Subset for alpha = .05
metro cities N 1 2 3 4
chennai 10 308.10
mumbai 10 376.40
kolkata 10 433.30
delhi 10 480.60
Sig. 1.000 1.000 1.000 1.000
Means for groups in homogeneous subsets are displayed.
a. Uses Harmonic Mean Sample Size = 10.000.
OUTPUT:

Between-Subjects Factors

Value Label N
PLACE OF 1 DELHI 10
SALES 2 KOLKATA 9
3 CHENNAI 10
GRADUATON 1 UG 11
FOR SALES 2 GRADUATE 11
3 PG 7

Descriptive Statistics

Dependent Variable: SALES

PLACE OF SALES GRADUATON Mean Std. Deviation N
DELHI FOR SALES
UG 34.75 10.50 4
GRADUATE 38.50 8.70 4
PG 57.50 3.54 2
Total 40.80 12.00 10
KOLKATA UG 23.33 7.64 3
GRADUATE 47.50 15.55 4
PG 72.50 10.61 2
Total 45.00 22.08 9
CHENNAI UG 48.75 34.25 4
GRADUATE 88.33 12.58 3
PG 112.67 32.72 3
Total 79.80 38.43 10
Total UG 36.73 22.58 11
GRADUATE 55.36 24.32 11
PG 85.43 32.62 7
Total 55.55 31.36 29

Levene's Test of Equality of Error Variances a

Dependent Variable: SALES

F df1 df2 Sig.
5.572 8 20 .001
Tests the null hypothesis that the error variance of the
dependent variable is equal across groups.
a. Design: Intercept+PLACE+GRADUATN+PLACE
* GRADUATN

Tests of Between-Subjects Effects

Dependent Variable: SALES

Type III Sum Noncent. Observed
a
Source of Squares df Mean Square F Sig. Eta Squared Parameter Power
Corrected Model 20044.672b 8 2505.584 6.681 .000 .728 53.449 .998
Intercept 91467.120 1 91467.120 243.896 .000 .924 243.896 1.000
PLACE 8957.647 2 4478.824 11.943 .000 .544 23.885 .987
GRADUATN 8688.611 2 4344.306 11.584 .000 .537 23.168 .984
PLACE * GRADUATN 1754.261 4 438.565 1.169 .354 .190 4.678 .299
Error 7500.500 20 375.025
Total 117039.000 29
Corrected Total 27545.172 28
a. Computed using alpha = .05
b. R Squared = .728 (Adjusted R Squared = .619)
OUTPUT:

Crosstabs:
Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
SERIAL * PLACE 4 100.0% 0 .0% 4 100.0%

SERIAL * PLACE Crosstabulation

PLACE
delhi mumbai Total
SERIAL crorepathi Count 1 1 2
Expected Count 1.0 1.0 2.0
% within SERIAL 50.0% 50.0% 100.0%
% within PLACE 50.0% 50.0% 50.0%
% of Total 25.0% 25.0% 50.0%
bigboss Count 1 1 2
Expected Count 1.0 1.0 2.0
% within SERIAL 50.0% 50.0% 100.0%
% within PLACE 50.0% 50.0% 50.0%
% of Total 25.0% 25.0% 50.0%
Total Count 2 2 4
Expected Count 2.0 2.0 4.0
% within SERIAL 50.0% 50.0% 100.0%
% within PLACE 100.0% 100.0% 100.0%
% of Total 50.0% 50.0% 100.0%

Chi-Square Tests

Asymp. Sig. Exact Sig. Exact Sig.

Value df (2-sided) (2-sided) (1-sided)
Pearson Chi-Square .000b 1 1.000
Continuity Correction a .000 1 1.000
Likelihood Ratio .000 1 1.000
Fisher's Exact Test 1.000 .833
Linear-by-Linear
.000 1 1.000
Association
N of Valid Cases 4
a. Computed only for a 2x2 table
b. 4 cells (100.0%) have expected count less than 5. The minimum expected count is
1.00.
OUTPUT:

Chi-square test:

attidude

Observed N Expected N Residual

in favour 8 20.0 -12.0
against 20 20.0 .0
undecided 32 20.0 12.0
Total 60

Test Statistics

attidude
Chi-Square a 14.400
df 2
Asymp. Sig. .001
a. 0 cells (.0%) have expected frequencies less than
5. The minimum expected cell frequency is 20.0.
OUTPUT:

Non-parametric Correlations:

Correlations
Household Retail
income purchases (Rs.
([Link]) thousand)

Correlation Coefficient 1.000 .942**

Household income ([Link])
Sig. (1-tailed) . .000
Spearman's rho N 20 20
**
Correlation Coefficient .942 1.000
Retail purchases (Rs.
Sig. (1-tailed) .000 .
thousand)
N 20 20
**. Correlation is significant at the 0.01 level (1-tailed).
OUTPUT:
Correlations

percentage
cet scores in ug degree
cet scores Pearson Correlation 1.000 .539*
Sig. (1-tailed) . .019
N 15 15
percentage in ug degree Pearson Correlation .539* 1.000
Sig. (1-tailed) .019 .
N 15 15
*. Correlation is significant at the 0.05 level (1-tailed).
OUTPUT:

Mann-Whitney Test

Ranks

Retail stores N Mean Rank Sum of Ranks

Delhi 10 11.90 119.00

Sales (Rs. lacs) Mumbai 10 9.10 91.00
Total 20

Test Statisticsa

Sales (Rs. lacs)

Mann-Whitney U 36.000

Wilcoxon W 91.000

Z -1.061

Asymp. Sig. (2-tailed) .288

Exact Sig. [2*(1-tailed Sig.)] .315b

a. Grouping Variable: Retail stores

b. Not corrected for ties.

OUTPUT:
Kruskal-Wallis Test:

Test Statisticsa,b
sales

Chi-Square 1.289
Df 2
Asymp. Sig. .525
a. Kruskal Wallis Test
b. Grouping Variable: Training

Ranks

Training N Mean Rank

training program 1 10 13.00

sales training program 2 10 17.30

training program 3 10 16.20
Total 30
OUTPUT:

Correlation
age Exam scores

Pearson Correlation 1 .893**

Age Sig. (2-tailed) .000

N 15 15
Pearson Correlation .893** 1

Exam scores Sig. (2-tailed) .000

N 15 15

**. Correlation is significant at the 0.01 level (2-tailed).

Regression
Variables Entered/Removed b

Variables Variables
Model Summary
Model Entered Removed Method
1
age of a . Enter
Adjusted Std. Error of
employees Model R R Square R Square the Estimate
a. All requested variables entered. 1 .893a .798 .782 5.57
b. Dependent Variable: exam scores a. Predictors: (Constant), age of employees

ANOVAb

Sum of
Model Squares df Mean Square F Sig.
1 Regression 1593.752 1 1593.752 51.337 .000a
Residual 403.581 13 31.045
Total 1997.333 14
a. Predictors: (Constant), age of employees
b. Dependent Variable: exam scores

Coefficientsa

Standardi
zed
Unstandardized Coefficien
Coefficients ts 95% Confidence Interval for B
Model B Std. Error Beta t Sig. Lower Bound Upper Bound
1 (Constant) 33.231 6.457 5.146 .000 19.281 47.181
age of employees 1.230 .172 .893 7.165 .000 .859 1.601
a. Dependent Variable: exam scores

Coefficient Correlations a

age of
Model employees
1 Correlations age of employees 1.000
Covariances age of employees 2.947E-02
a. Dependent Variable: exam scores
OUTPUT

Row Labels Sum of Sales Row Labels Sum of Sales

Brown 8120
Qtr1 29569
Johnson 24139
Qtr2 23238
Jones 18036
Qtr3 51929
Smith 45370
Qtr4 48180
Williams 57251
Grand Total 152916 Grand Total 152916

Row Labels Sum of Sales

Row Labels Sum of Sales Brown 8120
USA 8120
UK 75909 Johnson 24139
UK 9339
USA 77007 USA 14800
Jones 18036
Grand Total 152916 UK 7433
USA 10603
Smith 45370
UK 16753
USA 28617
Williams 57251
UK 42384
USA 14867
Grand Total 152916
OUTPUT

(i)

Salesperson Region Monthly Sales Target Sales

Alice North 45,000 50,000
Bob South 55,000 50,000
Charlie East 30,000 40,000
David West 60,000 55,000
Emma North 35,000 45,000
Frank South 50,000 50,000
Grace East 48,000 50,000
Harry West 70,000 60,000
Annie North 55,000 50,000
Bobby South 45,000 40,000
Charulatha East 60,000 50,000
Daivana West 65,000 55,000
Smitha North 39,000 45,000

(ii)

Salesperson
Region Monthly Sales Target Sales
Alice North 45,000 50,000
Bob South 55,000 50,000
Charlie East 30,000 40,000
David West 60,000 55,000
Emma North 35,000 45,000
Frank South 50,000 50,000
Grace East 48,000 50,000
Harry West 70,000 60,000
Annie North 55,000 50,000
Bobby South 45,000 40,000
Charulatha East 60,000 50,000
Daivana West 65,000 55,000
Smitha North 39,000 45,000
(iii)

Salesperson Region Monthly Sales Target Sales

Alice North 45,000 50,000
Bob South 55,000 50,000
Charlie East 30,000 40,000
David West 60,000 55,000
Emma North 35,000 45,000
Frank South 50,000 50,000
Grace East 48,000 50,000
Harry West 70,000 60,000
Annie North 55,000 50,000
Bobby South 45,000 40,000
Charulatha East 60,000 50,000
Daivana West 65,000 55,000
Smitha North 39,000 45,000
Employee Employee Basic LOP Net
Designation City DA TA HRA CCA Gross Pay LOP
Code Name Pay Days Pay

GKR001 Edison Senior Manager Chennai 55000 5500 2500 33000 2000 98000 2 6533 91467
GKR002 Anand Senior Executive Chennai 40000 4000 0 20000 64000 0 0 64000
GKR003 Jeeva Programmer Trainee Delhi 20000 2000 0 10000 32000 1 1067 30933
GKR004 Jhansi Programmer Trainee Bengaluru 20000 2000 0 10000 32000 0 0 32000
GKR005 Vijay Programmer Trainee Cochin 15000 1500 0 7500 24000 0 0 24000
GKR006 Prema Marketing Manager Bengaluru 48000 4800 2500 28800 2000 86100 0 0 86100
GKR007 Sanjay Marketing Executive Chennai 30000 3000 0 15000 48000 2 3200 44800
GKR008 Lalitha Marketing Executive Delhi 30000 3000 0 15000 48000 1 1600 46400
GKR009 Geetha HR Manager Cochin 35000 3500 2500 21000 2000 64000 1 2133 61867
GKR010 Ram HR Trainee Cochin 20000 2000 0 10000 32000 1 1067 30933
OUTPUT:
ABC College of Arts and
Science
[Link] STATS ECO O.R O.B CS AC LEB TOT % P/F RANK

ANJALI 51 50 60 53 65 75 58 412 58.8 P SECOND

BEENA 65 45 35 20 55 38 25 283 40.4 F FAIL

CHITRA 76 72 65 85 63 84 73 518 74 P DIST

DEEPA 25 35 56 62 58 59 83 378 54 F FAIL

ESHA 92 84 65 78 58 69 67 513 73.2 P FIRST

OUTPUT:
CALCULATION OF ROI

LOAN 100000

EMI 3000

ROI 3

OUTPUT:
CALCULATION OF FUTURE VALUE

PAYMENT 1000

RATE OF INTEREST 12%

YEARS 2

FUTURE VALUE 1690.05.

OUTPUT:
CALCULATION OF FUTURE VALUE

PAYMENT 1000

RATE OF INTEREST 12%

YEARS 2

FUTURE VALUE 26973.46

OUTPUT:

YEAR CASH FLOW PV@10

NPV
0 C0 -2378 1 -2378
1 C1 500 0.909 454.5
2 C2 900 0.826 743.4
3 C3 550 0.751 413.05
4 C4 478 0.683 326.474
5 C5 950 0.621 589.95
TOTAL 149.374
OUTPUT:
OFFER LETTER
Date: 01/03/2024
Ms Preethi
Candidate 1, Area 1
Chennai
600089

Dear Preethi,
We are pleased to offer you the position of Finance Manager at SBI. We feel confident that you will
contribute your skills and experience to the growth of our organization.
As per the discussion your starting date will be on 10/04/2024. Please confirm your acceptance of this
offer by signing and returning the copy of this offer letter.
We look forward to welcoming you on board.
Sincerely,
SBI
Rakesh
HR SBI OFFER LETTER

OFFER LETTER

Date: 02/03/2024
Mr Tharun
Candidate 2, Area 2
Tiruvallur
600021

Dear Tharun,
We are pleased to offer you the position of Data Analyst at TCS. We feel confident that you will
contribute your skills and experience to the growth of our organization.
As per the discussion your starting date will be on 11/04/2024. Please confirm your acceptance of this
offer by signing and returning the copy of this offer letter.
We look forward to welcoming you on board.
Sincerely,
TCS
Vikas
HR TCS
OUTPUT
OFFER LETTER
Date: 3/20/2024
Mr Karthick
Candidate 1, Area 1,
Chennai
600076

Dear Karthick,
We are pleased to offer you the position of System Engineer at Infosys. We feel confident that you
will contribute your skills and experience to the growth of our organization.
As per the discussion your starting date will be on 4/2/2024. Please confirm your acceptance of this
offer by signing and returning the copy of this offer letter.
We look forward to welcoming you on board.
Sincerely,
Infosys
Chandra
HR Infosys
OFFER LETTER
Date: 3/21/2024
Ms Sathya
Candidate 2, Area 2,
Coimbatore
600234

Dear Sathya,
We are pleased to offer you the position of Technology Lead at Wipro. We feel confident that you
will contribute your skills and experience to the growth of our organization.
As per the discussion your starting date will be on 4/3/2024. Please confirm your acceptance of this
offer by signing and returning the copy of this offer letter.
We look forward to welcoming you on board.
Sincerely,
Wipro
Vikas
HR WiproS