COMPUTING LABORATORY

20MSS16

NAME:AAKASH B
ROLL NO.:71762231001
EX NO:01WORD EXERCISES

DATE:27/10/2022 CREATING CV

QUESTION:
Create your CV in MS word and save the document in a folder of your name. List out all the
features used for creating CV

AIM:
Creating editing saving and printing text documents MS word curriculum vitae

PROCEDURE:
Step 1: Open MS word type the title of the document as curriculum vitae
Step 2: Go to home select the heading curriculum Etta and change the font to Cambria
heading and underline the text
Step 3: Change the heading size to 20
Step 4: Use bold letters of size 18 to type all the sub-headings in the font Calibri body.
Step 5: Now use italic letters of size 18 and type the details of the respective subheadings.
Step 6: We insert a table using insert option.
Insert table select number of rows and columns.
OUTPUT:

RESULT: We have a created a curriculum vitae using word.

EX NO: 2

DATE:29/10/2022 EDITING YOUR CV

QUESTION:
Edit the previous CV document and upload list out all the changes made and features used
for editing the CV

AIM:
Font and paragraph formatting simple character formatting

PROCEDURE:
Step 1: Open the saved file and start to edit the previous CV document
Step 2: Click page layout and then click page colour to change the page colour into peach
Step 3: And then click page Layout to add a watermark in the resume as "Resume"
Step 4: Change the font colour on the title as dark blue
Step 5: And change the font colour in the subheadings as green and the remaining words as
like light green
OUTPUT

RESULT:
We have edited our cv through word.
EX NO:3

DATE:29/10/2022 CLASS TIME TABLE

QUESTION:
recreate your class time table

AIM:
Inserting tables smart art page breaks

PROCEDURE:
Step 1: Open MS Word and type the title of the time table click shading to colour the
background of the title
Step 2: Click insert and then click tables to create a table for the time table
Step 3: Change the font style and font size for day and time as arial rounded MT bold font
style with 36 size to make it highlight
Step 4: In table tools click design to erase one column to write the lunch break as vertically
Step 5: Except day and time tide the subjects with Calibri font style and with font size 14
Step 6: Then save the file as time table
OUTPUT:

RESULT:
Class timetable is created using word.
EX NO:4

DATE:3/11/2022 CREATING A MAGAZINE

QUESTION:
create a magazine and do necessary formatting

AIM:
To add necessary images, page numbers, split text in two columns in first page, split text in
multiple columns in next page, cover page must have an image with caption

PROCEDURE:
Step 1: Open MS Word and start to create a magazine
Step 2: Click insert and then click page cover and select Puzzle for the cover page
Step 3: Add an image by clicking insert and then by clicking clip art and then type a caption
to the image
Step 4: To add page numbers click page number in insert and select Accent bar 1
Step 5: Click page layout and then click column and select two to split text two columns in
first page
Step 6: To change the page colour click page colour by clicking page layout and select grey
Step 7: To add a page border click page layout and page border and then select Shadow
Step 8: Then save the document
OUTPUT
:

RESULT: Magazine is successfully created through word.

EX NO:5

DATE:7/11/2022 SPELL CHECK

QUESTION:
Check the spelling and grammar of the text in MS word

AIM:
To use the “Spelling & Grammar” option in MS Word.

PROCEDURE:
Step 1: On the navigation menu bar click on the Review option
Step 2: Next click on the spellings & grammar option
Step 3: If there is a spelling mistake in the document then it will appear in the red underline
text
Step 4: Select the correct spelling from the suggestion menu.
Step 5: Next click on the YES option.

RESULT:
The spelling and grammar check is completed through word.
EX NO:6

DATE:7/11/2022MAIL MERGE

QUESTION:
Do mail merge with the help of MS word

AIM:
To understand & implement the concept of Mail Merge in MS Word

PROCEDURE:
Step 1: Open MS Word and click on the command sequence: Mailings tab → Start mail
merge group → Select recipients’button → Type new List.
Step 2:The second step is to prepare our master letter for use in the mail
merge. Before we enter all the letter text,we would like to link this Word file to
our list of names.
Step 3: Click Mailings tab → Start Mail Merge group → Start Mail Merge
→ Letters command.
Step 4: Mailings tab→ Write & Insert Field group → Insert Merge Field button. A pop-
down will appear showing all the table headings, so choose Title and press the spacebar to
create a space.
Step 5:Before we actually carry out the merge, we must first preview what the merged letters
will look like. Mailings tab→ Preview Results group → Preview Results button
Step 6: Once we are happy with the preview, you can carry out the actual mail merge. To do
this you click the Mailings tab → Finish group → Finish & Merge button and choose Edit
Individual Documents.
Step 7: Once you click OK all mails will be sent to corresponding address.

RESULT:
The mail merge is done successfully.
EX NO:7 POWERPOINT EXERCISE

DATE:10/11/2022 POWERPOINT RESUME

QUESTION:
Create a resume in PowerPoint

AIM:
To create an attractive PowerPoint using different features

PROCEDURE:
Step 1: Create a new PowerPoint document
Step 2: Give the title resume and the subtitle in the first slide
Step 3: Go to design under themes select opulent
Step 4: Under home (slides) new slide content with caption
Step 5: Add your photo and type out name date of birth and other details
Step 6: In new slide comparison layout can be used to enter the 10th and 12th marks
Step 7: In design background style style || can be used to change the texture of the
background
Step 8: Under animations transition to this slide dissolve can be used to add effect
to the emergence of a new slide
Step 9: Animation transition speed can be adjusted based on the need
Step 10: Under insert picture or clip are image can be inserted
Step 11: Insert word art can be used to display the text in different forms
Step 12: Slideshow from beginning can be used to preview the PowerPoint presentation
Step 13: Save the document by giving a suitable title
OUTPUT
RESULT:
A resume is created in PowerPoint.
EX NO:8 EXCEL EXCERSISES

DATE:14/11/2022 STUDENT MARKSHEET

QUESTION:
To create a student marksheet

AIM:
To develop a student marksheet using column headings registration number name average
subject rank result total and grade

PROCEDURE:
Step 1:Open MS Excel and create a new document
Step 2:In the First row give the column headings as registration number name average
subject rank result total and grade
Step 3:Type the registration number name and subject marks any number of subject columns
can be inserted

FORMULAS USED:
 To find the total: formulas Autosum sum
 To find the average: formulas Autosum average
 To find the result: type the condition in function box =IF (B1<75, "FAIL"." PASS")
 To find the rank: =RANK (I2, $1, $2; $I$11, 0)
 To find the grade: =IF(A1>=200, "A”. IF(A1>=150, " B", IF(A1>=100, "C",
IF(A1>=50, " D", "F"))))

OUTPUT
RESULT:
A student marksheet is created.
EX NO:9

DATE:17/11/2022 EMPLOYMENT PAY SLIP

QUESTION:
To create income tax of employees and to create employment pay slip

AIM:
To create employment pay slip using proper formulas

PROCEDURE:
Step 1:Open MS Excel and create new document
Step 2:Type the heading in each column
Step 3:Fill the employee number and name in the respective rows and column

FORMULAS USED:
 In decrease allowance column give (=30%*G2)
 In house rent allowance give the formula(=8%*H2)
 In medical allowance give the formula (=5%*F2)
 In provident fund give the formula (=12%*I2)
 In gross pay give the autosum option
 In tax percentage give the formula (=15%k2)
 In net pay give the formula as (=J2 - K2)
OUTPUT

RESULT:
The desired employment pay slip is created.
EX NO:10

DATE: 17/11/2022SALARY SHEET

QUESTION:
Create a salary sheet of 25 employees

AIM:
To perform simple calculations like sum, max, min, average, mean, median, standard
deviation

PROCEDURE:
Step 1:Open MS Excel and create a new Excel sheet
Step 2:Give name and salary to 25 employees
Step 3:All the functions will be available in formulas more function
Step 4:Save the document

FORMULAS USED:
 To calculate the sum use: =SUM () function
 To calculate maximum and minimum use: =MAX () and =MIN () function
 To calculate average use: =AVG () function
 To calculate median use: =MEDIAN () function
 To calculate standard deviation use: =STDEV () function
OUTPUT:
RESULT:
The salary sheet is created.

EX NO:11

DATE:17/11/2022 RANDOM VALUES

QUESTION:
Generate random values

AIM:
To generate random values using different functions of Excel

PROCEDURE:
Step 1:Open MS Excel and create a new document
Step 2: To generate random values in excel use Rand function
Step 3:In case if you want to set boundaries use rand between function
Step 4:Save the document

FUNTIONS USED:
 =RAND ()
 =RAND BETWEEN (10:50)
OUTPUT:

RESULT: The random values are generated.

EX NO:12

DATE:17/11/2022 ASCENDING AND DESCENDING ORDER

QUESTION:
Arrange the following data in ascending and descending order
4.6, 8.1, 2.0, 3.5, 0.7, 9.3 1.4, 0.8, 8, 3 ,11, 15, 0, 7, 2, 24, 9, 12

AIM:
To arrange the following data in ascending and descending order using proper function

PROCEDURE:
Step 1:Open MS Excel and create a new document
Step 2:Type the given data in a column
Step 3:To arrange them in ascending order, go to home editing sort smallest to largest.
The data will be arranged in ascending order
Step 4:To arrange in descending order, go to home editing sort largest to smallest. The
data will be arranged in descending order
Step 5:Save the document
OUTPUT:

RESULT: The data is sorted in ascending and descending order.

EX NO:13

DATE:21/11/2022 MATRIX IN EXCEL

QUESTION:
Do the following properties of addition for 3x3 matrix
 commutative law
 associative law
 identity of matrix
 additive inverse

AIM:
To create a 3x3 matrix and perform the following properties

PROCEDURE:
Step 1:Open MS Excel
Step 2:Give a matrix name A and give 9 values and assign the 9 values names as A
Step 3:Follow the same steps for Band C matrix and identity matrix

FORMULAS USED:
 For competitive property =A + B and B + A
 for associative property (A+ B) + C and A+(B+C)
 for additive inverse (-A)

OUTPUT:
RESULT:
The given matrices are verified in excel.

EX NO:14

DATE:21/11/2022PIE CHART AND COMPONENT BAR CHART

QUESTION:

Create a pie chart and component percentage bar chart 

SUBJECT           PLAN A (IN CRORES) PLAN B (IN CRORES)

AGRICULTURE      361                                 529

IRRIGATION 561 865

&POWER

MINERALS              292                               900

TRANSPORT          497                               1300

VILLAGE &             176                                200

SMALL INDUSTRIES

AIM:
To create pie chart and bar chart by inserting them

PROCEDURE:
FOR PIE CHART:

Step 1:Open MS Excel

Step 2:Input the above data in the Excel sheet select the first data
Step 3:In insert charts pie chart 2D pie
Step 4:Select the column B and insert the same chart for plan B
Step 5:Now format the charts using design tab
Step 6:Save the file
FOR COMPONENT BAR CHART:

Step 1:Open MS Excel

Step 2:Input the above data as rows and columns in excel
Step 3:Select the data and in insert charts bar 2D 100% bar
Step 4:In design tab chart styles and change the style of the chart
Step 5:Save the file by
office button save as percentage bar chart save
OUTPUT:

RESULT:
A pie chart and component bar chart is created for the given data.
EX NO:15

DATE:23/11/2022 COUNTING THE ERROR

QUESTION:
Create an array formula that counts the number of errors in a range

AIM:
To count the errors using appropriate function

PROCEDURE:
Step 1:Open MS Excel
Step 2:Create a range of random numbers
Step 3:Give backspace for some number then type special characters in that box, an error
will be generated
Step 4:Type the correct formula and give enter
Step 5:Save the document

FORMULAS USED:
To generate random numbers: =RANDBETWEEN()
To count the number of errors: =COUNT(IF(ISERROR(A1:A5),1,””))

OUTPUT:

RESULT:
The number of errors is found through excel.
EX NO:16

DATE:23/11/2022 FREQUENCY TABLE

QUESTION:

Construct the frequency table for each of the following .

a. 4,3,6,5,2,4,3,3,6,4,2,3,2,2,3,3,4,5,6,4,2,3,4
b. 6,7,5,4,5,6,6,8,7,9,6,5,6,7,7,8,9,4,6,7,6,5

AIM:
To create frequency table for the given data

PROCEDURE:
Step 1: Create a new document in MS Excel type of the given data in a column (A2 to A24)
Step 2: For the bins give the upper limit as data in a column (B2 to B3)
Step 3: Select the cell parallel to the Bin values to enter the formula
Step 4: Do the same for data in (b). Save the document

FORMULA USED:
 To find the frequency range: =FREQUENCY (A2:A24, B2:B3)
RESULT:
The frequency table is constructed.

EX NO:17

DATE:24/11/2022 GROUPED DATA

QUESTION:

The marks obtained out of 25 by 30 students of a class in the examination are given below .

20,6,23,19,9,14,15,3,1,12,10,20,13,3,17,10,11,6,21,9,6,10,9,4,5,1,5,11,7,

24.Reprsent the above data as a grouped data taking the class interval 0-5

AIM:
To represent the above information as grouped data

PROCEDURE:
Step 1:Open a new document in MS Excel
Step 2:Type the students mark in one row and align them properly
Step 3:Now create a class interval for the following data starting from 0 to 5
Step 4:Let the class interval be 0 to 5, 6 to 10, 11 to 15, 16 to 20, 21 to 25
Step 5:Use the formula to find frequency and save the document

FORMULA USED:
 To find the frequency: =FREQUENCY(A1:A31, B2:B3)
 

RESULT:
The above given information is represented as grouped data.

EX NO:18

DATE:29/11/2022 MEAN OF VALUES

QUESTION:
Find the mean of the following data. 

(a) 9, 7, 11, 13, 2, 4, 5, 5 

(b) 16, 18, 19, 21, 23, 23, 27, 29, 29, 35 

(c) 2.2, 10.2, 14.7, 5.9, 4.9, 11.1, 10.5 (d) 11/4, 21/2, 51/2, 31/4, 21/2 

AIM:
To find the mean of the above data

PROCEDURE:
Step 1:Open MS Excel and create a new document
Step 2:Type the values given
Step 3:Now in a new cell type the formula to find the mean
Step 4:The mean of the values is displayed
Step 5:Repeat the same for B C D also
Step 6:Save the document

RESULT:
The mean of the values is found through excel.
EX NO:19

DATE:29/11/2022 FINDING UNKNOWN VALUE

QUESTION:

The mean of 8, 11, 6, 14, x and 13 is 66. Find the value of the observation x.

AIM:
To find the unknown value in the given range

PROCEDURE:
Step 1:Open MS Excel
Step 2:Enter values and in X place assign X some value of your own
Step 3:Now find its mean using the formula and press enter the mean will be printed
Step 4:Go to data what if analysis goal seek
Step 5:Goal seek dialogue open in set cell give A7 and to value give 66 and by changing cell
give the name of the cell where you added random values
Step 6:Enter the value of x will be updated that
Step 7:Save the document
RESULT:
the unknown value is successfully found.
EX NO:20

DATE:29/11/2022 MEAN, MEDIAN AND MODE

QUESTION:

The runs scored in a cricket match by 11 players is as follows:

7, 16, 121, 51, 101, 81, 1, 16, 9, 11, 16

Find the mean, mode, median of this data.

AIM:
To find the mean, median and mode of the above data

PROCEDURE:
Step 1:Open new document
Step 2:Enter the values
Step 3:To find mean select the range of cell and give the formula
Step 4:To find median select the cell to give median value and type the formula
Step 5:To find mode select the cell to type mode and type the formula
Step 6:Save the document

RESULT:The mean, median and mode is found through excel.

EX NO:21

DATE:29/11/2022 MEAN OF TABLES

QUESTION:

Find the mean of the following Distribution

(a) The age of 20 boys in a locality is given below.

Age in Years 12 10 15 14 8

Number of 5 3 2 6 4
Boys
 
 
(b) Marks obtained by 40 students in an exam are given below.
Marks 25 30 15 20 24

Number of 8 12 10 6 4
Students
 
 
(c)
x 1 2 3 4 5
i

fi 4 5 8 1 3
0
 
 
(d) The daily wages of 50 employees in an organization are given below:
Daily wages (in $) 100 - 150 150 - 200 200 - 250 250 - 300

Number of Workers 12 13 17 8
 
 
Find the mean daily wages. 

AIM:
To find the mean of the above given tables
PROCEDURE:
Step 1: Open MS Excel and open a blank worksheet as
Step 2:Enter the values in columns in the next column give the name xifiand multiply the
columns with formula for example: A2*B2
Step 3: Sum thetotal of the second and third column using autosum in home
Step 4:Select a cell to give the output of mean and give the formula of C7/ b7.The mean will
be displayed
Step 5:Save the document
OUTPUT:

RESULT:
The mean of the corresponding tables is found.

EX NO:22
DATE: 29/11/2022 RANGE AND QUARTILE

QUESTION:
From the following data 
a. Range and coefficient of range  
b. Quartile deviation and coefficient of Quartile deviation 

MONTH 1 2 3 4 5 6 7 8 9 10 11 12
SALES’ 1000 Rs 78 80 80 82 84 86 84 86 86 88 88 90

AIM:
To find range, coefficient of range, quartile deviation, and coefficient of quartile deviation
for the given data

PROCEDURE:
Step 1:Open MS Excel
Step 2:Fill in the given data
Step 3:Find the maximum and minimum values of the given data
Step 4: Range is identified by the difference between maximum and minimum value
Step 5:Coefficient of range is found using a formula
Step 6:Quartile deviation is found using quartile function
Step7:Here we need Q3 and Q1 so we calculate these both
Step 8:The coefficient of quartile is calculated with the help of Q3 and Q1
Step 9:Save the document

FORMULAS USED:
 Coefficient of range: max-min/min+max
 Quartile deviation: =QUARTILE(A1:A3,1)
 Coefficient of quartile: Q3-Q1/Q3+Q1
 OUTPUT:

RESULT:
All the four properties given in the question are found.
EX NO:23

DATE:8/12/2022 FREQUENCY, MIDPOINT AND RANGE

QUESTION:

Prepare the frequency distribution table for the given set of scores:

39, 16, 30, 37, 53, 15, 16, 60, 58, 26, 28, 19, 20, 12, 14, 24, 59, 21, 57, 38, 25, 36, 24,

15, 25, 41, 52, 45, 60, 63, 18, 26, 43, 36, 18, 27, 59, 63, 46, 42, 48, 35, 64, 24.

Take class interval as (10-20), (20-30) . . . . . . and answer the following:

I. What does the frequency corresponding to the third-class interval mean?

II. What is the size of each class interval? Find the midpoint of the class interval 30-40.

III. What is the range of the given set of scores?

AIM:
To find frequency, size, midpoint, and range of the given data

PROCEDURE:
Step 1:Enter the given values in the column “score” and create another column named “bin”
to enter the intervals
Step 2:Click Excel options click add-ins go analysis tool pakanalysis tool pak VBA
Step 3:In the tab “data” click data analysis and select histogram
Step 4: In the box of the input range, select the column of scores, in the box of the column
bin select the column bin and select an empty range of cells where you want the histogram
Step 5: Save the document

FORMULAS USED:
Used the function: MAX(), MIN(), RANGE= MAX-MIN
RESULT:
The frequency, size, midpoint, and range of the given data is found.
EX NO:24

DATE:8/12/2022 STUDENT’S BODY WEIGHT

QUESTION:

Data: Student’s body weight (kg):

41 60 72 72 65 64 48 90 60 75 53 48 63 49 58 39 39 75 55 62 53 59 58 38 72 62 60 59 68 60
70 60 56 80 65 85 71 45 70 55

Make the frequency distribution table of the above data. Calculate range and frequency for
the same.

AIM:
To calculate range, frequency and to make a frequency table for the above data

PROCEDURE:
Step 1: Create a new document in MS Excel
Step 2:Type of the given data
Step 3:Make a class interval by taking as 10 (35-45)
Step 4:Find the upper limit of the class interval and type them for the corresponding class
interval
Step 5:To find the frequency of the following give the corresponding function and press
ctrl+shift+enter
Step 6:Find the maximum and minimum value of the data
Step 7:Range can be found using the highest value - lowest value
Step 8:Maximum - minimum gives the range
Step 9:Save the document
 OUTPUT:

RESULT:
Range and frequency is found and frequency table is constructed.
EX NO:25

DATE:8/12/2022 MILEAGE

QUESTION:

EPAGAS - The Environmental Protection Agency (EPA) perform extensive tests on all new
car models to determine their mileage ratings. The 25 measurements given below represent
the results of the test on a sample of size 25 of a new car model.

EPA mileage ratings on 25 cars are 36.3 41.0 36.9 37.1 44.9 40.5 36.5 37.6 33.9 40.2 38.5
39.0 35.5 34.8 38.6 41.0 31.8 37.3 33.1 37.0 37.1 40.3 36.7 37.0 33.9. 

Construct Frequency Distribution table for the same by using 5 intervals of equal length.

Include the left end point and omit the right end point.

AIM:
To construct frequency table for mileage ratings of cars

PROCEDURE:
Step 1:Open MS Excel and create a new document
Step 2:Type the data given in the question
Step 3:We are told to divide into 5 intervals of equallength
Step 4:If we start at 30.0 and use intervals of length 3, 5intervals can be used
Step 5:Now find upper limit values for the class interval
Step 6:Frequency is found using the frequency function
Step 7:Save the document

FORMULA USED:
 =FREQUENCY(A1:A5,B1:B5)
OUTPUT:

RESULT:
The desired frequency table is constructed.
EX NO:26

DATE:8/12/2022 TRANSPOSE OF A MATRIX

QUESTION:

Transpose a 2x3 Matrix to create  a 3x2 Matrix

AIM:
To find transpose of a matrix using appropriate function

PROCEDURE:
Step 1:Create a new MS Excel document
Step 2:In a new spreadsheet type a new matrix of 2 x 3
Step 3:Type the elements in the 2 x 3 matrix and select the whole 2 x 3 column and row and
name it as A
Step 4:The matrix is transposed using the corresponding function
Step 5:Save the document

FORMULA USED:
 =TRANSPOSE(A)

RESULT:
The matrix’s transpose is found.
EX NO:27 PIVOT TABLE

DATE:8/12/2022 SALES PERSON

QUESTION:

Create a new PivotTable 

 Add fields to a PivotTable  

Format and rename PivotTable fields  

Rearrange PivotTable fields 

 Remove fields from a PivotTable

AIM:
To create a pivot table with the above given properties

PROCEDURE:
Step 1: Create a new document
Step 2:Type of the given data in a column
Step 3:To create a pivot table
insert figure table
Step 4:In the dialogue box select the data you want in pivot table and where the pivot table
to be placed
Step 5:Once the table is created, pivot table field will appear with will contains column
name of sales person, zone and sales made
Step 6:Drag and drop the sales person column and zones column to the row field and the
sales to the value field
Step 7:Apivot table is thus created with separated data of each sales person
Step 8: To perform different queries under the pivot fields click on the sales field under
values value field settings choose the type of summary you want
Step 9:Save the document
RESULT:
The desired pivot table is created.
EX NO:28

DATE:8/12/2022 LOOKUP TABLE

QUESTION:
Create a lookup table

AIM:
To create a lookup table with any of our desired information

PROCEDURE:
Step 1:Open MS Excel
Step 2:Type of the given values in rows and columns
Step 3:Go to view new window
Step 4:In a new window select afresh cell and give the function of VLOOKUP
Step 5:This look up function we have to select a reference column or cell, the table the
column we need and 0 to display the exact value
Step 6:Lookup function is used to search for a piece of data in a row or column and return it
in another row or column
Step 7:Press ctrl + shift + enter to display the required data
Step 8: Save the document

FUNCTION USED:
 =VLOOKUP(A2:A11,A2:G11,6,0)

RESULT:
A VLOOKUP table is created.
EX NO:29

DATE:8/12/2022 FREQUENCY OF WEIGHTS

QUESTION:

The frequency distribution of weights (in kg) of 40 persons is given below .

WEIGHTS (IN KG): 30-45 35-40 40-45 45-50 50-55

FREQUENCY: 6 13 14 4 3

a)What is the lower limit of 4th class interval.

b)what is the class size of each class interval.

c)which class interval has the highest frequency.

AIM:
To find the above a), b) and c) from the given frequency table

PROCEDURE:
Step 1:Create a new document in excel
Step 2:Type of the given data in columns
Step 3:Find the lower limit using appropriate formula
Step 4:The size of each class interval can be found using the upper limit - lower limit
Step 5:To find which class interval has the highest frequency we can use the maximum
function in the f(x) box
Step 6:Class mark is also found through formula
Step 7: Save the document

FORMULAS USED:
 To find lower limit: =MID(E5,1,FIND(“-“,E5,1)-1)
  Class mark: lower limit + upper limit / 2
 MID(E5,1,FIND(“-“,E5,1)-1) + MID(E5,1,FIND(“-“,E5,1)+1) / 2

RESULT:
The following a), b) and c) is found through frequency table.
EX NO:30

DATE:8/12/2022 MONTHLY EXPENDITURE

QUESTION:
The following data gives the distribution of total monthly household expenditure of families
in a village.

EXPENDITURE (IN Rs) NUMBER OF FAMILIES

2000-2500 11

2500-3000 27

3000-3500 43

3500-4000 55

4000-4500 31

4500-5000 23

5000-5500 14

5500-6000 7

Construct the following: harmonic mean, standard deviation, variance, histogram, frequency
curve/ polygon

AIM:
To construct the following charts given in the question

PROCEDURE:
Step 1: Create a new document in MS Excel
Step 2:Enter the data into the cells
Step 3:Standard deviation, harmonic mean and variance is found using corresponding
formula
Step 4:Select all the data insert histogram. So a histogram is created
Step 5: Select the data again and insert scatter with straight lines
Step 6:Save the document

FORMULAS USED:
 Harmonic mean: =HARMEAN(B2:B9)
 Standard deviation: =STDEV(B2:B9)
 Variance: =VAR(B2:B9)

RESULT:
The following properties given in the question is found.