[go: up one dir, main page]
Scribd
Upload
183 views2 pages

Sse Test-1

The document is an internal test for engineers with 7 questions covering various data analysis and calculation tasks. It includes drawing a scatter graph with trend line and equation, computing summary statistics, evaluating data using logical conditions, computing a regression chart and model equation, finding roots of an equation, solving a system of equations using matrix multiplication, and calculating employee counts. The test has a total of 100 marks and is scheduled from 8:40 AM to 11:40 AM on December 9, 2023.

Uploaded by

Dr-Bharath Vedashantha Murthy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
183 views2 pages

Sse Test-1

The document is an internal test for engineers with 7 questions covering various data analysis and calculation tasks. It includes drawing a scatter graph with trend line and equation, computing summary statistics, evaluating data using logical conditions, computing a regression chart and model equation, finding roots of an equation, solving a system of equations using matrix multiplication, and calculating employee counts. The test has a total of 100 marks and is scheduled from 8:40 AM to 11:40 AM on December 9, 2023.

Uploaded by

Dr-Bharath Vedashantha Murthy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SPREAD SHEET FOR ENGINEERS

INTERNAL TEST-1
DATE: 12/09/2023 MARKS: 100 TIME: 8.40 TO 11.40 AM
1. Draw scatter graph for the given data. (2% Error, trend line and equation)

X Y
1 0.5
2 2
5 3.5
7 4
10 5
11 6
13 9
10 MARKS
2. Compute the sum, average, max, min, count for the given data.
70
73
77
82
91
55
60
63
10 MARKS

3. Evaluate the given data using AND condition. Use the condition: Marks >=40 and <=75.

Marks
43
55
15
80
73
23
60
25
10 MARKS

4. Compute regression chart for the given date. Write model equation.

X Y
1 9
2 13
3 17
4 21
5 25
15 MARKS
5. Find the roots of the given equation. F(x)=-x3-x2+0.1. 10 MARKS
6. Find X,Y and Z values for the given equation(matrix multiplication).
3X+4Y+2Z=5
4X+7Y+3Z=15
5X+3Y+4Z=3
20 MARKS
7. a) Calculate the number of employees in the accounting department
b) Calculate the number of employees with a salary greater than 15000 (remember the quatation
marks aroud the entire criteria) 25 MARKS

You might also like