Need help with lab question In R programming Language.

MTCARS Dataset

The mtcars dataset is a built-in dataset in R that contains information about 32 different models of cars. The dataset includes variables such as miles per gallon (mpg), number of cylinders (cyl), and horsepower (hp), among others.

The mtcars dataset can be loaded into R using the following code:

data("mtcars")

To learn more about mpg, open its help page by running ?mtcars.

Purpose:

This lab is designed for you to demonstrate the Visualization. After completing the tasks in this lab, you should be able to:

Load and understand the structure of the mtcars dataset.

Use the dplyr package to perform basic data transformations, such as filtering, selecting, and grouping data.

Summarize the data by creating new variables using the mutate function.

Group the data by one or more variables and summarize the grouped data using the group_by and summarize functions.

Visualize the transformed data using the ggplot2 package in the tidyverse.

1 a) Create a new column "power_to_weight_ratio" that is the ratio of "displacement" to "cylinders".

b)

Group the "mtcars" dataset by "cylinders" and "gear" and calculate the mean of "mpg" and "disp" for each group.

c)

Group the "mtcars" dataset by "cylinders" and create a new column "cylinder_mpg_ratio" that is the ratio of "mpg" to the number of "cylinders".