Please help with this code (visual basic 2013)

XYZ Corp's marketing department has recently launched a new campaign on their primary product: a diaper. The sales levels are always a bit fluctuating, so the current increase may or may not be related to the campaign.
In order to check this, you are given the task of writing a simple program to do some statistical checks. The program should

First, get inputs for two time series X and Y from the user. Here X represents the weekly amount of commercials from the campaign, normalized into an integer in [0,100].

And Y represents the weekly sales, again normalized into an integer in [0,100]. So the week with X=100 has the most commercials, and X=0 means no commercials. Similarly the week with Y=0 means no sales and Y=100 means maximum sales.

Then calculate the Pearson's correlation coefficient between X and Y, assuming Y is a function of X. You can use the formulations in any statistics textbook or on WIkipedia.

Then calculate the Pearson's coefficient again, now assuming that commercials need 1 week to create an effect, therefore shifting the values by 1 week.

Show the two correlation coefficients to the user.

For this program you need to use both loops and arrays.

First develop your program and then test it using any dataset you like. Your Instructor will have his own dataset to test your program.