Vizly: Analysis of Sources of Information about Cervical Cancer

Analysis of Sources of Information about Cervical Cancer

Jul 17, 2024, 3:14 PM

Ai data question 20.xlsx

Missing file

From where did you get to know about cervical cancer analyse each option seperately with each responses because it is multiple choice one person can select more than one options so analyse seperately.

Analysis of Sources of Information about Cervical Cancer

The data has been analyzed to determine the different sources from which people got to know about cervical cancer. Here are the counts for each option:

Option	Count
Social media	1510
College	723
Family or friends	656
Public health advertisements	605
School	548
Healthcare provider	312
	3
Books	2
Self reading	1
Newspaper	1
Social media	1
BOOKS	1
At CISF camp	1
Books	1
Part of my previous course	1
By Google search	1
Google Surfing	1
Internet	1
Magazines	1
Study	1

It appears that the most common sources of information are Social media, College, Family or friends, Public health advertisements, and School.

Would you like to visualize this data? If you have any other questions or need further analysis, feel free to ask!

Give me detail of sno.6 it is taken from which serial number of excel

The rows with empty options for the source of information about cervical cancer are from the following serial numbers in the Excel file:

Serial Number 189
Serial Number 731
Serial Number 2495

These rows have no specified source of information.

From where did you get to know about cervical cancer analyse each option seperately with each responses because it is multiple choice one person can select more than one options so analyse seperately.

The analysis of the sources of information about cervical cancer shows that the most common sources are Social media, College, Family or friends, Public health advertisements, and School. The data was visualized in a bar chart to provide a clear view of the distribution of responses.

If you have any further questions or need additional analysis, feel free to ask!

From where did you get to know about cervical cancer analyse each option seperately with each responses because it is multiple choice one person can select more than one options so analyse seperately. Make a table

Detailed Analysis of Sources of Information about Cervical Cancer

The table below shows the count of each option for each response. Each row represents a unique response, and the columns represent the different sources of information. A value of 1 indicates that the source was selected by the respondent, while a value of 0 indicates that it was not.

S.No.	Social media	Public health advertisements	College	Family or friends	School	Healthcare provider	BOOKS	Self reading	Internet	Magazines	Study
1	1	1	1	0	0	0	0	0	0	0	0
2	1	1	0	0	0	0	0	0	0	0	0
3	0	0	0	1	1	0	0	0	0	0	0
4	1	0	0	0	1	0	0	0	0	0	0
5	1	0	0	0	0	0	0	0	0	0	0
...	...	...	...	...	...	...	...	...	...	...	...
2774	0	1	1	0	0	0	0	0	0	0	0
2775	1	0	0	0	0	0	0	0	0	0	0
2777	1	1	1	0	0	0	0	0	0	0	0
2778	0	0	1	0	0	0	0	0	0	0	0

From where did you get to know about cervical cancer analyse each option seperately with each responses because it is multiple choice one person can select more than one options so analyse seperately.Make table for each options with total respondents and percentage

Analysis of Sources of Information about Cervical Cancer

The table below shows the count and percentage of respondents for each source of information about cervical cancer.

Option	Count	Percentage (%)
Social media	1510	69.01
College	722	33.00
Family or friends	656	29.98
Public health advertisements	605	27.65
School	548	25.05
Healthcare provider	312	14.26
Books	2	0.09
BOOKS	1	0.05
Newspaper	1	0.05
College.	1	0.05
Social media	1	0.05
Self reading	1	0.05
At CISF camp	1	0.05
Part of my previous course	1	0.05
By Google search	1	0.05
Google Surfing	1	0.05
Internet	1	0.05
Magazines	1	0.05
Study	1	0.05

This table provides a detailed breakdown of the sources of information and their respective counts and percentages.

If you have any further questions or need additional analysis, feel free to

Percentage should be of total count and include frequency in this also

Analysis of Sources of Information about Cervical Cancer

The table below shows the count, frequency, and percentage of respondents for each source of information about cervical cancer.

Option	Count	Frequency	Percentage (%)
Social media	1510	1510	34.57
College	722	722	16.53
Family or friends	656	656	15.02
Public health advertisements	605	605	13.85
School	548	548	12.55
Healthcare provider	312	312	7.14
Books	2	2	0.05
BOOKS	1	1	0.02
Newspaper	1	1	0.02
College.	1	1	0.02
Social media	1	1	0.02
Self reading	1	1	0.02
At CISF camp	1	1	0.02
Part of my previous course	1	1	0.02
By Google search	1	1	0.02
Google Surfing	1	1	0.02
Internet	1	1	0.02
Magazines	1	1	0.02
Study	1	1	0.02

This table provides a detailed breakdown of the sources of information, their respective counts, frequencies, and percentages.

If you have any further questions or need additional analysis, feel free to ask!

remove frequency from this table and send me download link

The table has been saved without the Frequency column. You can download it using the link below:

Download cervical_cancer_info_analysis.csv

If you have any further questions or need additional analysis, feel free to ask!

Get started with Vizly