Scribd
Upload
14 views2 pages

Practical 1

The document outlines a practical exercise for creating a two-way frequency table in MS Excel based on survey data from 12 students regarding their favorite sports and preferred days. It provides step-by-step instructions for entering data, applying the COUNTIFS function, and calculating totals for rows and columns. The exercise aims to help users visualize the relationship between sports preferences and days of play using Excel tools.

Uploaded by

Raman Reddy
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
14 views2 pages

Practical 1

The document outlines a practical exercise for creating a two-way frequency table in MS Excel based on survey data from 12 students regarding their favorite sports and preferred days. It provides step-by-step instructions for entering data, applying the COUNTIFS function, and calculating totals for rows and columns. The exercise aims to help users visualize the relationship between sports preferences and days of play using Excel tools.

Uploaded by

Raman Reddy
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

PRACTICAL-1

AIM: CREATING TWO-WAY FREQUECY TABLE USING MS EXCEL


1]A group of 12 students have been asked about their favorite sport
and the day of the week they prefer to play it. The data collected is as
follows:

Create a two-way frequency table to show how many


students prefer to play each sport on each day of the week
FORMULA/FUNCTION USED
=COUNTIFS(A1:A10, "Row_Criteria", B1:B10, "Column_Criteria")
STEP-1
Enter the given table in MS Excel with the following columns:
• Column A: Student (1 to 12)
• Column B: Favorite Sport (e.g., Football, Basketball, Cricket)
• Column C: Preferred Day (e.g., Monday, Tuesday, Wednesday)
STEP-2:
Create the layout and apply the formula:
• In a new section of the sheet:
o List unique values from Favorite Sport vertically as row
categories (leftmost column)
o List unique values from Preferred Day horizontally as
column categories (top row)
• At each intersection of a sport and day, apply:
• =COUNTIFS(B3:B14,G6,C3:C14,H5)
STEP-3:

Copy the formula across the table to complete the frequency values.
Then, calculate totals:

• Row totals: Use =SUM() across each row


• Column totals: Use =SUM() down each column

Resulting Two-Way Frequency Table:

You might also like