I wan to investigate and analyze a dataset using R.

Dataset link : https://www.dropbox.com/scl/fi/l76m63m9nd0qw0tjnufu3/Covid-Data-World.xlsx?dl=0&rlkey=4ed1qemp3ih8xvy0s12xt61a3

Part 1 I wanna do Data Preparation such as Show the information of the dataset. observations attributes data types missing values

head(), str(), attributes(), dim(), mean (), sd()

Briefly Explain Data Preparation of the dataset

Part 2 Data Exploration(EDA): Data Visualization, at least one histogram, one boxplot, and one overlay histogram with your conclusion

qplot(), geom_histogram(), geom_boxplot()

Briefly Explain Data Exploration of the dataset

Part 3 Data Analysis Hypothesis Testing: Construct a hypothesis testing with null and alternative hypotheses. Use the appropriate test to get the conclusion.

Eda hypothesis, p-value , t-test

Briefly Explain Hypothesis Testing of the dataset

Build a linear regression model with subset selection. Please indicate all significant attributes, assess your model, and predict in a test dataset. Prediction, Prediction Interval, plot, , diagnostic plots, , Multiple Linear Regression, Correlation, Checking MAE and MSE