I have been given an assignment where we have to use Power Query Editor in Excel to answer the question. I am only looking for a well explained outline rather than a step$-$by$-$step guide and am unable to get the $3$ datasets attached to this submission. Thanks!

Key question to answer: "The higher a country's GDP per capita the more silver medals won during the Olympics."

Context of dataset

The three datasets are to provide a base to answer the hypothesis question above. Datasets $1$ and $2$ are essential to finding the connection and solution to the hypothesis above. Dataset $3$ is a supplement to Dataset $1$ to provide names of the countries with abbreviations.

Where the Data is Obtained

The data is scraped from www$.$olympedia.org which has the latest up$-$to$-$date Olympics data set from the $1896$ Athene Summer Olympics to Beijing $2022$ Winter Olympics. Also available on kaggle.com site.

How to Start and Use the Dataset

$1.$ Download the datasets. Import them using Power Query Editor

$2.$ Include at least one more dataset that will help you control for more variables that might explain the number of silver medals.

$2.$ Perform descriptive analytics to treat missing values, if any.

$3.$ Perform further analysis, including but not limited to VAR, STDDEV, PROB, and Regression Analysis to find the answer to the relationship between the hypotheses

$4.$ Discuss your methods and answers.