Scribd
Upload
5 views2 pages

Practical Questions

The document outlines various tasks related to data analysis and visualization using Excel and R, including statistical calculations, data frame creation, and graphical representations. It covers topics such as mean, median, mode, regression, and correlation in Excel, as well as creating dashboards and visualizations like bar plots and pie charts. Additionally, it includes instructions for creating pivot tables, applying filters, and conditional formatting for sales data analysis.

Uploaded by

anmy8470
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views2 pages

Practical Questions

The document outlines various tasks related to data analysis and visualization using Excel and R, including statistical calculations, data frame creation, and graphical representations. It covers topics such as mean, median, mode, regression, and correlation in Excel, as well as creating dashboards and visualizations like bar plots and pie charts. Additionally, it includes instructions for creating pivot tables, applying filters, and conditional formatting for sales data analysis.

Uploaded by

anmy8470
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1.

Excel : mean median mode, regression, correlation and covariance

2. Excel dashboard

3. R- vector creation, creation of table by using vector And text analysis with wordcloud graph

4. Create a data frame named students with the following details:

 Name: "Amit", "Sara", "John", "Neha", “Nisha”, “Rahul”, ”Nisha”

 Age: 20, 21, 19, 22, 24, 25, 30

 Marks: 85, 90, 78, 88, 50,75,30

 Summary Statistics Find:

1. Average marks
2. Maximum marks
3. Minimum marks

5. Create a data frame of employees with columns:

 ID, Name, Department, Salary

 Summary Statistics Find:

4. Average marks
5. Maximum marks
6. Minimum marks

6. Create a data frame of students with marks.


Add a new column Result:

 Marks ≥ 40 → "Pass"

 Marks < 40 → "Fail"

7. Assign grades based on marks:

 ≥ 90 → "A+"

 75–89 → "A"

 50–74 → "B"

 < 50 → "C"

8. Create a data frame of students and their marks. Draw a bar plot showing marks of each student.

9. Create a data frame of different subjects and number of students. Draw a pie chart to show the
distribution.

10. Create a data frame showing sales of two products over 6 months. Plot both on the same graph
using different colors.

11. You are given the following dataset of a company’s sales:

Date Product Region Salesperson Sales Amount

01-01-2024 Laptop North Amit 50000

02-01-2024 Mobile South Sara 30000

03-01-2024 Tablet East John 20000

04-01-2024 Laptop West Neha 55000


Date Product Region Salesperson Sales Amount

05-01-2024 Mobile North Amit 25000

06-01-2024 Tablet South Sara 22000

1. Create Pivot Table

Create a Pivot Table to show:

 Total Sales Amount for each Product

2. Region-wise Analysis

Modify the Pivot Table to display:

 Total Sales by Region (Rows)

 Product (Columns)

3. Apply Filter

 Filter the Pivot Table to display data for only one Salesperson (e.g., Amit)

4. Sorting

 Sort the total sales in descending order

5. Conditional Formatting

 Apply conditional formatting to highlight:

o Highest sales → Green

o Lowest sales → Red

6. Pivot Chart

 Create a Column Chart based on the Pivot Table

7. Grouping

 Group the Date field into Months

You might also like