please any1 help with this problem it will be much appreciated! thanks!!
For this excel problem you will need to open the csv file in Excel. This should contain a column of data. These are the Y values of a unique function assigned to you for the X domain of -5:0.01:5 including the bounds (1001 samples). The data in the CSV file however has some corrupted data in it which take the form of x characters appearing throughout the column. Copy the column of data into a new workbook. You must write a VBA macro that will traverse the whole column of data and remove these x characters and place the results values in the column next to original column. I do not want you to hard-code in the locations of the x values I want you to traverse the column of data and check whether each cell contains the character and if it does you must not add that cell to resulting data array which will be assigned to the adjacent column. Conversely you can check if a cell is a number and then add it if it is.
NOTE: You must save the excel file as a Macro-Enabled Workbook (.xlsm) and when you open the file you must select options and enable the macros before they will work.
Once you have your column of clean Y values you must make a column of the associated X values (-5 to 5 with steps of 0.01). Using these X and Y values you will then make an X-Y scatter plot with labelled Axes, a Title and a Legend. Finally I want you to add a trendline to the chart of a function that best fits the data you were given (Polynomial of various orders, Exponential, etc). Finally save this .xlsm file for submission.
The following are the specific outputs required for this assignment
Copy data from CSV file to a macro-enabled workbook
Write a Macro that will traverse the Y values and copy only the numbers to the adjacent column
Create a column of related X values for the Y values (from -5:0.01:5)
Using the X and Y values create an XY-Scatter chart with Axis Labels, a Title and a Legend.
Add a trendline to the chart of the appropriate type (polynomial, exponential, etc).
0 · ·