excell help!! - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

excell help!!

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.
Outputs
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).


Sign In or Register to comment.